LIC003 Create a Transformation Map

LIC003 - Create a Transformation Map

Objectives

• To introduce you to creating a Transformation Map.
  The map will input an xml file and insert the data into a database table.

• To prepare the map for use within Composer

• To set up the database Configurations for the map so the database may be accessed at execution time by the Processing Sequence.

Before You Begin

In order to complete this tutorial, you should have completed the following steps:

• LIC001 - Introduce Composer Client & Validate Environment

• LIC002 - Create a Processing Sequence

Steps

To achieve these objectives, you will complete the following:

• Step 1. Create a Transformation Map Registration

• Step 2. Edit the Transformation Map

• Step 3. Identify the xml source for the Transformation Map

• Step 4. Identify the Target Database for the Transformation Map

• Step 5. Map the Input xml to the Target Database

• Step 6. Prepare your Transformation Map for use within Composer

• Step 7. Set up the Database Configuration

• Summary

Check System Settings

Before you attempt to create and use a Transformation Map, you should check that the values of the following system settings are appropriate for your environment:

• Server Network path: this value defines the prefix that the LANSA Composer client software uses to access files on the server.  It is combined with the value specified for Map definitions and so must be correct for your environment in order for the Map definitions setting to be effective.

• Map definitions: this should specify the location on your server where Transformation Map definitions will be stored and accessible for all LANSA Composer users

• Map generate and compile:. This specifies a file system location where intermediate files will be created when the maps are prepared.  Usually the default behavior (to use the Windows temporary directory for the user) is acceptable.

• LANSA Integrator (JSM) instance:  this specifies the path from the client to the JSM Instance folder on the server. This controls where the compiled Java archive file for a Transformation Map is placed when the Transformation Map is Prepared (it is placed in the \composer\LIC\map sub-folder of the path specified here, where LIC is the LANSA partition).

Refer to System Settings for further information.

Note: You must login to the IBM i server in Windows Explorer in order for these mappings to work.