SQLite JDBC Data Source

JDBC Data Source Connection
SQLite

Overview

A JDBC driver is a software component enabling a Java application to interact with a database. To connect with individual databases, JDBC (the Java Database Connectivity API) requires drivers for each database. The JDBC driver gives out the connection to the database and implements the protocol for transferring the query and result between the client and the database.

iDashboards is able to connect to SQLite databases using a JDBC driver. This document gives a step-by-step procedure to install the JDBC driver and make the connection to your SQLite database.

Prerequisites

Install the SQLite JDBC driver on the iDashboards server.

1. Download the latest version of the SQLite JDBC driver from here: https://bitbucket.org/xerial/sqlite-jdbc/downloads/
2. The driver will be a .JAR file. Copy this file into your <iDashboards Installation Directory>/ivizgroup/drivers folder
3. Restart the iDashboards service

In addition, the service account running the iDashboards service must have read/write permissions to the folder that contains your SQLite database.

iDashboards Data Source Connection

Once you have installed the SQLite JDBC driver and given proper folder permissions to the iDashboards service account, you can add this connection as a data source in iDashboards. The following steps describe this process.

1. Log on to your iDashboards Admin Application and click on the Data Sources tab
2. In the (new) dropdown menu, select Generic JDBC and click Add Data Source
   
3. In the Add Data Source screen, the following fields are required:
   • Data Source Name: This can be named anything and is used for reference within iDashboards
   • User ID: Database user with access to your database (may not be necessary if database is local to the iDashboards server)
   • Password: Password for the database user (may not be necessary if database is local to the iDashboards server)
   • Database URL (use the following template):
     • jdbc:sqlite:\C:\SQLite\db\chinook.db
   • JDBC Driver Class: org.sqlite.JDBC

Example:

In the database URL, replace the path to your database (“\C:\SQLite\db\chinook.db” in the above example) with the path to your database file. The SQLite driver requires that you use the full UNC path to your database file so if your path is remote from the iDashboards server, then your URL would be similar to this: "\<System Name>\C$\SQLite\db\chinook.db".

4. Click “Save”. Your data source is now available.