GETTING STARTED

• Start Talend Studio
• Create the First Job

GENERATING DATA ROWS

• Create the Job
• Configure the Schema
• Run and Debug

CONNECTION TYPES

• Setup
• Create an Iterate Connection
• Create an OnSubjobError Connection
• Create an OnSubjobOk Connection
• Create an OnComponentOk Connection
• Use an If Connection

WRITING DATA TO FILES

• Output Records to a File
• Output Records to Multiple Files
• Modify the Data

WRITING TO A DATABASE

• Configure the Job
• Load Data into a Database Table

DATABASE INPUT

• Set Up the Database Input
• Complete the Job

DATABASE METADATA

• Create a Metadata Connection
• Update the Schema
• Create a Database Metadata Connection
• Create a Job
• Run the Job

COMPARING BUILT-IN AND REPOSITORY PROPERTIES

• Modify the Job
• Built-in vs Repository

MODIFYING A SCHEMA WITH A TMAP COMPONENT

• Use tMap to Change Output
• Configure tMap
• Run the Job with Debug
• Change Output Order
• Modify Output Schema

TRANSFORMING DATA WITH A TMAP COMPONENT

• Changing Output
• Use Functions in tMap
• Use Additional Functions in tMap

DEFINING A JOIN IN A TMAP COMPONEN

• Create a Job with tMap and Lookup
• Configure tMap
• The tMap Editor Tool Bar

FILTER DATA IN TMAP

• set Up a Filter Condition

CATCHING DATA REJECTED BY A JOIN

• Configure tMap
• Configure the Job to Catch Rejects

CATCHING INFORMATION ABOUT JOB EXECUTION

• Using Triggers to Capture Errors
• Using tDie and tWarn
• Use tLogCatcher
• Use a Trigger to Control Execution

TXMLMAP

• Create the Input
• Set Up the Mapper
• Finish the Job

CONTEXTS

• Local Contexts
• Add Context Environments
• Create a Context Group
• Adding Groups
• Test Context Variables

JOB HIERARCHY

• Set Up the Scenario
• Create the Relationship
• Pass Data to the Child Job

ROUTINES

• Add a Custom Routine
• Test the Routine

EXPORTING AND RUNNING INDEPENDENT PROCESSES

• Create the Package
• Run the Job

CALLING WEB SERVICES

• Create the Metadata
• Create a Test Job

USE CASE PRACTICE

• Preliminary Jobs
• Main Job