Forum Discussion

wi11iamr's avatar
wi11iamr
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Accessing data via ESB such as webMethods, using webServices

Hi there,

 

We are establishing integration between a multitude of systems, using webMethods to orchestrate the web services.

 

The idea is that all data will be sourced directly from the source system, via webMethods - I.e. there is then no singular data mart or data warehouse. It is essentially then realtime access to data through an integration layer.

 

I am a bit stumped in figuring out how one could approach this - any advice, please?

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee

    wi11iamr

     

    To consume webservice, you can consider to use "get data"->"other"->"web". Another option is using Power Query, check this thread.