ODBC Driver for Informix 8 for Linux

The MicroStrategy ODBC Driver for Informix 8 is already installed in the INSTALL_PATH/lib directory.

The ODBC Driver for Informix 8 for Linux is a MicroStrategy-branded ODBC driver, but it is not accessible through the Connectivity Wizard.

However, the Informix Client Software Developer's Kit (CSDK) must be installed before you create a DSN. This software is not included in the MicroStrategy product suite installation and must be obtained through the database vendor or a third party. For information on installation, refer to the product documentation provided directly by the database vendor.

The following steps show how to configure the MicroStrategy ODBC driver for Informix 8.

To configure ODBC Driver for Informix 8

Begin by installing the Informix CSDK.

The directory where CSDK is installed should always be accessible to Intelligence Server.

The following set of instructions are divided into two sections: how to configure the environment and how to configure a DSN.

To Configure the Environment

In a Linux console window, browse to HOME_PATH where HOME_PATH is the specified home directory during installation.Browse to the folder env.
Add Write privileges to the ODBC.sh file by entering the following command:
```
chmod u+w ODBC.sh
```
Edit the ODBC.sh file and make the following changes:
- Provide the location of the directory where the Informix Client Software Developer's Kit (CSDK) is installed. The following definition is included:
  INFORMIXDIR='<INFORMIXDIR>'
  Replace this <INFORMIXDIR> placeholder with the directory path.
  Do not modify any other occurrences of <INFORMIXDIR> within odbc.sh.
- Provide the name of the Informix Server. The following definition is included:
  INFORMIXSERVER='<INFORMIXSERVER>'
  Replace this <INFORMIXSERVER> placeholder with the directory path.
  This value is chosen from the list in <INFORMIXDIR>/etc/sqlhosts.
  Do not modify any other occurrences of <INFORMIXSERVER> within odbc.sh.
Save the ODBC.sh file and remove Write privileges from the file by entering the following command:
```
chmod a-w ODBC.sh
```

To Configure a DSN

In a Linux console window, browse to HOME_PATH where HOME_PATH is the specified home directory during installation.
Open the odbc.ini.example file and search for the section that starts with [IBM INFORMIX]. Copy the section into the odbc.ini file.
Edit the DSN parameters Database, Servername, and Service. For information on the available parameters, refer to your third-party Teradata driver documentation. This can often be found along with the driver installation.
Save the odbc.ini file.

For details on these DSN parameters, refer to the product documentation provided directly by the database vendor.