`

Talend Data Mapper Essentials

Discover how Talend Data Mapper (TDM) can help you work with complex hierarchical data, for example, nested or looping structures. This product lets you define and execute transformations (called maps) between data records or documents. The input and output structures can be defined manually or imported from a variety of formats, such as XML, SWIFT, COBOL, CSV, EDI, XLS, and MySQL databases.

This course familiarizes participants with the most popular features of TDM.

The first day is dedicated to core content, and then participants select optional exercises that touch on COBOL, EDI, SWIFT, and database handling.

A private training session may include a mentoring session on use cases of interest to the attendees.

Duration 2 days (14 hours)
Target audience Java developers and software architects
Prerequisites Completion of Data Integration Basics, a general understanding of Java
Course objectives
After completing this course, you will be able to:
  • Import structures from existing files/databases or manually create them
  • Perform complex mappings and transformations between input and output structures
  • Harness the power of TDM from data integration Jobs or ESB routes
  • Work with complex standards like EDI and COBOL
  • Define and run test cases
Course agenda

Creating a simple XML to XML map

  • Creating a structure
  • Creating a map

Simple looping

  • Preparing the environment
  • Creating a new map
  • Testing a map
  • Adding a filter

Nested looping

  • Creating a new map
  • Testing a map

Aggregation looping

  • Creating and testing a map

Using more functions

  • Using a concatenation function
  • Using an if-then-else condition

Using the tHMap component

  • Using the tHMap component

Using context variables

  • Creating a DI Job
  • Using context variables

Using the cMap component

  • Creating a route
  • Importing an input XML structure
  • Creating an output JSON structure
  • Creating XML to JSON mapping
  • Configuring cMap and testing the route

Refactoring

  • Upgrading the output inheritance
  • Upgrading output mapping
  • Upgrading the input inheritance
  • Upgrading input mapping

Defining and running test cases

  • Setting up a test case