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

  1. Download and Deploy Oracle Cloud connector JAR file.
  2. Restart Incorta cluster from CMC.
  3. Add Oracle Cloud Applications as an External Data Source
  4. 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:

ParametersDescription
Username/PasswordAccount identifier and password.
Oracle Cloud Applications Username and Password.
Oracle Cloud Applications URLData location
Root Query TextAn optional filtering query that can be used to filter files retrieved from WCC.

Example: dSecurityGroup <matches> OBIAImport
Data Type Discovery PolicyDefines the metadata definition files. These files must be uploaded first to Incorta Data Files, and must have a *.csv extension.

Options:
  • Use Both Sample data and Metadata Definition Files
  • Use Sample Data
Metadata DirectoryEnter 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 PatternEnter 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 SinceEnter the time filter for the data source files to load. Use either:
  • a fixed date in the format
  • . Example:
  • will return all the files created or modified after this date.
  • a look-back period expressed as the number of years, months or days before the loading starts. Example:
  • will return all the files created in the last 90 days.
Keep Cached FilesEnable this property to keep cached load files for more than one hour
Keep File(S) ForEnable Keep Cached Files to view this property. Select the time period to keep the cached extract files for. The options are:
  • a Day
  • a Week
  • a Month
  • a Year
  • Forever
File ExtensionSelect csv for data files and pecsv for the primary key files
Default Hour Of The Day For Date ColumnsEnter the default hour of the day for date columns. The default is 12.
Advanced OptionsEnable this property to view the advanced data source options.
Request Page SizeEnable Advanced Options to view this property. Enter the request page size. The default is 2000.

Deploy Connector's JAR File

  1. Create a new extension directory:  $ mkdir -p <PATH_TO_INCORTA_NODE>/extensions/connectors/OracleCloud
  2. Copy the JAR file connector-oracle-fusion-1.2.jar to the new directory: /home/incorta/IncortaAnalytics/IncortaNode/extensions/connectors/OracleCloud
  3. Restart Incorta cluster.