Editing the odbc.ini File

You configure data source names for a Data Source database or OLAP Metadata Catalog database 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 Integration Services installation program installs a sample odbc.ini file in the products/common/ODBC/Merant/6.0 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 Data Source database and OLAP Metadata Catalog database.

IBM DB2: For each server computer to which you are connecting using the DataDirect Wire Protocol driver, you must create a bind package. DataDirect supplies a program that creates the bind package for you. See Creating IBM DB2 Bind Packages for DataDirect Wire Protocol Driver Connections for instructions on using the DataDirect-supplied program.

Teradata: When configuring a data source name, the data source description must be set to tdata.sl (HP-UX) or tdata.so (AIX and Solaris). Specific examples for AIX, HP-UX, and Solaris operating systems are shown in Examples of ODBC Settings for Teradata.

Tip:

The procedure in this section shows you how to configure a data source name by manually editing the odbc.ini file.

Note:

If you use a file other than the odbc.ini file (located by default in products/common/ODBC/Merant/6.0), be sure to set the ODBCINI environment variable to the name of the file that you use.

  To add an ODBC data source to an odbc.ini file:

  1. On the computer running Integration Server, open the odbc.ini file by using a text editor such as vi.

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

    To minimize confusion, the data source name can match the name of the database in the RDBMS.

  3. Add a new section to the file by creating a new line with the new data source name enclosed in brackets; for example:

    [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 guidelines for specific RDBMSs.

    Note:

    Ensure that the ODBC driver file actually exists in the location that you specify for the Driver= setting.

  5. Add a new section to the file by creating a new line with ODBC enclosed in brackets; for example:

    [ODBC]

  6. Under the [ODBC] heading, add the full path to the location where the /lib and /messages directories are contained.

    Use the examples shown in the following sections as guidelines for specific RDBMSs.

  7. When you finish editing odbc.ini, save the file and exit the text editor.

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 PDF file and the Readme files in the products/common/ODBC/Merant/6.0/books directory. For information about vendor-supplied ODBC driver settings, refer to the installation documentation for the vendor-supplied ODBC drivers.

Flat File Data Sources: If you are using a flat file data source, you must define the structure of the text files in your data source in a QETXT.INI file. The process for creating the QETXT.INI file for UNIX operating systems is described in the DataDirect Connect ODBC Reference in the PDF file in products/common/ODBC/Merant/6.0/books.