I've been running into this question a lot lately. I'm fairly certain we can, but I'm looking for more details, specifically, how. I'm assuming that when folks mention Pi and Pi Historian, they're talking about the same tool (by OSI Soft).
Yes
There is an OSI Pi ODBC driver available to people who have a Pi license.
Most people have the Excel Add-In and the ODBC driver. The query string that excel uses, is pretty much the same one you need in JMP. To get started writing queries in JMP its often very handy to have a copy of the Pi Tag list file.
Most of the time Pi and Pi Historian are the same thing. Sometimes people have older Rockwell or Factory Talk systems, and those haven't been easy to work with.
Attached is an ODBC Admin guide I found in their developers area. There is a section with an example format.
No, but if he's the guy to talk to, I will.
Here is the Defect: http://sww.sas.com/ds/DefectsSearch/S1365/S1365464.html
@DonMcCormack if you have the customer, I can add a note to the defect.