About Managing Data Connections

You can connect to a variety of data sources and remote applications to provide the background information for reports. You can blend the additional data from the various data sources with the ready-to-use datasets to enhance business analysis.

Oracle Fusion Analytics Warehouse can connect to other pre-validated data sources such as Oracle Object Storage, cloud applications such as Google Analytics, and on-premises applications such as Oracle E-Business Suite.

You'll need to create a data connection type before you create a data connection using that type.

Topics

• Create a Data Connection Type
• Edit a Data Connection Type
• Delete a Data Connection Type
• Create a Data Connection
• Test a Data Connection
• Update a Data Connection
• Delete a Data Connection
• Connect with Your Oracle Eloqua Data Source

Create a Data Connection Type

Connection Type specifies the source to which you are connecting. A connection type can have multiple connections.

You can create a custom data source type for any remote data connection. Be sure to create the data connection type before using it to Create a Data Connection.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Data Configuration under Application Administration.
3. On the Data Configuration page, click Manage Connections under Global Configurations.
   
   

   
   Description of the illustration fawag_manage_connections.png

   
   
4. On the Manage Connections page, click Create and then click Connection Type.
   
   

   
   Description of the illustration fawag_manage_connections_create.png

   
   
5. In the Create Connection Type dialog, enter the Name, Identifier, and Prefix for warehouse for the connection type.
   
   

   
   Description of the illustration fawag_create_connection_type.png

   
   
6. Click Add Property and enter the parameters for each property that defines the connection.
7. When you've finished adding the connection properties, you can reorder them as needed.
8. Click Save the Connection Type.

The new connection is available on the Connections page.

Edit a Data Connection Type

If the properties or parameters for a data connection type change, you can edit them.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Data Configuration under Application Administration.
   You see the Data Configuration page.
3. On the Data Configuration page, click Manage Connections under Global Configurations.
4. On the Manage Connections page, click Connection Types and then click or search for the connection type you want to edit.
   You can't edit or delete Oracle-managed connections.
5. Click the Action button next to the connection type you want to change.
6. In the dialog box for the connection type, edit the details for your connection type, and then click Save.

Delete a Data Connection Type

You can delete a data connection type if you don't need it anymore.

Note:

After you delete a connection type, you can't create new data connections to it.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Data Configuration under Application Administration.
   You see the Data Configuration page.
3. On the Data Configuration page, click Manage Connections under Global Configurations.
4. On the Manage Connections page, click Connections, then select or search for the connection you want to test.
5. Click the Action menu for the connection and select Delete.
6. In the Delete Connection dialog box, click Delete.

Create a Data Connection

You can create a data connection for any available connection type.

You need a connection type to create a data connection. You can either use a ready-to-use data connection type or Create a Data Connection Type that meets your business requirements.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Data Configuration under Application Administration.
3. On the Data Configuration page, click Manage Connections under Global Configurations.
4. On the Manage Connections page, click Create and then click Connection.
5. In the Create Connection dialog, click or search for the connection type you want to create.
   
   

   
   Description of the illustration fawag_create_connection.png

   
   
6. In the dialog box for the connection, enter the details for your connection in the fields.
7. Click Save.

The new connection is available on the Connections page.

Test a Data Connection

After you create a data connection, you should test it to ensure it works properly.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Data Configuration under Application Administration.
3. On the Data Configuration page, click Manage Connections under Global Configurations.
4. On the Manage Connections page, click Connections, then select or search for the connection you want to test.
5. Click the Action menu for the connection and select Test Connection.
6. On the Request History page, check the status of the request to test the connection.

Update a Data Connection

When you first make a data connection, or when you make changes, you need to initialize and refresh it.

1. Sign in to the Oracle Cloud Infrastructure Console.
2. In Oracle Cloud Infrastructure Console, click the Navigation menu icon in the top left corner.
3. Click Analytics & AI. Under Analytics, click NetSuite Analytics Warehouse.
4. Navigate to your service instances page.
5. On the Instances page, click the instance for which you want to update the service.
6. Click Connections, then select or search for the connection you want to test.
7. Click the Action menu for the connection and select Initialize/Refresh Connection.

Delete a Data Connection

You can delete a custom data connections if you don't need it anymore.

Note:

You can't update or load data from deleted data connections to the warehouse.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Data Configuration under Application Administration.
   You see the Data Configuration page.
3. On the Data Configuration page, click Manage Connections under Global Configurations.
4. On the Manage Connections page, click Connections, then select or search for the connection you want to test.
5. Click the Action menu for the connection and select Delete.
6. In the Delete Connection dialog box, click Delete.

Connect with Your Oracle Eloqua Data Source

If you’ve subscribed for Oracle Fusion CX Analytics and want to load data from your Oracle Eloqua source into Oracle Fusion Analytics Warehouse, then create a connection using the Eloqua connection type.

The Oracle Eloqua data that you load into Oracle Fusion Analytics Warehouse enables you to augment the data in your warehouse and create varied customer experience-related analytics.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Data Configuration under Application Administration.
3. On the Data Configuration page, click Manage Connections under Global Configurations.
4. On the Manage Connections page, click Create and then click Connection.
5. In Create Connection, select Eloqua as the connection type.
6. In the dialog for the Eloqua connection, select Standard in Connectivity Type, enter an email ID to receive notifications in Notification Email, and the credentials to connect with the Eloqua source in User Name and Password.
7. In URL, enter the URL for your Eloqua server in this sample format: https://<your eloqua server>/api/odata/1.0.
   Description of the illustration fawag_eloqua_create_connection.gif
8. Click Save.

Load Data from Your Oracle Eloqua Data Source

Create a data pipeline for the Marketing Campaign Analytics functional area to load data from your Oracle Eloqua source into Oracle Fusion Analytics Warehouse.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Data Configuration under Application Administration.
3. On the Data Configuration page, click your service. For example, under Applications, click Customer Experience.
4. On the Customer Experience page, click Create.
5. In the wizard, select Customer Experience Marketing Analytics in Offering and Marketing Campaign Analytics in Functional Area to transfer the data to the warehouse, and then click Next.
   
   

   
   Description of the illustration fawag_load_eloqua_data.png

   
   
6. Review the parameters and click one of the options:
   • Cancel: To cancel the data pipeline for the functional area.
   • Save: To save the data pipeline for the functional area but not activate it.
   • Activate: To schedule when to run the data pipeline for the functional area. See Activate a Data Pipeline for a Functional Area.