Set Up Database Connectivity

To run Oracle Business Intelligence visualizations through Oracle Life Sciences Data Hub, you must set up connectivity between the Oracle LSH database and the BI Server database.

You can use a system ODBC DSN or the Oracle Call Interface (OCI) to connect the Oracle BI Server to the Oracle LSH database server.

This section contains the following topics:

• Set Up Database Connectivity Using a System DSN
  Create a valid Oracle driver-based System Data Source Name (DSN) on the computer where the Oracle Business Intelligence server is installed.
• Set Up Database Connectivity Using OCI
  Create an entry in the BI Server's tnsnames.ora file with the name and connection details of the LSH database server.