From: Dustin on
I wanted to know if anyone out there is using MATLAB with a connection to an osisoft PI server. The reason I ask is we just started using it and I was looking to maybe jump up the learning curve and learn from anyone's past if they're willing to share.

I know it is better to ask specific questions but i dont know if anyone shares my application.

FYI right know I am makeing a connection to matlab using active-x controls and the PI OLE DB Provider and the biggest trouble I've been having is with the "PI-SQL" queries, but thats a question probably better left for an OSISoft forum.
From: Steve on
There is a great white paper on using data from OSIsoft's PI System into MATLAB, located on the OSIsoft Virtual Campus (vCampus) website. The paper describes various ways to use OSIsoft's PI Data Access products to bring that data in (OLE DB, JDBC, OPC, SDK). OSIsoft vCampus (http://vCampus.osisoft.com) is an online program and community that provides software (development licenses), support and collaboration around PI development and integration topics.

There will also be a session on this very topic, at our upcoming OSIsoft vCampus Live! 2010 event, on the week of September 13th in San Francisco (http://www.osisoft.com/vCampusLive2010).

Enjoy!

"Dustin " <dbrisset(a)gmail.com> wrote in message <i39n8f$bif$1(a)fred.mathworks.com>...
> I wanted to know if anyone out there is using MATLAB with a connection to an osisoft PI server. The reason I ask is we just started using it and I was looking to maybe jump up the learning curve and learn from anyone's past if they're willing to share.
>
> I know it is better to ask specific questions but i dont know if anyone shares my application.
>
> FYI right know I am makeing a connection to matlab using active-x controls and the PI OLE DB Provider and the biggest trouble I've been having is with the "PI-SQL" queries, but thats a question probably better left for an OSISoft forum.
From: Dustin on
Thanks for the response. The white paper is indeed helpful but I could still use more help. Let me elaborate. The white paper includes sample code for PI_CurrentValue and PI_SampledData but i need to build the more advanced functions that can be found in DataLink for Excel. For example how to use PI expressions in conjuction with calculated data and time filtered data. I am starting to make progress in doing this in PI-SQL but progress is slow.

Thanks for the info though, I will also be looking into the seminar you mentioned


"Steve " <spilon(a)osisoft.com> wrote in message <i3eat3$q19$1(a)fred.mathworks.com>...
> There is a great white paper on using data from OSIsoft's PI System into MATLAB, located on the OSIsoft Virtual Campus (vCampus) website. The paper describes various ways to use OSIsoft's PI Data Access products to bring that data in (OLE DB, JDBC, OPC, SDK). OSIsoft vCampus (http://vCampus.osisoft.com) is an online program and community that provides software (development licenses), support and collaboration around PI development and integration topics.
>
> There will also be a session on this very topic, at our upcoming OSIsoft vCampus Live! 2010 event, on the week of September 13th in San Francisco (http://www.osisoft.com/vCampusLive2010).
>
> Enjoy!
>
> "Dustin " <dbrisset(a)gmail.com> wrote in message <i39n8f$bif$1(a)fred.mathworks.com>...
> > I wanted to know if anyone out there is using MATLAB with a connection to an osisoft PI server. The reason I ask is we just started using it and I was looking to maybe jump up the learning curve and learn from anyone's past if they're willing to share.
> >
> > I know it is better to ask specific questions but i dont know if anyone shares my application.
> >
> > FYI right know I am makeing a connection to matlab using active-x controls and the PI OLE DB Provider and the biggest trouble I've been having is with the "PI-SQL" queries, but thats a question probably better left for an OSISoft forum.
From: Steve on
Nice, glad to see the paper helped and that you now want to do more! The good news is, it's definitely possible ;)

I would strongly recommend that you post your technical questions on the "PI System Integration" forum on OSIsoft vCampus - the whole community and a dedicated team from OSIsoft will be happy to assist you (plus, others will benefit from the answers).

Looking forward to seeing you online - and hopefully in person at the OSIsoft vCampus Live! 2010 event!

"Dustin " <dbrisset(a)gmail.com> wrote in message <i3eofc$fuc$1(a)fred.mathworks.com>...
> Thanks for the response. The white paper is indeed helpful but I could still use more help. Let me elaborate. The white paper includes sample code for PI_CurrentValue and PI_SampledData but i need to build the more advanced functions that can be found in DataLink for Excel. For example how to use PI expressions in conjuction with calculated data and time filtered data. I am starting to make progress in doing this in PI-SQL but progress is slow.
>
> Thanks for the info though, I will also be looking into the seminar you mentioned
>
>
> "Steve " <spilon(a)osisoft.com> wrote in message <i3eat3$q19$1(a)fred.mathworks.com>...
> > There is a great white paper on using data from OSIsoft's PI System into MATLAB, located on the OSIsoft Virtual Campus (vCampus) website. The paper describes various ways to use OSIsoft's PI Data Access products to bring that data in (OLE DB, JDBC, OPC, SDK). OSIsoft vCampus (http://vCampus.osisoft.com) is an online program and community that provides software (development licenses), support and collaboration around PI development and integration topics.
> >
> > There will also be a session on this very topic, at our upcoming OSIsoft vCampus Live! 2010 event, on the week of September 13th in San Francisco (http://www.osisoft.com/vCampusLive2010).
> >
> > Enjoy!
> >
> > "Dustin " <dbrisset(a)gmail.com> wrote in message <i39n8f$bif$1(a)fred.mathworks.com>...
> > > I wanted to know if anyone out there is using MATLAB with a connection to an osisoft PI server. The reason I ask is we just started using it and I was looking to maybe jump up the learning curve and learn from anyone's past if they're willing to share.
> > >
> > > I know it is better to ask specific questions but i dont know if anyone shares my application.
> > >
> > > FYI right know I am makeing a connection to matlab using active-x controls and the PI OLE DB Provider and the biggest trouble I've been having is with the "PI-SQL" queries, but thats a question probably better left for an OSISoft forum.