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 Enterprise Performance Management System Installation and Configuration Guide.