Help Center> Data Lake Visualization> User Guide> Data Connection Management> Creating Data Connections> Creating DDM Data Connections
Updated on 2024-06-21 GMT+08:00
View PDF

Creating DDM Data Connections

Before establishing a data connection to Distributed Database Middleware (DDM), ensure that the following conditions are met:

  • You have obtained the IP address, username, and password of DDM.
  • A CDM cluster is available and used as the network agent to ensure that DLV can communicate with DDM.

Creating a DDM Data Connection

  1. Log in to the DLV console.
  2. 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

  3. In the New Data Connection dialog box, set Data Source Type to DDM and set the related parameters.

    Figure 2 Creating a DDM data connection

    Table 1 describes the DDM data connection parameters.

    Table 1 DDM 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 (_).

    URL

    JDBC connection address of the DDM schema. For details about how to obtain the URL, see "How Do I Obtain a JDBC Connection Address of a DDM Schema?" in DLV FAQs.

    Username

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

    Password

    Password of the schema user.

    Agent

    Select an available connection agent, such as VPC connection, CDM proxy, or Internet.

    NOTE:

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

  4. Click OK.

Using DDM Data Sources

You can configure and use DDM data sources by referring to the instructions in Using DWS Data Sources.