Skip to content

Data Source

Note

Through the data source feature, you can add support for various custom data sources, perform subsequent data source operations, and so on.

Move the mouse over the Admin logo of the top menu, the drop-down box will pop up, click the first submenu in the drop-down box. A window similar to the following pops up, the default list is empty, you need to add it yourself.

img.png

If you added a data source, a page similar to the following appears

img_1.png

Add a data source

Click the Add button on the right side of the list display area (it is a + icon), and after clicking it, the Add Data Source window will pop up as follows

img_2.png

When we select a certain type of data source, the data source configuration information will be displayed in the top tab bar, different data sources have different configuration items, and its configuration order is in the specified directory of service startup.

When we select the source of type MySQL, a window similar to the following pops up

img_3.png

4 tabs appear in the configuration page, click on the different tabs to fill in the relevant information, and then click the Test button at the bottom, the following page will pop up:

img_4.png

When the data source is successfully tested, the version number of the current service will be displayed at the top, and you can save the data by clicking the Save button at the bottom.

Note

After the data source is saved, the list of data sources is automatically refreshed.

Modify the data source

Click the first button in Action in a data source in the list to modify the data source, similar to the Add Data Source action

Delete the data source

Click the second button in Action for a data source in the list to delete the data source, and the following will pop up after clicking

img_5.png

Click the small pop-up window and click OK to delete the selected data source.

Danger

It is important to note that when a data source is deleted, the query history associated with the data source is deleted.

Data source management

Click the third or fourth button in the Action of the data source in the list to jump to the data source management page.

img_6.png

The page is divided into two parts: left and right. The left side mainly displays the basic information of the data source, including:

  • Select the relevant metadata for the data source

Information module

When we select the database and data table on the left, the content on the right is displayed as follows

img_7.png

Two tabs appear in the right content:

  • Info（Default options）
  • Data

Note

By default, information about the current table is displayed under the Current tab.

Data modules

Click the Data tab and a page similar to the following will appear, which displays the relevant data of the currently selected table.

img_8.png

The four buttons at the top are:

  • First Page
  • Previous Page
  • Next Page
  • Last Page

The next button is to set the configuration for the data query:

img_9.png

  • Jump to Page
  • Show Page Size

Once the configuration is populated, click the Apply button to apply the current configuration information.

There is also a button on the right, which will display the detailed SQL content used by the current query

img_10.png

Note

The current SQL generation is based on the order in which it is synchronized to the metadata.

Danger

At present, not all data sources support management, you can add your own templates if needed. If you are interested, you can contribute the source code to us.

Last update: December 7, 2023
Created: January 29, 2023

Comments