Issue
Where to find Continuum SQL schema and table details so a 3rd party can have access to the database.
Product Line
Andover Continuum
Environment
Continuum
Cause
Third party requires access to the database
Resolution
It is not recommended that third party systems directly access to the Continuum SQL database as the Cyberstation software expects full access to all tables at all times. Should a table be locked or inaccessible to Cyberstation it may cause problems or runtime errors.
We do not publish any details on the database tables or a SQL schema as Continuum is used for Security applications it would undermine the security of the product.
Also the database does not contain live data, this should always be read directly from the controllers.
There are other alternatives that can be used.
- Use an existing open protocol XDriver e.g. Modbus IP or other open protocol
- BACnet IP or MS/TP link to the 3rd party system or controllers, could also be linked to StruxureWare Building Operation
- Export the required data from a Listview, Group or Report for use by a 3rd Party
- Create a Plain English program to regularly export data to a .CSV or .TXT file, see Automatically export logged data to .CSV files
- Commission the development of a new Xdriver or other integration; contact UK Technical Services department for a bespoke solution, paul.bates@schneider-electric.com