JDBC Connector

Back Next

JDBC target properties in synchronization tasks

You can also configure advanced target properties when you schedule the

synchronization

task.

When you configure a

synchronization

task to use a JDBC target, you can configure advanced target properties. Advanced target properties appear on the

Schedule

page of the

Synchronization

Task wizard.

The following table describes the JDBC advanced target properties:

Advanced Target Property	Description
Commit Interval	Interval in rows between commits. Default is 100.
Number of Retries	An integer value. Number of times to retry if the query execution fails due to a closed connection. Default is 5.
Retry Wait Period	Interval in seconds between two retry attempts. Default is 3 seconds.
Pre SQL	Pre-SQL command to run against the target database before writing data to the target.
Post SQL	Post-SQL command to run against the target database after writing data to the target.
Success File Directory	Directory for the success file. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Data Integration writes the success rows file to the following directory: <Secure Agent installation directory>/apps/Data_Integration_Server/data/success Enter a directory local to the Secure Agent. Ensure that your administrator has granted you access to this directory.
Error File Directory	Directory for the error rows file. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Data Integration writes the error rows file to the following directory: <Secure Agent installation directory>/apps/Data_Integration_Server/data/error Enter a directory local to the Secure Agent. Ensure that your administrator has granted you access to this directory.