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

Question

Just wondering since it can be done through the WebApp, thought there might be a call, but I haven't found one.

---

--ACG

Answer 1

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)

Answer 2

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

Answer 3

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)