ODBC Connector

Back Next

ODBC sources in mappings

In a mapping, you can configure a Source transformation to represent a single ODBC source, multiple ODBC sources, ODBC query or ODBC parameter.

The following table describes the ODBC source properties that you can configure in a source transformation:

Property	Description
Connection	Name of the source connection. You can select an existing connection, create a new connection, or define parameter values for the source connection property. If you want to overwrite the source connection properties at runtime, select the Allow parameter to be overridden at run time option. Specify the parameter file directory and name in the advanced session properties.
Source Type	Type of source object. Select Single Object, Multiple Objects, Query or Parameter.
Parameter	A parameter file where you define values that you want to update without having to edit the task. Select an existing parameter for the source object or click New Parameter to define a new parameter for the source object. The Parameter property appears only if you select parameter as the source type. If you want to overwrite the parameter at runtime, select the Allow parameter to be overridden at run time option. When the task runs, the Secure Agent uses the parameters from the file that you specify in the advanced session properties.
Object	Name of the source object. Select the source object for the task.
Objects and Relationships	Adds multiple objects. Click on Add Source Object. The Objects and Relationships property appears only if you select Multiple Objects as the source type.
Query	Click on Define Query and enter a valid custom query. The Query property appears only if you select Query as the source type.
Parameter	The parameter for the source object. Create or select the parameter for the source object. The parameter property appears only if you select Parameter as the source type.
Filter	Filters records and reduces the number of rows that the Secure Agent reads from the source. Add conditions in a read operation to filter records from the source.
Sort	Sorts records based on the conditions you specify.
Select distinct rows only	Eliminates duplicate rows. Select to eliminate duplicate rows. Default is false.
Tracing Level	Sets the amount of detail that appears in the log file. Select Normal, Verbose Initialization or Verbose Data. Default is normal.
Pre SQL	Pre-SQL command that must be run before reading data from the source.
Post SQL	Post-SQL command that must be run after reading data from the source.
Output is Deterministic	Specify only when the source output does not change between session runs.
Output is Repeatable	Specify only when the order of the source output is same between the session runs. Select Never or Always.
SQL Override	The SQL statement to override the default query generated from the specified source type to read data from the ODBC source.