1. Insert a Database component using either the Insert Database toolbar icon or by selecting Database from the Insert menu. To connect to the database you must identify or set up an ODBC connection.

    Altova MapForce runs on your PC and so, usually, the ODBC connection described here needs to connect from your PC to the server on which your application database resides.

    Altova MapForce displays a wizard and other panels that allow you to establish the ODBC connection suitable for your server.  You need to complete these panels according to the database and drivers you are using.  Connecting to databases in Transformation Maps in the Composer User Guide contains information and examples for IBM i and Microsoft SQL Server databases used in these tutorials:

    1. For the IBM i server, the database tables are supplied and installed as *FILE objects in your partition data library, for example, LICLICLIB.
      Refer to Example Database Connections for IBM i DB2 for examples of completing the ODBC connection to the tutorial database on your IBM i Server.

    2. For the Windows server, the database tables are supplied and installed in the database in which LANSA Composer was installed, in schema or collection named LC_DTA.
      Refer to Example Database Connections for Microsoft SQL Server for examples of completing the ODBC connection to the Windows server tutorial database when installed in an MS SQL Server database.
  2. The Select a Database, Connection Wizard will start. Select IBM DB2 and click Next to accept the IBM DB2 (JDBC) database.
  3. On the next dialog, select JDBC, and click the Next button. (Mapforce 2012 supports either JDBC or ODBC database connection while defining your map.)
  4. Then add the class path to the JT400.jar file in the JSM/jar directory e.g. \\<Servername>\ifs\lansa_licpgmlib\jsm\instance\jar\jt400.jar
  5. Enter user name and password.
  6. Add the JDBC connection string. E.g. jdbc:as400://<SERVER>/LICLICLIB;naming=system;errors=full;date format=iso;translate binary=true;:

    Click Connect to close the dialog.
  7.  When you have established your JDBC connection, the mapping tool allows you to choose the particular tables you wish to use in your transformation map:
  8. Select the arrow symbol next to the first library shown, to display all the IBM i libraries in a dropdown
  9. Scroll down to find the library containing the files you want to use in your transformation map. The tutorial database tables can be found in the library for the LANSA partition in which LANSA Composer was installed - for example, LC7LICLIB.

  10. Check the box next to files TUTORDH and TUTORDL to mark them as the files you wish to use in your Transformation Map..

    With a single file selected, the Preview button will display the file fields and data. In the example shown below, the file is currently empty:

    Click OK to close the dialog.  A database component representing the selected files is inserted in the workspace for the map.

When used to access IBM i DB2 database tables, the library from which you select the files is used only for the purpose of defining the transformation map.  LANSA Composer will remove the library qualifier from the generated Java code when you prepare the transformation map.  You must set up your database configuration such that the required files can be found in the desired library at run-time - you will do this in Step 7. Set up the Database Configuration .