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. Note: 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. Note: 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. Note: 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. |