Accessing data via ESB such as webMethods, using webServices

[wi11iamr]

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?

[Eric_Zhang · Accepted solution]

@wi11iamr

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