This procedure shows how to configure database output components to
write movies information to MySQL database tables.
Procedure
-
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.
Results
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.