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

ODBC Sources in Data Synchronization Tasks

You configure ODBC source properties on the Source page of the Data Synchronization Task wizard.

The following table describes the ODBC source properties:

Property	Description
Connection	Name of the source connection.
Source Type	Type of the source object. Select Single, Multiple or Saved Query.
Source Object	Name of the source object. Select the source object for a single source or multiple related sources.
Display source fields in alphabetical order	Displays source fields in alphabetical order instead of the order returned by the source system.

When you configure a Data Synchronization task to use an ODBC source, you can configure advanced source properties. Advanced source properties appear on the Schedule page of the Data Synchronization Task wizard.

The following table describes the ODBC advanced source 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.
Execution Mode	Sets the amount of detail that appears in the log file. Select Standard or Verbose. Default is Standard. Select Verbose for troubleshooting.

Rules and Guidelines for ODBC Sources

Consider the following rules and guidelines when you configure an ODBC source:

•ODBC source connections do not detect primary-foreign-key relationships. Therefore, these tables do not appear related when you add multiple source objects.
•If you add multiple MySQL tables as the source for a task and you use an ODBC connection to connect to MySQL, you must use a user-defined join. If you create the relationship and run the task, the task fails.