03-09-2013 10:31 AM
I'm the newest of the new with regards to OSI PI, I didn't even know it existed until I saw your post.
I took a look at their website, and it looks like you have a couple of options. I think the best is from the datasheet for the "PI Data Access" product, which states:
SQL Data Access Tools expose the
PI System as a relational database
– with tables and relationships –
and make it accessible through
SQL queries. The PI Data Access
SQL tools support the three major
relational database standards
(OLE DB, ODBC and JDBC).
This allows you to integrate your
PI System data with external systems
and facilitates the development of
The SAS/Access suite of products can easily access both OLE DB and ODBC data sources, so this would be my first choice.
Another option is as a web service. Again, the "PI Data Access" sheet says:
"PI Web Services™ exposes
PI System data to Web Service client
applications based on the Simple
Object Access Protocol (SOAP).
This is ideal for systems integration/
orchestration scenarios and the
development of custom web and
and SAS can consume web services. However, I assume you want to use SAS as a data analysis tools, which implies significant volume. If I'm after a large volume of data I feel that an ODBC-type connection will produce orders-of-magnitude better performance than a web service.
Good luck, let us know how it turns out!