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

Reading from database tables

Now that we have the Talend schemas available, we can start to use them to access the data in the database.

Getting ready

Create a job jo_cook_ch07_0010_readTables.

How to do it…

The default mode of reading a table in Talend is to read all the rows and columns of a table:

  1. Drag the customer table from the left-hand side panel. This will open up a list of options.
  2. Select tMysqlInput.
  3. Add a tLogRow component and create a flow between tMysqlInput and tLogRow. Change the Mode of tLogRow to table.
  4. Run the job and you will see that the complete table has been read.

Selected rows and columns

In many cases we do not want the whole table, so it is more efficient to filter the data in the database via a query:

  1. Open tMysqlInput and change ...

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