What are the option to integrate with PI OLEDB from Java. We don't have an option to use PI JDBC.
PI OLEDB itself is compliant to the OLEDB standard so using it is not different from using any other OLEDB. It is generally only used in the Windows environment. Could you share the use case for your project?
Would using the PI OLEDB as a linked server to Microsoft SQL Server or Oracle RDBMS be an option for your case?
Thank you for your response.
We are planning to get PI data from pi archive and store it temporarily in a database for analysis. Our customer has 6 PI servers. we asked them, can we use PI OLEDB as linked server to MS SQL server then the customer said only two of the 6 servers allow this type of connection but other don't. Customer said they don't have PI AF for 4 servers and using linked server require PI AF. Does PI OLEDB linked server to MS SQL Server require PI AF?
Can you please elaborate why you consider using PI JDBC Driver or PI SQL Client JDBC not a valid option?
The customer does not have licenses, acquiring licenses approval and installing any missing software takes time for them. My project time line is short. So we are looking for alternatives.
Using one of our Developer Technologies in production requires a PSA (PI System Access) license. It doesn't matter which Developer Technology is used in production. With other words, license wise, there is no difference between using PI OLEDB Provider / PI OLEDB Enterprise Provider or PI JDBC Driver (or any other Developer Technology).
The remaining challenge might be to enhance an existing PI OLEDB Provider/ PI OLEDB Enterprise installation with a PI SQL Data Access Server and a PI JDBC Driver installation. The PI SQL Data Access Server is a data access layer combining PI OLEDB Provider and PI OLEDB Enterprise Provider to be used by PI ODBC Driver of PI JDBC Driver. Running an OSIsoft setup kit is known to be dead easy. Configuring security might be a little more challenging but is worth the effort considering you could use native JDBC access.
We recommended it,customer have six pi servers and each server owned by a different group. it will take long time to get approval from each department for any change.
Can I use linked server to PI OLEDB from MS SQL Server without PI AF?
Yes. PI OLEDB Provider provides SQL like access to the PI Data Archive. PI OLEDB Enterprise Provider is the entrance gate to PI Asset Framework.
I understand your pain points due to "bureaucratic hurdles". On the other hand I would expect if there is support for your development project, you should also get support in choosing the best available option. Good planning is key for success. In that regards my idea would be to push data from sites to the central store rather than pulling the data from a central system. One of the advantages is that sites will have to care to fulfill the prerequisites if they recognize the value in the data analyses and like to participate. Have you looked into available options which wouldn't require any custom coding like using PI integrator for Business Analytics?
Thank you Gregor.
I will use Microsoft SQL Server linked server to PI OLEDB. Will also discuss your recommendations within our team.
Retrieving data ...