Talend Data Integration Basics | Agilitics





Buy Courses

APACHE HADOOP Administrator
February 26, 2018
ElasticSearch Stack
February 26, 2018
Show all

Talend Data Integration Basics

$2,000.00 $1,800.00

Talend Studio for Data Integration dramatically improves the efficiency of data integration Job design
through an easy-to-use graphical development environment. With integrated connectors to source
and target systems, it enables rapid deployment and reduces maintenance costs. It supports all
types of data integration, migration, and synchronization.

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 course serves as a prerequisite for many other Talend courses, and the skills learned apply to
most Talend products.

Duration: 17 Hours


Target audience – Anyone who wants to use the Talend Studio to perform data integration tasks: software developers and development managers.Prerequisites – Basic knowledge of computing, including familiarity with Java or another programming language, SQL, and general database concepts.

Course objectives – After completing this course, you will be able to:

  • 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

Course agenda

  • Getting started :1 hour : Theory 20 mins + Practical 40 mins
    Starting Talend Studio
    Creating a first Job
    Running a Job
  • Working with files :2 hours :Theory 1 hour + Practical 1 hour
    Reading an input file
    Transforming data
    Running a Job
    Combining columns
    Duplicating a Job
  • Joining data sources : 1 hour, Theory 20 mins + Practical 40 mins
    Creating metadata
    Joining data sources
    Capturing rejects
    Correcting a lookup
  • Filtering data : 2 hours :Theory 1 hour + Practical 1 hour
    Filtering output data
    Using multiple filters
  • Using context variables : 2 hour :Theory 1 hour + Practical 1 hour
    Understanding and using context variables
    Using repository context variables
  • Error handling :1 hour :Theory 30 mins + Practical 30 mins
    Detecting and handling basic errors
    Raising a warning
  • Generic schemas :1 hour :Theory 30 mins + Practical 30 mins
    Setting up sales data files
    Creating customer metadata
    Creating product metadata
  • Working with databases : 1 hour :Theory 30 mins + Practical 30 mins
    Creating database metadata
    Creating a customer table
    Creating a product table
    Setting up a sales table
    Joining data
    Finalizing a Job
  • Creating master Jobs :2 hour :Theory 1 hour + Practical 1 hour
    Controlling Job execution using a master Job
  • Working with web services :2 hour :Theory 1 hour + Practical 1 hour
    Accessing a web service
  • Running Jobs standalone :1 hour :Theory 30 mins + Practical 30 mins
    Building a Job
    Modifying a Job
  • Documenting a Job :1 hour: Theory 30 mins + Practical 30 mins
    Using best practices while documenting a Job
Request a Call Back
Request For Demo