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.
Create a Data Connection Type
Connection Type specifies the source to which you are connecting. A connection type can have multiple connections.
Edit a Data Connection Type
If the properties or parameters for a data connection type change, you can edit them.
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.Create a Data Connection
You can create a data connection for any available connection type.
Test a Data Connection
After you create a data connection, you should test it to ensure it works properly.
- Sign in to your service.
- In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Data Configuration under Application Administration.
- On the Data Configuration page, click Manage Connections under Global Configurations.
- On the Manage Connections page, click Connections, then select or search for the connection you want to test.
- Click the Action menu for the connection and select Test Connection.
- 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.
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.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.
- Sign in to your service.
- In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Data Configuration under Application Administration.
- On the Data Configuration page, click Manage Connections under Global Configurations.
- On the Manage Connections page, click Create and then click Connection.
- In Create Connection, select Eloqua as the connection type.
- 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.
- 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 - Click Save.