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 data table. |
dbKey | String | The address of the database connection pool. |
dbAppName | String | The name of the database application. |
dbUser | String | The database account. |
dbPassword | String | The password for the database account. |
autoSync | String | Specifies whether to automatically synchronize data.- `true`: Yes- `false`: No |
filter | String | The filter condition. Supported operators include <, >, =, !=, >=, and <=. Use a comma (,) to separate multiple conditions. |
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 bucket. |
ossRecordType | String | Type - Content - Meta |
ossBucketPrefix | String | The prefix. |
ossContentFormat | String | The content format.- `arbitrary`- `text`- `html`- `pdf`- `csv`- `xml`- `json`- `ppt`- `excel`- `word`Note: This field must be left empty when `ossRecordType` is set to `meta`. |
ossBucketLocation | String | The region where the bucket is located.- `oss-cn-hangzhou`: Hangzhou- `oss-cn-hongkong`: China (Hong Kong)- `oss-cn-qdjbp-a`: Qingdao Finance Cloud- `oss-cn-haidian-a`: Beijing Gov- `oss-cn-shanghai`: Shanghai- `oss-us-west-1`: US West 1- `oss-cn-hzjbp-b-console`: Hangzhou Finance Cloud- `oss-cn-shenzhen`: Shenzhen- `oss-cn-qingdao`: Qingdao- `oss-cn-bjzwy`: Beijing Gov Cloud- `oss-cn-beijing`: Beijing- `oss-ap-southeast-1`: Singapore |
autoSync | String | Specifies whether to automatically synchronize data.- `true`: Yes- `false`: No |
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 instance ID. |
dbName | String | The name of the database. |
dbTableName | String | The name of the data table. |
aliyunUserId | String | The Alibaba Cloud user ID. |
dbUser | String | The database account. |
dbPassword | String | The password for the database account. |
autoSync | String | Specifies whether to automatically synchronize data.- `true`: Yes- `false`: No |
filter | String | The filter condition. Supported operators include <, >, =, !=, >=, and <=. Use a comma (,) to separate multiple conditions. |