Create PRMART JDBC Connection

If you are installing Oracle Business Intelligence Publisher on a Windows machine, the TNS entry of Oracle Argus Insight must be added in TNSNAMES.ora file of the Oracle Business Intelligence Publisher Web Server.

If Oracle Business Intelligence Publisher is installed on a Linux machine, no modifications to the TNSNAMES.ora file are required.

When you have uploaded the Argus Insight.xdrz file to Oracle Business Intelligence Publisher, you also need to create a connection between the Oracle Business Intelligence Publisher and the database.

To connect the Oracle Business Intelligence Publisher and the database:

1. Log on to Oracle Business Intelligence Publisher using the administrator credentials.

   The Oracle Business Intelligence Publisher home page appears.

2. From top-menu, click Administration.
3. In the Data Sources section, click JDBC Connection.

   The Data Sources screen appears.

4. Click Add Data Source.
5. In the Add Data Source section:
   1. In the Data Source Name field, enter PRMART.
   2. From the Driver Type drop-down list, select the database.

      The Database Driver Class field is auto-populated based on the selected Driver Type.

   3. In the Connection String field, enter the connection string.

      You must enter all the details in lower case in this field.

   4. In the Username field, enter the username (Oracle Argus Insight application DB user, for example, apr_app) to connect to the database.
   5. In the Password field, enter the password for the user.
   6. Click Test Connection.

      If successful, a confirmation message appears.

6. Click Apply.

   The PRMART Data Source in the list of already existing data source names appears.

A connection between Oracle Business Intelligence Publisher and the database is successfully created.