locked
Can Staging data be loaded and Staging process be initiated through the WebService API? RRS feed

  • Question

  • Just wondering since it can be done through the WebApp, thought there might be a call, but I haven't found one.
    --ACG
    Wednesday, January 18, 2012 9:32 PM

Answers

  • Both are fine although using the SPROCs directly would probably get you better performance. I'll try and get a sample of calling staging SPROCs to load data up on this forum sometime today.

     

    Arun


    Arunjeet Singh (Microsoft SQL Server Master Data Services)
    • Marked as answer by ACG Monday, January 23, 2012 4:12 AM
    Friday, January 20, 2012 6:23 PM

All replies

  • Yes it can. Use the EntityStagingLoad (to load data) and EntityStagingProcess (to process the batch) API calls.

     

    Regards

    Arun


    Arunjeet Singh (Microsoft SQL Server Master Data Services)
    Thursday, January 19, 2012 7:44 PM
  • Thanks Arunjeet. If we are using SSIS to load data is it recommended that we call the WebService API or the SP's directly from SSIS?
    --ACG
    Friday, January 20, 2012 12:36 PM
  • Both are fine although using the SPROCs directly would probably get you better performance. I'll try and get a sample of calling staging SPROCs to load data up on this forum sometime today.

     

    Arun


    Arunjeet Singh (Microsoft SQL Server Master Data Services)
    • Marked as answer by ACG Monday, January 23, 2012 4:12 AM
    Friday, January 20, 2012 6:23 PM