Forum Discussion

Karthik12's avatar
Karthik12
Post Patron
3 years ago
Solved

Gateway connection setup for two different SQL databases and refresh setting

Hi All, I am handling two MS SQL databases from different sources. When I trying to setup schduled refresh, need to set up on premises gateway.  I have installed on premises gataway in both databas...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • sergej_og's avatar
    sergej_og
    3 years ago

    If you want to get data from two sources you have to add both sources to ONE gateway.
    Your selected gateway (marked with a dot) is performing then data from your sources.
    Just to give you an idea.
    It could see like this: there are different sources passing through one gateway to each region of your architecture 

    Regards

Karthik12's avatar
Karthik12
Post Patron
3 years ago

Hi sergej_og 

Thanks for the guidance. I am trying to add second source gateway also with first one. but, am afraid that, first source may stopped and gateway may shifted to second machine and is it will affect anything?

Actually, I don't have option for a VM. So, I am trying with both data source machines.

 

After adding second source, first source got unselected like below

Still it will work?

 

 

 

sergej_og's avatar
sergej_og
Super User
3 years ago

If you want to get data from two sources you have to add both sources to ONE gateway.
Your selected gateway (marked with a dot) is performing then data from your sources.
Just to give you an idea.
It could see like this: there are different sources passing through one gateway to each region of your architecture 

Regards