MySQL
Example
{
"dbTableName": "my_table",
"dbKey": "my_key",
"dbAppName": "my_app_name",
"dbUser": "my_account",
"dbPassword": "my_pwd",
"autoSync": "true",
"filter": "id>100"
}Structure
Field | Type | Description |
|---|---|---|
dbTableName | String | The name of the table. |
dbKey | String | The address that is used to connect to the database in a connection pool. |
dbAppName | String | The application name of the database. |
dbUser | String | The account that is used to connect to the database. |
dbPassword | String | The password that is used to connect to the database. |
autoSync | String | Indicates whether automatic data synchronization is enabled. Valid values: true and false. |
filter | String | The filter conditions. The following operators are supported: <, >, =, !=, >=, and <=. Separate multiple conditions with commas (,). |
OSS
Example
{
"ossBucketName": "test_name",
"ossRecordType": "content",
"ossBucketPrefix": "pre",
"ossContentFormat": "json",
"ossBucketLocation": "oss-cn-hangzhou",
"autoSync": "true"
}Structure
Field | Type | Description |
|---|---|---|
ossBucketName | String | The name of the Object Storage Service (OSS) bucket. |
ossRecordType | String | The type of the data from OSS. Valid values: content and meta. |
ossBucketPrefix | String | The prefix of object names in the OSS bucket. |
ossContentFormat | String | The format of the content. Valid values: arbitrary, text, html, pdf, csv, xml, json, ppt, excel, and word. Note: This parameter must be empty if the ossRecordType parameter is set to meta. |
ossBucketLocation | String | The region where the OSS bucket resides. Valid values:- oss-cn-hangzhou: China (Hangzhou)- oss-cn-hongkong: China (Hong Kong)- oss-cn-shanghai: China (Shanghai)- oss-us-west-1: China (Chengdu)- oss-cn-shenzhen: China (Shenzhen)- oss-cn-qingdao: China (Qingdao)- oss-cn-beijing: China (Beijing)- oss-ap-southeast-1: Singapore (Singapore) |
autoSync | String | Indicates whether automatic data synchronization is enabled. Valid values: true and false. |
DRDS
Example
{
"instanceId": "my_instance_id",
"dbName": "my_db",
"dbTableName": "my_table",
"aliyunUserId":"123455789",
"dbUser":"my_user",
"dbPassword":"my_passwd",
"autoSync":"true",
"filter": "id>100"
}Structure
Field | Type | Description |
|---|---|---|
instanceId | String | The ID of the instance. |
dbName | String | The name of the database. |
dbTableName | String | The name of the table. |
aliyunUserId | String | The ID of the Alibaba Cloud account. |
dbUser | String | The account that is used to connect to the database. |
dbPassword | String | The password that is used to connect to the database. |
autoSync | String | Indicates whether automatic data synchronization is enabled. Valid values: true and false. |
filter | String | The filter conditions. The following operators are supported: <, >, =, !=, >=, and <=. Separate multiple conditions with commas (,). |