Oracle data connection

ORACLE database is currently the most widely used database management system in the world. As a general database system, it has complete data management functions; as a relational database, it is a complete relational product; as a distributed database, it realizes distribution type processing function.

In this chapter, we will introduce how to connect to the Oracle database in FineBI.

Note: For a detailed description of each setting item of the data connection, please refer to: Configure Data Connection.

2.1 Configuration information

2.2 Set the driver

If you are using Oracle 19c, you need to change the driver file.

1) Download the driver of 2.1 Configuration information.

2) Put the driver file in the webapps\webroot\WEB-INF\lib path of the project, and delete ojdbc14.jar at the same time.

3) Restart FineBI.

2.3 Ways to connect to database

There are two ways to connect:

• Method 1: After installing the driver isolation plugin, then connect to the database.

• Method 2: Do not use the driver isolation plugin, directly connect to the database.

See below for connection method. But in this way, there may be conflicts between JAR packages and cause connection failure. It is recommended that users use the first method.

2.4 Create a data connection

1) Log into the data decision system as an administrator, click "Manage>Data Connection>Data Connection Management>New Data Connection", as shown in the figure below:

2) Select "Oracle" under the "Commonly Used" option, as shown in the figure below:

2.5 Configure data connection

Enter the corresponding data connection information according to the actual situation, as shown in the following figure:

1) The introduction of driver, database name and URL is shown in the following table:

In the jdbc:oracle:thin:@TNSName URL, the value of TNSName is the value of ORCL in the tnsnames.ora file, as shown in the following figure:The description of TNSName is as follows:

The complete URL is: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST =(ADDRESS=(PROTOCOL=TCP)(HOST =localhost)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl )))

2) The introduction of other setting items is shown in the following table:

2.6 Test connection

Click "Test Connection", or click "Click to Connect Database" under "Pattern". If a successful connection prompt pops up, it means that the database is successfully connected, as shown in the following figure:

Note: After the connection is successful, the pattern will automatically select the default value.

3) Click "Save" in the upper right corner.

2.7 Preview effect

After the Oracle database is successfully connected, you can edit, rename, copy, delete and other operations on the platform, as shown in the following figure:

For some errors and solutions in Oracle data connection, please refer to: Oracle Data Connection Common Error Solutions.