Gunakan API CreateDataSource untuk menambahkan sumber data - DataWorks - Alibaba Cloud -

Menambahkan sumber data ke DataWorks.

Coba sekarang

Coba API ini di OpenAPI Explorer tanpa perlu penandatanganan manual. Panggilan yang berhasil akan secara otomatis menghasilkan contoh kode SDK sesuai dengan parameter Anda. Unduh kode tersebut dengan kredensial bawaan yang aman untuk penggunaan lokal.

Test

RAM authorization

Tidak ada otorisasi untuk operasi ini. Jika Anda mengalami masalah saat menjalankan operasi ini, hubungi dukungan teknis.

Parameter permintaan

Parameter	Type	Required	Description	Example
ProjectId	integer	Yes	ID workspace DataWorks tempat sumber data berada. Anda dapat memanggil operasi ListProjects untuk meminta ID tersebut.	1
Name	string	Yes	Nama sumber data.	abc
Description	string	No	Deskripsi sumber data.	abc
DataSourceType	string	Yes	Jenis sumber data. Nilai yang valid: odps mysql rds oss sqlserver polardb oracle mongodb emr postgresql analyticdb_for_mysql hybriddb_for_postgresql holo	rds
SubType	string	No	Subjenis dari sumber data. Parameter ini hanya berlaku jika Anda menetapkan parameter DataSourceType ke rds. Jika parameter DataSourceType ditetapkan ke rds, parameter ini dapat diatur ke mysql, sqlserver, atau postgresql.	mysql
EnvType	integer	Yes	Lingkungan tempat sumber data digunakan. Nilai yang valid: 0 dan 1. Nilai 0 menunjukkan lingkungan pengembangan. Nilai 1 menunjukkan lingkungan produksi.	1
Content	string	Yes	Detail sumber data. Contoh detail dari beberapa sumber data yang umum: odps `{ "accessId": "***", "accessKey": "*", "authType": 2, "endpoint": "http://service.odps.aliyun.com/api", "project": "xsaxsax", "tag": "public" }` mysql `{ "database": "xsaxsa", "instanceName": "rm-xsaxsa", "password": "xsaxsa", "rdsOwnerId": "xasxsa", "regionId": "cn-shanghai", "tag": "rds", "username": "xsaxsa" }` rds `{ "configType": 1, "tag": "rds", "database": "xsaxsa", "username": "xsaxsa", "password": "xssaxsa$32050", "instanceName": "rm-xsaxs", "rdsOwnerId": "11111111" }` oss `{ "accessId": "*", "accessKey": "*", "bucket": "xsa-xs-xs", "endpoint": "http://oss-cn-shanghai.aliyuncs.com", "tag": "public" }` sqlserver `{ "jdbcUrl": "jdbc:sqlserver://xsaxsa-xsaxsa.database.xxx.cn:123;DatabaseName=xsxs-xsxs", "password": "sdasda$fs", "tag": "public", "username": "sxaxacdacdd" }` polardb `{ "clusterId": "pc-sdadsadsa", "database": "dsadsadsa", "ownerId": "121212122", "password": "sdasdafssa", "region": "cn-shanghai", "tag": "polardb", "username": "asdadsads" }` redis `{ "password": "xxxxxx", "address":"[{\"host\":\"xxxxxxx.redis.rds.aliyuncs.com\",\"port\":6379}]", "tag": "public" }` oracle `{ "jdbcUrl": "jdbc:oracle:saaa:@xxxxx:1521:PROD", "password": "sxasaxsa", "tag": "public", "username": "sasfadfa" }` mongodb `{ "address": "[\"xsaxxsa.mongodb.rds.aliyuncs.com:3717\"]", "database": "admin", "password": "sadsda@", "tag": "public", "username": "dsadsadas" }` emr `{ "accessId": "*", "emrClusterId": "C-dsads", "emrResourceQueueName": "default", "emrEndpoint": "emr.aliyuncs.com", "accessKey": "*", "emrUserId": "224833315798889783", "name": "sasdsadsa", "emrAccessMode": "simple", "region": "cn-shanghai", "authType": "2", "emrProjectId": "FP-sdadsad" }` postgresql `{ "jdbcUrl": "jdbc:postgresql://xxxx:1921/ssss", "password": "sdadsads", "tag": "public", "username": "sdsasda" }` analyticdb_for_mysql `{ "instanceId": "am-sadsada", "database": "xsxsx", "username": "xsxsa", "password": "asdadsa", "connectionString": "am-xssxsxs.ads.aliyuncs.com:3306" }` hybriddb_for_postgresql `{ "connectionString": "gp-xsaxsaxa-master.gpdbmaster.rds.aliyuncs.com", "database": "xsaxsaxas", "password": "xsaxsaxsa@11", "instanceId": "gp-xsaxsaxsa", "port": "541132", "ownerId": "xsaxsaxsas", "username": "sadsad" }` holo `{ "accessId": "*", "accessKey": "***", "database": "xsaxsaxsa", "instanceId": "xsaxa", "tag": "aliyun" }` kafka `{ "instanceId": "xsax-cn-xsaxsa", "regionId": "cn-shanghai", "tag": "aliyun", "ownerId": "1212121212112" }`	{"database":"dbname","instanceName":"instancename","password":"password","rdsOwnerId":"123","username":"username"}

Elemen respons

Element	Type	Description	Example
	object	Parameter respons.
HttpStatusCode	string	Kode status HTTP.	200
Data	integer	ID sumber data.	123
RequestId	string	ID permintaan.	0bc141151593763****
Success	boolean	Menunjukkan apakah permintaan berhasil.	true

Contoh

Respons sukses

JSONformat

{
  "HttpStatusCode": "200",
  "Data": 123,
  "RequestId": "0bc141151593763****",
  "Success": true
}

Kode kesalahan

HTTP status code	Error code	Error message
400	Invalid.Tenant.ConnectionNotExists	The connection does not exist.
400	Invalid.Tenant.ProjectNotExists	The project does not exist.
400	Invalid.Tenant.UserNotInProject	The user is not in the project.
400	ConnectionAlreadyExist	The connection with envType %s and name %s already exists.
400	DataSource.CheckRamRoleFailure	Failed to check the RAM role. AccountId %s. roleArn %s.
400	DataSource.ConnectionStrProperty.PatternNotMatch	The pattern value %s is invalid. The correct pattern is %s.
400	Invalid.DataSource.DataSourceTypeNotSupport	The dataSourceType %s and subType %s are not supported.
400	Invalid.Param.Odps.EngineIdOrConnectStrEmpty	Either the compute engine ID or the connection string must be specified when data source type is ODPS.
400	MissingParam.ConnectionStr.Property	You must specify property %s required by the data source connection string.
400	Invalid.DataSource.DataSourceTypeNotExist	The data source type %s does not exist.
403	Invalid.Tenant.UserIsNotProjectOwnerOrAdmin	The user is not a project administrator or owner.
403	Invalid.Tenant.UserNotInTenant	The user is not in tenant.

Lihat Error Codes untuk daftar lengkap.

Catatan rilis

Lihat Release Notes untuk daftar lengkap.