Creating Yonghong BI Data Set

Create a DLI data set in the Yonghong SaaS production environment.

On the home page of the Yonghong SaaS production environment, click Create Data Set in the left navigation tree. See Figure 1.

Figure 1 Creating a data set
On the displayed page, click SQL Data Set. See Figure 2.

Figure 2 Creating a SQL data set
On the displayed page, select the added DLI data source from the Connection drop-down list box. See Figure 3.

Figure 3 Selecting a data source
In the Table area on the left pane, right-click and choose Update to update tables. All databases and their tables are listed in the area. Figure 4 shows the page displayed when Table Structure is not configured during connection creation.

Figure 4 Updating tables
In the SQL Statement area on the left pane, enter the select * from table_name command to query tables. On the Preview Data page on the right pane, click . Metadata of the table, including fields and field types, is displayed. See Figure 5.

Figure 5 Querying the table
Click on the right pane to query data details. See Figure 6.

Figure 6 Querying data of the table
On the tool bar of the displayed page, click Save.