Features

• Features
  • Quick report creation
  • Interactive reports
  • Scheduled reports
  • Charts
  • Dashboards
  • Alerts
  • Dynamic queries
  • Parameterized reports
  • Individualized reports
  • Dynamic datasources
  • Dynamic job recipients
  • Formatted reports
  • Internationalized user interface
  • Pipelines
  • Start condition
  • Holidays
  • Password protect PDF or Excel output
  • Multiple schedules
  • Job error notification
  • Application error notification
  • LDAP authentication
  • Windows domain authentication
  • Send file to FTP
  • Report auto-refresh

Features

ART is a reporting tool that enables quick deployment of SQL query results. Some of its features include the following.

Quick report creation

Paste the report SQL in the report definition and you have a report ready for users

Interactive reports

Run and accessed via a browser

Scheduled reports

Delivered via email or accessible via a browser

Charts

Generate charts from SQL

Dashboards

Have multiple charts or reports on a single page

Alerts

Send an email when a given condition is satisfied

Dynamic queries

Run different SQL statements depending on user input

Parameterized reports

Users can select or input parameters that are then passed to the SQL query

Individualized reports

Use rules or values to dynamically filter query results depending on the user running the report

Dynamic datasources

Choose the report's target database at runtime

Dynamic job recipients

Email reports to a dynamic list of people

Formatted reports

Create pixel perfect reports

Internationalized user interface

With translations available in several languages

Pipelines

You can specify jobs to run in a specific order e.g. run job1, then job3 then job6.

Start condition

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.

Holidays

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.

Password protect PDF or Excel output

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.

Multiple schedules

You can specify multiple schedules for a job, in case the schedule required is complex and can't be specified using a single rule.

Job error notification

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.

Application error notification

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.

LDAP authentication

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.

Windows domain authentication

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.

Send file to FTP

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.

Report auto-refresh

You can set 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.