Skip navigation
All Places > PI Developers Club > Blog > Author: jlakumb

PI Developers Club

14 Posts authored by: jlakumb

The latest release of PowerShell Tools for the PI System 1.1 is now available in the Download Center!  This new version provides support for PI Collectives, PI Annotations, PI Firewall (courtesy of this request from Rhys), reading the local PI Message Log, removing of PI Values, and minor enhancements and bug fixes.  In addition, we included support for PI Server 2012, Windows 8/2012, and PowerShell 3.0.  Several new example scripts which are documented in the Release Notes are also included.  We encourage you to try PowerShell Tools for the PI System 1.1, check out the “PowerShell for PI System Admins” session materials from vCampus Live! 2012, and direct any questions or feedback to the Discussion Hall.  Happy Scripting and Happy Holidays!


PI SDK 2012 RC2

Posted by jlakumb Nov 5, 2012

This week we posted a pre-release version of PI SDK 2012 in the Download Center.  This next PI SDK includes support for Windows 8/2012, localization of PI SDK Utility and other dialogs/controls, as well as dozens of other minor bug fixes.  We encourage you to try out these 32/64-bit RC2 versions and send questions or feedback to


PI Server 2012 at UC 2012

Posted by jlakumb Apr 20, 2012

This year is very exciting for the PI Server team as we are getting ready to unveil the latest PI Server. During this year’s Users Conference 2012 in San Francisco we will be announcing PI Server 2012.




PI Server 2012 offers significant enhancements in performance, scalability, reliability and manageability while utilizing system resources better than ever before and this year’s Users Conference is the place for you to learn more about all these enhancements. Here’s where:




·         The Partner Expo, on Monday April 23rd, is where you can find some of our early adopters like SISCO and Rockwell. These Technology Adoption Program (TAP) participants have already the power of PI Server 2012 and they are ready to share it with you.


·         During the General Session keynote, you’ll discover how the PI Server is the foundation of the PI System’s evolution. The OSIsoft Engineering Leadership Team will walk us through cutting edge demos to showcase the performance and scalability of PI Server 2012.


·         During the product talks on Day 1 and 2 you’ll find different sessions showing what’s new with PI Server 2012. You’ll get a chance see it live in both the PI Server 2012 breakout session, as well as the PI Server 2012 kiosk during the Product Expo.


·         We’ll continue our discussion on configuration, visualization, asset centricity and the powerful analytic tools in other breakout sessions. Don’t miss your chance to learn how PI System Calculations can help you operate, maintain and improve the performance of your processes. Also, if you need to know when certain events occur—even when you are not at your desk—see how the PI System can provide this information using PI Notifications.


·         During these same sessions, we’ll also introduce new capabilities like organizing and visualizing your data by business events with PI Event Frames through the PI Data Access products.


·         And last, but not least, the Product Education Day will help you prepare your existing environment for the upgrade to PI Server 2012, so be certain not to miss this one!




We hope to see you at all the PI Server 2012 related talks and don’t be shy, we want to hear your questions and impressions! So register to the OSIsoft’s UC 2012, attend the presentations, and raise your hand or send us an email at




PI Server 2012 Team


Are you up for the challenge?

Posted by jlakumb Jan 24, 2012

As Jon Peterson announced last month, we're looking for customers and partners who would like to join the PI Server 2012 Technology Adoption Program (TAP).  This release of PI Server offers significant gains in scalability and performance, as well as improvements in manageability and reliability.  If you haven't already seen it, check out this video of our vCampus Live! presentation for a sneak peek.  Do you have a particularly interesting use case which could benefit from PI Server 2012?  Are you willing to share your story with other customers and partners?  Then send us an e-mail at and we'll follow up with a short survey.  The first beta version will be available to TAP participants by the end of January.


Think you're up for the challenge?

For those of you who attended vCampus Live! and we had the privilege to present to you a "Sneak Peek at PI Server 2012", one of the more exciting developments we announced are new PowerShell Tools for the PI System.  This is a set of cmdlets for Windows PowerShell which allows you to manage a PI System.  Hopefully this will make the lives of PI System administrators that much easier by enabling you to create powerful, reusable scripts for commonly needed or bulk system management operations.  We used several example scripts to show off the power of PI Server 2012, which everyone will get a chance to see once the video is posted.  We encourage you to check that out since it has exciting stuff on performance, scalability, and reliability in PI Server 2012 - something for everyone in this next release!




