ART is a reporting tool that enables quick deployment of SQL query results. Some of its features include the following.
Paste the report SQL in the report definition and you have a report ready for users
Run and accessed via a browser
Delivered via email or accessible via a browser
Generate charts from SQL
Have multiple charts or reports on a single page
Send an email when a given condition is satisfied
Users can select or input parameters that are then passed to the SQL query
Dynamically filter query results depending on the user running the report
Choose the report's target database at runtime
Email reports to a dynamic list of people
Create pixel perfect reports
With translations available in several languages
You can specify jobs to run in a specific order e.g. run job1, then job3 then job6.
You can specify multiple schedules for a job.
You can specify to get an email if an error occurs when running a job. This may be useful for critical jobs where you may need to know if an error occurred for you to take action.
You can specify to get an email when application errors occur. This may be useful to know if the system is performing well or if there are error conditions that need to be addressed.
You can specify that users authenticate to the application using credentials in an LDAP server. This may be useful if LDAP is already used for authentication within the organisation and so users may not need to know new passwords for the ART application.
You can specify that users authenticate to the application using credentials of a windows domain. This may be helpful to avoid users having to know a new password for the ART application and instead they can just use the password they use to log in to the windows domain.
You can send a report to a number of destinations after a job is run. This may be useful to have backup copies of reports, or to send a report to an external recipient. These destinations include FTP and Network Shares.