Menu

Features

features (1)
Timothy Anyona Timothy Anyona

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

Several report formats

Including xlsx, pdf

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

Drill Down reports

Drill down on charts or tabular reports

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

OLAP

Connect to OLAP datasources and provide for slicing and dicing of data

Internationalized user interface

With translations available in several languages

File parameter

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.

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.

Encrypt files using PGP or AES

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.

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. The passwords can come from the SQL query of the report and so can be dynamic and different for different recipients.

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.

Self service dashboards

Allow users to create their own dashboards by specifying which reports they would like to appear on them.

Self service reports

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.

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, Amazon S3.

Upload report to a website

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.

Tabbed dashboards

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.

Report auto-refresh

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.

Conditional emails

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.


Related

Wiki: Home

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.