Establish Connectivity to Oracle Business Intelligence

This article describes how to connect to Oracle Business Intelligence in order to load data into Datasets and Reports in Metric Insights.

[Release 6.x]: 'Remote Data Collector' renamed to 'Remote Data Processor'

1. Access Admin > Data Sources

At the bottom of the screen click [+ New Data Source].

The Select the Type of New Data Source pop-up opens.

2. Select the Type of the New Data Source

  1. Select "Other" and choose "Oracle Business Intelligence" from the drop-down list
  2. Move to the Next step

3. Provide the Required Parameters

  1. Data Source Name: set a name for the data source
  2. Server: define the server protocol (http or https) and a hostname
  3. Username: note that your Username must be in the same format that your Oracle Business Intelligence server uses for authentication 
  4. Password: provide your password credential

4. Advanced Configuration

  1. Use Remote Data Collector: is set to "no" by default
    • If required, switch to "yes" and add a Remote Data Collector by clicking [+New Remote Collector] 
  2. Generate Object List 
    • automatically: all Reports are going to be fetched by the system
    • manually: Reports may be added one-by-one or via CSV file
  3. Object List Refresh Trigger: from the dropdown, select the Trigger that will be used to fetch data via the Oracle Business Intelligence plugin
  4. Object Selection Method: specify how Oracle Business Intelligence Reports will be fetched
  5. Optionally, state the maximum number of concurrent Threads to utilize during data and/or image fetch to be used in background processing when the system updates Reports for this Data Source 
    • If you do not specify any value for this setting, batch data collection processing will be single-threaded
  6. Test Connection (this will also Save your data)

5. Other settings

  1. You can create Datasets directly from the respective tab
  2. Click Permissions to assign permissions to Groups or Power Users