In this blog we will cover how to connect Open Source BI product Helical Insight application with Firebird database. Click on “Data Sources” page.
- The list of Data sources is present as a collection of icons for each database.
- Click on “Firebird”. Since the firebird driver is not by default present we would be first uploading the driver.
- Click on Download Relevant Database Driver. You will be directed to the website from where the driver needs to be downloaded. Make sure that the driver supports the version on database that you are using.
- Once the driver has been downloaded, click on Upload Driver. You will be taken to the File Browser. Select the driver that you have downloaded. The driver should be a jdbc4 .jar or .zip file.
- Click on Detect the driver in lib/classpath if the driver is present in the lib/classpath. Helical Insight will detect the driver and automatically upload it in the “Drivers” folder of the server.
Once the driver has been uploaded the firebird DB icon will also have tick icon which means it can be connected and used. The data source connection can be established now. Click on the Firebird DB icon once again.
- Now in the “Create” tab, enter the following details:
- Host: Enter the server details or IP where the database resides.
- Port: Enter the port number to connect to your database server.
- Database Name: Enter the name of your database.
- User Name: Enter the username credential if required to access your database.
- Password: Enter the password credential if required to access your database.
- Data Source Name: Enter a name of your choice to the data source connection.
- Advanced: If you have any advanced settings required to access your database, click on “Advanced” link at the top right corner of the Create Tab. The additional fields are:
- Other Options: Enter the properties that are required additionally apart from the Host IP and Port to access the database. E.g.: ?sel=true.
- URL: This field shows the URL that is generated to create the JDBC connection. This can be used to verify if the properties are sufficient to access the database.
- Driver: This field shows the driver that is being used to establish the connection. It can be changed if required.
- Datasource: This is the name of the datasource provider. By default it is Tomcat. It can be changed, if required.
- Once all the details have been filled, click on Test Connection.
If the test is successful, click on Save Data Source to save the data source connection.
Once the connection is successful you can then click on “View” and view the connection which has been made. Now you can create metadata from this saved connection which can then in turn be used for reporting purposes.
For further assistance kindly contact us on firstname.lastname@example.org