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.
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.
What we do at our organization for daily (Weekly, etc.….) routine reports is as follow: