You configure data source names (DSNs) for data source databases in an odbc.ini file. In one section of the file, add a name and description for the ODBC data source. In a separate, newly created section of the file, provide the ODBC driver path, file name, and all other required driver settings.
The EPM System installation program installs a sample odbc.ini file in the products/common/ODBC/Merant/6.0 and products/common/ODBC-64/Merant/6.0directory. The file contains generic ODBC connection and configuration information for supported ODBC drivers. Use the file as a starting point to map the ODBC drivers that you use to the data source databases.
Tip: | The procedure in this section shows you how to configure a DSN by manually editing the odbc.ini file. |
To add an ODBC data source to an odbc.ini file:
On the computer where the EPM System common components are installed, locate and open the appropriate odbc.ini file.
Use the vi $ODBCINI command to edit the odbc.ini file and statements:
32-bit:
$EPM_ORACLE_HOME/common/ODBC/Merant/6.0/odbc.ini64-bit:
$EPM_ORACLE_HOME/common/ODBC-64/Merant/6.0/odbc.iniLocate the section starting with [ODBC Data Sources] and add a new line with the data source name and description; for example:
mydata=data source for analysis
Add a new section to the file by creating a new line with the new DSN enclosed in brackets; for example:
[mydata]
On the lines following the data source name, add the full path and file name for the ODBC driver required for this data source and any other required database information.
Use the examples shown in the following sections as guidelines for specific RDBMSs.
Note:
Ensure that the ODBC driver file actually exists in the location that you specify for the “Driver=” setting.
When you finish editing odbc.ini, save the file and exit the text editor.
Configuration Verification Tips
You can run ivtestlib (32-bit) or ddtestlib (64-bit) to verify that the environment is set to run the correct ODBC driver file.
For example, run ivtestlib and paste the path and file name that follow Driver= in the odbc.ini file that you edited.
In the odbc.ini file, under the [ODBC] heading, verify that these parameters setting are specified as indicated:
InstallDir—The full path to the driver installation directory. This setting should not contain a variable descriptor, such as <installDir>.
TraceDll—The full path to the /lib directory. This setting should not contain a variable descriptor, such as <traceDll>.
Use the examples shown in the following sections as guidelines for specific RDBMSs.
For information about the odbc.ini file and the ODBC driver settings for each RDBMS or flat file data source, see the DataDirect Connect ODBC Reference in the products/common/ODBC/Merant/6.0/books or products/common/ODBC-64/Merant/6.0 directory. For information about vendor-supplied ODBC driver settings, refer to the installation documentation for the vendor-supplied ODBC drivers.
Flat File Data Sources: In Essbase Studio, ODBC configuration is not required for flat file data sources.