Introduction
ART is a Java web application that enables quick deployment of SQL query results.
- ART Administrators define reports, users, etc.
- ART Users run reports and view the results in a browser or in a variety of file formats.
ART is open source software distributed under the GPLv3 license. You can install and use it without any charge.
Administration Overview
The Administrators define a number of items including
- ART Database used to store ART objects e.g. report definitions
- Settings used to configure how ART works
- Datasources against which reports are run
- Reports that can be run
- Report Groups used to group reports
- User Groups used to group users
- Users who can access the application
- User Group Membership to add or remove users from user groups
- Access Rights to determine which users or user groups can access which reports, report groups or jobs
- Admin Rights to determine which datasources and report groups report creators can use
- Parameters to be used by reports
- Rules to be applied to reports
- Rule Values to be used with specific users or user groups
- Jobs to run reports at scheduled times
- Schedules to manage schedules that can be used when creating jobs
- Caches to enable clearing of ART object caches
- Connections to view datasource connection pools
- Loggers to manage which application debug information is logged by ART
The typical process when defining a report is
- Obtain the SQL statement for the report
- Create the report
- Grant access rights to allow users to run the report