Creating a Connection from Hyperion BI+ Interactive Reporting to an Oracle Database

Creating a Connection from Hyperion BI+ Interactive Reporting to an Oracle Database [ID 1050593.1]
		Modified 19-JUL-2011     Type HOWTO     Status PUBLISHED

In this Document
  Goal
  Solution

---

Applies to:

Hyperion BI+ - Version: 9.3.0.0.00 to 9.3.3.0.00 - Release: 9.3 to 9.3
Information in this document applies to any platform.
Oracle Database
Oracle*Net
ODBC
***Checked for relevance on 19-Jul-2011***

Goal

Creating connections from Hyperion BI+ Interactive Reporting to Oracle Database

Solution

There are two options (ODBC, Oracle*Net):

ODBC

1. Create ODBC connection using MERANT OEM 5.2 32-BIT Oracle Wire Protocol (in Microsoft Windows that would be in Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN tab; in Unix .odbc.ini file)
2. Create an OCE file (with the same name as the intended Hostname/Provider to be assigned in LSC below) on Microsoft Windows using Interactive Reporting Studio (File menu > New... > A New Database Connection File > OK button) using ODBC/ODBC or ODBC/Oracle as "What connection software do you want to use?"/"What type of database do you want to connect to?"
3. Launch Hyperion > Reporting and Analysis > Utilities and Administration > Service Configurator > Local Service Configurator and double click on DAS.
4. Create a new data source using ODBC/ODBC (or ODBC/Oracle) as  Connectivity Type/ Database Type; "Select the name of the data source:".
5. Restart Services.
6. Import this OCE file in workspace to be available as a data source for BQY files.

ORACLE*NET (SQL*NET)

1. Install Oracle database client software on machine with DAS server and machine with IR Studio; Ensure tnsnames.ora file points to database to be queried.
2. Create an OCE file on Microsoft Windows using Interactive Reporting Studio (File menu > New... > A New Database Connection File > OK button) using Oracle Net/Oracle as "What connection software do you want to use?"/"What type of database do you want to connect to?"
3. Launch Hyperion > Reporting and Analysis > Utilities and Administration > Service Configurator > Local Service Configurator and double click on DAS.
4. Create a new data source using Oracle Net/Oracle as Connectivity Type/ Database Type; "Select the name of the data source:".
5. Restart Services.
6. Import this OCE file in workspace to be available as a data source for BQY files.