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:

  1. Create a configuration file (a text file) named esssql.cfg.

  2. 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.