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 presents one or two stumbling blocks. You should therefore 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").