Forum Discussion
Dataset with multiple gateways
That didn't work in my scenario. The databases are not on the same networks and there is no way for the gateway to connect externally. I tried the set up as recommended and the gateway on the same network as the on premise database could not connect to the Azure database even though its gateway was configured in the on premise gateway cluster.
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,
Apologies for any confusion. Here's what I did...
- On Prem Gateway: Already installed and connected to the on premise SQL instance.
- Installed the enterprise gateway on the Azure Postgre database server.
- Added it to the On Premise gateway cluster using that instances recovery key. Connections both tested good.
- Added the postgre datasource to the on premise gateway.
- Refresh failed with an error that the datasource could not be accessed.
Am I missing something here?
Is there any update on this subject?