Writing dynamic columns from a database to an output file

This scenario applies to all Talend products.

For more technologies supported by Talend, see Talend components.

In this scenario, MySQL is used for demonstration purposes. You will read dynamic columns from a MySQL database, map them and then write them to a table in a local output file. By defining a dynamic column alongside known column names, we can retrieve all of the columns from the database table, including the unknown columns.