IBM Transformation Extender Fundamentals



IBM Transformation Extender performs transformation and routing of data from source systems to target systems in batch and real-time environments. Through a combination of lectures and hands-on lab exercises, this course will teach you how to use the IBM Transformation Extender Design Studio to define, transform, and route business objects and complex flat file data. Specific topics discussed include an overview of the IBM Transformation Extender product and its features, creating and deploying maps, working with a resource registry, retrieving/updating data from database. Hands-on exercises give you practical experience with skills such as optimizing maps, handling and logging errors, defining data, and indexing output.


Developers, Programmers, and Business Analysts

Learning Objectives

After completing this course, you will be able to:

  • Define workspaces and projects that use the Eclipse workbench
  • Use the Type Designer to define data structures, data properties, and data components as type trees
  • Validate type trees to ensure that they accurately describe the data
  • Transform flat files that use the Map Designer
  • Use type design and mapping techniques to improve validation and throughput
  • Use the Resource Registry to improve portability between operating environments
  • Implement error handling
  • Optimize map performance

Unit 1. IBM Transformation Extender product overview


Unit 2. Eclipse workbench fundamentals

  • Exercise: Defining workspaces and projects


Unit 3. Defining the data

  • Exercise: Defining the data


Unit 4. Defining properties

  • Exercise: Defining item and group properties


Unit 5. Defining components

  • Exercise: Completing the type tree


Unit 6. Validating data definitions

  • Exercise: Creating a validation map


Unit 7. Type Tree Importer

  • Exercise: Using the COBOL Copybook Importer to create the Type Tree


Unit 8. Building more validation into type tree

  • Exercise: Adding restriction lists and component rules
  • Exercise: Validation concept review


Unit 9. More about mapping

  • Exercise: Indexing an output


Unit 10. Functional maps

  • Exercise: File to file transformation
  • Exercise: Using ASFUNCTION with functional map


Unit 11. More efficient mapping

  • Exercise: Extracting data by using the EXTRACT function and partitions
  • Exercise: Using the COUNT and SUM functions
  • Exercise: Creating a second output file
  • Exercise: Mapping from COBOL to XML


Unit 12. Error handling

  • Exercise: Error handling and logging


Unit 13. Resource Registry

  • Exercise: Using the Resource Registry


Unit 14. Database Interface Designer basics

  • Exercise: Creating a database query file
  • Exercise: Implementing database lookup and inserting data
  • Exercise: Retrieving data from database


Unit 15. Map optimization

  • Exercise: Using the Map Profiler
  • Exercise: Configuring card and map settings

Unit 16. Map deployment

Exercise: Generating platform-independent compiled maps