Distributed databases
Accessing non-local data bases with the OPC Router is not much of a challenge. Indeed administrating the rights on the data base servers is the part which could trouble you. Therefore call to your data base systems documentation.
Basically we recommend to notice following:
- Does the data base allow remote access? Does this have to be assigned to every single user?
- Does the log in procedure have to be defined (Windows-/NT-authentification or user/password)?
- Does the access to every single data base or table have to be assigned to the user?
- Do the needed functions have to be assigned explicit to the user?
- Is the needed port in the firewall open(we recommend to deactivate local firewalls)?
- Depending on the data base system the property Server/Data of the data base access data includes a different declaration (s. "Storage").