Since yesterday, after browsing through various posts it seems i hadn’t configured the database source on Grafana. I have the following questions i need some help with:
-
From one of the posts i’ve read it seems for me to read data from the sql server i will have to create a new table in the openHistorian database ( as seen in an example when another user was configuring openPDC (https://gridbits.gridprotectionalliance.org/t/configuration-to-get-data-from-database/583/8 ). Should i do the same to be able to retrieve data from the database or any other query? If so, is there a specific default table where the measurement data is kept from which i should conduct my queries?
-
The connectivity between the Remote SQL Database and my VM seems to be working but when i try to retrieve data from the openHistorian Web Client (via Trend/Export Data) the following error message is displayed.
Does that mean that even though i can see that the tables and the database has been created that they are not populated aka there’s nothing written in those tables?