Connect to a Data Source Using a Data Connection

In Oracle Analytics Cloud, users with DV Content Author access can set up connections to a wide range of data sources, and make these data connections available to business modelers building semantic models in Model Administration Tool by setting a connection option called System Connection.

For a list of data sources with the system connection option, see Supported Data Sources.

To use a data connection in Model Administration Tool, you enter its Object ID in the Connection Pool dialog. You don’t have to re-enter the connection details.

1. In Oracle Analytics Cloud, obtain the Object ID of the connection you want to use in Model Administration Tool.
   1. If you haven’t done so already, create a connection to your data source and select the System Connection check box.

      See Database Connection Options.

   2. On the Home page, click Navigator, click Data, and then click the Connections tab.
   3. In the Connections page, locate the connection, click Actions , and then click Inspect.
   4. Click Copy to copy the connection's Object ID.
      
2. In Model Administration Tool, navigate to the Physical pane, and open the Connection Pool dialog.
3. In Name, enter a name for the data source.
4. Select the Use Data Connection check box.
5. Enter the Object ID of the data connection you want to use.

   Object IDs use the format: 'owner'.'connection name'

   For example: '[e-mail]'.'myoracledatabase'

   

   Note:

   Ignore the other options on this dialog, for example Data source name, Shared Logon User Name and Password.