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

Posted in analytics | Tagged , , ,


Would you like to build your dashboard now?

If so, click to buy now, including 60 minutes of dashboard development for free!