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.
To configure data sources on UNIX:
Open the $EPM_ORACLE_HOME/common/ODBC/Merant/x.x/odbc.ini file and add a data source description.
Copy the $EPM_ORACLE_HOME/common/ODBC/Merant/x.x/odbc.ini to $ESSBASEPATH/bin/.odbc.ini.
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
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 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.
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