Help Center > > Developer Guide> Connecting the Third-party BI Tool to the DLI> Interconnection Between Yonghong BI System and DLI> Creating Yonghong BI Data Set

Creating Yonghong BI Data Set

Updated at: Apr 09, 2019 GMT+08:00

Scenario

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

Procedure

  1. 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

  2. On the displayed page, click SQL Data Set. See Figure 2.

    Figure 2 Creating a SQL data set

  3. 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

  4. 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

  5. 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

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

    Figure 6 Querying data of the table

  7. On the tool bar of the displayed page, click Save.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel