6.0
/
This document describes how to connect to an SQLite database.
FineBI comes with the built-in sqlite-jdbc.jar driver package.
org.sqlite.JDBC
URL format: jdbc:sqlite:[PATH_TO_DB_FILES]
If the built-in driver is accidentally deleted, you can re-download it: SQLite Driver. For details about uploading the driver, see Driver Management.
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.
You can add database tables to FineBI by adding database tables or adding SQL datasets.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy