Articles in this section

Import data into MySQL

Before you begin

Set up a connection to MySQL.

Tip

Click pencil_handlebars.svg to open the Build SQL query editor and ask Celigo AI to generate a query. Enter a description of your SQL query in plain English in the space provided, and Celigo AI will attempt to generate a SQL query based on your prompt.

Use bulk insert SQL query

The bulk insert data option is ideal for large data volumes. integrator.io builds the insert query for you automatically for each batch of records. Each batch's default number of records bound is 100, but you can use the Batch size field to tune your imports as needed.

20191113391515-Import new destination table view.png

By using metadata, you can now:

Note

  • The metadata search will fail if you have a database or table that contains a period ( . ).

  • You can use any schema and table name regardless of what you used in your connection with the following format in your import’s Destination table search: database.tableName.

Use SQL query once per record

Execute a SQL query once for each record.

You can write your SQL command in the SQL query text field. Click Edit (edit.svg) to the right of the text field to open the SQL Query builder AFE.

Use SQL query once per page of records

Execute a SQL query once per page of data. You can write your SQL command in the SQL query text field. Click Edit (pencil_handlebars.svg) to the right of the text field to open the SQL Query builder AFE.

Once_per_page_of_records__2_.png

Use SQL query on first page only

Use this option if you want to run a SQL command once per flow run. The SQL will execute as soon as the first page of data reaches the flow step. This option should be used carefully to avoid race conditions in your flows.

first_page_only__2_.png

Troubleshooting

Question: I am getting an invalid_parameter error while exporting data from NetSuite to PostgreSQL.

Answer: When you are exporting data from NetSuite to a database, such as PostgreSQL, ensure that you enable Skip grouping in NetSuite export. By default, NetSuite results are returned as an array of arrays, whereas integrator.io expects a simple (not nested) array of results. When you enable Skip grouping, the results are received as a simple array.