|
|
Features Overview
- Provide live data via a web browser (table/crosstab, graphs, spreadsheets, pdf)
- Group queries/graphs in a single portal-like page
- Schedule queries and publish or send via e-mail the results
- Build rules to dynamically filter query results based on user
- Leverage on your LDAP / MSWin domain or existing authentication systems
- Simple to install, administer and use
- Open, platform independent, freely available
From a simple Query to a Business Intelligence Solution
Once a SQL query code is ready, it can be plugged in Art in a few minutes. Granted users can login and specify parameters (text, data, numbers, drop down List of Values, chained parameters), view the result in the browser, export to spreadsheet/pdf or schedule and receive the output via email.
Just change the query type to render the information in a chart (basic 3D Pie, Line, Bar etc).
By grouping multiple queries/charts in a single portal like page, multiple business metrics can be displayed in a single screen.
There is no need to read tons of documents or edit huge xml files: end-users can start using Art with no training, while just standard SQL is needed for a developer to be productive and deliver.
Technology
ART is a J2EE (Java2 Enterprise Edition) web application compliant with the Servlet 2.4/JSP 2.0 specification. You can install the application in any Servlet/JSP container 2.4+/2.0+ compliant (tested with Apache Tomcat, Oracle OC4J, Jetty). Any Operative System with a Java Virtual Machine (1.4 or upper) can be used (tested with Linux, HP-UX, MS W2K).
ART leverages on other Open Source technologies: Apache POI to create MS Excel files, samba.org JCIFS to provide MS Win authentication, iText for PDF output ,cewolf/jfreechart for graphs, TinyMCE as in-browser html editor and ajaxtags for Ajax enabled components.
ART uses a small set of database tables - ART Repository - to store query definitions, users, privileges, databases to connect to etc. Tested with Oracle, Mysql, Postgresql or with the ready-to-use hsqldb embedded database (see ArtHsqldb for more details).
Queries can be created toward any database where a JDBC driver is available (tested on: Oracle, Postgresql, Mysql, SQL Server, AS400, Informix, DB2, etc.).
What is not
ART target is simplicity: once you have a SQL query you can let user access information in matter of minutes.
There is not much control over the output formatting: if you are looking for a tool to create nice looking printable sheets - like invoices or purchase orders - probably Art is not the tool for you: have a look at http://jasperreports.sourceforge.net instead.
|
|
ART