We are now making available the PowerShell Tools for the PI System as an extra in the Download Center.  We know there is a lot of interest in using PowerShell (or other scripting tools) with the PI System, based on the following discussion threads -




Powershell & Archive Maintenance


PI - Automation of Maintenance


Powershell scripts for PI System maintenance


Powershell and Archive Maintenance


Get the Archive - Files


Scripting MDB edits










Some of the use cases we have heard are monitoring message logs, scheduling backups, adding users or mappings, and managing archives.  In fact, we provided sample scripts for each of these.  The samples are well documented and should be a good starting point.  In addition, the online help for each of the cmdlets is extensive and a great resource.  In case you have a question or need further assistance, feel free to leverage the vCampus community.  We will also be listening in for feedback and providing "support" (although it is not an officially supported PI product).




If you are new to PowerShell, here are some links you might find useful to get started:


Windows Powershell Getting Started Guide


Scripting with Windows Powershell




Enjoy the new PowerShell Tools for the PI System and if you like it, or you want to see some features/functionality added, or you have a helpful script to share, then please let the vCampus community knowStay tuned for a webinar early next year where we can dive into more of the capabilities of this tool.




Happy scripting!




edit by Michael @ OSIsoft: the PowerShell Tools for the PI System are not available yet in the Download Area, we are uploading them this very minute. Stay tuned The download is up in the Download Area, under 'Extra's'!


Update: check out this webinar -

Builders's Café Webinar Series: The PI System and PowerShell - The Life of the PI System Admin Just Got Easier


Rolling your own web services

Posted by jlakumb Jan 19, 2011

I noticed a pattern in several posts where folks are struggling with rolling their own web services or web-based application using PI/AF SDK (see here, here, here, here, here, and here).  I know that some of you are quite comfortable with using our SDKs, and that PI Web Services is a fairly new product, but I want to draw your attention to an important point.  Here is an excerpt from the "Optimizing your PI SDK Applications" whitepaper in the vCampus Library:



PI SDK applications can often provide the highest performance and scalability for accessing PI data, but this requires careful planning and development using the above techniques. For most users, it may be more efficient to leave these issues to OSIsoft and use PI Web Services instead. PI Web Services leverages all of these PI SDK optimizations and provides a simple query/response interface for programmers, allowing them to focus on what data to read/write to PI, instead of how to do it.

The efficiency and ease of development with PI Web Services may be more cost-effective than doing "raw" PI SDK programming, especially when coding in .NET languages or creating modern web-based applications. The OSIsoft vCampus development license (and the corresponding PI System Access runtime license) allows customers to choose the right tool for the job, so please consider which approach (PI SDK, PI Web Services, or another PI Data Access tool) makes the most sense for your particular situation, and for the long run.



Hopefully this will convince you to review the functionality of PI Web Services first to determine if it will meet your needs, before trying to roll your own.  If not, please drop us a note (vCampus, Tech Support, etc.) and let us know what enhancements we should consider in future releases.

For those of you who attended our OSIsoft vCampus Live! session on "New to PI SDK and AF SDK 2010", we announced the Community Technology Preview (CTP) of PI SDK 2010, which is now available in the "Pre-Release" area of the vCampus Download Center.  This major release includes two key features known as PI SDK Buffering and Fanning.  In a nutshell, PI SDK Buffering allows certain writes to the PI Server/Collective to be buffered when the network connection is lost.  On the other hand, PI SDK Fanning supports writing to all members of an HA PI Collective.  Taken together, these features enable custom PI SDK-based applications to write data to PI, similar to PI API-based PI Interfaces.  Note that it also enables PI OLEDB-, PI JDBC-, and PI Web Services-based applications to buffer and fan data (since these PI Data Access products all communicate to PI through the PI SDK).


It is important to note that this functionality is targeted for a specific use case: applications that insert new data into PI.  Additionally, PI SDK 2010 will have limited support for editing existing data or entering annotations, and can only write to one PI Server or PI Collective.  In some cases, manual entry applications like PI Manual Logger or PI DataLink (using the PIPutVal macro) may work with buffering and fanning, although a future release of PI SDK will include more capabilities for these scenarios.  We realize manual entry is a significant use case for you and we believe the scope of this initial release offers significant value.  However, there was just too much involved in both PI SDK and PI Buffer Subsystem (PIBufSS, which PI SDK 2010 leverages) for us to tackle it all.  Rest assured that we are aware of the need and will continue to enhance PI SDK Buffering/Fanning going forward.


