Notes and Constraints
Constraints on the MySQL Source
Constraints on the SQL Server Source
Type |
Description |
---|---|
Applicable Version |
Enterprise Edition 2016, 2017, 2019, and 2022; Standard Edition 2016 SP2 and later, 2017, 2019, and 2022 |
Required Permissions |
sysadmin or view server state permissions, and db_datareader or db_owner permissions of the database to be synchronized
|
Synchronization objects |
|
Database |
If Force Protocol Encryption is set to Yes for the source database, Trust Server Certificate also must be set to Yes. |
Usage |
|
Other |
|
Constraints on the PostgreSQL Source
Type |
Description |
---|---|
Applicable Version |
PostgreSQL 9.4, 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16 |
Required Permissions |
Database CONNECT permission, schema USAGE permission, table SELECT permission, sequence SELECT permission, REPLICATION connection permission, and the permission to query pg_ls_waldir() functions. For details, see How Do I Add Additional Permissions for PostgreSQL and GaussDB Data Sources?
NOTE:
To add the permission to create replication connections, perform the following steps:
|
Synchronization objects |
|
Database |
|
Usage |
|
Other |
|
Constraints on the Oracle Source
Type |
Description |
---|---|
Applicable Version |
10, 11, 12, and 19 |
Required Permissions |
The account must have the permissions to archive logs, query tables, and parse logs of the Oracle database. For details about how to grant the permissions, see How Do I Grant the Log Archiving, Query, and Parsing Permissions of an Oracle Data Source? |
Synchronization objects |
|
Database |
The names of the source databases, tables, and fields cannot contain periods (.), hyphens (-), or non-ASCII characters. You are advised to use common characters to avoid a failure. |
Usage |
|
Other |
|
Constraints on the MongoDB Source
Constraints on the GaussDB Source
Type |
Description |
---|---|
Applicable Version |
Kernel engine versions: 505.1.0, 505.1.0.SPC0100, and 505.2.0 |
Required Permissions |
|
Synchronization objects |
|
Database |
|
Usage |
|
Other |
|
Constraints on the Hudi Destination
Type |
Description |
---|---|
Applicable Version |
|
Required Permissions |
The MRS user must have read and write permissions for the Hadoop and Hive components. You are advised to assign the roles and user groups shown in the following figure to the MRS user.
Figure 1 Minimal permissions for MRS Hudi
![]() For details, see MRS Cluster User Permission Model. |
Database |
The names of the Hudi databases, tables, and fields can only contain digits, letters, and underscores (_). Field names must start with a letter or an underscore (). You are advised to use common characters in names. |
Usage |
|
Constraints on the DWS Destination
Constraints on the Doris Destination
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot