Hello,

I am looking at performing calculations on PI data to generate metrics (N-to-1, or perhaps N-to-few) for data sets, and writing these metrics back into PI.

- this will involve use of the Signal Processing toolbox, as well as Statistics/Machine Learning toolbox, which I am already aware

Currently I am using PI SDK for accessing data from Batch DB (for limited batch context) as well as continuous data (and so have not needed to use either MATLAB's Database or OPC toolboxes).

However, as we move towards adopting Event Frames and PI Integrator for Business Analytics, I am **wondering if I will need or should have MATLAB's database (or other toolbox) to access info from the Integrator, or if there's a separate PI AF SDK or specific SDK for accessing Integrator-collated data.**

Any assistance on this would be appreciated,

Jerry

Hi Jerry,

As always there are a number of options to integrate Matlab with PI. We've used the AF SDK, which you will need to use as the PI SDK can't access EventFrames. I wrote a blog post a few years ago that will hopefully give you an idea of how to get started.

@Steve: Yes you can access an OLE-DB, ODBC or JDBC data source using Matlab if you have the Database Toolbox. The one limitation of the current integrators or OLE-DB is that you can't write back to AF, something that Jerry mentioned.