That said, we know there are some folks who have developed custom applications and will benefit from PI SDK Buffering/Fanning, so we want to make this available for testing as soon as possible.  We would like to encourage you to check out the complete list of features in the "Introducing PI SDK Buffering" document in the vCampus Library (under vCampus PI Products Kits > Data Access Technologies), then try out the CTP bits with your application and send all feedback to  Also, please join us for the PI SDK 2010 CTP webinar at the end of October to learn more about this exciting release.


We look forward to seeing you at the webinar and hearing your feedback...


UPDATE 11/3/10: We all love getting something for free.  In that spirit, I have some good news to share!  It turns out that SDK Buffering will actually significantly improve the performance for applications that write to PI.  Check out this discussion thread for more details.  The real question is what does this mean for your application?  We encourage you to try this and find out, then report your results here.  We think you will be pleasantly surprised.


Announcing PI OLEDB Enterprise

Posted by jlakumb Mar 18, 2010

As my good friend Ken so astutely observed, a supported scenario with PI OLEDB 4.0 Beta 2 is for use in PI WebParts. This allows folks to bring more AF data into PI WebParts, than it currently supports through its native AF data access. For example, PI OLEDB supports more AF data references such as Formulas and Tables, as well as UOMs and other AF functionality. If you have been waiting for thin client visualization of AF, here is your chance to leverage the powerful combination of PI WebParts with PI OLEDB.


Question: Are there other PI Clients that can take advantage of this technique? Answer coming in a moment...


For those of you who watch the Engineering Plan like hawks (you know who you are), you may have noticed a name change for PI OLEDB 4.0 to PI OLEDB Enterprise (aka PI System OLEDB). This change implies that PI OLEDB Enterprise is designed for use with AF (as well as some PI data), and is a separate product from the existing PI OLEDB 3.x Provider. In addition, PI OLEDB Enterprise will be licensed under the new PI System Access (PSA) license, which was announced at vCampus Live (this was also renamed from PAL to PSA). Unfortunately this reverses my earlier statement on licensing; however, you should find that the PSA provides much, much more. Since this is not a forum to discuss sales issues, I encourage you to watch the PI Data Access product page for the Datasheet and PSA FAQ document, then contact your Account Manager for any follow up questions.


Answer: Given the ubiquity of OLEDB integration in Microsoft tools, it is also possible to bring AF data into Excel/Excel Services using PI OLEDB Enterprise. The External Data feature of Excel makes it relatively easy to write SQL queries and bring in tables of AF data, where this can be combined with DataLink/DataLink for Excel Services to create reports, charts, and dashboards with PI/AF data.


Bonus: Any idea how to do this with ProcessBook? (Hint: use ODBC datasets). If you figure this out, please test it out and post your results in the Comments section.


Now for some March Madness - Go Tennessee Vols and St. Mary's Gaels!


UPDATE 5/25/10: Full credit goes to Matt Ziegler (DataLink PM) for putting together a nice video ( Jay Lakumb) showing how to use PI OLEDB Enterprise in Excel 2010 and PowerPivot. Note, this approach of accessing external data works in previous versions of Excel as well.

Bad news: We are planning to repurpose the machine which is currently hosting the PIWS CTP. This means the CTP will no longer be accessible after this week.


Good news: We are moving forward with our plans to productize PIWS and are working on a Beta release which will be available on vCampus probably in April.


We hope this is a net positive. Please continue to share your feedback on PIWS in this forum, so we ensure we are developing the right product for your needs.

I've been traveling quite a bit last month, visiting customers and presenting at our Regional Seminars in Atlanta and Raleigh. I'm also preparing for talks at OSIsoft vCampus Live!, so things have been busy toward the end of this year...


With all this going on, I wanted to take a moment to share our plans on AF support in PI Data Access Tools. As you know, we already have a couple ways to read/write AF data - AF SDK and PI OLEDB 4.0 (beta announcement is here).


