Data Connection to Derby

Version

Application Scenario

This document introduces how to connect to the Derby data source.

Note:

This database does not support data tables with direct connection attributes.

Enabling the Remote Service

You can skip this step during local use (namely, FineBI and the database on the same machine).

For non-local use, you need to use the following command to start the database network service on the server where the database is located. The IP address in the command needs to be modified to the actual IP address of the Derby database server.

NetworkServerControl start -h 192.168.5.143 -p 1527

Version/Driver

Download the driver package and upload it to FineBI. For details, see the "Uploading the Database Driver" section in Driver Management.

Connection Information Collection

Before connecting FineBI to the database, you need to collect the following information:

• IP address and port number of the database server

• Database name

• Username and password of the database

• Schema of the database to be connected

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

Note:

If you are not the admin, you can configure data connections only after the admin assigns you the permission on the data connection module. For details, see Data Connection Permission Overview.

2. Find the Derby database, as shown in the following figure.

3. Select Custom from the Driver drop-down list, select the driver uploaded in the "Version/Driver" section, and enter the connection information collected in the "Connection Information Collection" section.

Schema is available after the database is connected. Click Click to Connect Database, and then set Schema, as shown in the following figure.

4. Click Test Connection. If the connection is successful, click Save, as shown in the following figure.

Two methods are available to add tables to FineBI from the DERBY database.

• Adding Database Tables

• Adding SQL Datasets