> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Source

> YiDA paid editions support integration with multiple Data Sources, including relational databases such as MySQL and SQL Server, and File Types such as Excel and CSV. Learn how to Add these Data Sources in your App to improve Data interoperability efficiency.

The following table lists the number of data sources supported by each YiDA edition.

| **Capability**                                       | **Free plan** | **Basic edition** | **Professional edition** | **Dedicated edition** |
| ---------------------------------------------------- | ------------- | ----------------- | ------------------------ | --------------------- |
| **Connect to mainstream database Data Sources**      | Not supported | Not supported     | 20                       | 20                    |
| **Number of File Data Sources (Organization scope)** | Not supported | 50                | 100                      | 100                   |

## Data Source Overview

A data source is a description of data source information. By connecting to a data source, diverse data such as local databases (public network access required) and spreadsheets can be deeply integrated with YiDA apps, improving data interoperability efficiency. YiDA already supports the management and maintenance of data sources such as files and databases.

YiDA supports the following two types of data sources:

* Relational databases: MySQL (version 5.7 or later), SQL Server (version 2012 or later), Oracle (version 19c or later), PostgreSQL (version 9.0 or later), Hologres.
* File: Excel files, CSV files. For how to Create a dataset from a File, see Create a dataset from a File.

## Add a Data Source

Follow the steps below to add a database-type data source.

1. Sign in to the YiDA workbench and go to the App Settings Page.
2. Select Data Factory > Dataset in sequence, and click Create dataset.
3. In the Create Data Source dialog box, fill in the database information and click Confirm to complete the creation.

| **Configuration item**      | **Description**                                                                                                                                                                                                                                                     |
| --------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Data Source Type**        | Select the type of relational database to add. The following five databases are supported.<br />• MySQL (version 5.7 or later)<br />• SQL Server (version 2012 or later)<br />• Oracle (version 19c or later)<br />• Postgre (version 9.0 or later)<br />• Hologres |
| **Name**                    | Enter a name for the new data source. Up to 200 characters are supported.                                                                                                                                                                                           |
| **Database address & port** | Enter the public network access address of your database and the corresponding port number.<br />For example:<br />• Database address: aliwork<br />• Port: 3306                                                                                                    |
| **Account & password**      | Enter the access account and password for the database.                                                                                                                                                                                                             |
| **Database name**           | Enter the database name. Up to 30 characters are supported.                                                                                                                                                                                                         |
| **URL**                     | Enter the full access URL of the database.<br />**Note**: One-click parsing using a [JDBC](https://docs.oracle.com/middleware/1213/eventprocessing/server-administer/CEPAG.epub) string is supported. The data source URL cannot carry parameters.                  |

## FAQ

Q: When retrieving data from a SQL Server database in a report and using the SUM function, the error **"concat ws" is not a recognized built-in Function name** occurs. Why?

A: This issue may be caused by an outdated version of your SQL Server database. We recommend upgrading the database to SQL Server 2017 or later.