August 15, 2023

Scenario: Inserting data into a database table and extracting useful information from it – Docs for ESB 6.x

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.

use_case_tmssqlconnection.png

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.


Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x