Oracle Autonomous Database Connector > Mappings for Oracle Autonomous Database > Source properties for Oracle Autonomous Database
  

Source properties for Oracle Autonomous Database

In a mapping, you can configure a Source transformation to represent a Oracle Autonomous Database source.
The following table describes the Oracle Autonomous Database 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.
Source Type
Type of the source object.
Select Single Object, Query, or Parameter.
The Multiple Objects source type is not applicable.
Object
The source object for the task. Select the source object for a single source.
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.
The following table describes the advanced properties that you can configure in a Source transformation:
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.
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.