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
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
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.