Getting Started with Talend Open Studio for Data Integration

This is the complete course for anybody who wants to get to grips with Talend Open Studio for Data Integration. From the basics of transferring data to complex integration processes, it will give you a head start.

Getting Started with Talend Open Studio for Data Integration

Cookbook
Jonathan Bowen

2 customer reviews
This is the complete course for anybody who wants to get to grips with Talend Open Studio for Data Integration. From the basics of transferring data to complex integration processes, it will give you a head start.
$10.00
$44.99
RRP $26.99
RRP $44.99
eBook
Print + eBook
$29.99 p/month

Find out more

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3500+ books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

+ Collection
Free Sample

Book Details

ISBN 139781849514729
Paperback320 pages

Book Description

Talend Open Studio for Data Integration (TOS) is an open source graphical development environment for creating custom integrations between systems. It comes with over 600 pre-built connectors that make it quick and easy to connect databases, transform files, load data, move, copy and rename files and connect individual components in order to define complex integration processes.

"Getting Started with Talend Open Studio for Data Integration" illustrates common uses and scenarios in a simple, practical manner and, building on knowledge as the book progresses, works towards more complex integration solutions.

TOS is a code generator and so does a lot of the “heavy lifting” for you. As such, it is a suitable tool for experienced developers and non-developers alike. You'll start by learning how to construct some common integrations tasks – transforming files and extracting data from a database, for example. These building blocks form a “toolkit” of techniques that you will learn how to apply in many different situations.

By the end of the book, once complex integrations will appear easy and you will be your organization’s integration expert!

Best of all, TOS makes integrating systems fun!

Table of Contents

Chapter 1: Knowing Talend Open Studio
What Talend Open Studio is
Installing Talend Open Studio
Other useful software
Sample jobs and data
Summary
Chapter 2: Working with Talend Open Studio
Studio definitions
Starting the Studio
Tour of the Studio
Creating a new project
Creating an example job
Metadata
Summary
Chapter 3: Transforming Files
Transforming XML to CSV
Transforming CSV to XML
Maps and expressions
Advanced XML output for complex XML structures
Working with multi-schema XML files
Enriching data with lookups
Extracting data from Excel files
Summary
Chapter 4: Working with Databases
Database metadata
Extracting data from a database
Extracts from multiple tables
Writing data to a database
Database to database transfer
Modifying data in a database
Dynamic database lookup
Summary
Chapter 5: Filtering, Sorting, and Other Processing Techniques
Filtering data
Sorting data
Aggregating data
Normalizing and denormalizing data
Extracting delimited fields
Find and replace
Sampling rows
Summary
Chapter 6: Managing Files
Managing local files
FTP file operations
Summary
Chapter 7: Job Orchestration
What is a subjob
A simple subjob
On Subjob Error
On Component OK
Run If
Jobs as subjobs
Iterating and looping
Duplicating and merging dataflows
Summary
Chapter 8: Managing Jobs
Job versions
Exporting and importing jobs
Scheduling jobs
Summary
Chapter 9: Global Variables and Contexts
Global variables
Contexts
Summary
Chapter 10: Worked Examples
Product catalog
Product inventory data
Order file processing
Order status updates
Automating processes
Summary

What You Will Learn

  • How to transform data files from one format to another
  • Getting data in and out of a relational database
  • Using common data operations such as filtering, sorting and aggregating
  • Managing files – moving, copying, renaming and deleting
  • Adding flow logic to integration jobs, including “if/then” operations and sequence dependencies
  • How to use dynamic variables, avoiding hard-coded routines
  • Using TOS in real-life scenarios with lots of tips and tricks
  • Learn how to integrate data to and from many different sources

Authors

Table of Contents

Chapter 1: Knowing Talend Open Studio
What Talend Open Studio is
Installing Talend Open Studio
Other useful software
Sample jobs and data
Summary
Chapter 2: Working with Talend Open Studio
Studio definitions
Starting the Studio
Tour of the Studio
Creating a new project
Creating an example job
Metadata
Summary
Chapter 3: Transforming Files
Transforming XML to CSV
Transforming CSV to XML
Maps and expressions
Advanced XML output for complex XML structures
Working with multi-schema XML files
Enriching data with lookups
Extracting data from Excel files
Summary
Chapter 4: Working with Databases
Database metadata
Extracting data from a database
Extracts from multiple tables
Writing data to a database
Database to database transfer
Modifying data in a database
Dynamic database lookup
Summary
Chapter 5: Filtering, Sorting, and Other Processing Techniques
Filtering data
Sorting data
Aggregating data
Normalizing and denormalizing data
Extracting delimited fields
Find and replace
Sampling rows
Summary
Chapter 6: Managing Files
Managing local files
FTP file operations
Summary
Chapter 7: Job Orchestration
What is a subjob
A simple subjob
On Subjob Error
On Component OK
Run If
Jobs as subjobs
Iterating and looping
Duplicating and merging dataflows
Summary
Chapter 8: Managing Jobs
Job versions
Exporting and importing jobs
Scheduling jobs
Summary
Chapter 9: Global Variables and Contexts
Global variables
Contexts
Summary
Chapter 10: Worked Examples
Product catalog
Product inventory data
Order file processing
Order status updates
Automating processes
Summary

Book Details

ISBN 139781849514729
Paperback320 pages
Read More
From 2 reviews

Read More Reviews