Firebird SQL Data Source

Table of Contents

JDBC Driver Installation
Standard Data Source Connection
Generic JDBC Connection

JDBC Driver Installation

iDashboards can connect to a Firebird database using a JDBC (Java Database Connectivity) driver. Before you can connect, the driver must first be installed on your iDashboards server.

1. Check to see if you already have the driver installed. To do so, log on to the iDashboards Admin Application and click Data Sources. Underneath your list of data sources, you will see a list of installed JDBC Driver Classes.
   
   The driver class for the Firebird JDBC driver is org.firebirdsql.jdbc.FBDriver. Note the absence of a particular driver class from this list does not necessarily mean that it is not installed. To install the driver, proceed to the next step. If you already have the driver installed, you can skip the remainder of this section.
2. Download the latest version of the driver on your iDashboards server from the following location:
   http://www.firebirdsql.org/en/jdbc-driver/
3. Unzip the downloaded file to a temporary location and locate the following file: Jaybird-3.0.1-JDK_1.7.zip
4. Copy the jaybird-3.0.1.jar file to your <ivizgroup home>/drivers Note: For iDashboards production installations deployed using the automated Windows installer, the default <ivizgroup home> directory is C:\Program Files (x86)\iDashboards_SRV
5. Restart your iDashboards Server service to complete the driver installation.

Standard Data Source Connection

Once the JDBC driver is properly installed, you can make the connection in iDashboards. Note that the iDashboards server must have access to your database server, and you will need a username and password with at least SELECT privileges to your desired database.

1. Log on to the iDashboards Admin Application and click Data Sources
2. In the (new) row below your existing data sources, click the (Select Type) dropdown, select Generic JDBC, and then Add Data Source
   
3. You will be presented with the Add Data Source screen. The following fields are required:
   
   Data Source Name: This can be anything you like and is for reference only
   UserID: A database user with at least SELECT privileges to your database
   Password/Confirm Password: The user’s password
   Server Name: The host name or IP address of the server with your database server instance
   Port Number: Your database server's port
   Database Name: The name of the database that you wish to connect to
   All other fields are optional. Please refer to the iDashboards Admin Manual for details on all of the fields
   
   
4. Click Save. If all of the information is correct and there are no connectivity issues, your data source is now available

Generic JDBC Connection

Alternatively, you can use the Generic JDBC option to construct a custom connection string to your database. This can be useful if there are special parameters that need to be added to your connection string that would otherwise not be possible with the standard Add Data Source options.

1. Log on to the iDashboards Admin Application and click Data Sources
2. In the (new) row below your existing data sources, click the (Select Type) dropdown, select Generic JDBC
   
   
3. You will be presented with the Add Data Source screen. The following fields are required:
   Data Source Name: This can be anything you like and is for reference only
   Database URL: The connection string to your database which should begin with jdbc:firebirdsql://
   Example Connection String: jdbc:firebirdsql://server:port/C:\\Temp\\TEST.FDB
   JDBC Driver Class: org.firebirdsql.jdbc.FBDriver
   The UserID and Password fields are required only if you do not include these values in your connection string. All other fields are optional. Please refer to the iDashboards Admin Manual for details on all of the fields
4. Click Save. If all of the information is correct and there are no connectivity issues, your data source is now available

 Applies To

• iDashboards Enterprise