Property | Description |
|---|---|
Connection | Name of the target connection. You can select an existing connection, create a new connection, or define parameter values for the target connection property. |
Target Type | Type of the target object. Select Single Object or Parameter. |
Object | Name of the target object. You can select an existing object. The target name can contain alphanumeric characters. You can use only a period (.), an underscore (_), an at the rate sign (@), a dollar sign ($), and a percentage sign (%) special characters in the file name. You can use parameters defined in a parameter file in the target name. |
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 target type. Select an existing parameter for the target object, or click New Parameter to define a new parameter for the target 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. |
Operation | The target operation. Select Insert. |
Property | Description |
|---|---|
Bucket Name | The Oracle Cloud Object Storage bucket name that contains the objects. |
Local 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. |
COPY_DATA Command Options | The options to provide in the COPY_DATA command when loading the data from Oracle Cloud Object Storage to Oracle Autonomous Database. For example, ignoremissingcolumns : true |
Schema Name | Overrides the schema name of the target object. |
Table Name | Overrides the table name configured in the target object and uses the specified table name to write data at runtime. |
Batch Size | The number of rows to load in a batch. The default value is 2,000,000. |
Number of files per batch | The number of files in a batch. The default value is 20. |
Forward Rejected Rows | Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the agent forwards rejected rows to the next transformation. |