Summary

Summary

LIC003 - Create a Transformation Map

• You have created a Transformation Map using Altova MapForce. If you haven't already done so, it is worthwhile working through the tutorials provided with MapForce to familiarize yourself with the features available in the mapping.

• You have prepared your Transformation map so it is available for use within Composer.

• You have identified how to connect to the database tables used in your Transformation Map with a Database Configuration. This identifies the JDBC connection that will be used by Composer when your Transformation Map is executed on your server.

• Reminder: The connect to the Database tables within MapForce uses an ODBC connect and connects from your PC client to your server.
  
  The connect to the Database tables when the Transformation Map is executed within Composer uses a JDBC connect and will execute on the server.

• LANSA Composer does not provide the database connectivity components (ODBC and JDBC drivers). You must ensure that you have the appropriate drivers for the databases you wish to use with Composer and documentation for the drivers, including how to setup the connection strings. Your database software vendor will normally provide these. For DB2 on an IBM i server you should refer to the IBM documentation for System i, DB2 and their JDBC driver.

• Refer to Additional Considerations for Transformation Maps Using IBM DB2 for i5/OS in the Composer online guide for more information. The database connections string provided in this example will not require that your physical files are journalled. If you require the file changes made via the transformation map to be journalled, you should refer to the information in the guide.