CreateRemoteADBDataSource - AnalyticDB - Alibaba Cloud Documentation Center

This topic is generated by a machine translation engine without any human intervention. ALIBABA CLOUD DOES NOT GUARANTEE THE ACCURACY OF MACHINE TRANSLATED CONTENT. To request a human-translated version of this topic or provide feedback on this translation, please include it in the feedback form.

Create Homogeneous Data Source

Debugging

You can run this interface directly in OpenAPI Explorer, saving you the trouble of calculating signatures. After running successfully, OpenAPI Explorer can automatically generate SDK code samples.

Debug

Authorization information

The following table shows the authorization information corresponding to the API. The authorization information can be used in the Action policy element to grant a RAM user or RAM role the permissions to call this API operation. Description:

Operation: the value that you can use in the Action element to specify the operation on a resource.
Access level: the access level of each operation. The levels are read, write, and list.
Resource type: the type of the resource on which you can authorize the RAM user or the RAM role to perform the operation. Take note of the following items:
- For mandatory resource types, indicate with a prefix of * .
- If the permissions cannot be granted at the resource level, All Resources is used in the Resource type column of the operation.
Condition Key: the condition key that is defined by the cloud service.
Associated operation: other operations that the RAM user or the RAM role must have permissions to perform to complete the operation. To complete the operation, the RAM user or the RAM role must have the permissions to perform the associated operations.

Operation	Access level	Resource type	Condition key	Associated operation
gpdb:CreateRemoteADBDataSource	create	*DBInstance `acs:gpdb:{#regionId}:{#accountId}:dbinstance/{#DBInstanceId}`	none	none

Request parameters

Parameter	Type	Required	Description	Example
LocalDBInstanceId	string	Yes	Instance ID of the data being used (required).	gp-test1
LocalDatabase	string	Yes	Database name of the data being used (required)	db1
RemoteDBInstanceId	string	Yes	Instance ID providing the data (required).	gp-test2
RemoteDatabase	string	Yes	Database name providing the data (required).	db2
UserName	string	Yes	Account name of the data-providing instance used for user mapping (required).	account1
UserPassword	string	Yes	Password of the data-providing instance account used for user mapping.	password1
ManagerUserName	string	Yes	Management account of the data-using instance.	managerAccount
ManagerUserPassword	string	Yes	Password of the management account of the data-using instance.	password2
DataSourceName	string	No	Customer-specified DataSourceName.	test

Response parameters

Parameter	Type	Description	Example
	object
RequestId	string	Request ID.	e9d60eb1-e90d-4bc6-a470-c8b767460858
TaskId	integer	Workflow task ID.	90000
DataSourceItem	object	Returns the successfully added data sharing service data.
Id	long	ID	1
DataSourceName	string	Data source name.	db1_gptest1_to_db2_gp-test2
LocalInstanceName	string	Local instance name	gp-test1
LocalDatabase	string	Local database name	db1
RemoteInstanceName	string	Remote instance name	gp-test2
RemoteDatabase	string	Remote database name	db2
UserName	string	User name	user1
ManagerUserName	string	Management account user name	manager_user
Status	string	Synchronization status	creating
Description	string	Description information.	userName
RegionId	string	Region ID. Note You can call the DescribeRegions API to view available region IDs.	cn-beijing

Examples

Sample success responses

JSONformat

{
  "RequestId": "e9d60eb1-e90d-4bc6-a470-c8b767460858",
  "TaskId": 90000,
  "DataSourceItem": {
    "Id": 1,
    "DataSourceName": "db1_gptest1_to_db2_gp-test2",
    "LocalInstanceName": "gp-test1",
    "LocalDatabase": "db1",
    "RemoteInstanceName": "gp-test2",
    "RemoteDatabase": "db2",
    "UserName": "user1",
    "ManagerUserName": "manager_user",
    "Status": "creating",
    "Description": "userName",
    "RegionId": "cn-beijing"
  }
}

Error codes

For a list of error codes, visit the Service error codes.