Installing

• Requirements
• Download ART
• Deploy the web application
  • Installing Tomcat
    • Linux Installation
    • Windows Installation
  • Deployment on Tomcat
• Launch ART
• Using the demo database
  • Demo users
  • Demo datasources
  • Demo reports
• Using your own database

Requirements

• Java EE application server or servlet container e.g. Apache Tomcat 9. ART currently doesn't work with Tomcat 10 or any Jakarta EE application server.
• Java 8 and above

Download ART

• Download the latest ART package from http://sourceforge.net/projects/art/files/
• Unzip the package to a temporary location. The resulting directory path will be referred to as PACKAGE_PATH.

Deploy the web application

Deploy the ART web application, art.war, to the application server. If you don't already have a java application server set up, you can download and use Apache Tomcat.

Installing Tomcat

You can get Tomcat from http://tomcat.apache.org/

Linux Installation

• Download the latest binary distribution
• Unpack the archive somewhere e.g.

  tar xvzf apache-tomcat-7.0.23.tar.gz
  sudo mv apache-tomcat-7.0.23 /usr/local/tomcat
  

The /usr/local/tomcat directory will be referred to as TOMCAT_HOME.

• Go to TOMCAT_HOME/bin and run ./startup.sh to start Tomcat.
• To stop Tomcat, go to TOMCAT_HOME/bin and run ./shutdown.sh

Windows Installation

• Download and install the Windows Service Installer package
• Change the default install location from C:\Program Files, e.g. install to C:\tomcat.
• To start Tomcat, start the service e.g. type "net start tomcat7" in a command prompt window. You may need to open the command prompt window using the "Run as administrator" option.
• To stop Tomcat, stop the service e.g. type "net stop tomcat7" in a command prompt window

Once Tomcat is installed and started, open a browser and navigate to localhost:8080. You should see the Tomcat welcome page. This indicates that the Tomcat installation was successful.

Deployment on Tomcat

You can deploy web applications to Tomcat via a browser using the Tomcat Manager utility available from localhost:8080, or by copying the .war file to the TOMCAT_HOME\webapps directory.

• Ensure Tomcat is running
• Copy the file PACKAGE_PATH\art.war to TOMCAT_HOME\webapps. This will cause the web application to be deployed and a new directory TOMCAT_HOME\webapps\art to be created. This directory will be referred to as ART_HOME.

Launch ART

• Using a browser, navigate to localhost:8080/art
• You will be taken to the ART Database page. ART needs a database to store details about reports, users etc (the ART repository).

Using the demo database

ART comes with a demo database embedded within the application. This allows you to explore the application's functionality without having to set up your own database first. The demo database is a HSQLDB database that is run in standalone mode. The files for the database are contained in the ART_HOME\WEB-INF\hsqldb directory of the deployed application. To use this database as the ART repository,

• Select the Configure | ART Database menu
• For the Database Type field, select Demo
• Click on Save

Note:

• If you use the demo database as your live/production setting, be careful. If the application is undeployed, accidentally or otherwise, you will lose the database as the database files will be deleted along with all other application files when the application is undeployed/redeployed. It is therefore not recommended to use the demo database as your live database.

Demo users

The demo database has 2 users configured - admin and user. To login, use one of the following username/password combinations

• admin/admin (an admin user)
• user/user (a normal user who can schedule jobs)

Demo datasources

The demo database has 2 datasources configured - ArtRepository and SampleDB.

• ArtRepository allows you to query ART repository tables e.g. ART_USERS, ART_QUERIES etc. The username/password for this database is ART/ART.
• SampleDB allows you to query a sample target database. It has tables like ORDERS, ITEMS, REGIONS, CITIES. Most of the demo reports use this datasource. The username/password for this database is SAMPLE/SAMPLE.

Demo reports

The demo database comes with a number of reports. These sample reports help to illustrate some of the report types and features of the application.

Using your own database

You can use a different database for the ART repository, instead of the demo one that comes with the application. The following steps are required to use a different database.

• Create a database in your RDBMS to be used for the ART repository
• Edit the file PACKAGE_PATH\database\art-tables.sql as per the NOTES for your RDBMS, and then run the file on the database you have created
• Run the SQL file for your RDBMS located in the PACKAGE_PATH\database\quartz directory
• Navigate to localhost:8080/art using your browser
• On the ART Database page enter the appropriate details for your database and click on the Save button
• Select the Configure | Users menu and then the Add button and create a user with the Admin role to be used for administering the application
• Log off
• Log in as the newly created admin user
• Create reports as desired