IBM DB2 OLAP Starer Kit 7.2 requires an ODBC.ini file for operation of Open Database Connectivity (ODBC) connections from OLAP Integration Server to the relational data source and to the OLAP Metadata Catalog.
The ODBC.ini file is available in ODBC software packages and is included with Microsoft Office software. Additional information about applications that install ODBC drivers or the ODBC Administrator is available at the following web site: http://support.microsoft.com/.
For Oracle users on AIX machines: To configure ODBC for Oracle, you must update the ODBC.ini file to point to the MERANT 3.6 drivers.
In Version 7.2, the OLAP Starter Kit manages ODBC connections to the relational data source and to the OLAP Metadata Catalog. To accommodate these ODBC connections, the OLAP Starter Kit uses ODBC drivers on Windows NT 4.0, Windows 2000, AIX, and Solaris systems.
On AIX and Solaris systems, you must manually set environment variables for ODBC and edit the odbc.ini file to configure the relational data source and OLAP Metadata Catalog. Make sure you edit the odbc.ini file if you add a new driver or data source or if you change the driver or data source.
If you will be using the DB2 OLAP Starter Kit on AIX or Solaris systems to access Merant ODBC sources and DB2 databases, change the value of the "Driver=" attribute in the DB2 source section of the .odbc.ini file as follows:
AIX: The Driver name is /usr/lpp/db2_07_01/lib/db2_36.o
Sample ODBC source entry for AIX:
[SAMPLE] Driver=/usr/lpp/db2_07_01/lib/db2_36.o Description=DB2 ODBC Database Database=SAMPLE
Solaris Operating Environment: The Driver name is /opt/IBMdb2/V7.1/lib/libdb2_36.so
Sample ODBC source entry for Solaris Operating Environment:
[SAMPLE] Driver=/opt/IBMdb2/V7.1/lib/libdb2_36.so Description=DB2 ODBC Database Database=SAMPLE
On UNIX systems, you must set environment variables to enable access to ODBC core components. The is.sh and is.csh shell scripts that set the required variables are provided in the Starter Kit home directory. You must run one of these scripts before using ODBC to connect to data sources. You should include these scripts in the login script for the user name you use to run the OLAP Starter Kit.
To configure a data source in an odbc.ini file, you must add a name and description for the ODBC data source and provide the ODBC driver path, file name, and other driver settings in a separate section that you create for the data source name. The installation program installs a sample odbc.ini file in the ISHOME directory. 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 relational data source and OLAP Metadata Catalog.
If you use a different file than the odbc.ini file, be sure to set the ODBCINI environment variable to the name of the file you use.
The following example shows how you might edit odbc.ini to connect to a relational data source, db2data, on DB2 Universal Database Version 6.1 on AIX, using an IBM DB2 native ODBC driver. In the vi editor, use the $ODBCINI command to edit the odbc.ini and insert the following statements:
[ODBC Data Sources] db2data=DB2 Source Data on AIX ... [db2data] Driver=/home/db2inst1/sqllib/lib/db2.o Description=DB2 Data Source - AIX, native
Here is an example of how you might edit odbc.ini to connect to a relational data source, oradata, on Oracle Version 8 (on Solaris Operating Environment), using a MERANT Version 3.6 ODBC driver. In this example, LogonID and Password are overridden with the actual values used in the OLAP Starter Kit user name and password.
[ODBC Data Sources] oradata=Oracle8 Source Data on Solaris ... [myoracle] Driver= /export/home/users/dkendric/is200/odbclib/ARor815.so Description=my oracle source
Configuring an OLAP Metadata Catalog on AIX and Solaris systems is similar to configuring a data source. For the OLAP Metadata Catalog database, add a data source name and section to the odbc.ini file, as described in 30.6.1.2, Editing the odbc.ini File. No other changes are required.
You must create an OLAP Metadata Catalog database in a supported RDBMS before configuring it as an ODBC data source.
Here is an example how you might edit odbc.ini to connect to the OLAP Metadata Catalog, TBC_MD, on DB2 Version 6.1 (on Solaris Operating Environment), using a native ODBC driver:
[ODBC Data Sources] ocd6a5a=db2 v6 ... [ocd6a5a] Driver=/home/db2instl/sqllib/lib/db2.0 Description=db2
To configure a relational data source on Windows NT or Windows 2000 systems, you must start ODBC Administrator and then create a connection to the data source that you will use for creating OLAP models and metaoutlines. Run the ODBC Administrator utility from the Windows Control Panel. The following example creates a DB2 data source; the dialog boxes for other RDBMSs will differ.
To configure a relational data source with ODBC Administrator, complete the following steps:
Customers, products, markets
You might type the following words to describe the sample application database:
Sample relational data source
The descriptions help to identify the available data sources for your selection when you connect from OLAP Starter Kit Desktop.
To edit configuration information for a data source:
To configure an OLAP Metadata Catalog on Windows NT or Windows 2000, start ODBC Administrator and then create a connection to the data source that contains the OLAP Metadata Catalog database.
The following example creates a DB2 data source; dialog boxes for other RDBMSs will differ. To create a data source for the OLAP Metadata Catalog, complete the following steps:
OLAP Catalog first
You would type the following name to indicate that you are connecting to the sample application OLAP Metadata Catalog database:
TBC_MD
My first models and metaoutlines
You might type the following words to describe the sample application OLAP Metadata Catalog database:
Sample models and metaoutlines
The descriptions help you to identify the catalog that you want to select when you connect to the OLAP Metadata Catalog from the OLAP Starter Kit Desktop.
To edit configuration information for a data source:
After you configure the relational data source and OLAP Metadata Catalog, you can connect to them from the OLAP Starter Kit. You can then create, modify, and save OLAP models and metaoutlines.
The SQL Server ODBC driver may time out during a call to an SQL Server database. Try again when the database is not busy. Increasing the driver time-out period may avoid this problem. For more information, see the ODBC documentation for the driver you are using.
For more information on ODBC connection problems and solutions, see the OLAP Integration Server System Administrator's Guide.