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.
-
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.