Executing a stored procedure using tMDMSP
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.
-
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:
For more information on working with stored procedures, see Talend Studio User Guide.