Data sources from different servers

Suppose I have datasources from two different servers in one model,
while setting up gateway, should I setup two different ones for each source?

Hi Anu,

Yes you need to set up gateway for both the sources in order to refresh the data from the service. If it’s a excel file from 2 different servers then definitely yes, or if one is SQL source and other is excel then also its a yes. Sharing a example from my experience.

image

If both the data sources are excel files, then I would advise you to setup one central location for all the files. That would be better.

If both are SQL?

If the database is same then 1 gateway would work for both of them, else you’ve to create 2 gateways.