Firebird JDBC example and SQL to build dashboard

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

Here are the detailed steps to get connected with Firebird using JDBC and build dashboard with InfoCaptor.

Assumptions

  • Make sure Firebird is installed
  • Make sure Firebird server is running
  • Setup SYSDBA user and password (the default password is masterkey)

1. Download Firebird JDBC driver. For this tutorial we have used the 64bit drivers for windows

Image

2. Unzip the zip file and extract the files

3. Copy the jaybird-full-3.0.2.jar to the infocaptor_path/tomcat/lib directory

Image

4. Paste the jar file in the InfoCaptor Tomcat/lib directory

Image

5. For our testing on a windows machine we had to change the wirecrypt setting in Firebird

Edit the firebird.conf file (it should be in the firebird directory under program files)

Change or uncomment the setting for WireCrypt and set it to Enabled

Image

Save the file.

6. Restart Firebird if needed (if you modified the firebird.conf file then you need to restart)

7. If InfoCaptor is already running then stop by shutting down the Tomcat window (since only jar file is updated, we can restart only Tomcat)

8. Start InfoCaptor by running the local or network mode

Image

9. Go to the connection window and define the JDBC connection as shown below. In the example below we are connecting to the default database employee.db supplied by Firebird

Image

 

Here are the details

org.firebirdsql.jdbc.FBDriver

jdbc:firebirdsql:localhost/3050:C:/Program Files/Firebird/Firebird_3_0/examples/empbuild/EMPLOYEE.FDB

Make sure to enter user and password

10. Click on “Test Connection”. If successful you should see a list of tables

Image

How to query Firebird database within the dashboard creator

1. Once you define the connection handle, head over to InfoCaptor’s Data Tab and expand the “Database connection list”

Image

2. Click on “firebird”, this is our newest connection handle

It should display all the tables that belong to this connection

Image

3. Click on the ‘SALES’ table and it should display sample data

Image

4. Click on “Analyze Data from selected Table”

Image

5. It will take you to the Visualizer Tab

You should see a list of Dimensions and Measures for the selected “SALES” table

Image

Quickly drag the “ITEM_TYPE” and add any measure. It should display a pivot table or any selected chart.

This completes the setup and integration of Firebird jdbc for building dashboards

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH