I want to create a connection using PI OLEDB with JMP and PI data. How do I achieve that?
Is your question for JMP referring to https://www.jmp.com?
As far as I can see the English product documentation is available online and as PDF download. My search for OLEDB didn't yield any result. According to the online help, it is possible to Import Data from Excel or text file format.
So based on this very basic research I believe the easiest and fastest option is using PI DataLink to get PI Data into MS Excel and to import from JMP.
Yes, it's jmp.com. I've tested connecting JMP with PI using PI ODBC and it works good but haven't found any other way to connect JMP and PI.
I didn't see ODBC connectivity is supported by JMP but am happy it is working for you. If you are interested in exploring additional options and because I obviously didn't find supported communication standards, please let us know what standards are supported or even better, point us to the corresponding place in JMP's online documentation. We might be able to suggest other options depending of what's supported by them.
Yes, JMP can connect to Pi. Its almost identical to the way Excel connects to Pi
you must have the Pi ODBC driver to make it work.
I use a quick short cut to get a template is to connect to Pi in Excel, then copy the connection string and use that in JMP. (find an example query in the Scripting Index, then substitute your connection string)
I suppose it would are relatively easy to use File>Database> then use your configured machine data source from there.
Pi has some other connection tools that are relatively new to make this even easier, I don't remember the name of the product.
My search on OLEDB Support from the JMP side is also similar to Gregor Beck.
JMP didn't seem to support the OLEDB standard natively. It did support ODBC Driver and it seems to be a more popular choice.
JMP does look like it supports JSON which is a typical response type from Web Services, such as PI WebAPI.
I can imagine that using it with PI WebAPI will not be much different from this google search result:Reading JSON data with a REST API - JMP User Community
In the latest version of JMP, v15, JSON can be opened directly, so that makes things a little easier too.
Retrieving data ...