Writing dynamic columns from a database to an output file

This scenario applies only to subscription-based 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.