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

Managing database sessions

Database sessions allow the developer to control how and when the data is committed to a database. This recipe shows how this is achieved in Talend.

Getting ready

Open the job jo_cook_ch07_0060_databaseSession. On inspection, you will see that the job has been set up to commit after each record has been written.

How to do it…

The steps to be performed are as follows:

Run the job. You will see that it is very slowly adding the records to the database.
Kill the job. If you inspect the database table testSession, you will see that the records have been added to the database.
Drag tMysqlConnection from the metadata panel and tMysqlCommit from the palette (note that this isn't available from the Repository panel) and wire up as shown in the following screenshot:
Open tMysqlOutput and tick the option for Use an existing connection. You will see that all the connection information is now hidden.
Run the job and Kill it before all ten records have been processed. If you examine...