JDBC Connector > Synchronization tasks with JDBC > JDBC target properties in synchronization tasks
  

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.