My prospect customer asks me a question about database access to OSYsoft PI from JMP.
They recently installed PI system in their factory and just started to discuss how to utilize data. They want to know the best practice to access to OSYsoft PI.
I saw the following discussion and understand JMP can access using ODBC driver.
https://community.jmp.com/t5/JMP-SE-Discussions/Can-JMP-Access-data-from-Pi/m-p/43392
But, I saw the following defects. It seems that it has some problems when access to PI.
https://sirius.na.sas.com/Sirius/GSTS/ShowTrack.aspx?trknum=7612389374
Anybody know the best way to access to PI?
I found a following addin, which connects to an OLEDB and converts it to a SQLite database to be used with Query Builder.
Do you think this is a better approach?
https://community.jmp.com/t5/JMP-Add-Ins/OLE-Database-Tools-Addin/ta-p/23702
Additionally, anybody have any picture of recommended system architecture ? I want to share the customer if we have.
Stan, vielen Dank für Ihren Kommentar. Diese Informationen sind sehr hilfreich.