`

Talend Data Mapper Essentials

Talend Data Mapper (TDM) helps 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. Input and output structures can be defined manually or imported from a variety of formats, including XML, SWIFT, COBOL, CSV, EDI, XLS, or 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 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 or 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

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

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 the XML to JSON mapping
  • Configuring cMap and testing the Route

Using the tHMapFile component

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

EDI optional module:

Mapping the EDI format

  • Embedding multiple representations
  • Creating a map

Refactoring

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

COBOL optional module:

Handling COBOL redefined fields (RDEFs)

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

Mapping COBOL to Excel

  • Creating a COBOL structure
  • Creating a DI Job

Flattening a looping COBOL structure

  • Creating a Job

Mapping COBOL to XML

  • Creating a COBOL structure
  • Creating a map

SWIFT and databases optional module:

Working with SWIFT structures

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

Mapping SWIFT files to MySQL

  • Setting up a MySQL connection
  • Creating a DI Job
  • Mapping elements
  • Running the Job

Mapping multiple record types

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

Performing a database lookup

  • Creating a database structure
  • Adding a database lookup