Establish Connectivity to Oracle

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

1. Create a New Data Source

Access Admin > Collection & Storage > Data Sources

  1. [+ New Data Source] 
  2. Select "Oracle" in the SQL section.
  3. [Next]

2. Complete Data Source Creation

  1. Name: Give the Data Source a descriptive name.
  2. Auth Type: Select the authorization type:
    • Password: Use the credentials to provide access to the database.
    • Identity Profile: Select the existing Identity Profile in the Identity Profile field.
  3. Data Source Username and Data Source Password are obtained from database administrator.
  4. Host name: Provide the database host name. By clicking [Ping] the user can check connection to the mentioned host.
  5. Port: The "1521" value is auto-filled by default.
  6. JDBC driver: The "Oracle" value is chosen in this field by default.
  7. JDBC string: This string is auto-generated by default, but the User can change it according to specific needs.
  8. [Create]

3. Check the Connection

[Test Connection] to check if the system connects to the database successfully.

The next step would be creating a Dataset from Oracle Data Source. For more information on that, check the Create Dataset from Plugin or SQL Data Source article.