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.