May 17, 2016 8:01 PM
| Last Modified: Nov 17, 2016 12:53 AM
This addin will connect to an OLEDB and convert it to a SQLite database so that it can be used with Query Builder. The addin uses a combination of JMP Scripting Language and a Python script to do most of the work.
The addin executes a Python script (thanks for the help on writing the Python script from bryan.boone) that in turn creates a snapshot of the OLEDB and saves it out as a SQLite DB. The SQLite DB can then be directly accessed from QB as shown. External programs such as Python can be executed by using the JMP scripting language or JSL. JSL has a function called Run Program.
Options for submitting a custom query or limiting the number of rows are available from the menu.
The addin was used to access Proficy Historian and Microsoft Access OLE databases. See my blog post for additional details for connecting to a Proficy Historian database.