Configuring Data Sources

In This Section:

About Configuring Data Sources

Configuring Data Sources on Windows

Configuring Data Sources on UNIX

About Configuring Data Sources

Before using SQL Interface to access data, you must configure the operating system of each data source and the driver required for each data source.

The Essbase installation provides DataDirect ODBC drivers.

Note:

The DataDirect ODBC drivers that connect to Oracle 11g databases are configured to enable multi-threaded connections and to disable uppercase conversion.

For detailed, driver-specific information on each DataDirect driver, see the DataDirect Connect for ODBC Reference. The location of this reference (typically within the /EPM_ORACLE_HOME/common/ ... /books/odbc/odbcref/ directory), varies depending upon the platform.

To configure non-DataDirect ODBC drivers, or to change the default settings for DataDirect ODBC drivers, see Using Non-DataDirect Drivers.

For a list of supported drivers, see Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.

To connect to Oracle databases using the native Oracle Call Interface (OCI), see Enabling Faster Data Loads with OCI and Oracle Essbase Administration Services Online Help.

Configuring Data Sources on Windows

On Windows, you use ODBC Administrator to configure data sources.

  To use ODBC Administrator to configure data sources:

  1. Select Start, then Administrative Tools, and then Data Sources (ODBC).

  2. Select or add a data source, and enter the required information about the driver.

    For detailed instructions, see the ODBC provider documentation.

Configuring Data Sources on UNIX

  To configure data sources on UNIX:

  1. Open the $EPM_ORACLE_HOME/common/ODBC/Merant/x.x/odbc.ini file and add a data source description.

  2. Copy the $EPM_ORACLE_HOME/common/ODBC/Merant/x.x/odbc.ini to $ESSBASEPATH/bin/.odbc.ini.

  3. Create a symbolic link to the $ESSBASEPATH/bin/.odbc.ini from the UNIX user home directory:

    ln -s $EPM_ORACLE_HOME/common/ODBC/Merant/x.x/odbc.ini /home/myfolder/.odbc.ini
  4. Verify that the odbc.ini file in the user home directory matches the odbc.ini file in $EPM_ORACLE_HOME/common/ODBC/Merant/x.x.

    If the files do not match, repeat step 1 through step 3.

odbc.ini File Updates

If you add data sources or change driver products or data sources, you may need to edit the odbc.ini file to update ODBC connection and configuration information, such as data source name and driver product name. Update instructions and requirements vary by platform.

Example: Updating odbc.ini for DB2

Assuming this scenario:

  • Essbase running on AIX

  • Connecting to a DB2 8.2 database named “tbc_data”

  • Using an ODBC data source (named “db2data”) that invokes the DataDirect 6.0 Wire Protocol driver

To edit the odbc.ini file, use the vi command and insert these example statements:

[ODBC Data Sources]
tbcdata=DB2 Source Data on AIX
...
[tbcdata]
Driver=/home/hyperion/hyperion/common/odbc/Merant/5.2/lib/ARdb222.so
Database=tbcdata
IpAddress=isaix7
TcpPort=50000

Note:

For detailed, driver-specific information on each DataDirect driver, see the DataDirect Connect for ODBC Reference. The location of this reference (typically within the /EPM_ORACLE_HOME/common/ ... /books/odbc/odbcref/ directory), varies depending upon the platform.