- Establish a relational database connection (to MS SQL, MySQL, or PostgreSQL)
- Export data from the connected database
Create a connection to MySQL.
- From the Resources menu, select Exports to open the list of exports for your account.
- At the upper right of the Exports page, click + New export.
- In the resulting Create export panel, give the new export a meaningful name. (The Name field is required; Description is optional, for your reference.)
- Continuing in the Create export panel, select a relational database technology from the Application list: MS SQL, MySQL, or PostgreSQL.
- After you select a database application, the Connection list is populated only with existing connection resources for that database type. Select a connection (building on the example above), or click the plus (+) button to add a new connection to a relational database.
- Then, in the Query field, write the SQL statement that fetches the data that you require.
Note: Some implementations require you to specify the database name when accessing a table – for example,
SELECT * FROM salesrecords.`order`;
where salesrecords is the database name.
- Select an Export type:
- All – to export all data, always
- Delta – to export only data that has changed since the last time the data flow was run
- Once – to export only data that has not already been exported
Test – to export only one record, intended to avoid syncing lots of data during testing
Note: The export type field option Test is renamed to Limit - export a set number of records. When you select the export type as Limit - export a set number of records, another field How many records would you like to export? is enabled for you to enter the maximum number of records to export each time this flow runs while developing and testing an integration. The default field value for existing users is set to 1. You can export a maximum of 100 records and if you enter a value more than the specified limit, an error message “Value cannot be less than 1 or greater than 100” is displayed.
- Click preview to see sample JSON-formatted data. If the SQL query is not executed successfully, revise the Query or Export type values.
- Click Save, and proceed to access the new export within a flow.
The Grouping option allows you to manage your flow’s files by grouping records by field. This feature allows you to aggregate your data based on your chosen field(s).