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.
- 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. - Download the latest version of the driver on your iDashboards server from the following location:
http://www.firebirdsql.org/en/jdbc-driver/ - Unzip the downloaded file to a temporary location and locate the following file: Jaybird-3.0.1-JDK_1.7.zip
- 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
- 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.
- Log on to the iDashboards Admin Application and click Data Sources
- In the (new) row below your existing data sources, click the (Select Type) dropdown, select Generic JDBC, and then Add Data Source
- 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 - 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.
- Log on to the iDashboards Admin Application and click Data Sources
- In the (new) row below your existing data sources, click the (Select Type) dropdown, select Generic JDBC
- 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 - 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
Comments
0 comments
Please sign in to leave a comment.