You can configure data sources for DataService Studio to read table schemas and process API query requests.

Prerequisites

To ensure that resource groups for DataService Studio can access data sources, you must configure network connectivity between the resource groups and data sources and configure IP address whitelists for the data sources. Otherwise, DataService Studio cannot work as expected.

Procedure

  1. Log on to the DataWorks console.
  2. In the left-side navigation pane, click Workspaces.
  3. In the top navigation bar, select the region in which your workspace resides. Find the workspace, move the pointer over the More icon in the Actions column, and then select Workspace Settings. In the Workspace Settings panel, click More.
  4. In the left-side navigation pane, click Data Source.
    Add a data source on this page. The following table describes the supported types of data sources and the configuration methods.
    Data source type Create an API by using the codeless UI Create an API by using the code editor Configuration method
    Hologres Supported Supported Add a Hologres data source
    Note

    Hologres is compatible with PostgreSQL. PostgreSQL does not support the DATETIME data type. If your Hologres instance contains data of the DATETIME type, Hologres converts the data from the DATETIME type to the TIMESTAMP type. This way, DataService Studio can query the data.

    ClickHouse Supported Supported Add a ClickHouse data source
    RDS Supported Supported The supported ApsaraDB RDS engine types include MySQL, PostgreSQL, and SQL Server.
    PolarDB-X 1.0 Supported Supported Add a DRDS data source
    Note You can add this type of data source only by using a connection string.
    MySQL Supported Supported Add a MySQL data source
    PostgreSQL Supported Supported Add a PostgreSQL data source
    SQL Server Supported Supported Add an SQL Server data source
    Oracle Supported Supported Add an Oracle data source
    Note You can add this type of data source only by using a connection string.
    AnalyticDB for MySQL V2.0 Supported Supported Add an AnalyticDB for MySQL 2.0 data source
    AnalyticDB for MySQL 3.0 Supported Supported Add an AnalyticDB for MySQL 3.0 data source
    AnalyticDB for PostgreSQL Supported Supported Add an AnalyticDB for PostgreSQL data source
    Tablestore Supported Not support Add a Tablestore data source
    Note You can add this type of data source only by using a connection string.
    MongoDB Supported Not supported Add a MongoDB data source
    MaxCompute
    • Acceleration Service: supported in the China (Beijing) and China (Shanghai) regions
    • MCQA: supported in the China (Beijing), China (Hangzhou), China (Shanghai), and China (Shenzhen) regions
    • Acceleration Service: supported in the China (Beijing) and China (Shanghai) regions
    • MCQA: supported in the China (Beijing), China (Hangzhou), China (Shanghai), and China (Shenzhen) regions
  5. In the dialog box in which you add the data source, set the Resource Group connectivity parameter to Data Service and use a resource group for DataService Studio to test network connectivity. The following example shows how to add a MySQL data source.
    Test network connectivity
    Note If the network connectivity test fails, check your configurations. For more information, see Configure network connectivity and whitelists.
  6. After the data source passes the network connectivity test, return to DataService Studio to create an API for the data source.