Automatically fill in data from external source

SaraGo — Sat, 10 Jun 2023 23:42:32 GMT

Is there a way to link a JMP database to an external source, and automatically fill in new data in the JMP table as the external source is updated?

Re: Automatically fill in data from external source

briancorcoran — Thu, 13 Jan 2022 15:24:30 GMT

Hi Sara,

The short answer is yes, but there are many steps to getting a final solution. You must get access to the database from your IT administrators, and then install an appropriate ODBC driver to access the database. Once you have that working outside of JMP, the steps are fairly straightforward. You can form a query in Query Builder, or with the Open Table dialog. When you get the JMP table the way you like it, there is an Update script created in the table properties by JMP that you can reference. Take the JSL (script) out of there, and create a standalone file with it. Then, use something like the Windows Task Scheduler or Mac Automator to run the script everyday.

I gave a talk at a Discovery conference that describes much of this. You can reference it at

I hope this helps,

Brian Corcoran

JMP Development

topic Automatically fill in data from external source in Discussions

Automatically fill in data from external source

Re: Automatically fill in data from external source