Scenario: Inserting data into a database table and extracting useful information from
it
The scenario describes a Job that reads the employee data from a text file, inserts the
data into a table of an MSSQL database, then extracts useful data from the table, and
displays the information on the console.
This scenario involves the following components:
-
tMSSqlConnection: establishes a connection to the
MSSQL server. -
tFileInputDelimited: reads the input file,
defines the data structure and sends it to the next component. -
tMSSqlOutput: writes data it receives from the
preceding component into a table of an MSSQL database. -
tMSSqlInput: extracts data from the table based
on an SQL query. -
tLogRow: displays the information it receives
from the preceding component on the console. -
tMSSqlCommit: commits the transaction in the
connected MSSQL server.