Outputting the result of the preparation into a database

The result of the preparation will be exported to a MySQL database.

1. In the design workspace, select tDataprepRun and click the Component tab to define its basic settings.

   

2. In the Property Type list, select Built-in to set the database connection details manually.
3. In the DB Version list, select the version of MySQL you are using, MySQL 5 in this example.
4. In the Host, Port, Database, Username and Password fields, enter the MySQL connection details and the user authentication data for the database, between double quotes.
5. In the Table Name field, type the name of the table to be write in, between double quotes.
6. From the Action on table drop-down list, select Create table if does not exist.
7. From the Action on data drop-down list, select Insert.
8. Click Sync columns to retrieve the new output schema, inherited from the tDataprepRun component.