Pentaho Email Alerting system
Pentaho can used to create an Alerting tool using that any kind of report can be triggered using email.
Some use case example,
- Suppose I want todays sales report to get this report just send email to given email id with specific subject like “send me todays sales report” After some time (2-3 min) an email with sales report graphical and tabular as attachment (pdf ,csv, excel ..)will be send to the user.
- Data base Artifact report form almost any database can be generated and send on demand to the user .
- It can configured to send some alert also
- if database/table space is less then 10 %
- if any specific query is taking longer than expected to execute.
- Top 10 query by performance.
- Top 10 table by space used.
- It can configured to load data from any excel sheet(from email attachment) to any database in predefined tables.
- It configure to execute any batch of shell command directly from email.
- Major advantage of this tool is to get reports/Alerts without logging into any system, everything can be triggered using email from specific id.
- These reports/Alerts can be scheduled to run on any specific time also,
