KINGBASE

Kingbase is a database product oriented to transaction processing and simple analysis applications in Jincang of the People's University of China. It can carry related businesses of management information systems and business production systems in various industries, and can be used to replace Oracle's large-scale general relational database. In this chapter, we will introduce how to connect to the Kingbase database in FineBI.

2.1 Configuration information

2.2 Connection steps

• Download the driver package, and place the driver package in the FineBI folder %FineBI%\webapps\webroot\WEB-INF\lib, and restart FineBI.

• Log in to the FineBI data decision system, select Manage> Data Connection, click "New Data Connection" to select more data connections, and select "Kingbase" in the pop-up box, as shown in the following figure:

• Click OK to enter the data connection configuration page, and enter the corresponding information of the database according to the configuration information provided above. You can choose to fill in the connection pool attribute information (for the connection pool attribute introduction, please refer to the "configuration data connection"), as shown in the figure below:

• Click "test connection". If the "successful connection pop-up box" as shown in the figure below appears, it means that the database is successfully connected.

• The pattern can be selected only after the test connection is successful, and the corresponding pattern can be selected according to the requirements. If you do not select, the first pattern will be defaulted.

• After the pattern is selected, click the save button in the upper right corner, and the data connection is added successfully. As shown below: