PacktLib: Getting Started with Talend Open Studio for Data Integration

Getting Started with Talend Open Studio for Data Integration

Credits

Foreword

Foreword

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Preface

Knowing Talend Open Studio

What Talend Open Studio is

Installing Talend Open Studio

Other useful software

Sample jobs and data

Summary

Working with Talend Open Studio

Studio definitions

Starting the Studio

Tour of the Studio

Creating a new project

Creating an example job

Metadata

Summary

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

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

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

Managing Files

Managing local files

FTP file operations

Summary

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

Managing Jobs

Job versions

Exporting and importing jobs

Scheduling jobs

Summary

Global Variables and Contexts

Global variables

Contexts

Summary

Worked Examples

Product catalog

Product inventory data

Order file processing

Order status updates

Automating processes

Summary

Installing Sample Jobs and Data

Installing Sample Jobs and Data

Resources

Resources

Resources

Resources

Resources

Resources

Index