Preparing data from a database in a Talend Job

This scenario applies to all Talend products.

For more technologies supported by Talend, see Talend components.

The tDataprepRun component allows you to reuse an existing preparation made in Talend Data Preparation or Talend Cloud Data Preparation, directly in a data integration Job. In other words, you can operationalize the process of applying a preparation to input data with the same model.

The following scenario creates a simple Job that :

• retrieves a table from a MySQL database, that holds some employee-related data,
• applies an existing preparation on this data,
• outputs the prepared data into an Excel file.

This assumes that a preparation has been created beforehand, on a dataset with the same schema as your input data for the Job. In this case, the existing preparation is called datapreprun_scenario.

This simple preparation puts the employees last names into upper case and isolate the employees with a salary greater than 1500$.