The configuration file must contain the driver file names (DriverName), and an optional description (Description), the value for which must be enclosed in double quotation marks (the default value for Description is " "); it may contain additional keywords, the values for which are 0 or 1, as shown in Table 1.
Keywords and values must be separated by at least one space, and the set of keywords and values for each driver must be enclosed within brackets ( [ ] ).
Different drivers may require additional values. See the driver documentation for specific information.
In the following example, the first entry for Oracle changes the default settings for the DataDirect drivers distributed with Essbase. The second entry is for Microsoft SQL Server, a non-DataDirect driver.
[ Description "Oracle Wire Protocol" DriverName ARORA UpperCaseConnection 0 UserId 1 Password 1 Database 1 SingleConnection 0 IsQEDriver 1 ] [ Description "Microsoft SQL Server 32-bit" DriverName SQLSRV32 UpperCaseConnection 0 UserId 1 Password 1 Database 1 SingleConnection 0 IsQEDriver 0 ] [ Description "Oracle BI Server" DriverName libnqsodbc UpperCaseConnection 0 UserId 1 Password 1 Database 1 SingleConnection 1 ConvertUTF16toUTF8 1 ]
Defaults apply to values that are not specified. The defaults applied within configuration files differ from the Essbase default values that apply if no esssql.cfg file exists.
Table 1. Configuration File Keywords and Values for Non-DataDirect Drivers
Note: | The DataDirect ODBC drivers that connect to Oracle 11g databases are configured to enable multi-threaded connections and to disable uppercase conversion. To enable multi-threaded connections for the SQL Server Wire Protocol driver, see Performing Multiple SQL Data Loads in Parallel to Aggregate Storage Databases. |