Database Connectivity Components and Drivers
When you insert a database component into a Transformation Map you must have the necessary ADO or ODBC database connectivity components installed on your client workstation. You define the map through the mapping tool and if you do a trial execute of the map in the mapping tool, you will use the selected ADO or ODBC database connector for the database connectivity.
When you execute the map in a LANSA Composer Processing Sequence, the map will use JDBC database connectivity components installed on your LANSA Composer server computer. The details for the JDBC database connection are provided by means of a Database Configuration.
LANSA Composer supplies neither the ADO or ODBC (client-side) nor the JDBC (server-side) database connectivity components. You must obtain and install these components yourself for use with LANSA Composer – usually these components are supplied by your database software vendor.
Most vendors will provide the requisite drivers on their installation CDs, as well as allow you to download them from their web site. In many case these drivers will be available at no charge. Most databases will need you to use a driver that is of exactly the same version as the database. Therefore, ensure that you have access to the correct driver for the version and type of database that you wish to connect to. Vendor web sites are the best source for this information.
Some useful sites are as follows for:
Note: For many databases, drivers can also be obtained from third party sources.
The IBM Toolbox for Java comes with two JDBC drivers for the IBM i , which can be used for accessing DB2 data:
- IBM Toolbox for Java JDBC Driver - this is a Type 4 driver, that makes direct socket connect to the database host server
- IBM Developer Kit for Java JDBC Driver - this is a Type 2 driver, and makes native method calls to the SQL CLI (Client Level Interface).
JDBC driver components need to be installed either into the jar directory of the LANSA Integrator instance or into a location that is accessible through the classpath.