Data Integration Connectors
- Data Integration Connectors
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
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. If you select the
source type as query or you specify the SQL query property, the
Select distinct rows only 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. |
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. |
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. |