It turns out, due to our JDBC-OLEDB bridge architecture, that PI JDBC will also support AF. In fact, the current PI JDBC Driver 1.0 can connect to PI OLEDB 4.0 Beta to access AF. All you need to do is specify "Provider=PISysOLEDB" in the connection string. (Note, this provider name may change in the PI OLEDB 4.0 release version).


Using PI JDBC 1.0 with PI OLEDB 4.0 provides same AF functionality as using PI OLEDB directly. This means vCampus folks can use PI JDBC now to access PI data, and be assured there is a path forward to access AF data as well.


UPDATE 11/6/09: For non-beta or non-dev systems, the recommended solution is to wait for PI JDBC 1.1 to use with PI OLEDB 4.0.  We plan to document, test, and support this combination of products.


PI OLEDB 4.0 beta is available

Posted by jlakumb Oct 14, 2009


Give it a test drive and let us know what you think.  Looking forward to your feedback...



Posted by jlakumb Sep 10, 2009

If you're monitoring the Engineering Plan on the Tech Support site, you may have noticed that we just announced a new major release - PI OLEDB 4.0. You might have also seen that we removed PI System OLEDB Provider 1.0. It turns out that all we did is combine the existing PI OLEDB 3.3 and the new PI System OLEDB 1.0 into one release called PI OLEDB 4.0.


We are doing this for several reasons:


1. PI OLEDB and PI System OLEDB Providers are complementary and will likely be used together in apps
2. Encourage current PI OLEDB customers to upgrade and use the AF functionality in PI System OLEDB
3. Simplify our product offering (this is a general strategy we are using across the PI infrastructure)


We hope this reduces the activation energy to allow your OLEDB apps to leverage both time-series data in PI with context metadata in AF.

In my last post, I pre-announced the availability of PI JDBC Driver 1.0 on vCampus this week. I'm pleased to say the software is now available in the Download Center and documentation can be found in the Library. I also pre-announced that I'd be writing more often, so I guess I'm 2 for 2. ;-)


So what are the use cases for PI JDBC Driver?
1) Developing custom Java applications that access PI data
2) Accessing PI data from non-Windows operating systems
3) Using 3rd party Java tools that support JDBC out-of-the-box


For you Java folks out there, check out the PI JDBC Driver manual and system requirements then give this new data access product a try. If you have any questions or run into any issues, feel free to contact our outstanding Technical Support. We also created a new Discussion Hall forum dedicated to PI JDBC Development.


Oh, and if you find this to be a valuable product, leave us a note somewhere here on vCampus - we never get tired of hearing your success stories. Now I'm off to grab my morning cup of Java...

Hi Folks! This is Jay Lakumb here. Welcome back to the PM Blog. You've come to the right place for current news and future plans regarding all PI products. Yes, we've been a little quiet lately. Too quiet. All that is about to change as we introduce not one, but two new products today...


First, a little about myself. I've been with OSIsoft for nearly 6 years, based in our San Leandro office. I started as the Dev Lead for PI WebParts then joined the PM team in 2007. I'm responsible for PI Data Access products (including all the ones represented on vCampus) as well as Microsoft Office integration (including DataLink and DataLink for Excel Services). I'm passionate about a few things: my 6-year old son (which parent isn't?), traveling, golf!, and delivering great software to our customers and partners.


Now on to the news of the day. As you probably know, we announced the availability of the PI Web Services Community Technology Preview (CTP) last month. As of this week, the VM is finally live. My colleague Steve blogged about it here and here. Feel free to try this out and let us know what you think. Considering your past, current, and future projects using web services, how well does PI Web Services match your needs? You can send feedback (questions, comments, or criticisms - be nice!) to, post in the Web Services and PI discussion forum, or just add a comment here on the PM blog.


The other piece of news, in advance of the webinar on Aug 26, is the availability of PI OPC UA Server CTP. Again, the VM is live and here is the URL:


Please send feedback to, post in the PI OPC Development forum, or add a comment here. We will be providing more info on how to access both of these data access tools at the webinar tomorrow. Look forward to seeing you there!


As a bonus, I'll pre-announce the availability of PI JDBC Driver 1.0 on vCampus. Keep your eyes open for the bits in the Download Center (later this week?). With the recent releases of 64-bit PI SDK, AF SDK, and PI OLEDB, this is an exciting year for enabling newer and better access to all the goodness in the PI System. I encourage you to stay tuned to this blog - we'll try to share more than once every 10 months... ;-)

Filter Blog

By date: By tag: