Add database table

The database table belongs to the basic table. For the concept of basic table, please refer to: Basic table.

1.1 Version

1.2 Application

Users need to add database tables to the decision-making system and perform subsequent data analysis and dashboard display.

1.3 Feature introduction

FineBI supports the addition of four types of data tables. This article introduces the operation steps of "adding a database table".

1.4 Applicable people

Data processing users

2.1 Grant permission to add database tables

The permission to add database tables requires the administrator to configure the user, and the user type must be "data processing user".

2.2 Confirm the original field name form of the data table

When adding a table, the original name of the table field should not appear that there are both A and A-B fields (for example, there are both "sales" and "sales-waterfall chart" fields), otherwise it will be in the process of adding the table automatically treat such fields as self-circulating columns for processing.

2.3 Turn on the data type identification switch

If you need to ensure the correct identification of the data type, you can turn on the "Data Type Identification" switch in the "Manage<System<General<BI/Spider Parameter", but when the accuracy of the numeric type field exceeds the BI readable range (1~19 digits) ), it will be automatically converted to text type for reading.

3.1 Enter the package

Log in to the system, select "Data Preparation" and enter the package, as shown in the figure below:

3.2 Add table

1) Click "Add Table", select "Database Table", as shown in the figure below:

2) Enter the database table selection interface, you can select the created data connection, the right side will display the obtained table information in the data connection, and the added table cannot be grayed out. As shown below:

3) Select the table added to the package according to your needs, and select the table Sales_Volume. Click OK, FineBI will automatically read the database association, table name escape, column name escape, etc. in the selected table, as shown in the following figure:

Note: The table name and column name escape in the database will only be obtained when the table is added. After updating the table, add a comment in the database and update the table in the BI again, the escape will not be obtained .

When the data is extracted, you need to click "Update Data", and then preview in the data preview, as shown in the following figure:

4) Then enter the package, you can see the newly added database table in the business package. As shown below:

Note: After adding the basic table, you can edit it.

Note: The fields recognized as the date type by BI will automatically complete the "year, month, day, hour, minute, and second", displayed as yyyy-MM-dd HH:mm:ss (example: 2020-10-15 00:00:00)

3.3 View the path of database table

Click "Add Table" again, hover the mouse to the "Sales_Volume" table just added, you can see that the table has been grayed out and prompt that the table has been added to the package, as shown in the following figure:

The prompt rules are as follows:

3.4 Search database table

Enter keywords in the search box of the add table interface to display all related database tables, as shown in the following figure:

3.5 View database table source

In the preview interface, click "..." to view the original name and source of the added database table, as shown in the following figure:

4.1 Data update settings

If you do not choose to enable real-time data for a database table that is successfully added, you need to update the data before you can use it, such as adding self-service datasets, creating components, and so on.

4.2 Read escape name of database

The table name and column name escape in the database will only be obtained when the table is added. After updating the table, add a comment in the database and update the table in the BI again, the escape will not be obtained .

4.3 Data preview interface does not displat after adding fields

4.3.1 Problem

Add a field to the database and update the corresponding table of FineBI, without displaying the added fields, as shown in the following figure:

4.3.2 Solution

Click "Edit" to enter the editing interface, tick the newly added fields, click "Save" and update the data. At this time, the new fields will appear in the "Data Preview" interface, as shown in the figure below:

4.4 Data preview interface does not display after adding data

4.4.1 Problem

Create a sqlite data connection and add a database table. There is data in the database but the data preparation interface does not display the data, as shown in the following figure:

4.4.2 Solution

Go to "Manage > Data Connection", edit the corresponding data connection, and add "?zeroDateTimeBehavior=convertToNull" after the data connection URL, as shown in the figure below: