August 15, 2023

Scenario: Retrieving personal information using a stored procedure – Docs for ESB 6.x

Scenario: Retrieving personal information using a stored procedure

This scenario describes a Job that retrieves a personal information record from a
specified table using a stored procedure according to the id value defined in the input flow.

components-tmssqlsp_s1_job.png

In this scenario, the table to retrieve data from contains the personal information.
To reproduce this scenario, you can write the data into the table from a CSV file like
the following. For how to write data into a MS SQL table, see Scenario: Inserting data into a database table and extracting useful information from it.

In this scenario, the stored procedure used to retrieve the personal information is as
follows:


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