Hello everyone,
I have two gateways and one of them is connected to an SQL server database and my question is, is it possible to connect that database to the 2nd gateway? I do not have access to the SQL server itself so I cannot directly make a connection to the database from the 2nd gateway and the connection should be indirect. I want to be able to query for that database from the 2nd gateway.
Thank you!
You have to link the gateways (make an connection from each one). You also have to setup permissions for the new server to run sql commands on the other gateway,
https://docs.inductiveautomation.com/display/DOC81/Gateway+Network
https://inductiveuniversity.com/videos/remote-history-provider/8.1
I actually tested and it worked! Thank you very much!!! However, this is not quite what I want.
Do you know if it is possible to have that database as a database on the 2nd gateway? Not as a remote tag history provider?
@jgooding
I have the database running on the 2nd gateway as a remote history provider, but the information that I am getting from the database is not similar to what I have on the 1st gateway. I do not see the schema that I had anymore. I want to be able to query for that database from the 2nd gateway.