Talend Data Integration Basics

18 – 19 Apr 2019 | Kuala Lumpur
Book Your Seat Today!

Kindly advise me your company detail and our consultant will contact you soonest!

Course Objectives

  • Create a project
  • Create and run a Job that reads, converts, and writes data
  • Merge data from several sources within a Job
  • Save a schema for repeated use
  • Create and use metadata and context variables within Jobs
  • Connect to, read from, and write to a database from a Job
  • Access a web service from a Job
  • Work with master Jobs and subJobs
  • Build, export, and test run Jobs outside Studio
  • Invoke basic error-handling techniques
  • Use best practices for Job and component naming, hints, and documentation

Description

This course helps you use Talend Studio for Data Integration as quickly as possible. It focuses on the basic capabilities of Studio and how you can use it to build reliable, maintainable data integration tasks that solve practical problems, including extracting data from common database and file formats, transforming it, and integrating it into targets. This two days course is designed for anyone who wants to use the Talend Studio to perform data integration tasks.

Target Audience

Anyone who wants to use Talend Data Integration to perform data integration and management tasks: software developers and development managers

Training Outline

Getting Started
  • Starting Talend Studio
  • Creating a first Job
  • Running a Job
Working with Files
  • Reading an input file
  • Transforming data
  • Running a Job
  • Combining columns
  • Duplicating a Job
Joining Data Sources
  • Creating metadata
  • Joining data sources
  • Capturing rejects
  • Correcting a lookup
Filtering Data
  • Filtering output data
  • Using multiple filters
Using Context Variables
  • Understanding and using context variables
  • Using repository context variables
Error Handling
  • Detecting and handling basic errors
  • Raising a warning
Generic Schemas
  • Setting up sales data files
  • Creating customer metadata
  • Creating product metadata
Working with Databases
  • Creating database metadata
  • Creating a customer table
  • Creating a product table
  • Setting up a sales table
  • Joining data
  • Finalizing a Job
Creating Master Jobs
  • Controlling Job execution using a master Job
Working with Web Services
  • Accessing a web service
Running Jobs Standalone
  • Building a Job
  • Modifying a Job
Documenting a Job
  • Using best practices while documenting a Job

Prerequisite

Basic knowledge of computing, including familiarity with Java or another programming language, SQL, and general database concepts.