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 a 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 *.csv extension. Options:
|
| File Name Pattern | file_<catalog>_<schema>_<table>batch*.zip |
| File Criteria - Last Modified Timestamp | Acts as a time filter for all the results concerning this data source. Use date format yyyyMMdd HH:mm. Example >= ‘2019-05-31 15:30’ “ will return all the files created or modified after this date. |
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.jarto the new directory:/home/incorta/IncortaAnalytics/IncortaNode/extensions/connectors/OracleCloud - Restart Incorta cluster.