O'Reilly logo

Talend Open Studio Cookbook by Rick Barton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

  1. Run the job. You will see that it is very slowly adding the records to the database.
  2. Kill the job. If you inspect the database table testSession, you will see that the records have been added to the database.
  3. 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required