Is there any way to access the data stored in the historian in a reasonably user friendly way from 3rd party software such as MATLAB? The only way I can see this happening is querying the database with a somewhat complex procedure that will take into account all the different tables the data may reside depending on the time range. Then it gets extra complicated if you try to get multiple tags, each having separate logging times
For example, when I was testing out Canary Labs historian they had a simple tool that from within MATLAB I could run a SQL query like 'SELECT TagA, TagB FROM CanaryHistorian WHERE date < ‘2019-02-02’ and date < ‘2019-02-25’. And on Canarys end they would grab the data, do any interpolation needed to the number of rows match up for each tag and pop the data right into MATLAB.
I know there is the system.tag.queryTagHistory function in Igniton that basically does exactly what I’d like, but it is only accessible from within the Ignition environment.
The only way I can think of at this point is to write a RESTful API in Ignition and query the database via a URL. Still seems strange to me there isn’t something out of the box that would satisfy this.