Microsoft Azure Synapse SQL Connector

Back Next

Bulk processing for write operations

You can enable bulk processing to write large amounts of data to

Microsoft Azure Synapse SQL

. Bulk processing utilizes minimal number of API calls and the performance of the write operation is optimized.

To enable bulk processing, specify the property -DENABLE_WRITER_BULK_PROCESSING=true in the Secure Agent properties:

Perform the following steps to configure bulk processing before you run a mapping:

In Administrator, select the Secure Agent listed on the

Runtime Environments

tab.

Click

Edit

In the

System Configuration Details

section, select

Data Integration Server

as the service and

DTM

as the type.

Edit the JVM option, and enter -DENABLE_WRITER_BULK_PROCESSING=true.

Click

Save

You cannot use bulk processing in write operations for mappings in advanced mode.

You cannot use bulk processing in mapping tasks configured with

SQL ELT optimization

using the

Microsoft Azure Synapse SQL

ODBC connection or the

Microsoft Azure Synapse SQL

connection.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.