Dear vCampus Community,

 

We are pleased to announce the PI Data Access 2010 R3 wave of releases, the last piece of the greater PI Server 2010 R3 release! Indeed, we just released the 2010 R3 version of PI OLEDB Enterprise, PI JDBC and PI Web Services, which complete the family portrait with the release of the classic PI OLEDB Provider 2010 R3 back in early January. These releases focus on performance improvements and provide several other enhancements and bug fixes:

  • PI OLEDB Enterprise
    • Support for AF attribute searches and AF attribute value searches anywhere in the asset structure, without the need to traverse and reference AF elements from the hierarchy
    • Support for the LEFT OUTER JOIN statements, which is very useful for more sophisticated queries that combine asset metadata and time series data.
    • Significant performance enhancements for both time series data access and asset metadata access
    • Reduced memory consumption
    • Ability to configure error handling options (Embed Errors, Ignore Errors) globally, via the Connection String
    • Ability to change the Catalog in use dynamically ("USE <catalog name>" statement)
  • Classic PI OLEDB Provider
    • This release includes an important performance enhancement, specifically around archive queries that involve many tags but few values per tag
    • Bug fixes, including Punchlist Item (PLI) #22196OSI8
    • This version comes bundled with PI SDK 2010 R2 which enables Client-Side Buffering (buffered data writes and writing to High Availability PI Server)
  • PI JDBC
    • Benefits from all enhancements made to PI OLEDB Enterprise and the classic PI OLEDB Provider, as listed above
    • Support for the Java Runtime Environment (JRE) version 7
  • PI Web Services
    • Performance enhancements
    • Support for "data by exception" for PI tags (commonly referred to as "signup for updates")
    • Improved installation experience
    • Support for additional data insertion modes
    • Support for hosting PI Web Services in Windows without Microsoft Internet Information Services (IIS)
    • This version comes bundled with PI SDK 2010 R2 which enables Client-Side Buffering (buffered data writes and writing to High Availability PI Server)

Of course you can consult individual product Release Notes for a more detailed listing of changes/fixes.

 

While I certainly hope the user manuals provide all the information you need on the new functionality, we will be hosting a webinar to discuss the PI Data Access 2010 R3 wave of releases, show performance numbers and go through the new functionality. More details to come.

 

I look forward to reading about how the improved performance and the new features of these products are helping you bring projects to fruition! Please do not hesitate to share snippets of your projects (e.g. screenshots) with me, as I love to hear how you make use of our products, what problems you solve, as well as what you would like to see next. Of course you can contact me directly at spilon@osisoft.com if you don't want to provide this kind of feedback publicly, on the forums

 

Now what? You can look forward to the PI Data Access 2012 releases, whose main purpose will be to deliver PI Event Frames capabilities! Please reach out to me if you are interested in being an early adopter for these!