ODBC Connector

Back Next

ODBC targets in synchronization tasks

You can use an ODBC object as a target in a

synchronization

task.

You can configure ODBC target properties on the

Target

page of the

Synchronization

Task wizard.

You can configure target objects to perform the following operations:

Insert

Update

Upsert

Delete

The following table describes the ODBC target properties:

Property	Description
Connection	Name of the target connection.
Target Object	Name of the target object.
Truncate Target	Truncates an ODBC target before writing data to the target. Select True or False. When you truncate a target through an ODBC connection, it executes a DELETE FROM statement to truncate the table. When you write to DB2 and you enable Truncate Target option for the target object, the Secure Agent runs the truncate command instead of the delete command, which enhances the performance of the write operation. If the truncate command fails, the Secure Agent runs the delete command.
Display target fields in alphabetical order	Displays target fields in alphabetical order instead of the order returned by the source system.

When you configure a

synchronization

task to use ODBC targets, you can configure advanced target properties. Advanced target properties appear on the

Schedule

page of the

Synchronization

Task wizard.

The following table describes the ODBC advanced target properties:

Advanced Property	Description
Preprocessing Commands	Enter pre-processing script that should be executed before running the synchronization task.
Post-processing Commands	Enter post-processing script that should be executed after running the synchronization task.
Parameter File Name	File that contains the parameters to be used in filters or expressions. Ensure that you have saved the parameter file in the Secure Agent /main/rdtmDir/userparameters directory.
Maximum Number of Log Files	The maximum number of files to retain for each of the following logs: Session log Error log Import log
Execution Mode	Sets the amount of detail that appears in the log file. Select Standard or Verbose. Default is Standard. Select Verbose for troubleshooting.