🗃️ Data Sources
The Metad Analytics Cloud supports connecting to many different databases and data warehouses, so you can explore and learn from your data no matter where it's stored.
Officially Supported Data Sources
| Data Source | SQL | MDX | C/D Table |
|---|---|---|---|
| SQLite | ✔️ | ✔️ | ✔️ |
| MySQL | ✔️ | ✔️ | ✔️ |
| Doris | ✔️ | ✔️ | ✔️ |
| StarRocks | ✔️ | ✔️ | ✔️ |
| Postgres | ✔️ | ✔️ | ✔️ |
| Redshift | ✔️ | ✔️ | ✔️ |
| Hive | ✔️ | ||
| Presto | ✔️ | ||
| Trino | ✔️ | ||
| ClickHouse | ✔️ | ✔️ | |
| SAP HANA | ✔️ | ||
| SAP BW (OLAP) | ✔️ |
tip
MDX modeling is not supported when using the local proxy.
Data Sources
Create, modify, and delete data sources in the data source management interface.
Click the New Data Source button to add a new data source configuration. In the wizard window, you first need to select the Data Source Type and click Next to fill in the detailed information. Common information includes:
- Name: The name of the data source, required, and must be globally unique.
- Use Local Proxy: Whether to connect to this data source through a local proxy when using this data source, otherwise, connect to the data source on the server side.
- Authorization Method: By default, fixed authorization information is used, but you can also choose Basic Authentication. When viewing models or stories, users will log in to this data source using their own account.
Authorization Method
If you want to create MDX semantic models, please select None as the authorization method.
Local Proxy
- If the user's data source is in an intranet environment and cannot be accessed from the public network, the user needs to connect to their data source through a local proxy.
- Local proxy is not applicable to private deployment systems.
Test Connection
Click the Test Connection button to verify that the filled data source information is correct.