I want to read PI data in MSQL Server. Any ideas for the implementation?
Could you elaborate a bit more on details? "PI data" is so general that it is too vague to provide an adequate answer. Do you want data from a PIPoint in the Data Archive, or data from an AFAttribute somewhere in an AFDatabase? Do you want the current values (formerly snapshot) or history? If you want history, do you want it to be recorded archived values or interpolated? If interpolated, what is the interval? Or perhaps you want summaries? Or do you really want meta-data, that is the PIPoint or AFAttribute definition?
I agree with Rick (I don't remember ever disagreeing with him, come to think of it). One other point of clarity.. you stated "read the data", do you desire the ability to simply query/ view the PI data using a query tool OR do you want to both query AND store the same data in SQL as well.
Thanks for the reply!
I want data from PIPoint in the data archive. Also I want recorded archived values which I can query and store the same data in SQL as well.
For PI values, consider the information pasted below. The interface is bi-directional.
PI Interface for Relational Database (RDBMS via ODBC) 3.23
The PI Interface for Relational Databases enables you to transfer data between the PI Data Archive and any relational database management system (RDBMS) that supports Open Database Connectivity (ODBC) drivers. The interface runs on Microsoft Windows operating systems and can connect to any PI Server node available on the network. To read and write data, you define SQL queries in the ExDesc attribute of a PI tag or in text files. The interface provides the following capabilities:
While that last bullet is a true statement, please consider the following found in the Live Library documentation:
Note: OSIsoft recommends using the PI System auditing features to audit changes to points, rather than this interface.
Be sure to check out the SQL examples in the documentation.
Regarding PIPoint information/ tag definitions/ attributes, there are also other alternatives, including the use of Linked Servers:
Please don't hesitate to call on Technical Support for assistance. These can be a bit overwhelming, at first, with a steep learning curve.
Others here may chime in with additional ideas as well.
Retrieving data ...