topic Tiny Tricks with Data Connectors in Discussions

Tiny Tricks with Data Connectors

hogi — Fri, 27 Mar 2026 21:58:52 GMT

The new Data connector Concept in JMP is very helpful:

- within a few minutes (and a willing AI) a user can create any data connector they want. Here is a wonderful introduction by Brian Corcoran:

- The data is piped through Query Builder. Together with the data, the user gets a working UPDATE functionalitiy.

- ...

here are some tricks:

Re: Tiny Tricks with Data Connectors

hogi — Sat, 28 Mar 2026 11:10:43 GMT

Trigger the Python Package installation again after a first installation:
e.g.:

You installed the Addin in JMP v19 , but the Connector doesn't work in JMP v25?
you installed an update of the AddIn but the Python Package is still the old one

-> delete the file 'INSTALLED_TO' or "xyz_installed.txt" from the AddIn Directory.

Re: Tiny Tricks with Data Connectors

hogi — Fri, 27 Mar 2026 22:31:28 GMT

You added a new field via the python package, but after installing the new version of the AddIn the new field is not visible in the GUI of the Data Connector.
-> close JMP and try again.

Re: Tiny Tricks with Data Connectors

hogi — Sat, 28 Mar 2026 15:21:58 GMT

Unfortunately, there is a one drawback with Data Connectors: Subfolders!
How to access the right file?

First-level subfolders can be interpreted as schemas, but deeper levels are not accessible.

The current workaround:
save a dummy data connector once.
Don't use Connect to use the Data Connector, instead click on Edit, enter the current folder manually, then click Connect.
(don't save with the new settings)
-> Connection will be opened for the specific folder

This approach feel complicated - compared to a standard Windows/Mac file dialogue to select an arbitrary file/folder
[Discovery Summit Europe 2026]: there are plans to work on this issue

Re: Tiny Tricks with Data Connectors

briancorcoran — Mon, 30 Mar 2026 16:54:12 GMT

It is true that we only support 1 level of drill down (Schema/Table) now with the dialogs and design. We are considering how to fit in multi-level while still maintaining familiarity for those traditional DB users who already have what they need. Thank you for the feedback.

Brian