Executing a stored procedure using tMDMSP - Cloud - 8.0

MDM data processing

Version
Cloud
8.0
Language
English
Product
Talend Data Fabric
Talend MDM Platform
Module
Talend MDM Server
Talend MDM Web UI
Talend Studio
Content
Data Governance > Third-party systems > MDM components > MDM data processing components
Data Quality and Preparation > Third-party systems > MDM components > MDM data processing components
Design and Development > Third-party systems > MDM components > MDM data processing components
Last publication date
2024-02-20

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

For more technologies supported by Talend, see Talend components.

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.

Prerequisites:
  • Make sure the Talend 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 Talend 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: