Before you can use the data API to generate a service, you must configure the data source in advance. Data Service allows you to obtain schema information of data tables from data sources and handle API requests.

You can configure a data source on the data integration > data source page in the dataworks console, support for different data source types and how to configure them is shown in the following table.
Data source name Wizard mode to generate data API Script Mode generation data API Configuration method
RDS (ApsaraDB for RDS) Supported Supported The RDS includes MySQL, PostgreSQL, and SQL Server.
DRDS Supported Supported Configure DRDS data sources
MySQL Supported Supported Configure MySQL database
PostgreSQL Supported Supported Configure PostgreSQL Data Source
SQL Server Supported Supported Configuring SQL Server data source
Oracle Supported Supported Configure Oracle data source
AnalyticDB(ADS) Supported Supported Configure the AnalyticDB Data Source
Table Store(OTS) Yes No OTS data source
MongoDB Supported No Configure MongoDB data source