EcoStruxure Geo SCADA Expert Forum
Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-02-20 09:38 PM
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
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-02-27 03:03 AM
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.
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-02-26 07:42 AM . Last Modified: 2025-02-26 07:52 AM
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.
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-02-26 06:40 PM
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
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-02-27 01:50 AM
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...
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-02-27 03:03 AM
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.
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-03-07 04:46 AM
Thank you so much for the solution.
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.
With achievable small steps, users progress and continually feel satisfaction in task accomplishment.
Usetiful Onboarding Checklist remembers the progress of every user, allowing them to take bite-sized journeys and continue where they left.
of