Adding database output components to your Job
In the example below we will create a new Job from the Job filter_movies and add two tMySqlOutput components. These components will be used to write the processed movies information to the specified database tables.
Before you begin
-
You have created and successfully executed the Job filter_movies as described in Filtering the movies information.
Procedure
-
Click where the tLogRow was on the design workspace and
type the name of tMySqlOutput or part of it, and then
select and double-click tMySqlOutput on the list to add it onto
the design workspace.
When you start typing the component name, a list of components that match your input appears. You can select a component to view its description besides the component list.
-
Right-click the tMap component, select from the context menu, and click the
tMySqlOutput to
link it with the tMap.
The connection name Valid_movies corresponds to the name of the existing output table in tMap.
-
Click the tMap component, and drag
and drop the arrow icon displayed onto the design
workspace.
A text field and a list of suggested components appear. You can select a component to view its description besides the component list.
-
In the text field, type the name of tMySqlOutput, select the
component on the list, and press Enter to add another tMySqlOutput component onto
the design workspace.
A dialog box appears, asking you to enter a name for the output connection.
-
In the dialog box, enter
Invalid_movies and click
OK to connect
tMap to the
second tMySqlOutput
component.
Results
Now you have added and connected the database output components you need to write the processed movies information to a MySQL database. Next, you'll need to configure new mappings in the tMap and database settings in the tMySqlOutput components.