This procedure shows how to configure database output components to write movies information to MySQL database tables.
Double-click the first tMySqlOutput component to open its Basic settings in the Component view.
Provide the connection details needed to access your database, including the host name or IP address, port number, database name, user name and password, in the relevant fields.
When entering your password, you need first to click the [...] button next to the Password field to open a dialog box, enter your password between double quotation marks in the text field, and then click OK.
In the Table field, enter the name of the target database table.
In this example, the table for valid movies information is valid_movies.
Select the Action on table and Action on data options according to your needs.
In this example, we want to remove the table first if it already exists and then create an empty one, and use the default option for the action on data.
In the Basic settings of the second tMySqlOutput component, use the same settings as in the first tMySqlOutput except the name for the target database table.
In this example, the table for invalid movies information is invalid_movies.
Press F6 or click the Run button on the Run view to execute your Job.
The movies records with valid director information are saved to the database table named valid_movies, and those without valid director information are saved to the database table named invalid_movies.