Data Export and Import

Connection definitions

Export selected connections as a JSON file for backup or reuse. Import the JSON from the Connections page; OL DataIQ validates required fields and skips duplicate names.

Export a dataset

1. Execute a successful SELECT query.
2. Select Export Dataset.
3. Choose a target connection and target table.
4. Set a record limit and decide whether existing target data should be cleared.
5. Run the export.

The target table must already exist and have compatible column names and types. Large exports can take time.

Export a schema

From the Tables area, select the source tables, choose Export Schema, select the target connection, choose whether to drop existing tables, and execute the export.