General Page
This TechNote contains the instructions on using the DataDirect ODBC driver with the IBM Transformation Extender, version 9.0.0.4, for both—customers who are migrating a DataDirect ODBC driver from any of the earlier versions of the 9.0.0.x series to the 9.0.0.4 one as well as customers who are altogether installing a new DataDirect ODBC driver to use with version 9.0.0.4.
About this task
The IBM Transformation Extender, version 9.0.0.4, has the DataDirect ODBC driver removed. However, customers working on the AIX platform wanting to use the DataDirect ODBC driver with version 9.0.0.4—can now do so as the 9.0.0.4 version has been enhanced to support the use of DataDirect on the AIX platform.
Before you begin
Note: DataDirect included with 9.0.0.x will only be supported until April 29, 2020.
Only customers using the AIX operating system can use the DataDirect ODBC driver with IBM Transformation Extender, version 9.0.0.4.
Procedure for migration
If you wish to continue using DataDirect from any of the earlier versions of the 9.0.0.x series, then follow the steps below to migrate the drivers to the 9.0.0.4 release.
- Copy the odbc_drivers folder from the prior ITX v9.0.0.x installation directory, to the ITX v9.0.0.4 installation directory.
- Under odbc_drivers folder, open odbcinst.ini file and modify the paths to point to the ITX v9.0.0.4 install directory.
- Under odbc_drivers folder, open odbc.ini, and create a stanza for the database you will be using for ODBC and under the stanza enter all necessary information needed for the ODBC database one will be using, ensure paths use ITX v9.0.0.4 install location.
- In the root of the install, open setup script file and modify the path for odbc to point to the install of your ITX v9.0.0.4 install.
- Run . ./setup from your install of ITX v9.0.0.4.
- Type following at command prompt export LD_PRELOAD=$LD_PRELOAD:<explicit path location of ITX v9.0.0.4 install>/ODBC_driver/lib/libodbc.so
-
Now you can execute any maps using ODBC Database Data Direct drivers. One can view the .dbl file to verify the correct Data Direct drivers library is being used.
Procedure for installing a new DataDirect ODBC driver
If you are installing a new Direct ODBC MS SQL Server ITX v9.0.0.4 on AIX, then follow the steps below.
- Follow steps 1-4 from the earlier section on Procedure for migration.
- Create odbc.sh under odbc_drivers folder and change the install path for ITX v9.0.0.4.
- Under the root of your install open setup. Change paths to point to odbc_drivers folder and the last statement to execute odbc.sh file within the if statement (ie . ${DTX_HOME_DIR}/odbc_drivers/odbc.sh).
- Create a korn shell script file with the following info inside:
-
mkdir odbc_workdir cd odbc_workdir cp $DTX_HOME_DIR/odbc_drivers/lib/libodbc.a . ar -X64 -x libodbc.a #to extract odbc.so mv odbc.so libodbc.so.2 #to rename DD odbc.so to expected libodbc.so.2 ar -X64 rcs libodbc.a libodbc.so.2 #to create a new archive libodbc.a that has renamed DD odbc.so in mv $DTX_HOME_DIR/odbc_drivers/lib/libodbc.a $DTX_HOME_DIR/odbc_drivers/lib/libodbc.a.orig # create a backup of original DD cp libodbc.a $DTX_HOME_DIR/odbc_drivers/lib/libodbc.a - Set script file to 777 permission.
- Execute script (ie ./<script file name>).
- Exit from OS.
- Log back into the platform.
- Run . ./setup from ITX v9.0.0.4 install.
Results
The environment is now set up to run ODBC on a platform using data direct driver.
Note: You can view the .dbl file to verify that the correct DataDirect drivers' library is being used.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSD8","label":"IBM Transformation Extender"},"Component":"DataDirect ODBC Driver","Platform":[{"code":"PF002","label":"AIX"}],"Version":"9.0.0.4","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
10 August 2022
UID
ibm11126311