Supported Data Sources (2.9.3.300)
- Table/File migration in the import of data into a data lake or migration of data to the cloud. For details, see Data Sources Supported by Table/File Migration.
- Entire DB migration in the import of data into a data lake or migration of data to the cloud. For details, see Supported Data Sources in Entire DB Migration.
![](https://support.huaweicloud.com/eu/productdesc-cdm/public_sys-resources/note_3.0-en-us.png)
This section describes the data sources supported by CDM clusters of version 2.9.3.300. The supported data sources vary depending on the CDM cluster version.
Data Sources Supported by Table/File Migration
Table/File migration can migrate data in tables or files.
Category |
Source |
Destination |
Description |
---|---|---|---|
Data warehouse |
Data Warehouse Service |
|
The DWS physical machine management mode is not supported. |
Data Lake Insight (DLI) |
|
Recommended MongoDB version: 4.2 |
|
MRS ClickHouse |
Data warehouse: MRS ClickHouse and Data Lake Insight (DLI) |
Recommended MRS ClickHouse version: 21.3.4.X |
|
Hadoop |
MRS HDFS |
|
|
MRS HBase |
|||
MRS Hive |
|
||
MRS Hudi |
|
||
FusionInsight HDFS |
|
|
|
FusionInsight HBase |
|||
FusionInsight Hive |
|||
Apache HBase |
|
|
|
Apache Hive |
|||
Apache HDFS |
|||
Object storage |
Object Storage Service (OBS) |
|
|
File system |
FTP |
|
|
SFTP |
|||
HTTP |
Hadoop: MRS HDFS |
||
Relational database |
RDS for MySQL |
|
|
RDS for SQL Server |
|
||
RDS for PostgreSQL |
|||
MySQL |
|
||
PostgreSQL |
|||
Oracle |
|||
Microsoft SQL Server |
|
||
SAP HANA |
|
SAP HANA data sources have the following restrictions:
|
|
Database Sharding |
|
Database shards cannot serve as the destination. |
|
ShenTong |
|
- |
|
NoSQL |
Distributed Cache Service (DCS) |
Hadoop: MRS HDFS, MRS HBase, and MRS Hive |
NoSQL except CloudTable cannot serve as the destination. For how to migrate data from Redis to DCS, see Migrating Data from Self-Hosted Redis to DCS. |
Redis |
|||
Document Database Service |
|||
MongoDB |
|||
CloudTable |
|
||
Cassandra |
|
||
Message system |
Apache Kafka |
Search: Cloud Search Service (CSS) |
The message system cannot serve as the destination. |
DMS Kafka |
|||
MRS Kafka |
|
|
|
Search |
Elasticsearch |
|
Only the non-security mode is supported. |
Cloud Search Service (CSS) |
N/A |
![](https://support.huaweicloud.com/eu/productdesc-cdm/public_sys-resources/note_3.0-en-us.png)
In the preceding table, the non-cloud data sources, such as MySQL, include on-premises MySQL, MySQL built on ECSs, or MySQL on the third-party cloud.
Supported Data Sources in Entire DB Migration
Entire DB migration is used when an on-premises data center or a database created on an ECS needs to be synchronized to a database service or big data service on the cloud. It is suitable for offline database migration but not online real-time migration.
Table 2 lists the data sources supporting entire DB migration using CDM.
Category |
Data Source |
Read |
Write |
Description |
---|---|---|---|---|
Data warehouse |
Data Warehouse Service |
Supported |
Supported |
- |
Hadoop (available only for local storage, and not for storage-compute decoupling, Ranger, or ZooKeeper for which SSL is enabled) |
MRS HBase |
Supported |
Supported |
Entire DB migration only to MRS HBase
Recommended versions:
|
MRS Hive |
Supported |
Supported |
Entire DB migration only to a relational database
2.x versions are not supported. The following versions are recommended:
|
|
FusionInsight HBase |
Supported |
Not supported |
Recommended versions:
|
|
FusionInsight Hive |
Supported |
Not supported |
Entire DB migration only to a relational database
2.x versions are not supported. The following versions are recommended:
|
|
Apache HBase |
Supported |
Not supported |
Recommended versions:
|
|
Apache Hive |
Supported |
Not supported |
Entire DB migration only to a relational database
2.x versions are not supported. The following versions are recommended:
|
|
MRS Hudi |
Supported |
Supported |
Supported only by local storage and in storage-compute decoupling scenarios 2.x versions are not supported. The following versions are recommended:
|
|
Relational database |
RDS for MySQL |
Supported |
Supported |
Migration from OLTP to OLTP is not supported. In this scenario, you are advised to use the Data Replication Service (DRS). |
RDS for PostgreSQL |
Supported |
Supported |
||
RDS for SQL Server |
Supported |
Supported |
||
MySQL |
Supported |
Not supported |
||
PostgreSQL |
Supported |
Not supported |
||
Microsoft SQL Server |
Supported |
Not supported |
||
Oracle |
Supported |
Not supported |
||
SAP HANA |
Supported |
Not supported |
|
|
Dameng database |
Supported |
Not supported |
Only to DWS and Hive |
|
NoSQL |
Distributed Cache Service (DCS) |
Not supported |
Supported |
Only migration from MRS to DCS is supported. |
Document Database Service (DDS) |
Supported |
Supported |
Only migration between DDS and MRS is supported. |
|
CloudTable |
Supported |
Supported |
- |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.