All Products
Search
Document Center

Unsupported data sources

Last Updated: Sep 09, 2021

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 key of the connection 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- 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- meta

ossBucketPrefix

String

The prefix of the OSS bucket name.

ossContentFormat

String

The format of the content. Valid values:- arbitrary- text- html- pdf- csv- xml- json- ppt- excel- word Note: This parameter must be empty when 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-qdjbp-a: China North 1 Finance- oss-cn-haidian-a: China North 2 Ali Gov- oss-cn-shanghai: China (Shanghai)- oss-us-west-1: China (Chengdu)- oss-cn-hzjbp-b-console: China East 1 Finance- oss-cn-shenzhen: China (Shenzhen)- oss-cn-qingdao: China (Qingdao)- oss-cn-bjzwy: China North 2 Ali Gov- oss-cn-beijing: China (Beijing)- oss-ap-southeast-1: Singapore (Singapore)

autoSync

String

Indicates whether automatic data synchronization is enabled. Valid values:- true- false

PolarDB-X (Upgraded version of 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- false

filter

String

The filter conditions. The following operators are supported: <, >, =, !=,>=, and <=. Separate multiple conditions with commas (,).