Oracle Cloud Applications Connector
The Oracle Cloud Applications connector extracts data from Web Cloud Content (WCC) that the Oracle Business Intelligence Cloud Connector Console compresses in a comma-separated value (CSV) file format.
Prerequisites
- Download and Deploy Oracle Cloud connector JAR file.
- Restart Incorta cluster from CMC.
- Add Oracle Cloud Applications as an External Data Source
- Define Oracle Cloud Applications connector parameters in New Data Source dialog.
Oracle Cloud Parameters
In the New Data Source dialog for Oracle Cloud Applications, provide the following:
Parameters | Description |
---|---|
Username/Password | Account identifier and password. Oracle Cloud Applications Username and Password. |
Oracle Cloud Applications URL | Data location |
Root Query Text | An optional filtering query that can be used to filter files retrieved from WCC. Example: dSecurityGroup <matches> OBIAImport |
Data Type Discovery Policy | Defines the metadata definition files. These files must be uploaded first to Incorta Data Files, and must have a *.csv extension. Options:
|
Metadata Directory | Enter the path to the metadata files. For example, /path/to/metadata/directory . Leave this field blank if the metadata files are in the root directory. |
File Name Pattern | Enter the file name filter for the data source files to load. The default value is file_<catalog>_<schema>_<table>-batch*.zip , but you can also enter a custom value. |
Load Only Files Created Since | Enter the time filter for the data source files to load. Use either:
|
Keep Cached Files | Enable this property to keep cached load files for more than one hour |
Keep File(S) For | Enable Keep Cached Files to view this property. Select the time period to keep the cached extract files for. The options are:
|
File Extension | Select csv for data files and pecsv for the primary key files |
Default Hour Of The Day For Date Columns | Enter the default hour of the day for date columns. The default is 12. |
Advanced Options | Enable this property to view the advanced data source options. |
Request Page Size | Enable Advanced Options to view this property. Enter the request page size. The default is 2000. |
Deploy Connector's JAR File
- Create a new extension directory:
$ mkdir -p <PATH_TO_INCORTA_NODE>/extensions/connectors/OracleCloud
- Copy the JAR file
connector-oracle-fusion-1.2.jar
to the new directory:/home/incorta/IncortaAnalytics/IncortaNode/extensions/connectors/OracleCloud
- Restart Incorta cluster.