Testing the JDBC Driver Connection

After configuring the JDBC Driver, it is recommended that you test the data source to verify that it is able to communicate and authenticate with the driver. Testing the data source requires that the Enterprise Server/Security Server services are up and running. Additionally, ensure that Oracle BI Publisher is up and running.

To test the JDBC Driver connection:

1. Start the Oracle BI Publisher server.

2. Sign in to Oracle BI Publisher Console using an administrative account.

3. Click the Administration tab.

4. Under the Data Sources section, select JDBC Connection.

5. Select the data source that you want to test.

6. Click the Test Connection button to initiate the test.

   If the data source is able to communicate and authenticate with the Data Access Driver, the "Connection established successfully" message appears.

   Note: It is also possible to test the connection when adding the data source.