Setting Up a Database Connection Using a JNDI Connection Pool

BI Publisher supports connecting to the JDBC data source through a connection pool.

Using a connection pool increases efficiency by maintaining a cache of physical connections that can be reused. When a client closes a connection, the connection gets placed back into the pool so that another client can use it. A connection pool improves performance and scalability by allowing multiple clients to share a small number of physical connections. You set up the connection pool in your application server and access it through Java Naming and Directory Interface (JNDI).

After you set up the connection pool in your application server, enter the required fields in this page so that BI Publisher can use the pool to establish connections.See Configuring JDBC Data Sources in Administering JDBC Data Sources for Oracle WebLogic Server.

To set up a database connection using a JNDI connection pool:

1. From the Administration page, click JNDI Connection to display the list of existing JNDI connections.
2. Click Add Data Source.
3. Enter the following fields for the new connection:

   • Data Source Name — Enter a display name for the data source. This name is displayed in the Data Source selection list in the Data Model Editor.

   • JNDI Name — Enter the JNDI location for the pool. For example, jdbc/BIPSource.

   • Use Proxy Authentication — Select this box to enable Proxy Authentication. See About Proxy Authentication.

4. Click Test Connection. A confirmation message is displayed.
5. Define security for this data source. Use the shuttle buttons to move roles from the Available Roles list to the Allowed Roles list. Only users assigned the roles on the Allowed Roles list can create or view reports from this the data source.