Set a Connection Pool's Connection Property

A connection pool's connection must be correctly assigned before you can preview a physical table's data.

When you import a .rpd or .zip file or load the deployed semantic model to create a semantic model, Oracle Analytics doesn't always automatically assign the connection pool's connection. In such cases you must manually assign one.

The Connections field displays the data source connections that you can use with semantic models. You must create or have been given access to the needed semantic model's data source connection. See Share a Data Source Connection.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Physical Layer and locate and double-click a database.
4. In the database, click Connection Pools and click Detail view.
5. Go to the connections pool list and click a connection pool to display its details.
6. In the connection pool's details, scroll to the Connection field, click it, and select a connection.
7. Click Save.