Notes and Constraints

General Constraints

• Offline processing migration jobs are not supported in enterprise mode.
• You can use offline processing migration jobs only after apply for the whitelist membership. To enable it, contact customer service or technical support.

Permissions Configuration for Relational Database Migration

Common minimum permissions required by relational database migration:

• MySQL: You need to have the read permission on the INFORMATION_SCHEMA database and data tables.
• Oracle: You need to have the resource role and have the select permissions on the data table in the tablespace.
• Dameng: You need to have the select any table permission in the schema.
• DWS: You need to have the schema usage permission and the query permission on the data tables.
• SQL Server: You need to have the sysadmin permission.
• PostgreSQL: You need to have the select permission on schema tables in the database.

Constraints on DWS

The DWS physical machine management mode is not supported.

Constraints on Hadoop

• Recommended MRS ClickHouse version: 21.3.4.X
• Recommended MRS HDFS versions:
  • 2.8.X
  • 3.1.X
• Recommended MRS HBase versions:
  • 2.1.X
  • 1.3.X
• MRS Hive and MRS Hudi 2.x versions are not supported. The following versions are recommended:
  • 1.2.X
  • 3.1.X

Constraints on Relational Databases

• SAP HANA: Only the 2.00.050.00.1592305219 version is supported.
• Recommended Apache HDFS versions:
  • 2.8.X
  • 3.1.X

Constraints on Non-relational Databases

• Recommended MongoDB version: 4.2
• MongoDB data sources with SSL enabled are not supported.

Constraints on Message Systems

• Apache HDFS can only be the source.
• Recommended Apache HDFS versions:
  • 2.8.X
  • 3.1.X