4 Create a Connection to Your Source Applications

To create a data connection to your Oracle Energy and Water Data Intelligence source applications, log a service request with Oracle Energy and Water Data Intelligence Support through My Oracle Support. 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 Energy and Water Data Intelligence instance was created.
  4. Select the Oracle Energy and Water 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 Deployment Information tab gather the following details and include on the SR:
      • 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 Energy and Water 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 Energy and Water Data Intelligence, Customer Analytics Oracle Energy and Water Customer Data
    2 Oracle Energy and Water Data Intelligence, Device Analytics

    Oracle Energy and Water Device Data

    Oracle Energy and Water AMI Data

    3 Oracle Energy and Water Data Intelligence, Work and Asset Analytics Oracle Energy and Water Work and Asset Data
    4 Oracle Energy and Water Data Intelligence, Digital Asset Analytics Oracle Energy and Water Digital Asset Data
    5 Oracle Energy and Water Data Intelligence, Grid Operations Insights Analytics Oracle Energy and Water Grid Insights 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.