Having the fact that MS SQL Server support for StreamInsight is almost nothing; what other technologies that can connect to PI and provide similar functionality.
TIBCO StreamBase with a custom (AFSDK) adapter, or use one of the file based input adapters.
I also looked into CEP & PI. I decided to use Microsoft Reactive Extensions (Rx) instead. It provides all the functionality I need for real time data streams and offers better support.
Thanks for your reply. This is a good direction specially that I'm only starting my way into this, and a Microsoft solution will be good considering community support behind it and also free. I would really appreciate it if you can share a sample or even a description of the ideas where you used Rx against PI. I'm a developer and not much of 'Process Engineer' man but I know PI is not utilized to its full potential in my Gas plant, and to be able to play the 'Evangelist' role to my colleagues, I need to show a proof of concept.
If you search VCampus you will find Reactive Extensions examples for almost all PI systems: AF, EF, PI Server.
Barry Shang wrote a nice intro to get you started: Reactive Extensions for AF SDK (Part 1): LINQ to AFDataPipe
I used Rx to write an Excel RTD server in order to stream values and events on a spreadsheet.
In case you haven't done so already: If you want get more use out of your PI system I would start with building an ISA-95 compliant AF Structure, dash boarding using Coresight and calculating KPI's such as OEE.
KPI's and data aggregates throughout the equipment hierarchy (site level vs enterprise level) are typically what companies do first.
Once you have a good AF structure and some KPI's, you could use the OSIsoft BI tools. This should impress your management ... =;-)
Retrieving data ...