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

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

  • quarta-feira, 18 de janeiro de 2012 21:32
     
     
    Just wondering since it can be done through the WebApp, thought there might be a call, but I haven't found one.
    --ACG

Todas as Respostas

  • quinta-feira, 19 de janeiro de 2012 19:44
     
     

    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)
  • sexta-feira, 20 de janeiro de 2012 12:36
     
     
    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
  • sexta-feira, 20 de janeiro de 2012 18:23
     
     Respondido

    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)
    • Marcado como Resposta ACG segunda-feira, 23 de janeiro de 2012 04:12
    •