Does OSI provide any good examples for using OLEDB so an application can be notified of new data for defined PI tags? This is fairly easy using PISDK, would like to look into OLEDB equivalents.
We used to support "events" for the PIArchive.PIComp table, back in version 2.x of the PI OLEDB Provider. For various reasons we took it out in version 3.x, as we added additional tables like PIComp2 and PISnapshot.
While we plan to bring this back at a later time (not scheduled yet) but it will most likely not go back to the OLEDB mechanism. The reason is that the new architecture - the PI Data Access Server (DAS), announced at the last Users Conference - will support other standards like JDBC and we want "events" there as well.
On another hand, you might want to explore our PI OPC DA/HDA Server (also provided in the vCampus PI Products set) as another alternative; it exposes the PI System via the OPC specifications. Traditionally, OPC has been closer to "time-series data" than relational databases and it also supports (maybe even better ) events: it's called OPC Advise.
Thanks for the update Steve.
So at this moment using current release of OLEDB there is no substitute for PISDK EventPipes? If you want your application to be notified (advised) of changes to data for certain tags you either stick to PISDK or go the OPC route.
Whilst from a development point of view I have not fully explored OPC, does OSI plan on making the move to OPC UA? What is OSIs advice on this, make the move to OPC now or wait for OPC UA? Oh and one final comment, does OSI provide client code examples? I have used couple of 3rd party OPC SDKs and used them for simple clients but would be good to get some OSI examples.
For the last 2 years, OSI has had representation in the OPC Foundation and has been actively involved in the UA working group among other UA programs. Due to this work, OSI will be releasing the first versions of the PI OPC UA Interface and Server in 2009. For more details please take a look at the Engineering Plan:http://techsupport.osisoft.com/techsupport/NonTemplates/EngPlan.aspx?ProductName=PI+OPC+UA+Server&ProductGroup=OPChttp://techsupport.osisoft.com/techsupport/NonTemplates/EngPlan.aspx?ProductName=PI+OPC+UA+Interface&ProductGroup=OPC
Wether or not you can afford waiting for OPC UA strongly depends on your timeframe. And we do have some examples in the Training material for the "Accessing PI as a Relational Database or an OPC Server" class. But as OPC is a standard you should be fine with any OPC SDK you already have.
Retrieving data ...