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. |
Source Type | Type of the source object. Select Single Object, Multiple Objects, Query, or Parameter. You can use implicit joins and advanced relationships with multiple objects. When you select the source type as query, you need to map all the fields selected in the query in the Field Mapping tab. |
Object | The source object for the task. Select the source object for a single source. When you select the multiple source option, you can add multiple source objects and configure a relationship between them. |
Parameter | A parameter file where you define values that you want to update without having to edit the task. The Parameter property appears only if you select parameter as the source type. Select an existing parameter for the source object, or click New Parameter to define a new parameter for the source object. If you want to overwrite the parameter at runtime, select the Allow parameter to be overridden at run time option when you create a parameter. When the task runs, the agent uses the parameters from the file that you specify in the advanced session properties. |
Filter | Filters records based on the filter condition. You can specify a simple filter or an advanced filter. |
Sort | Sorts records based on the conditions you specify. You can specify the following sort conditions:
|
Select distinct rows only | Extracts distinct rows from the source table. Note: If you select the source type as query or you specify the SQL query property, the Select Distinct option is ignored. |
Property | Description |
|---|---|
Bucket Name | The Oracle Cloud Object Storage bucket name that contains the objects. |
Staging Directory Path | Path of the local staging directory. Ensure that the user has write permissions on the directory. In addition, ensure that there is sufficient space to enable staging of the entire file. Default staging directory is the /temp directory on the machine that hosts the Secure Agent. The temporary files are created within the new directory. |
EXPORT_DATA Command Options | The options to provide in the EXPORT_DATA command when loading the data from Oracle Autonomous Database to Oracle Cloud Object Storage. For example, DELIMITER=| |
Schema Name | Overrides the schema name of the source object. |
Table Name | Overrides the table name configured in the source object and uses the specified table name to read data at runtime. |
Pre-SQL | The pre-SQL command to run on the Oracle Autonomous Database source table before the agent reads the data. For example, if you want to update records in the database before you read the records from the table, specify a pre-SQL statement. The query must include a fully qualified table name. You can specify multiple pre-SQL commands, each separated with a semicolon. |
Post-SQL | The post-SQL command to run on the Oracle Autonomous Database table after the agent completes the read operation. For example, if you want to delete some records after the latest records are loaded, specify a post-SQL statement. The query must include a fully qualified table name. You can specify multiple post-SQL commands, each separated with a semicolon. |
SQL Override | The SQL statement to override the default query used to read data from the Oracle Autonomous Database source. |
Tracing Level | Determines the amount of detail that appears in the log file. You can select Terse, Normal, Verbose Initialization, or Verbose Data. Default is Normal. |