UNIX Systems - Connect_ETL - 9.13

Connect Default Driver Manager

The Connect install and databaseSetup programs assist you in creating unixODBC data sources.

Alternatively, you can define ODBC data sources manually. The ODBC data source manager provides support for ODBC data sources through two configuration files, odbcinst.ini and odbc.ini that are located in the directory <connect_install>/etc. This directory also contains templates and examples of the configuration files. To change the location of the configuration files, export the ODBCSYSINI environment variable to the new directory where both files reside.

The files need to be set up appropriately before you can access databases via ODBC. This is a one-time configuration step, similar to defining system data sources on Windows. 

• <connect_install>/etc/odbcinst.ini: This file contains DBMS specific and system specific driver definitions. Configuring this file corresponds to selecting the DBMS driver while adding a data source on a Windows system.
• <connect_install>/etc/odbc.ini: This file contains DBMS specific data source definitions, based on the drivers defined previously in the odbcinst.ini file. Configuring this file corresponds to following DBMS driver specific instructions while adding a data source on a Windows system.

If you want to remove a data source, delete the section that corresponds to that data source from the odbc.ini file. A section starts with the data source name enclosed by [], and ends at the beginning of the next section or at the end of the file.

64 Bit ODBC

The ODBC headers and libraries that are shipped with the Microsoft Data Access Components (MDAC) 2.7 Software Development Kit (SDK) have changed from earlier versions of ODBC to support 64-bit platforms. Since the ODBC driver for a specific DBMS and the unixODBC libraries are built separately, there may be an incompatibility in the definition of SQLLEN variable which was specifically introduced for ODBC access on 64-bit UNIX platforms. On 64-bit UNIX platforms, Connect assumes that the ODBC driver is 64-bit compliant and defaults the value of SQLLEN variable to 8 bytes. You can overwrite this default, that is, the DMXSQLLEN value corresponding to the specific DBMS driver, in the odbcinst.ini file.

Use Other ODBC Driver Manager

By default, Connect uses the shipped unixODBC driver manager to load all ODBC drivers. Some ODBC drivers, such as Teradata ODBC driver, may not work with it. You can tell Connect to use a different ODBC driver manager by specifying the option DMXDBCDRIVERMANAGER=No under the driver section in the odbcinst.ini file. You need to make sure that your ODBC driver manager library path (e.g. /usr/odbc/lib for Teradata V12) is in the system library path (e.g. LD_LIBRARY_PATH on Linux) so that it is loaded first by Connect. In addition, you may need to export the ODBCINI environment variable with the absolute path to the file odbc.ini (e.g. export ODBCINI=<connect_install>/etc/odbc.ini). Refer to your DBMS documentation for details on this requirement.