Release Notes

|30.6 Configuring ODBC for the OLAP Starter Kit

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

• |On Windows systems, this file is in the Registry under |HKEY_LOCAL_MACHINE/SOFTWARE/ODBC. Use ODBC Data Source |Administrator to store information about how to connect to a relational data |source.
• |On UNIX systems, the installation program creates a model |odbc.ini file. To store information about how to |connect to a relational data source, edit the file using your preferred |editor. |

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

• |DB2 Universal Database Version 6 Database Client: DB2 Version 6 ODBC |drivers on Windows NT 4.0 SP5 or Windows 2000, AIX 4.3.3, |and Solaris Operating System 2.6, 7, or 8 (Sun OS 5.6, |5.7, or 5.8).
• |DB2 Universal Database 7.1 Database Client: DB2 Version 7 |ODBC drivers on Windows NT 4.0 SP5 or Windows 2000, AIX |4.3.3, and Solaris Operating System 2.6, 7, or 8 (Sun OS |5.6, 5.7, or 5.8).
• |Oracle 8.04 and 8i SQL*Net 8.0 Database Client: MERANT |3.6 ODBC drivers on Windows NT 4.0 SP5 or Windows 2000, AIX |4.3.3, Solaris Operating System 2.6, 7 or 8 (Sun OS |5.6, 5.7, or 5.8).
• |MS SQL Server 6.5.201 (no Database Client required): |MS SQL Server 6.5 ODBC drivers on Windows NT 4.0 SP5 or Windows |2000.
• |MS SQL Server 7.0 (no Database Client required): MS SQL |Server 7.0 ODBC drivers on Windows NT 4.0 SP5 or Windows |2000. |

|30.6.1 Configuring Data Sources on UNIX 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

|30.6.1.1 Configuring ODBC Environment Variables

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

|30.6.1.2 Editing the odbc.ini File

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

|30.6.1.3 Adding a Data Source to an odbc.ini File

1. |On the system running the OLAP Starter Kit servers, open the |odbc.ini file by using a text editor such as |vi.
2. |Find the section starting with [ODBC Data Sources] and add a new line with |the data source name and description, such as: mydata=data source |for analysis. To minimize confusion, the name of the data source |should match the name of the database in the RDBMS.
3. |Add a new section to the file by creating a new line with the name of the |new data source enclosed in brackets, such as: |[mydata].
4. |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 |ODBC driver information. Use the examples shown in the following |sections as a guideline to map to the data source on your RDBMS. Make |sure that the ODBC driver file actually exists in the location you specify for |the Driver= setting.
5. |When you have finished editing odbc.ini, save the file |and exit the text editor. |

|30.6.1.4 Example of ODBC Settings for DB2

|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

|30.6.1.5 Example of ODBC Settings for Oracle

|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

|30.6.2 Configuring the OLAP Metadata Catalog on UNIX Systems

|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

|30.6.3 Configuring Data Sources on Windows Systems

|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: |

1. |On the Windows desktop, open the Control Panel window.
2. |In the Control Panel window, perform one of the following steps: |
   1. |On Windows NT, double-click the ODBC icon to open the ODBC Data |Source Administrator dialog box.
   2. |On Windows 2000, double-click the Administrative Tools icon, |and then double-click the Data Sources (ODBC) icon to open the ODBC |Data Source Administrator dialog box. |
3. |In the ODBC Data Source Administrator dialog box, click the System |DSN tab.
4. |Click Add to open the Create New Data Source dialog box.
5. |In the driver list box of the Create New Data Source dialog box of ODBC |Administrator, select an appropriate driver, such as IBM DB2 ODBC |Driver, and click Finish to open the ODBC IBMDB2 Driver - Add |dialog box.
6. |In the ODBC IBM DB2 Driver - Add dialog box, in the Database |alias drop-down list, select the name of the database for your |relational source data (for example, TBC in the sample application).
7. |In the Description text box, type an optional description that |indicates how you use this driver and click Add. For |example, type the following words to describe the My Business database:

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

8. |Click OK to return to the ODBC Data Source Administrator dialog |box. The data source name you entered and the driver you mapped to it |are displayed in the System Data Sources list box on the |System DSN tab. |

|To edit configuration information for a data source: |

1. |Select the data source name and click Configure to open the |ODBC IBM DB2 - Add dialog box.
2. |Correct any information you want to change.
3. |Click OK twice to exit. |

|30.6.4 Configuring the OLAP Metadata Catalog on Windows Systems

|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: |

1. |On the desktop, open the Control Panel window.
2. |In the Control Panel window, perform one of the following steps: |
   1. |On Windows NT, double-click the ODBC icon to open the ODBC Data |Source Administrator dialog box.
   2. |On Windows 2000, double-click the Administrative Tools icon, |and then double-click the Data Sources (ODBC) icon to open the ODBC |Data Source Administrator dialog box. |
3. |In the ODBC Data Source Administrator dialog box, click the System |DSN tab.
4. |Click Add to open the Create New Data Source dialog box.
5. |In the driver list box of the Create New Data Source dialog box of ODBC |Administrator, select an appropriate driver, such as IBM DB2 ODBC |Driver, and click Finish to open the ODBC IBMDB2 Driver - Add |dialog box.
6. |In the ODBC IBM DB2 Driver - Add dialog box, in the Database |alias drop-down list, select the name of the database for your OLAP |Metadata Catalog (for example, TBC_MD in the sample application). The |name of the selected database is automatically displayed in the Data |Source Name text box.
7. |If you want to change the name of the data source, select the name |displayed in the Data Source Name text box, type a new name to |indicate how you use this driver, and click Add. For |example, you might type the following name to indicate that you are using the |driver to connect to the first OLAP Metadata Catalog:

   |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 

8. |In the Description text box, enter a description that indicates |how you use this driver. For example, you might type the following |words to describe the OLAP Metadata Catalog:

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

9. |Click OK to return to the ODBC Data Source Administrator dialog |box. The data source name you entered and the driver you mapped to it |are displayed in the System Data Sources list box on the |System DSN tab. |

|To edit configuration information for a data source: |

1. |Select the data source name and click Configure to open the |ODBC IBM DB2 - Add dialog box.
2. |Correct any information you want to change.
3. |Click OK twice to exit. |

|30.6.5 After You Configure 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.