How to config ODBC driver for Sybase IQ for Linux

Background
Strategy have enabled Sybase IQ in Data Source Management. Currently, only ODBC is supported.

Since ODBC driver for Sybase IQ is not a Strategy-branded driver. The following steps show how to install Sybase IQ ODBC driver and configure Strategy.
 

Action

Install Sybase IQ ODBC Driver for Your Environment

1. Download Sybase IQ installer from SAP.
2. Run following command to start the installation:

tar -zxvf Linux64-iq1610_eval.tgz
cd Linux64-iq1610sp05_eval
./setup.bin

1. Choose Custom

1. Uncheck all options except SAP IQ Client.

NOTE: Installing SAP IQ ODBC Driver only is not enough to establish an ODBC connection. However, SAP IQ Client will have ODBC driver included.
The directory where ODBC driver for Sybase IQ is installed should always be accessible to Strategy 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.
 

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

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

IQDIR16='<IQDIR16>'

<IQDIR16>

ODBC.sh

# ODBC Driver for SAP Sybase IQ 16.x
#
IQDIR16='/opt/SybaseIQ/IQ-16_1'

if [ "${IQDIR16}" != '<IQDIR16>' ]; then
	export IQDIR16
	
	mstr_append_path PATH "${IQDIR16:?}/bin64"
	export PATH
	
	mstr_append_path LD_LIBRARY_PATH "${IQDIR16:?}"/lib64
	export LD_LIBRARY_PATH
fi

1. Save the

   ODBC.sh

   file and remove Write privileges from the file by entering the following command:

chmod a-w ODBC.sh

1. Restart I-Server

Configuration for DSNLess

1. In the Linux console windows, browse to Strategy

   HOME_PATH

   where

   HOME_PATH

   is the directory you specified as the home directory during Strategy installation.
2. Modify odbcinst.ini for Sybase IQ, the value of Driver and Setup should be the location of installed ODBC driver.

as is:

[Sybase IQ]
Driver=<IQDIR>/lib/libdbodbc12_r.so (if 15.4) or libdbodbc16_r.so (if 16.0)
Description=IQ ODBC Driver
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
Setup=<IQDIR>/lib/libdbodbc12_r.so (if 15.4) or libdbodbc16_r.so (if 16.0)
SQLLevel=0
DriverUnicodeType=1

[Sybase IQ]
Driver=/opt/SybaseIQ/IQ-16_1/lib64/libdbodbc17_r.so
Description=IQ ODBC Driver
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
Setup=/opt/SybaseIQ/IQ-16_1/lib64/libdbodbc17_r.so
SQLLevel=0
DriverUnicodeType=1

Configure for 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 SYBASEIQ16]. 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

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