topic How to do a routine data import from data base and running JMP script in Israel JMP Users - קבוצת משתמשים - ישראל

How to do a routine data import from data base and running JMP script

Gilad_Markman — Tue, 03 Jul 2018 08:38:25 GMT

Does anyone know if the JMP supports routine import of data from a data base?

We are interested in daily import of data and than running a script on the data in an automatic manner.

Currently this a general question, we have two JMP users in our organization, it seems like more people are interstred and a routine reporting is one of the functions they want to have.

Thanks

Re: How to do a routine data import from data base and running JMP script

tom_abramov — Tue, 03 Jul 2018 09:20:58 GMT

Hi,

Yes, JMP can import data from database (with regular SQL queries) to JMP data table and then JMP can run on that data any JMP platform user needs. You can develop dashboards and statistical Addins/Tools/Automatic scripts with JSL (Jmp Scripting Language). As for "daily automatic import and analysis", I see two ways:

1. You schedule some JMP script execution with Windows Schedule to run once a day

2. You leave your JMP always ON with running script. In that script you put a loop with delay of 24 hours after each iteration.

Scripts in JMP can create and email data tables and reports in Journal/PPT/PDF formats.

If you have more questions, I'll be glad to answer.

Regards,

Tom Abramov

054-4967206

tom.abramov@ald.co.il

Re: How to do a routine data import from data base and running JMP script

Gilad_Markman — Tue, 03 Jul 2018 10:40:28 GMT

Thank you very much Tom.

Re: How to do a routine data import from data base and running JMP script

Omer — Wed, 04 Jul 2018 04:44:37 GMT

Gilad Hi

What we do at our organization for daily (Weekly, etc.….) routine reports is as follow:

We establish a JMP working station that always on.
This station has ODBC read only to the relevant DB.
We made a script that can start running at open (on double click).
The script enters DB, pool out all info need, and then make manipulations all the way to report (as graphs, Summaries and more)
At the end of this script it saves that report as PDF or Interactive HTML to a known folder.
We make a schedule procedure at the window that run the script and then send mail to the recipients.

Best Regards

Omer