1 / 31

Overview: Transformation Maps

Overview: Transformation Maps. Understanding Transformation Maps Mapping Tool Database Connectivity Work with Transformation Maps Transformation Map Details Load IBM i File Definitions Objective: To understand the use of Transformation Maps and the Mapping Tool. Transformation Maps.

hume
Download Presentation

Overview: Transformation Maps

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Overview: Transformation Maps • Understanding Transformation Maps • Mapping Tool • Database Connectivity • Work with Transformation Maps • Transformation Map Details • Load IBM i File Definitions Objective: To understand the use of Transformation Maps and the Mapping Tool

  2. Transformation Maps • Enables powerful visual mapping • Defines how to transform or map data between disparate formats: • XML documents • EDI documents • Text files (for example, comma-separated values) • Web service functions • wide range of databases, including IBM DB2 Universal Database for IBM i

  3. Understanding Transformation Maps and Mapping Tool • Altova MapForce included for defining transformations. • For editing, MapForce provides LANSA Composer with the mapping tools to visually define connections between source and target components. • For preparation, LANSA Composer invokes MapForce to generate Java code for the map, and then LANSA Composer compiles the code. • When a Processing Sequence executes the Transformation Maps, it invokes the generated and compiled Java code via a LANSA Integrator service. • No Altova software is required at run-time.

  4. Mapping Tool

  5. Database Connectivity • Design time (Client): Must establish two types of database connectivity for use with the mapping tool: • ODBC or ADO connection from the LANSA Composer client computer running MapForce • JDBC connection from the LANSA Composer server computer. • Execution time (Server): Generated Java uses JDBC database connectivity - initiated from the server on which the transformation map executes. • Your responsibility to obtain, install and correctly configure database connectivity of components on client and server – usually from database vendor.

  6. Work with Transformation Maps • Filter Transformation Maps • Create or Copy a Transformation Map • Delete a Transformation Map • Review or Change a Transformation Map • Review Transformation Map Parameters • Display where a Transformation Map is used • Transformation Map Details • In addition, as with other such as activities, configurations and processing sequences, you can: • Define or Review Notes • Review Audit Details.

  7. Transformation Map Details • The details consist of basic identification and status information

  8. Create New Map

  9. Edit Transformation Map (1) • Edit transformation map uses the MapForce mapping tool • Windows must be logged into IBM i server to edit maps

  10. Edit Transformation Map (2) • MapForce is not designed exclusively for use with LANSA Composer • Refer to Composer documentation for supported functions

  11. Edit Transformation Map (3) • Insert source and target components • Try to use “universal” paths and connectivity so the map definition can be opened unchanged by other LANSA Composer users

  12. Insert XML Schema/File

  13. Insert Database

  14. Define Database Connection #1 • DB/2 Example

  15. Define Database Connection #2 • To define a new connection

  16. Define Database Connection #3 • Define ODBC Connection Any unique Name and suitable Description IBM i server name (domain name)

  17. Define Database Connection #4 Connection Options

  18. Define Database Connection #5 • Connect to DB/2 Database

  19. Define Database Connection #6 • Select Tables/Views to Insert Select library from dropdown Select file(s) Preview available

  20. Edit Transformation Map • Connect data items between source and target components:

  21. Edit Transformation Map • Connect data items between source and target components: • Some connections affect when data is output

  22. Save Transform Map

  23. Prepare Transformation Map • Prepare transformation map for use in LANSA Composer processing sequence

  24. Prepare Transformation Map • What does Prepare do? • Generates Java code • Compiles generated Java code • Jar file placed into map folder in JSM instance. e.g. • /LANSA_k12pgmlib/jsm/instance/composer/LIC/map(where LIC = partition) • Determines parameters required • e.g.: path to XML or text file • e.g.: database configuration to connect to source or target database

  25. Execute Transformation Map • Combine transformation maps with other activities and processing directives in a Processing Sequence

  26. Execute Transformation Map • Add transformationmap to processingsequence • Provide values for transformation map parameters • Variables or literals

  27. Run Transformation Map • Map may be run independently • Useful for testing

  28. Setup Database Configuration • When Transform used with a Processing Sequence: • Executed on server • Uses the generated JAR file • Uses JDBC to connect to database tables • Needs a Database Configuration

  29. Setup Database Configuration Your IBM i server name and library name

  30. Exercise: LIC003 Transformation Map • Create a Transformation Map

More Related