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, 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.

Duration2 days (14 hours)
Target audience Java developers and software architects
PrerequisitesCompletion of Data Integration Basics or Introduction to Talend Studio, as well as a general understanding of Java
Course objectives

After completing this course, you will be able to:

  • Import structures from existing files and databases, or manually create them
  • Perform complex mapping and transformation between input and output structures
  • Harness the power of TDM from data integration Jobs or ESB Routes
  • Work with complex standards such as EDI and COBOL
  • Define and run test cases
Course agenda

TDM in context

  • Concepts

Creating a simple XML to XML map

  • Creating a structure
  • Creating a map

Simple looping

  • Preparing the environment
  • Using simple loops
  • Sorting by item quantity
  • Adding a filter

Nested looping

  • Creating a new map using nested loops

Aggregation looping

  • Aggregating data
  • Nested looping

Using more functions

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

Using the tHMap component

  • Using the tHMap component
  • Reusing an existing map

Using context variables

  • Using context variables

Defining and running test cases

  • Setting up a test case

Using the cMap component

  • Creating a Route
  • Creating XML to JSON mapping
  • Configuring cMap and testing the Route

Using the tHMapFile component

  • Creating a Big Data Job
  • Creating XML to JSON mapping
  • Using the tHMapFile component

Instructions for optional modules

  • Navigating optional modules

EDI – Mapping the EDI format

  • Embedding multiple representations
  • Creating a map

EDI – Refactoring

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

COBOL – Handling COBOL redefined fields (RDEF)

  • Creating a COBOL structure
  • Configuring the structure for redefined fields

COBOL – Mapping COBOL to Excel

  • Creating a structure
  • Creating a DI Job

COBOL – Flattening a looping COBOL structure

  • Creating a Job

COBOL – Mapping COBOL to XML

  • Creating a COBOL structure
  • Creating a map

SWIFT – Working with SWIFT structures

  • Creating a SWIFT structure
  • Creating F30 and F20 fields
  • Creating F31P and F35B fields
  • Creating F35A and F83D fields
  • Creating an F87D field

SWIFT – Mapping SWIFT files to MySQL

  • Setting up a MySQL connection
  • Creating a DI Job
  • Performing mapping
  • Running the Job

SWIFT – Mapping multiple record types

  • Creating an input structure
  • Creating an output structure
  • Mapping elements
  • Creating a DI Job

SWIFT – Performing a database lookup

  • Creating a database structure
  • Adding a database lookup