Help Center> Data Lake Visualization> User Guide> Creating Data Connections
Updated on 2023-06-02 GMT+08:00

Creating Data Connections

Source data required for screen creation can be static data or non-static data.

  • Static data: You can enter and use static data on the screen development page.
  • Non-static data: Non-static data is stored locally or in other cloud services.

Assume that user data is stored in Data Warehouse Service (DWS). The following section describes how to establish a data connection between DLV and DWS on the Data page. After the data connection is successfully created, DLV can use data in DWS.

For details about more data sources, see Creating Data Connections.

Prerequisites

  • You have obtained the IP address, port number, username, and password of DWS.
  • A Cloud Data Migration (CDM) cluster is used as the network agent to ensure that DLV can communicate with DWS. Ensure that an available CDM cluster exists and is in the same region, AZ, and VPC as the DWS data source. In addition, the CDM cluster and DWS data source must be in the same security group or the security group rule allows them to communicate with each other.

    In CDM, you only need to do nothing but create a CDM cluster.

Creating a Data Connection

  1. Log in to the DLV console.
  2. In the navigation pane on the left, click Data.
  3. On the Data page, click the workspace drop-down list at the top of the page, select the workspace to be accessed, and click New Data Connection.

    Figure 1 Creating a data connection

  4. In the data source list, choose Data Warehouse Service. Specify the related parameters. For details about how to create a data connection, see Data Connection Overview.

    For example, if Data Source Type is set to Data Warehouse Service, configure the data source parameters by referring to Table 1.

    Figure 2 Configuring the data source
    Table 1 DWS data connection parameters

    Parameter

    Description

    Name

    Name of the data connection. Must contain 1 to 32 characters and contain only letters, digits, hyphens (-), and underscores (_).

    Cluster Name

    Name of the DWS cluster. To create a DWS cluster, click Create Cluster next to the drop-down list.

    Domain Name

    After a DWS cluster is selected, an intranet domain name of a database will be automatically matched. The domain name is alterable.

    Port

    After a DWS cluster is selected, a database port will be automatically matched. The port is alterable.

    Username

    Username of the database. The database user must have permission to access data tables and metadata.

    Password

    Password of the database user.

    Agent

    Name of the CDM cluster. To view all available CDM clusters, click View Agent next to the drop-down list.

    NOTE:

    DWS is not a fully managed service and thus cannot be directly connected to fully managed DLV. A CDM cluster serves as an agent that enables communication between them.

    Database

    You can select a database from the Database drop-down list.

    NOTE:

    If there is no database displayed, check whether the database username and password are correct. Then, ensure that security group rules have been configured to allow database connections. Ensure that the CDM proxy and the DB instance are in the same VPC. If the fault persists, contact technical support.

    Currently, DLV cannot use CDM 2.9 or later as a proxy.

  5. Click OK.