Configuring Non-DataDirect Drivers
Essbase recognizes the basic configuration information for DataDirect drivers, such as the name of the driver and whether the name and password are case-sensitive. You must provide configuration information for non-DataDirect drivers, or if you want to change the default settings for the DataDirect drivers that are distributed with Essbase.
To provide configuration information:
Create a configuration file (a text file) named esssql.cfg.
Place the file in the $ARBORPATH/bin directory on Essbase Server.
In a default installation, ARBORPATH is: EPM_ORACLE_INSTANCE/EssbaseServer/essbaseserver1
Note: | If you do not create a configuration file, Essbase uses default values that may prevent you from connecting to SQL databases. |