How do I query raw data from a Proficy Historian?
How can I retrieve raw time-series data from a Proficy Historian/iHistorian? Ideally, I would ask for data for a particular tag between two dates. ...
historian
How to query data from an AspenTech IP21 Historian?
Old subject, combined with new tools: What would be the best/appropriate way to query data for a web application from an AspenTech IP21 (InfoPlus.21) data historian? In the past, I've used some pretty awful queries via the Aspen SqlPlus ODBC driver, but that doesn't seem like the right approach, as it doesn't seem to install on Win 7 at...
Selecting a column with period in the column name SQL Server
I am linked to a Proficy Historian that allows periods in the column names. Because the data is stored in a non DBMS format I can not use openquery to get the data because there is no set schema to the tables. So I must use four part name syntax to get the data. This example works: SELECT * FROM iHist...[SELECT * FROM ihTrend] but ...