Modifying Data Sources
Function
This API is used to modify a data source.
URI
PUT /v2/{project_id}/fdi/instances/{instance_id}/datasources/{datasource_id}
|
Parameter |
Mandatory |
Type |
Description |
|---|---|---|---|
|
project_id |
Yes |
String |
Project ID. For details about how to obtain the project ID, see Appendix > Obtaining a Project ID in the ROMA Connect API Reference. Minimum: 1 Maximum: 64 |
|
instance_id |
Yes |
String |
Instance ID. Minimum: 1 Maximum: 64 |
|
datasource_id |
Yes |
String |
Data source ID. Minimum: 1 Maximum: 64 |
Request Parameters
|
Parameter |
Mandatory |
Type |
Description |
|---|---|---|---|
|
datasource_name |
No |
String |
Data source name. The value is a string of 1 to 255 characters and cannot contain the following special characters: & < > " ' ( ) Minimum: 4 Maximum: 255 |
|
datasource_type |
No |
String |
Data source type.
Minimum: 4 Maximum: 32 |
|
app_id |
No |
String |
ID of the application to which the data source belongs. Minimum: 4 Maximum: 255 |
|
custom_plugin_id |
No |
String |
ID of the connector to which the data source belongs. This parameter is mandatory for customized data sources. Minimum: 4 Maximum: 64 |
|
content |
No |
Content object |
Data source details. |
|
description |
No |
String |
Data source description. Minimum: 4 Maximum: 1024 |
|
Parameter |
Mandatory |
Type |
Description |
|---|---|---|---|
|
gauss100_version |
No |
String |
Gauss100 version.
Minimum: 1 Maximum: 64 |
|
host |
No |
String |
Host IP address.
Minimum: 4 Maximum: 255 |
|
port |
No |
String |
Port number. The value ranges from 0 to 65535.
Minimum: 1 Maximum: 65535 |
|
database_name |
No |
String |
Database name.
Minimum: 4 Maximum: 2147483647 |
|
redis_database |
No |
String |
Redis data source type, which is a database ID containing only digits. Minimum: 1 Maximum: 1000 |
|
user_name |
No |
String |
User name for accessing the service.
Minimum: 4 Maximum: 2147483647 |
|
password |
No |
String |
Password for accessing the service.
Minimum: 4 Maximum: 2147483647 |
|
mode |
No |
String |
Data source connection mode. The value can be default, professional, or multiAddress.
Minimum: 4 Maximum: 255 |
|
cdc_mode |
No |
String |
CDC mode, which is used only for composite tasks. Minimum: 4 Maximum: 10 |
|
multi_oracle_address |
No |
Array of objects |
IP address of the Oracle cluster. This parameter is mandatory when mode is set to multiAddress. |
|
oracle_service_name |
No |
String |
Service name of the Oracle cluster. Minimum: 4 Maximum: 64 |
|
ftp_connect_mode |
No |
String |
Connection mode for accessing the FTP service. The value can be active or passive. Minimum: 4 Maximum: 2147483647 |
|
ftp_protocol |
No |
String |
Protocol for accessing the FTP service. The value can be SFTP or FTP. Minimum: 4 Maximum: 2147483647 |
|
address |
No |
String |
Address.
Minimum: 0 Maximum: 256 |
|
ak |
No |
String |
Access key ID.
Minimum: 0 Maximum: 256 |
|
sk |
No |
String |
Secret access key.
Minimum: 0 Maximum: 256 |
|
bucket_name |
No |
String |
Bucket name. This parameter is mandatory when the data source is OBS. Minimum: 0 Maximum: 256 |
|
https |
No |
Boolean |
Whether to use HTTPS. This parameter is mandatory when the data source is OBS. Generally, HTTPS is used by default. Minimum: 0 Maximum: 10 |
|
url |
No |
String |
Connection string, indicating the access URL.
Minimum: 0 Maximum: 256 |
|
api_method |
No |
String |
API access request mode.
Minimum: 0 Maximum: 10 |
|
auth_method |
No |
String |
Authentication mode for accessing the WEBSOCKET service.
Minimum: 0 Maximum: 256 |
|
api_auth_detail |
No |
ApiAuthDetail object |
API authentication field details. |
|
broker |
No |
String |
Addresses of the Kafka and ActiveMQ servers, in the format of IP address:Port number. Use commas (,) to separate multiple IP addresses and port numbers. Minimum: 0 Maximum: 256 |
|
ssl_enable |
No |
Boolean |
Whether to enable SSL authentication.
Minimum: 0 Maximum: 10 |
|
ssl_username |
No |
String |
SSL user name or application key.
Minimum: 0 Maximum: 256 |
|
ssl_password |
No |
String |
SSL password or application secret.
Minimum: 0 Maximum: 256 |
|
mongodb_auth_source |
No |
String |
MONGODB authentication source. Minimum: 0 Maximum: 60 |
|
mongodb_cluster_enable |
No |
Boolean |
MONGODB cluster mode.
Minimum: 0 Maximum: 256 |
|
mongodb_replica_set |
No |
String |
MONGODB replica set. This parameter is mandatory when the MONGODB is in non-cluster mode. Minimum: 0 Maximum: 256 |
|
encoding |
No |
String |
Encoding format.
Minimum: 0 Maximum: 10 |
|
mysql_timeout |
No |
Integer |
MySQL connection timeout time (seconds). Minimum: 1 Maximum: 20000 |
|
trust_store_password |
No |
String |
Password of the public key library.
Minimum: 0 Maximum: 256 |
|
trust_store |
No |
String |
Public key library file.
Minimum: 0 Maximum: 1024 |
|
trust_store_file_type |
No |
String |
Type of a public key library file.
Minimum: 0 Maximum: 10 |
|
ssl_auth_method |
No |
String |
Authentication method. This parameter is mandatory when the data source is ACTIVEMQ or ARTEMISMQ and SSL authentication is enabled.
Minimum: 0 Maximum: 10 |
|
key_store |
No |
String |
Content of the private key library file.
Minimum: 0 Maximum: 1024 |
|
key_store_file_type |
No |
String |
Type of the private key library file.
Minimum: 0 Maximum: 10 |
|
key_store_password |
No |
String |
Private key library password.
Minimum: 0 Maximum: 256 |
|
key_store_key_password |
No |
String |
Private key of the private key library.
Minimum: 0 Maximum: 256 |
|
dis_tunnel_name |
No |
String |
DIS tunnel name. Minimum: 0 Maximum: 256 |
|
dis_data_type |
No |
String |
DIS data type.
Minimum: 0 Maximum: 256 |
|
dis_setting_type |
No |
String |
DIS configuration type.
Minimum: 0 Maximum: 256 |
|
dis_endpoint |
No |
String |
DIS endpoint. This parameter is mandatory when setting_type is set to senior. Minimum: 0 Maximum: 256 |
|
dis_region |
No |
String |
DIS region. This parameter is mandatory when setting_type is set to senior. Minimum: 0 Maximum: 256 |
|
dis_source_project_id |
No |
String |
Project ID of the DIS source. This parameter is mandatory when setting_type is set to senior. Minimum: 0 Maximum: 256 |
|
hl7_position |
No |
String |
HL7 data source direction.
Minimum: 0 Maximum: 256 |
|
hl7_whitelist_enable |
No |
Boolean |
Whether to enable the HL7 whitelist setting. Minimum: 0 Maximum: 256 |
|
hl7_whitelist |
No |
String |
HL7 whitelist.
Minimum: 0 Maximum: 256 |
|
ldap_security_auth_type |
No |
String |
LDAP security authentication type. Minimum: 0 Maximum: 256 |
|
rabbitmq_virtual_host |
No |
String |
RabbitMQ virtual host. Minimum: 0 Maximum: 256 |
|
rabbitmq_ssl_protocol |
No |
String |
RabbitMQ SSL authentication protocol.
Minimum: 0 Maximum: 10 |
|
sap_client |
No |
String |
SAP client ID. Minimum: 0 Maximum: 10 |
|
sap_sysnr |
No |
String |
SAP instance ID. Minimum: 0 Maximum: 256 |
|
snmp_network_protocol |
No |
String |
SNMP network protocol.
Minimum: 0 Maximum: 10 |
|
snmp_version |
No |
Integer |
SNMP version number. Minimum: 0 Maximum: 3 |
|
snmp_community |
No |
String |
SNMP community name, which is used as an authentication password for access to the SNMP management agent. Minimum: 0 Maximum: 256 |
|
ibmmq_ccs_id |
No |
String |
IBMMQ character set ID. Minimum: 0 Maximum: 65535 |
|
ibmmq_queue_manager |
No |
String |
IBMMQ queue manager. Minimum: 0 Maximum: 256 |
|
ibmmq_channel |
No |
String |
IBMMQ channel name. Minimum: 0 Maximum: 256 |
|
ibmmq_cipher_suite |
No |
String |
IBMMQ cipher algorithm suite. Minimum: 0 Maximum: 256 |
|
hdfs_path |
No |
String |
HDFS URL.
Minimum: 0 Maximum: 256 |
|
principal_name |
No |
String |
Machine-machine interaction username.
Minimum: 0 Maximum: 256 |
|
config_file_name |
No |
String |
User authentication file. For details about how to obtain the file, see Appendix > Obtaining the Data Source Configuration File in the ROMA Connect API Reference.
Minimum: 0 Maximum: 256 |
|
config_file_content |
No |
String |
Content of the user authentication file. The content of the config_file_name file is encoded in Base64.
Minimum: 0 Maximum: 256 |
|
connection_instance_id |
No |
String |
Connector instance ID, which is generated when a connector is published Minimum: 0 Maximum: 256 |
|
connector_params |
No |
Object |
Data source parameter corresponding to the connector. Set this parameter based on actual requirements. Minimum: 0 Maximum: 256 |
|
Parameter |
Mandatory |
Type |
Description |
|---|---|---|---|
|
oracle_address |
No |
String |
Oracle address. Minimum: 1 Maximum: 30 |
|
oracle_port |
No |
String |
Oracle port. Minimum: 1 Maximum: 10 |
|
Parameter |
Mandatory |
Type |
Description |
|---|---|---|---|
|
auth_method |
No |
String |
Authentication mode for accessing the API service.
Minimum: 0 Maximum: 256 |
|
app_auth_type |
No |
String |
App authentication mode for accessing the API service. This parameter is mandatory when the authentication mode is apiGateway.
Minimum: 0 Maximum: 2000 |
|
user_name |
No |
String |
Username for accessing the API service.
Minimum: 4 Maximum: 2000 |
|
password |
No |
String |
Password for accessing the API service.
Minimum: 4 Maximum: 2000 |
|
app_key |
No |
String |
AppKey for accessing the API service.
Minimum: 0 Maximum: 256 |
|
app_secret |
No |
String |
AppSecret for accessing the API service.
Minimum: 0 Maximum: 256 |
|
secret |
No |
String |
Secret for accessing the API service.
Minimum: 0 Maximum: 256 |
|
alt_ip |
No |
String |
Alternative IP address for accessing the API service.
Minimum: 0 Maximum: 256 |
|
access_token_url |
No |
String |
AccessTokenUrl for accessing the API service.
Minimum: 0 Maximum: 256 |
|
client_id |
No |
String |
Client ID for accessing the API service.
Minimum: 0 Maximum: 256 |
|
client_secret |
No |
String |
Client secret for accessing the API service.
Minimum: 0 Maximum: 256 |
|
scope |
No |
String |
Scope for accessing the API service.
Minimum: 0 Maximum: 256 |
|
authorization |
No |
String |
Authorization for accessing the API service.
Minimum: 0 Maximum: 256 |
|
grant_type |
No |
String |
Authorization type for accessing the API service.
Minimum: 0 Maximum: 256 |
Response Parameters
Status code: 200
|
Parameter |
Type |
Description |
|---|---|---|
|
datasource_id |
String |
Data source ID. Minimum: 4 Maximum: 64 |
|
datasource_name |
String |
Data source name Minimum: 4 Maximum: 255 |
|
datasource_type |
String |
Data source type.
Minimum: 1 Maximum: 32 |
|
vpc_id |
String |
ID of the VPC to which the data source belongs. Minimum: 4 Maximum: 64 |
|
app_id |
String |
ID of the application to which the data source belongs. Minimum: 4 Maximum: 255 |
|
app_name |
String |
Name of the application to which the data source belongs. Minimum: 4 Maximum: 255 |
|
instance_id |
String |
ID of the instance to which the data source belongs. Minimum: 4 Maximum: 255 |
|
create_time |
Integer |
Data source creation time. Minimum: 0 Maximum: 99999999999999999 |
|
update_time |
Integer |
Data source modification time. Minimum: 0 Maximum: 99999999999999999 |
|
custom_plugin_id |
String |
ID of the connector to which the data source belongs. Minimum: 0 Maximum: 64 |
|
content |
Content object |
Data source details. |
|
description |
String |
Data source description. Minimum: 4 Maximum: 2147483647 |
|
app_permission |
Array of strings |
Integration application permission.
|
|
Parameter |
Type |
Description |
|---|---|---|
|
gauss100_version |
String |
Gauss100 version.
Minimum: 1 Maximum: 64 |
|
host |
String |
Host IP address.
Minimum: 4 Maximum: 255 |
|
port |
String |
Port number. The value ranges from 0 to 65535.
Minimum: 1 Maximum: 65535 |
|
database_name |
String |
Database name.
Minimum: 4 Maximum: 2147483647 |
|
redis_database |
String |
Redis data source type, which is a database ID containing only digits. Minimum: 1 Maximum: 1000 |
|
user_name |
String |
User name for accessing the service.
Minimum: 4 Maximum: 2147483647 |
|
password |
String |
Password for accessing the service.
Minimum: 4 Maximum: 2147483647 |
|
mode |
String |
Data source connection mode. The value can be default, professional, or multiAddress.
Minimum: 4 Maximum: 255 |
|
cdc_mode |
String |
CDC mode, which is used only for composite tasks. Minimum: 4 Maximum: 10 |
|
multi_oracle_address |
Array of objects |
IP address of the Oracle cluster. This parameter is mandatory when mode is set to multiAddress. |
|
oracle_service_name |
String |
Service name of the Oracle cluster. Minimum: 4 Maximum: 64 |
|
ftp_connect_mode |
String |
Connection mode for accessing the FTP service. The value can be active or passive. Minimum: 4 Maximum: 2147483647 |
|
ftp_protocol |
String |
Protocol for accessing the FTP service. The value can be SFTP or FTP. Minimum: 4 Maximum: 2147483647 |
|
address |
String |
Address.
Minimum: 0 Maximum: 256 |
|
ak |
String |
Access key ID.
Minimum: 0 Maximum: 256 |
|
sk |
String |
Secret access key.
Minimum: 0 Maximum: 256 |
|
bucket_name |
String |
Bucket name. This parameter is mandatory when the data source is OBS. Minimum: 0 Maximum: 256 |
|
https |
Boolean |
Whether to use HTTPS. This parameter is mandatory when the data source is OBS. Generally, HTTPS is used by default. Minimum: 0 Maximum: 10 |
|
url |
String |
Connection string, indicating the access URL.
Minimum: 0 Maximum: 256 |
|
api_method |
String |
API access request mode.
Minimum: 0 Maximum: 10 |
|
auth_method |
String |
Authentication mode for accessing the WEBSOCKET service.
Minimum: 0 Maximum: 256 |
|
api_auth_detail |
ApiAuthDetail object |
API authentication field details. |
|
broker |
String |
Addresses of the Kafka and ActiveMQ servers, in the format of IP address:Port number. Use commas (,) to separate multiple IP addresses and port numbers. Minimum: 0 Maximum: 256 |
|
ssl_enable |
Boolean |
Whether to enable SSL authentication.
Minimum: 0 Maximum: 10 |
|
ssl_username |
String |
SSL user name or application key.
Minimum: 0 Maximum: 256 |
|
ssl_password |
String |
SSL password or application secret.
Minimum: 0 Maximum: 256 |
|
mongodb_auth_source |
String |
MONGODB authentication source. Minimum: 0 Maximum: 60 |
|
mongodb_cluster_enable |
Boolean |
MONGODB cluster mode.
Minimum: 0 Maximum: 256 |
|
mongodb_replica_set |
String |
MONGODB replica set. This parameter is mandatory when the MONGODB is in non-cluster mode. Minimum: 0 Maximum: 256 |
|
encoding |
String |
Encoding format.
Minimum: 0 Maximum: 10 |
|
mysql_timeout |
Integer |
MySQL connection timeout time (seconds). Minimum: 1 Maximum: 20000 |
|
trust_store_password |
String |
Password of the public key library.
Minimum: 0 Maximum: 256 |
|
trust_store |
String |
Public key library file.
Minimum: 0 Maximum: 1024 |
|
trust_store_file_type |
String |
Type of a public key library file.
Minimum: 0 Maximum: 10 |
|
ssl_auth_method |
String |
Authentication method. This parameter is mandatory when the data source is ACTIVEMQ or ARTEMISMQ and SSL authentication is enabled.
Minimum: 0 Maximum: 10 |
|
key_store |
String |
Content of the private key library file.
Minimum: 0 Maximum: 1024 |
|
key_store_file_type |
String |
Type of the private key library file.
Minimum: 0 Maximum: 10 |
|
key_store_password |
String |
Private key library password.
Minimum: 0 Maximum: 256 |
|
key_store_key_password |
String |
Private key of the private key library.
Minimum: 0 Maximum: 256 |
|
dis_tunnel_name |
String |
DIS tunnel name. Minimum: 0 Maximum: 256 |
|
dis_data_type |
String |
DIS data type.
Minimum: 0 Maximum: 256 |
|
dis_setting_type |
String |
DIS configuration type.
Minimum: 0 Maximum: 256 |
|
dis_endpoint |
String |
DIS endpoint. This parameter is mandatory when setting_type is set to senior. Minimum: 0 Maximum: 256 |
|
dis_region |
String |
DIS region. This parameter is mandatory when setting_type is set to senior. Minimum: 0 Maximum: 256 |
|
dis_source_project_id |
String |
Project ID of the DIS source. This parameter is mandatory when setting_type is set to senior. Minimum: 0 Maximum: 256 |
|
hl7_position |
String |
HL7 data source direction.
Minimum: 0 Maximum: 256 |
|
hl7_whitelist_enable |
Boolean |
Whether to enable the HL7 whitelist setting. Minimum: 0 Maximum: 256 |
|
hl7_whitelist |
String |
HL7 whitelist.
Minimum: 0 Maximum: 256 |
|
ldap_security_auth_type |
String |
LDAP security authentication type. Minimum: 0 Maximum: 256 |
|
rabbitmq_virtual_host |
String |
RabbitMQ virtual host. Minimum: 0 Maximum: 256 |
|
rabbitmq_ssl_protocol |
String |
RabbitMQ SSL authentication protocol.
Minimum: 0 Maximum: 10 |
|
sap_client |
String |
SAP client ID. Minimum: 0 Maximum: 10 |
|
sap_sysnr |
String |
SAP instance ID. Minimum: 0 Maximum: 256 |
|
snmp_network_protocol |
String |
SNMP network protocol.
Minimum: 0 Maximum: 10 |
|
snmp_version |
Integer |
SNMP version number. Minimum: 0 Maximum: 3 |
|
snmp_community |
String |
SNMP community name, which is used as an authentication password for access to the SNMP management agent. Minimum: 0 Maximum: 256 |
|
ibmmq_ccs_id |
String |
IBMMQ character set ID. Minimum: 0 Maximum: 65535 |
|
ibmmq_queue_manager |
String |
IBMMQ queue manager. Minimum: 0 Maximum: 256 |
|
ibmmq_channel |
String |
IBMMQ channel name. Minimum: 0 Maximum: 256 |
|
ibmmq_cipher_suite |
String |
IBMMQ cipher algorithm suite. Minimum: 0 Maximum: 256 |
|
hdfs_path |
String |
HDFS URL.
Minimum: 0 Maximum: 256 |
|
principal_name |
String |
Machine-machine interaction username.
Minimum: 0 Maximum: 256 |
|
config_file_name |
String |
User authentication file. For details about how to obtain the file, see Appendix > Obtaining the Data Source Configuration File in the ROMA Connect API Reference.
Minimum: 0 Maximum: 256 |
|
config_file_content |
String |
Content of the user authentication file. The content of the config_file_name file is encoded in Base64.
Minimum: 0 Maximum: 256 |
|
connection_instance_id |
String |
Connector instance ID, which is generated when a connector is published Minimum: 0 Maximum: 256 |
|
connector_params |
Object |
Data source parameter corresponding to the connector. Set this parameter based on actual requirements. Minimum: 0 Maximum: 256 |
|
Parameter |
Type |
Description |
|---|---|---|
|
oracle_address |
String |
Oracle address. Minimum: 1 Maximum: 30 |
|
oracle_port |
String |
Oracle port. Minimum: 1 Maximum: 10 |
|
Parameter |
Type |
Description |
|---|---|---|
|
auth_method |
String |
Authentication mode for accessing the API service.
Minimum: 0 Maximum: 256 |
|
app_auth_type |
String |
App authentication mode for accessing the API service. This parameter is mandatory when the authentication mode is apiGateway.
Minimum: 0 Maximum: 2000 |
|
user_name |
String |
Username for accessing the API service.
Minimum: 4 Maximum: 2000 |
|
password |
String |
Password for accessing the API service.
Minimum: 4 Maximum: 2000 |
|
app_key |
String |
AppKey for accessing the API service.
Minimum: 0 Maximum: 256 |
|
app_secret |
String |
AppSecret for accessing the API service.
Minimum: 0 Maximum: 256 |
|
secret |
String |
Secret for accessing the API service.
Minimum: 0 Maximum: 256 |
|
alt_ip |
String |
Alternative IP address for accessing the API service.
Minimum: 0 Maximum: 256 |
|
access_token_url |
String |
AccessTokenUrl for accessing the API service.
Minimum: 0 Maximum: 256 |
|
client_id |
String |
Client ID for accessing the API service.
Minimum: 0 Maximum: 256 |
|
client_secret |
String |
Client secret for accessing the API service.
Minimum: 0 Maximum: 256 |
|
scope |
String |
Scope for accessing the API service.
Minimum: 0 Maximum: 256 |
|
authorization |
String |
Authorization for accessing the API service.
Minimum: 0 Maximum: 256 |
|
grant_type |
String |
Authorization type for accessing the API service.
Minimum: 0 Maximum: 256 |
Status code: 400
|
Parameter |
Type |
Description |
|---|---|---|
|
error_code |
String |
Error code. Minimum: 8 Maximum: 36 |
|
error_msg |
String |
Error message. Minimum: 2 Maximum: 512 |
|
detail |
String |
Description details. Minimum: 2 Maximum: 512 |
Status code: 404
|
Parameter |
Type |
Description |
|---|---|---|
|
error_code |
String |
Error code. Minimum: 8 Maximum: 36 |
|
error_msg |
String |
Error message. Minimum: 2 Maximum: 512 |
Status code: 500
|
Parameter |
Type |
Description |
|---|---|---|
|
error_code |
String |
Error code. Minimum: 8 Maximum: 36 |
|
error_msg |
String |
Error message. Minimum: 2 Maximum: 512 |
Example Requests
{
"datasource_name" : "fdi_ds_y3k674",
"datasource_type" : "MYSQL",
"content" : {
"host" : "**.**.**.**",
"port" : "3306",
"database_name" : "testfdi",
"user_name" : "fditest",
"password" : "******",
"mode" : "default"
},
"app_id" : "9dbd2cd2-9622-4a1b-ad47-31018cf44cbd",
"description" : "testtesttest"
}
Example Responses
Status code: 200
OK
{
"datasource_id" : "acd5502992254b3ab2dfd5b6900159db",
"datasource_name" : "TY_KAFKA",
"datasource_type" : "KAFKA",
"content" : {
"project_id" : "c53626012ba84727b938ca8bf03108ef",
"type" : "KAFKA",
"instance_id" : "05173009-2e5f-4773-8303-8e05cc9c9302",
"broker" : "10.01.01.01:9092",
"ssl_username" : "1",
"ssl_password" : "******",
"ssl_enable" : true
},
"create_time" : 1616784907101,
"update_time" : 1619650507230,
"app_id" : "141bbdf5-131e-4111-898d-5a6292a2113b",
"app_name" : "app-zhe",
"instance_id" : "05173009-2e5f-4773-8303-8e05cc9c9302",
"remark" : "No change."
}
Status Codes
|
Status Code |
Description |
|---|---|
|
200 |
OK |
|
400 |
Error response |
|
404 |
Not Found |
|
500 |
Internal Server Error |
Error Codes
See Error Codes.
Last Article: Querying a Specified Data Source
Next Article: Deleting a Specified Data Source
Did this article solve your problem?
Thank you for your score!Your feedback would help us improve the website.