Create a Database Connection

To establish a database connection with the Oracle Argus Safety database, create a new JDBC connection named asbip in the Oracle Business Intelligence Publisher.

Note:

It is recommended to provide the JDBC connection name, user name and database connection information in the lower case.

1. Log in to Oracle Business Intelligence Publisher using the administrator credentials. This displays the Oracle Business Intelligence Publisher Home Page.
2. Click Administration.
3. Click JDBC Connection under Data Sources.

   This displays the Data Sources screen.

4. Click Add Data Source.
5. In the Add Data Source section:
   1. Enter asbip in the Data Source Name field.

      Make sure that you enter this data source name in lowercase only.

   2. Select the database from the Driver Type drop-down.

      This auto-populates the Database Driver Class field.

   3. Enter either of the following connection strings in the Connection String field.
      • url="jdbc:oracle:thin:@[host]:[port]/[sid]"
      • url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host.com)(PORT=<port number>)))(CONNECT_DATA=(SID=orcl)))"
   4. Enter the Oracle Argus Safety Oracle Business Intelligence Publisher schema username (for example, bip_owner) and the password.

      This user is created as part of the Oracle Argus Safety database installation.

   5. Click Test Connection.

      If successful, this displays a confirmation message.

6. Click Apply. This displays the asbip Data Source in the list of already existing data source names.

   This successfully creates a connection between Oracle Business Intelligence Publisher and the Oracle Argus Safety database.