4 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. 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.	Sign in to the Oracle Cloud Infrastructure Console. Click the Navigator menu icon, click Oracle Database, and click on Goldengate. Under Data replication deployments click on View Resources. Click on the appropriate GoldenGate instance. 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.