Request for Database Schema Information

[AYLN]

I hope this message finds you well.

I am currently working on a project where we need to retrieve data from ClearSCADA (GeoSCADA) for integration with our reporting system. We have reviewed the available documentation, but we have not been able to locate the database schema or specific table structures for ClearSCADA.

Could you please provide the following information

Database Schema: Is there a database schema available for ClearSCADA? If so, could you share it or provide guidance on how to access it?

Table Structures: Any available documentation on the table structures in ClearSCADA would be greatly appreciated. We are particularly interested in understanding the relationship between various data tables and classes.

Data Retrieval: If there are any additional resources or recommendations for querying the database for both real-time and historical data, that would also be helpful.

We look forward to your guidance and assistance on this matter.

Best regards,
Aylin

[geoffpatton]

With the database server running use a chromium browser and you can open the schema. http or https://localhost/schema you can also replace localhost with the servers IP address.

Firefox does not seem to work right.

For SQL Queries look in the help for Historic Views. Those can be quite helpful with data retrieval efficiency. An example is using a Daily  Average view lets the server quickly retrieve the average values and only return those instead of all the values in your time period for the SQL client to then have to average.

[AdamWoodlandToo]

As Geoff mentioned, the schema is available via a web interface. One reason is that it is dynamic, it depends on what modules you install and what server configuration options you enable.

You could install Geo SCADA on your own machine and view the schema, but you'd need to make sure you install the same modules and configure the same options (off the top of my head including metadata fields, per server settings such as enabling per-user security) and ofcourse needing to make sure the versions match as there are some slight changes between versions as new features and functions are added

[ChrisHinton]

Dependant on Version, from ViewX you should be able to go File / Help / Database Schema
this will use the server IP and open a browser for you...

[AndrewScott · Accepted solution]

The help has a section on the database schema, see Working with the Database Schema, including instructions on how to access it using a web browser.

[HalliePritchard]

Thank you so much for the solution.