I am looking for some advice to write a piece that obtains PI process data (either in batch or real-time), puts it in my pre-configured DB schema, and does certain proprietary calculations on my end. Currently, my software uses MySQL as backend (it already has an OPC client).
Is PI JDBC driver the right thing to get started? I was originally planning to use OLEDB provider, but realized that it may not work with mysql.
Any advice will be much appreciated!