Teiid Dashboard Builder

Teiid Dashboard Builder is a web application for the visual composition of dashboards. A dashboard is composed by a set of business indicators (aka Key Performance Indicators) which are feed from data coming from Teiid virtual databases.

The project itself is a customization of the Dashboard Builder project. This customization has the following goals in mind:

• To replace the whole tooling look&feel with Teiid's branding.
• To provide users with a set of out-of-the-box sample dashboards to demonstrate how to exploit data coming from Teiid virtual databases.
• To offer a tight integration between Dashbuilder and Teiid at the data connectivity layer.

If you discover pitfalls, tips and tricks not described in this document, please update it using the markdown syntax.

Building the project

If you want to build the project please, proceed as indicated:

1. Prerequisites:

This guide assumes you have Java JDK 1.6 (set as JAVA_HOME), and Maven 3.0.4+ (set as MAVEN_HOME) in your system. The java and mvn commands must be added to the executable's path as well.

2. Open a terminal window, go to the project root directory and type the following command:

    $ mvn clean install -Dfull -DskipTests
   

This command compiles, builds and runs the application. It'll last a few minutes (but only for the first time) because the maven build process needs to download a lot of third-party libraries.

Quickstart Demo

To execute a quick demo, first see "Building the project", the proceed as indicated:

1. Go to the builder/target directory and unzip the teiid-dashbuilder-demo-installer.zip file to a given directory (the [target_directory]). You should get a directory structure like this:

     [target_directory]/teiid-dashboard-demo
                          README.md
                          start-demo.sh
                          realm.properties
                          /db
                          /log
   

2. Open a command window and execute the start-demo.sh script:

    $ cd [target_directory]/teiid-dashbuilder-demo
    $ sh start-demo.sh
   

NOTE: The application uses an auto-deployable embedded H2 database which it's automatically created when you start the app for the very first time. The database initialization procedure takes a few minutes. Furthermore, you should take into account that the H2 database downgrades the application performance compared with other databases like PostgreSQL, MySQL, which are normally used in production environments.

3. Once the application is started, open a browser and type the URL: http://localhost:8080/teiid-dashboard. The following user/password are available by default:

   root/root: to sign-in as the superuser
   demo/demo: to sign-in as an end user

On start-up, the application installs automatically some ready-to-use sample dashboards, for demo and learning purposes.

To stop the application close the terminal window or type the "Ctrl + C" command.

4. Application database

The application database will be generated automatically when you start the application for the first time. If you want to restore the application to its initial state you can:

• Stop the application (if running).
• Delete the database files in the /db directory.
• Re-Start the application.

JBoss Application Server

Prerequisite: It's assume Teiid will be deployed to the same JBoss Application Server that the dashbuilder war will be deployed. If you wish to use only the Teiid JDBC driver to access a remote Teiid server, you will need to add the Teiid JDBC driver to the war or make sure its in the classpath to be picked up by the war.

To deploy the dashbuilder war to a JBoss Application Server, first see "Building the project", then proceed as indicated:

1. Go to the builder/target directory and find the teiid-dashbuilder-jboss-as7.war

2. Now take a look at the following file builder/README.md.