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.
- In Model Administration Tool, navigate to the Physical Layer pane, and open the Connection Pool dialog.
- In Name, enter a name for the data source.
- Select the Use Console Connection check box.
- In Connection Name, enter the name of
the database connection exactly as defined in Console
(case-sensitive). For example, MyCloudSalesDB.
Ignore the other options on this dialog, for example Data source name, Shared Logon User Name and Password.