Now that we have the Talend schemas available, we can start to use them to access the data in the database.
Create a job
The default mode of reading a table in Talend is to read all the rows and columns of a table:
customertable from the left-hand side panel. This will open up a list of options.
tLogRowcomponent and create a flow between
tLogRow. Change the Mode of
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:
tMysqlInputand change ...