Articles in this section

Export data from Microsoft SQL

Anitha Abraham
Updated

Before you begin, set up a connection to Microsoft SQL if you don't have an existing connection that you can use.

Export data from the connected database

  1. From the Resources menu, select Exports to open the list of exports for your account.

  2. At the upper right of the Exports page, click + New export.

  3. In the resulting Create export panel, give the new export a meaningful name. (The Name field is required; Description is optional, for your reference.)

  4. Continuing in the Create export panel, select Microsoft SQL from the Application list.

  5. After you select a database application, the Connection list is populated only with existing connection resources for that database type. Select an existing connection, or click the plus (+) button to add a new connection.

    export-data-ms-sql.png

  6. Then, in the Query field, write the SQL statement that fetches the data that you require.

    ms-sql-query.png

    Note

    Some implementations require you to specify the database name when accessing a table – for example,

    SELECT * FROM <databasename>.<schema>.<tablename>

  7. 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

    • Limit – to export a limited set of records, primarily used for testing to avoid syncing lots of data

      Note

      When you select the export type as Limit - export a set number of records , another setting 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. The default value is set to one. You can export a maximum of 100 records.

  8. Click preview to see sample JSON-formatted data. If the SQL query is not executed successfully, revise the Query or Export type values.

    Note

    In the export Preview and import mappings Input, you will see the bigint datatype values in string format. Bigint values are returned as strings to avoid precision issues and accurately represent very large numbers.

  9. Click Save, and proceed to access the new export within a flow.

Group export records

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).

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.