ODBC Connector > Synchronization tasks with ODBC Connector > ODBC sources in synchronization tasks
  

ODBC sources in synchronization tasks

You configure ODBC source properties on the Source page of the 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 synchronization task to use an ODBC source, you can configure advanced source properties. Advanced source properties appear on the Schedule page of the Synchronization Task wizard.
The following table describes the ODBC advanced 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 installation directory>/apps/Data_Integration_Server/data/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
The default value is 10.
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: