3 Create a Connection to Your Source Applications

To create a data connection to your Oracle Utilities Data Intelligence source applications, log a service request with Oracle Utilities Data Intelligence Support through My Oracle Support (MOS).

For logging the service request, fill in the fields as follows:

  • Product - Oracle Utilities Data Intelligence
  • Category - DevOps Request
  • Sub-Category - Onboarding

You will need to include several details about your instance as part of the service request. The steps below explain how to find and copy the details you need.

  1. Sign in to the Oracle Cloud Infrastructure Console.
  2. Click the Navigator menu icon, click Analytics & AI, and then under Analytics, click Data Intelligence.
  3. Select the Compartment in which your Oracle Utilities Data Intelligence instance was created.
  4. Select the Oracle Utilities Data Intelligence 'Display Name' to get more details for that instance.
  5. Copy the following information:
    • Instance OCID
    • Instance Name
    • Region
    • URL
  6. Get your list of SKUs/Subscriptions which are available on your instance. This detail can be obtained by navigating to the service instance page. Click on your instance and in the instance details page, under Resources, click Subscriptions.
  7. Based on the above SKUs/subscriptions you have and the sources to be configured, include the following details related to the source environment in the service request based on the scenario:
    Scenario Information to Provide
    The source environment is software-as-a-service (for example, Customer Cloud Service). Provide the source application URL.
    The source environment is on-premises. Provide the following database details:
    • Schema
    • Pluggable Database Name
    • Dump Encryption Key/Password (shared through a secure medium)
    You have OCI GoldenGate.
    1. Sign in to the Oracle Cloud Infrastructure Console.
    2. Click the Navigator menu icon, click Oracle Database, and click on Goldengate.
    3. Under Data replication deployments click on View Resources.
    4. Click on the appropriate GoldenGate instance.
    5. From the Deployment Information tab, gather the following details and include them in the service request:
      • GoldenGate OCID
      • GoldenGate URL
      • GoldenGate Infra(CIDR)/Subnet
    You have on-premises GoldenGate. Provide the following:
    • GoldenGate Subnet
    • GoldenGate Master key wallet (shared through a secure medium)
  8. Submit the service request and wait for confirmation in the service request regarding completion of connector setup.

Test Your Data Connection

After the service request has been updated to confirm that the data connection has been created, you can test it to ensure it works properly.

  1. Sign in to your service.
  2. In the Oracle Utilities Data Intelligence Admin Console, under Application Administration, click Data Configuration.
  3. On the Data Configuration page, under Configurations, click Manage Connections.
  4. On the Manage Connections page, click Connections, then select or search for the connection you want to test.
    Number SKU/Subscription Connectors Available
    1 Oracle Utilities Data Intelligence, Customer Analytics Oracle Utilities Customer Data

    Oracle Utilities Base Data

    2 Oracle Utilities Data Intelligence, Customer Insights Oracle Utilities Customer Insights
    3 Oracle Utilities Data Intelligence, Customer Program Management Analytics Oracle Utilities Customer Program Data
    4 Oracle Utilities Data Intelligence, Device Analytics

    Oracle Utilities Meter Data

    Oracle Utilities AMI Data

    Oracle Utilities Base Data

    5 Oracle Utilities Data Intelligence, Grid Operations Insights Oracle Utilities Grid Insights Data

    Oracle Utilities Base Data

    6 Oracle Utilities Data Intelligence, Work and Asset Analytics Oracle Utilities Work and Asset Data
  5. Click the Action menu for the connection and select Test Connection. Repeat this step for each of the connector(s) made available for each SKU/subscription available on your instance.
  6. Once the test connection is successful, click the Action menu for the connection again and select Refresh Metadata for each of the connections.

On the Activity tab, you can check the status of the test connection request.