MicroStrategy ONE

ODBC Driver for Sybase Adaptive Server IQ for Linux

ODBC driver for Sybase Adaptive Server IQ is not a MicroStrategy-branded driver. The following steps show how to configure ODBC driver for Sybase Adaptive Server IQ.

To Configure ODBC Driver for Sybase Adaptive Server IQ

Begin by installing ODBC Driver for Sybase Adaptive Server IQ for the correct operating system. For information on installation, refer to the Installation and Configuration Guide provided by Sybase.

The directory where ODBC driver for Sybase Adaptive Server IQ is installed should always be accessible to MicroStrategy Intelligence Server.

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

To Define the Location of Your Environment

  1. In a Linux console window, browse to HOME_PATH, where HOME_PATH is the directory you specified as the Home Directory during installation. Browse to the folder env.
  2. Add Write privileges to the ODBC.sh file by entering the following command:
    chmod u+w ODBC.sh
  3. Edit the ODBC.sh file and add the location of the directory where the ODBC Driver for Sybase Adaptive Server IQ is installed. Within the ODBC.sh file, the following definitions are included:

    IQDIR15='<IQDIR15>'

    IQDIR16='<IQDIR16>'

    Replace the <IQDIR15> and <IQDIR16> placeholders, depending on your version of Sysbase Adaptive Server IQ, with the directory path.

    Do not modify any other occurrences of <IQDIR15> or <IQDIR16> within odbc.sh.

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

  1. In a Linux console window, browse to HOME_PATH where HOME_PATH is the directory you specified as the home directory during installation.
  2. Open the odbc.ini.example file and find the section that starts with [SAP SYBASEIQVersion], where Version is the version of Sybase Adaptive Server IQ. Copy the section into the odbc.ini file.
  3. Edit the DSN parameters EngineName, DatabaseName and CommLinks, and modify the value of the Driver with the location of the directory where the ODBC Driver for Sybase Adaptive Server IQ is installed. For information on the available parameters, refer to your third-party Sybase driver documentation. This can often be found along with the driver installation.
  4. Save the odbc.ini file.

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