SQLite Data Connection

Version

Application Scenario

This document describes how to connect to an SQLite database.

Version and Driver

If the built-in driver is accidentally deleted, you can re-download it: SQLite Driver. For details about uploading the driver, see Driver Management.

Downloading the Driver File

Before connecting the database, you need to collect the following information.

T1. The database storage path

2. The username and password of the database

1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, and click New Data Connection, as shown in the following figure.

2. Find the icon of the SQLite database.

3. Enter the username, password, and the data connection URL.

If the path of the database is C:\Users\86150\Downloads\FRDemo.db, modify the URL to jdbc:sqlite:C:\Users\86150\Downloads\FRDemo.db.

If the database is in the project, for example, the built-in database in the FineReport project is located on %FineReport_10.0%\webapps\webroot\help, the URL can also be written as a relative path: jdbc:sqlite://${ENV_HOME}/../help/FRDemo.db.

If the database and the project are located on different servers, you need to share the network path and replace the above path.

4. Click Test Connection. If the connection is successful, click Save.

Note:

When a SQLite database is obtaining a connection, if there is no database under the PATH path in the URL, a database will be created automatically under this path. Therefore, the connection may be successful even if there is no SQLite database under the actual PATH path.

You can add database tables to FineBI by adding database tables or adding SQL datasets.