July 31, 2023

Executing a stored procedure using tMDMSP – Docs for ESB Jdbc 7.x

Executing a stored procedure using tMDMSP

This scenario applies only to Talend MDM Platform and Talend Data Fabric.

In this scenario, the Job first generates parameters and sends them to tMDMSP, which executes a predefined stored procedure,
and then extracts data from the returned execution result and presents the extracted
data in the console.

Executing a stored procedure using tMDMSP_1.png

  • Make sure the MDM server is up and running.

  • You have imported the MDM demo project and loaded the sample data into the data container
    Product by running the Job MDM_LoadAll.

  • You have been assigned a role with the appropriate user authorization and access rights to
    the data model Product.

  • You have created a store procedure called ProductSelection and
    deployed this stored procedure to the MDM server.

In this example, the stored procedure ProductSelection is designed to query two fields
Name and Price of
Product data records within a price range:

Executing a stored procedure using tMDMSP_2.png

For more information on working with stored procedures, see

Talend Studio
User Guide

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