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
Including xlsx, pdf
Generate charts from SQL
Have multiple charts or reports on a single page
Send an email when a given condition is satisfied
Run different SQL statements depending on user input
Users can select or input parameters that are then passed to the SQL query
Use rules or values to dynamically filter query results depending on the user running the report
Drill down on charts or tabular reports
Choose the report's target database at runtime
Email reports to a dynamic list of people
Create pixel perfect reports
Connect to OLAP datasources and provide for slicing and dicing of data
With translations available in several languages
You can specify a report to take a file parameter. Users will be provided with a dialog to select a file and this file can be processed in the report source as need be.
You can specify jobs to run in a specific order e.g. run job1, then job3 then job6.
You can specify that before a job runs, a certain condition must be met e.g. ensuring that a table has been loaded with data before a job runs. This prevents situations where a scheduled job runs in error or returns incorrect results because of a problem or a delay with an ETL process.
You can specify that scheduled jobs should not run on certain days e.g. public holidays. This would prevent running or emailing of jobs unnecessarily.
You can specify that report output is encrypted using the PGP or AES algorithms immediately upon generation. This may be useful if the recipient of a file or report requires that it be encrypted.
You can specify that PDF or Excel output be password protected upon generation. This may be useful if you need to send report output to a client or clients as password protected. The passwords can come from the SQL query of the report and so can be dynamic and different for different recipients.
You can specify multiple schedules for a job, in case the schedule required is complex and can't be specified using a single rule.
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 or warnings 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.
Allow users to create their own dashboards by specifying which reports they would like to appear on them.
Allow users to do basic querying and create their own reports, allowing them to select the columns they would like to see and define conditions for the report. This would be useful to have users do simple ad-hoc queries themselves instead of having to refer to the IT department.
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, Network Shares, Amazon S3.
You can have a report uploaded to a website after a job is run. This may help to automate a process where a report is required to be uploaded to a website.
You can define a dashboard to have tabs. This allows presentation of different charts or reports on different tabs, allowing quick access to varied pieces of information.
You can set dashboards and reports to auto-refresh after a given period of time. This allows for an easy way to have always up-to-date information being displayed on the screen.
Have emails sent only when a report contains data. This may help avoid unnecessary emails where a report sometimes contains no data. Users will be sure that any time they actually receive the report, it will have data in it.