Gateway Network SQL Access
under review
m
mmaynard@usg.com
We need the ability to issue SQL Queries across the Gateway network against the data sources on the remote sever.
Something like system.db.RunRemoteQuery('GatewayNodeId',Query,database='MyDB')
I have this working now utilizing gatewway messaging but it is quite hacky and unsupported.
Log In
P
Paul Griffith
Merged in a post:
Remote Database Connection to other Gateway
P
Peter Engelman
When having gateways and DBs in different zones on the network and behind multiple firewalls it would be helpful to have the ability to query a DB on a remote gateway.
For example we have an OT tag server which is in out OT environment and then a proxy server in our DMZ and then our DB server is in our corporate environment. This means there are two firewalls between our OT gateway and the DB server, so we have to use gateway to gateway comms to query the DB through our Proxy server in the DMZ to do DB queries to update tags that would otherwise be able to be query tags. It would streamline the process to be able to add a Remote DB just like a Remote Alarm Journal.
M
Marco Barbieri
Bump
C
Cole Townsend
This feature would be useful to me as well. I am doing the exact same thing as the other guys in this thread. Just passing along SQL queries in gateway messages and returning the result set. Seems like a cool feature to add in.
m
mmaynard@usg.com
BUMP
E
Etienne Balardelle
+1. I am currently doing the same thing mmaynard is doing as a work-around. As a potential angle to this implementation, could database connections be remote mapped in the same manner remote tag providers or remote historical providers are?
m
mmaynard@usg.com
BUMP :P
P
Paul Griffith
under review