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.

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

Course Objectives:

After completing this course attendees should 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 sub Jobs
• Build, export, and test-run Jobs outside Studio
• Implement basic error-handling techniques
• Use best practices for Job and component naming, hints, and documentation

Course content

Getting started with Talend Data Integration

• Starting Talend Studio
• Creating your first Job
• Running a Job
• Using the component help
• Designing a Job using best practices
• Documenting a Job

Working with files

• Working with delimited files
• Working with hierarchical files

Working with databases

• Creating tables in MySQL databases
• Creating your first Job
• Applying best practices

Using repository metadata

• Using delimited file metadata
• Using XML file metadata
• Applying best practices
• Using database metadata
• Using generic schemas
• Updating metadata

Processing data

• Mapping data using tMap
• Joining data using tMap
• Capturing join rejects
• Filtering data and capturing filtering rejects
• Using other data processing components

Using contexts and context variables

• Creating a built-in context variable
• Connecting to databases using context variables
• Creating a context group in the repository
• Loading context variables from a flow

Building executables and Docker images from data integration Jobs

• Building a stand-alone Job
• Building a new version of the Job
• Building a Docker image

Controlling execution

• Managing files
• Processing files
• Managing Job execution using a master Job

Handling errors

• Detecting and handling basic errors
• Raising a warning

Working with web services

• Accessing a SOAP web service

Use case: Creating a master sales table from different data sources

• Setting up a customer table
• First challenge
• Setting up a sales table
• Joining data
• Performing calculations
• Second challenge
• Creating a master job

Using Git in Talend Studio

• Using Git in Talend Studio

Remote Job execution

• Creating and running a Job remotely

Basic debugging

• Debugging Jobs using Debug Run

Parallel execution

• Writing large files
• Writing to databases
• Automatic parallelization
• Partitioning

Memorizing data

• Preparing and memorizing a sequence of rows with the tMemorizeRows component
• Reusing memorized rows in tMap

Joblets

• Creating a Joblet from an existing Job
• Creating a Joblet from scratch
• Triggering Joblets

Using Custom Java Code

• Using Java in Talend Studio
• Executing simple instructions with tJava
• Processing data with custom Java code using the tJavaRow and tJavaFlex components
• Creating and using Java routines

Change data capture

• Examining databases
• Configuring the CDC database
• Monitoring changes
• Updating a warehouse
• Resetting the database

To see the full course content Download now