Free Sample
+ Collection

Getting Started with Talend Open Studio for Data Integration

Cookbook
Jonathan Bowen

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.
$26.99
$44.99
RRP $26.99
RRP $44.99
eBook
Print + eBook

Want this title & more?

$21.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 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.

Book Details

ISBN 139781849514729
Paperback320 pages

About This Book

  • Develop complex integration jobs without writing code
  • Go beyond “extract, transform and load” by constructing end-to-end integrations
  • Learn how to package your jobs for production use

Who This Book Is For

Are you a developer, business analyst, project manager, business intelligence specialist, system architect or a consultant who needs to undertake integration projects, then this book is for you.

The book assumes a certain level of familiarity with Relational database management systems with SQL and experience and Java.

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

In Detail

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!

Authors

Read More