ODBC Connector Guide > Data Synchronization Tasks with ODBC Connector > ODBC Targets in Data Synchronization Tasks
  

ODBC Targets in Data Synchronization Tasks

You can use an ODBC object as a target in a Data Synchronization task.
You can configure ODBC target properties on the Target page of the Data Synchronization Task wizard.
You can configure target objects to perform the following operations:
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.
Note: When you truncate a target through an ODBC connection, it executes a DELETE FROM statement to truncate the table.
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 Data Synchronization task to use ODBC targets, you can configure advanced target properties. Advanced target properties appear on the Schedule page of the Data 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 Data Synchronization task.
Post-processing Commands
Enter post-processing script that should be executed after running the Data 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.