Step 1: Installing ODBC Driver
[root@ogg-1 unixODBC-2.3.2] export CFLAGS="-DBUILD_REAL_64_BIT_MODE"
[root@ogg-1 unixODBC-2.3.2] ./configure --prefix=/home/informix/unixODBC-2.3.2
--sysconfdir=/etc --enable-gui=no --enable-drivers=no
[root@ogg-1 unixODBC-2.3.2]# make
[root@ogg-1 unixODBC-2.3.2]# make install
After the success install, you will have a /home/informix/unixODBC-2.3.2/bin directory that contains isql and a lib directory with libodbc.so library (the driver manager). Older ODBC drivers are still looking for an libodbc.so.1.0.0 ODBC Driver Manager library, so I just add a symbolic link to the lib directory "/home/informix/unixODBC-2.3.2/lib":
ln -s libodbc.so.2.0.0 libodbc.so.1
Then, you can setup the environment variables to make sure the correct odbc.ini configuration and ODBC libraries are picked up by Oracle GoldenGate.
export ODBCINI=/etc/odbc.ini
export LD_LIBRARY_PATH=/home/informix/unixODBC-2.3.2/lib:$LD_LIBRARY_PATH
export PATH=/home/informix/unixODBC-2.3.2/bin:$PATH
Step 2: Defining the ODBC Data Sources
ODBC.ini files contain the definitions of the data sources. For each data source, the name is embraced by square brackets, and the properties follow on subsequent lines and use PropertyName = PropertyValue. For example,
[syscdcv1]
Driver=/dbase/informix/informix115FC8/CSDK410FCW1/lib/cli/iclit09b.so
Description=IBM INFORMIX ODBC DRIVER
Database=syscdcv1
LogonID=informix
pwd=informix123
Servername=ictrn_prd_mirror
;--------------------------------------------------------------------
; IBM INFORMIX ODBC Sample File
;
; File: odbc.ini
;
;--------------------------------------------------------------------
[ODBC Data Sources]
syscdcv1=IBM INFORMIX ODBC DRIVER
sourcedb=IBM INFORMIX ODBC DRIVER
targetdb=IBM INFORMIX ODBC DRIVER
;
; Define ODBC Database Driver's Below - Driver Configuration Section
;
[syscdcv1]
Driver=/home/informix/ifx1170/lib/cli/iclit09b.so
Database=syscdcv1
LogonID=informix
pwd=informix123
Servername=ol_informix1170
CursorBehavior=0
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/home/informix/ifx1170/lib/esql/igo4a304.so
[sourcedb]
Driver=/home/informix/ifx1170/lib/cli/iclis09b.so
Description=IBM INFORMIX ODBC DRIVER
Database=sourcedb
LogonID=informix
pwd=informix123
Servername=ol_informix1170
CursorBehavior=0
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/home/informix/ifx1170/lib/esql/igo4a304.so
[targetdb]
Driver=/home/informix/ifx1170/lib/cli/iclis09b.so
Description=IBM INFORMIX ODBC DRIVER
Database=targetdb
LogonID=informix
pwd=informix123
Servername=ol_informix1170
CursorBehavior=0
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/home/informix/ifx1170/lib/esql/igo4a304.so
[superstores]
Driver=/home/informix/ifx1170/lib/cli/iclis09b.so
Database=superstores_demo
Servername=ol_informix1170
CursorBehavior=0
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/home/informix/ifx1170/lib/esql/igo4a304.so
[ODBC]
;uncomment the below line for UNICODE connection
UNICODE=UTF-8
;UNICODE=UCS-4
;
; Trace file Section
;
Trace=0
TraceFile=/tmp/odbctrace.out
InstallDir=/home/informix
TRACEDLL=idmrs09a.so
Add content in $INFORMIXDIR/etc/odbcinst.ini to /etc/odbcinst.ini.
;---------------------------------------------------------------------------
; IBM INFORMIX ODBC Sample File
;
; File: odbcinst.ini
;
;---------------------------------------------------------------------------
[ODBC Drivers]
IBM INFORMIX ODBC DRIVER=Installed
[IBM INFORMIX ODBC DRIVER]
Driver=/home/informix/ifx1170/lib/cli/iclit09b.so
Setup=/home/informix/ifx1170/lib/cli/iclit09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.51
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y
Step 3: Testing the ODBC Connection
setenv PATH ${INFORMIXDIR}/bin:${PATH}
setenv LIBPATH $INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$LIBPATH
isql -v syscdcv1
You're connected to the database and can for example query the customer table:
[informix@ogg-1 bin]$ isql -v sourcedb informix informix123 +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> select * from customer +-------------+--------------+--------------+-------------+--------------+--------------+--------------+ | customer_num| customer_type| customer_name| customer_loc| contact_dates| cust_discount| credit_status| +-------------+--------------+--------------+-------------+--------------+--------------+--------------+ | 501 | W | | 1 | | 0.00000 | R | | 502 | W | | 2 | | 0.07500 | P | | 503 | W | | 3 | | 0.05000 | R | | 504 | W | | 4 | | 0.02000 | P |