Skip navigation
All Places > PI Developers Club > Blog > 2010 > February

This year OSIsoft vCampus Live! 2010, the in-depth technology event of the year, will take place on September 13th-14th! Once again, we’ll hold it at the Palace Hotel in San Francisco.


Spread the word, there will be technical content for everybody: PI System administrators, developers, systems integrators. No matter what your affiliation with OSIsoft, come and join other PI geeks on this collaborative, technical journey.


New Learning Lab Schedule


The highly rated 'Hands-On Learning Labs' are coming back - twice as valuable this year: there will be sessions both on Sunday before the event (September 12th), as well as on Wednesday after the event (September 15th). Plan your travel to take advantage of these new options!


Help Set the Agenda


You saw last year how we really strive to provide an event for the community, by the community... you will be hearing more about how you can participate in shaping an event that really suits your needs, and helps you get more out of your PI System.


Already have ideas for talks, presentations or activities? Make sure you share those on the General vCampus Discussions forum or, in private, send an email to Also follow us on twitter for the latest news:


We look forward to seeing you September!


The OSIsoft vCampus Live! Event Team


Perhaps you've heard a rumor...

Posted by smohr Feb 18, 2010

Some comments on the discussion forum say that OSIsoft's Silverlight applications do not use PI Web Services for data access.  We have one forthcoming Silverlight application that could have used PI Web Services but does not.  Why?


The main reason our Silverlight application is not using PI Web Services is that that data feed can be focused precisely on the needs of the classes consuming the data in the Silverlight application.  This is a good result  for the application, but a bad fit for a product, i.e., PI Web Services, that is intended as a general purpose product consumed by all sorts of clients.  Both the custom data layer and PI Web Services share an implementation layer in common; indeed, PI Web Services relies largely on this layer for its implementation.  The end result is that consumers of PI Web Services and the PI Silverlight application will receive the same behavior and data results.  Only the interfaces are different.

Hello JDBC and Web Service developers!


Some of you might have noticed we released PI JDBC 2010 R2 and PI Web Services 2010 R2 around Christmas time, and I would like to talk a little more about these. (I recognize this post is a little late, but I'm sure the beginning of the year was pretty hectic for all of us  )


The 2010 R2 releases are incremental releases to the "2010" versions released in August 2010 - they broaden the support for information contained in the PI Asset Framework (AF) and provide a few bug fixes and enhancements. Let me go through the details for each of them.




PI JDBC 2010 R2
The main change for this release is the change from the classic PI OLEDB Provider (PI-centric) to PI OLEDB Enterprise (AF-centric) as the underlying data access layer, which implies a whole new table set and new functionality are available. Note, this release is backward compatible and using the same settings as in PI JDBC 2010 will fall back to the previous, classic PI OLEDB Provider behavior. Here's how:


As you may already know, JDBC uses database URLs to connect to databases. The URL for PI JDBC needs to provide the name of the PI SQL Data Access Server (DAS) machine and then some PI OLEDB Enterprise (or classic PI OLEDB) connection string. In this 2010 R2 release and going forward, you should use:


As an example, to use the PI OLEDB Enterprise table set and connect to the PI Asset Framework (AF), you could use this URL:
    jdbc:pisql://mySQLDAS/Data Source=myAFServer; Integrated Security=SSPI;


If you want to revert back to the classic PI OLEDB Provider table set and connect to the PI Data Archive, you would use:


For example:
    jdbc:pi://mySQLDAS/Data Source=myPIServer; Integrated Security=SSPI;




The 2010 R2 release also includes several other enhancements and bug fixes, including significant performance improvements for writing time-series data and support for multiple connections from multiple threads; please consult the Release Notes for more details. One thing I would like to bring to your attention, however, is a significant performance enhancement with regards to writing data into PI. Indeed, the 2010 R2 version implements a JDBC interface called AddBatch which does batch processing of the write operations. Combined with the FLUSH option (see the "PI OLEDB SQL Optimization" White Paper for more details), it really pushes the limits of what you can do with PI JDBC. Our good friend Andreas Schremmer is currently working on a White Paper about this... you can expect this within the next couple weeks




PI Web Services 2010 R2
Just like for PI JDBC, PI Web Services 2010 R2 brings new data retrieval features, particularly wider adoption of the PI Asset Framework (AF). PI Web Services 2010 R2 offers new features including the following:
     - New methods for basic PI tag search and snapshot retrieval
     - Extended AF Data Reference support
     - Extension of filter expression support
     - Support for additional data insertion modes


I talk about these a little more in the "PI Web Services 2010 and Beyond" (see under the Auditorium), but once again you can consult the Release Notes for more details on this particular release.




We hope these changes help you in your projects, and contribute to making more out of your PI System (including making it an "asset-powered" one )


In closing, I look forward to hearing from you about what you think is important we work on next - simply comment on this blog post or initiate new discussion threads in the appropriate forum under Discussion Hall.

Filter Blog

By date: By tag: