Forum Discussion

matthewkaess's avatar
matthewkaess
Icon for Helper I rankHelper I
5 years ago

Dataset with multiple gateways

Greetings all! How would one configure data refresh when the datasources are using different on premise gateways. I have a dataset that using data from an on prem SQL source and Postgre database on ...
Need Help
ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
5 years ago

I'm sorry but I'm not following the "network" issue you are talking about. If you have two sources, Onprem SQL Server and Postgres in Azure VM. Then you need two gateways in a cluster. Like this: 

1- Gateway on a local environment that can reach SQL Server on premise.

2- Gateway on the same Azure VM of the postgres or a different VM with visibility to the postgres.

If you have those you will be able to connect. Be carefull with gateway installation. Be sure that the VM or PC with the gateway can reach the databases or you won't be able to connect.

Hope that helps,

matthewkaess's avatar
matthewkaess
Icon for Helper I rankHelper I
5 years ago

Apologies for any confusion. Here's what I did...

  1. On Prem Gateway: Already installed and connected to the on premise SQL instance.
  2. Installed the enterprise gateway on the Azure Postgre database server.
  3. Added it to the On Premise gateway cluster using that instances recovery key. Connections both tested good.
  4. Added the postgre datasource to the on premise gateway.
  5. Refresh failed with an error that the datasource could not be accessed.

Am I missing something here?