Distributed databases

Accessing non-local databases with OPC Router does not pose any particular difficulties. In fact, it is more the rights management of the database server that can present a few stumbling blocks. Therefore, please consult the documentation for your database system.

We generally recommend that you consider the following:

• Does the database allow remote access? Does this have to be explicitly assigned to individual users?
• Does the login procedure have to be specified (Windows/NT authentication or user/password)?
• Does the user have to be explicitly assigned access to the individual database or table?
• Do the required functions have to be explicitly assigned to the user?
• Is the required port enabled in the firewall (we recommend deactivating local firewalls)?
• Depending on the database system, the server/file property of the DB connection contains different information (see "Storage").