Connecting to Databases while Executing a Transformation Map using JDBC
After you have defined and prepared your Transformation Map, you will execute it by including it in a Processing Sequence, probably along with other Activities, and then running the Processing Sequence. The Processing Sequence runs on your LANSA Composer server, and so:
- The database connection will be relative to (from) the LANSA Composer server computer
- Any required database connectivity components must be installed on the LANSA Composer server computer
When the Processing Sequence runs the Transformation Map, it does so by executing the Java code that was generated for the Transformation Map. If the Transformation Map includes any database components, the processing sequence controller prepares and provides a JDBC connection to the database(s).
The JDBC connection is prepared according to the Database Configuration that you provide as a parameter to the Transformation Map. You must define the Database Configuration with the correct details necessary to establish the particular database connection to be used.
Several example database configurations are supplied with LANSA Composer that illustrate how to connect to databases commonly used with LANSA Composer. You can copy and modify these example configurations or create your own from scratch.
Refer to the following topics for further information:
Database Connectivity Components and Drivers
Note: When your transformation map uses database components that connect to IBM DB2 for i5/OS database tables, LANSA Composer will remove the library qualifier from the generated Java code when you prepare the transformation map. You must setup your database configuration so that the required files can be found at run-time. Usually this is done by specifying the library name as part of the URL in the JDBC connection string. For more information, refer to Additional Considerations for Transformation Maps Using IBM DB2 for i5/OS.
About JDBC
JDBC stands for Java database connectivity. It is an API for the Java programming language that defines how a client may access a database. It provides methods for querying and updating data in a database. JDBC is oriented towards relational databases.
Major database vendors provide approved JDBC drivers for their database products. Refer to Database Connectivity Components and Drivers for further information.