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.
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.
The steps to be performed are as follows:
testSession, you will see that the records have been added to the database.
tMysqlConnectionfrom the metadata panel and
tMysqlCommitfrom the palette (note that this isn't available from the Repository panel) and wire up as ...