Connect to a Data Source Using a Console Connection

Administrators can define database connections for semantic models using the Console in Oracle Analytics Cloud. This includes databases such as Oracle Database Cloud Service, Oracle Autonomous Data Warehouse, and Oracle Autonomous Transaction Processing.

If you want to re-use these database connections in Model Administration Tool, you don’t have to re-enter the connection details. Instead, you refer to the database connections “by name” in the Connection Pool dialog.

If you haven't already done so, create the database connection in Console and note down its name. For example, MyCloudSalesDB.

1. In Model Administration Tool, navigate to the Physical Layer pane, and open the Connection Pool dialog.
2. In Name, enter a name for the data source.
3. Select the Use Console Connection check box.
4. In Connection Name, enter the name of the database connection exactly as defined in Console (case-sensitive). For example, MyCloudSalesDB.

   Note:

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