Packt+ | Advance your knowledge in tech

You're reading from Talend Open Studio Cookbook Getting familiar with Talend Open Studio will greatly enhance your data handling and integration capabilities. This is the perfect reference book for beginners and intermediates with a host of practical recipes that clarify even complex features.

Product type Paperback

Published in Oct 2013

Publisher Packt

ISBN-13 9781782167266

Length 270 pages

Edition 1st Edition

Languages

Java

Tools

Talend

Concepts

Data Analysis

Author (1):

Rick Barton

View More author details

Table of Contents (16) Chapters

Preface

1. Introduction and General Principles FREE CHAPTER

2. Metadata and Schemas

3. Validating Data

4. Mapping Data

5. Using Java in Talend

6. Managing Context Variables

7. Working with Databases

8. Managing Files

9. Working with XML, Queues, and Web Services

10. Debugging, Logging, and Testing

11. Deploying and Scheduling Talend Code

12. Common Mistakes and Other Useful Hints and Tips

A. Common Type Conversions

B. Management of Contexts

Index

Introduction

Many applications and organizations rely on databases to store their corporate data. These can be application databases to support operational systems, data warehouses, data marts, or ODS (Operational Data Store), and any data integration developer must understand how to manipulate the database objects and the data held within the database.

Talend usually connects to a database using JDBC, so it can connect to any datasource for which there is a JDBC driver, which means that Talend can connect to all of the most popular databases and a host of less well-known ones too.

In order to perform the recipes in this chapter, you need to ensure that you have a database installed. This book uses MySQL, a popular open source database that is freely downloadable. In addition, some of the recipes will make use of the HSQL database driver as a means of creating transient in-memory tables.

You will also need a general working knowledge of databases and have a reasonable understanding of SQL.

It...

The rest of the chapter is locked

You're reading from Talend Open Studio Cookbook Getting familiar with Talend Open Studio will greatly enhance your data handling and integration capabilities. This is the perfect reference book for beginners and intermediates with a host of practical recipes that clarify even complex features.

Table of Contents (16) Chapters

Introduction

Authors (1)

Personalised recommendations for you

You're reading from Talend Open Studio Cookbook Getting familiar with Talend Open Studio will greatly enhance your data handling and integration capabilities. This is the perfect reference book for beginners and intermediates with a host of practical recipes that clarify even complex features.

Table of Contents (16) Chapters

Introduction

Unlock this book and the full library FREE for 7 days

Authors (1)

Personalised recommendations for you