A datasource is essential for retrieving data from a variety of data storage systems, including databases like MySQL and PostgreSQL, big data platforms such as TableStore, APIs, and files. This topic describes the datasources supported by DataV-Board and offers guidance on selecting the appropriate datasource.
Limits
Datasource support varies by version. For more information, see Specifications.
Some datasources are subject to regional restrictions. For more information, see Region Support.
Database-type datasources must be internet-accessible and require a configured access whitelist. For more information, see Configure Database Whitelist.
Connections to database-type datasources are subject to a 10-second timeout limit.
Datasource selection
Database selection instructions
DataV-Board supports the integration of self-managed databases. When setting up a self-managed database using a virtual machine or ECS, make your choice based on the public network access availability:
If the public network can access the database address: Opt for a MySQL-compatible datasource method or the corresponding database's external network connection method.
If the public network cannot access the database address: Consider using the DataV Proxy Service.
DataV Proxy Service
The proxy service is an alternative when external network access is not possible or desired. It is particularly useful in scenarios such as:
Databases within an internal network.
Avoiding exposure of the database to external network access.
SQL queries that are lengthy and exceed the 10-second timeout limit.
API selection instructions
How should you choose among API, Alibaba Cloud API Gateway, and Open API when using a datasource?
Datasource type | Type description | Scenarios |
API | General data interface. | If you have a directly usable API, you can connect using the API datasource. For example, interfaces provided by existing sites or interfaces built by purchased cloud services. For specific usage operations, see Add API Datasource. |
Alibaba Cloud API Gateway | An Alibaba Cloud product that provides API hosting services. | If the logic in your existing API is not supported when using the API datasource (such as signature calculation), you can use Alibaba Cloud API Gateway to host your API. When DataV-Board connects to the Alibaba Cloud API Gateway datasource, it can indirectly invoke the API you hosted in the API Gateway. At this time, Alibaba Cloud API Gateway acts as a proxy for the API. For specific usage operations, see Add Alibaba Cloud API Gateway Datasource. |
Open API | The method of invoking open interfaces provided by Alibaba Cloud products. Using Open API allows you to easily call API interfaces provided by various cloud products, usually to obtain information about Alibaba Cloud products. | If you want to obtain data information from Alibaba Cloud products (such as ECS load conditions, SLS log statistics), you can use the Open API datasource. Open API only supports invoking APIs provided by Alibaba Cloud products. For specific usage operations, see Add Open API Datasource. |
API invocation methods vary widely. While DataV-Board may not directly invoke all APIs, the Alibaba Cloud API Gateway can host these APIs. Decide whether to use Alibaba Cloud API Gateway based on your specific needs, which may include the following:
APIs with custom signature authentication algorithms that DataV-Board cannot directly invoke. Alibaba Cloud API Gateway can handle the custom logic, allowing direct connection and invocation via DataV-Board.
APIs that are not directly accessible, such as those within a virtual private cloud, can be hosted through Alibaba Cloud API Gateway.
If you prefer not to disclose API invocation details, Alibaba Cloud API Gateway can obscure them.
APIs that use datasources or interfaces not currently supported by DataV-Board, such as invoking Function Compute, can also retrieve data through Alibaba Cloud API Gateway.
Datasource classification
DataV-Board supports an extensive array of datasources, including database, big data storage, API, and file types.
denotes support, 
indicates lack of support.For datasources that require a whitelist, you must configure the database whitelist for a successful connection.
Datasource type | Datasource | Public network connection | VPC connection | Whitelist setting | Remarks |
Database-type |
|
|
| None. | |
|
|
| None. | ||
|
|
| When SQLServer is Microsoft Azure, you must check encrypt. | ||
|
|
| None. | ||
|
|
| None. | ||
|
|
| None. | ||
|
|
| None. | ||
|
|
| None. | ||
|
|
| None. | ||
|
|
| None. | ||
|
|
| Compatible with older versions of MySQL. You need to enable insecureAuth. Supports compatibility with Azure Database for MySQL. | ||
|
|
| Domestic database. | ||
|
|
| Domestic database. | ||
|
|
| Domestic database. | ||
|
|
| None. | ||
Big data storage-type |
|
|
| None. | |
|
|
| None. | ||
|
|
| None. | ||
File and static data | N/A | N/A | N/A | The file size must not exceed 512KB. | |
N/A | N/A | N/A | JSON format data, only in the widget datasource configuration panel. | ||
General API-type |
|
| N/A | Supports GET or POST, only in the widget datasource configuration panel. | |
|
| N/A | None. | ||
|
| N/A | None. | ||
Third-party API-type | N/A | N/A | N/A | DataV Proxy Service provides an open-source database proxy service that can be deployed on ECS. Through the proxy service, you can reduce the risk of exposing the database's public network IP. For deployment and installation of DataV Proxy Service, see Configure DataV Proxy Service. | |
Others |
| N/A | N/A | None. |
For database-type datasources, ensure they are accessible:
The database is not blocked by a firewall.
The database domain name is resolvable.
Region support
Database-type Datasource Supported Regions:
Region | Region ID |
China (Hangzhou) | cn-hangzhou |
China (Shanghai) | cn-shanghai |
China (Shenzhen) | cn-shenzhen |
China (Qingdao) | cn-qingdao |
China (Beijing) | cn-beijing |
China (Zhangjiakou) | cn-zhangjiakou |
China (Hohhot) | cn-huhehaote |
China East 2 Finance | cn-shanghai-finance-1 |
China South 1 Finance | cn-shenzhen-finance-1 |
Hong Kong (China) | cn-hongkong |
FAQ
For additional questions about datasource configuration, see FAQ on Datasource Configuration and Usage.