Creating Data Sources
Function
This API is used to create a data source.
URI
POST /v2/{project_id}/fdi/instances/{instance_id}/datasources
|
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 |
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: 201
|
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: 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" } -
{ "datasource_name" : "fdi_ds_v2frp", "datasource_type" : "FTP", "content" : { "connect_mode" : "active", "host" : "**.**.**.**", "port" : "21", "user_name" : "ftpuser", "password" : "******", "protocol" : "ftp" }, "app_id" : "9dbd2cd2-9622-4a1b-ad47-31018cf44cbd", "description" : "testtesttest" } -
{ "datasource_name" : "fdi_ds_api_v2", "datasource_type" : "API", "content" : { "url" : "http%3A%2F%2FVM6_ip%3A1080%2F0928njapi", "api_method" : "GET", "ApiAuthDetail" : { "auth_method" : "none" } }, "description" : "testAPI", "app_id" : "9dbd2cd2-9622-4a1b-ad47-31018cf44cbd" }
Example Responses
Status code: 201
Created
{
"datasource_id" : "123",
"datasource_name" : "fdi_ds_api_v2",
"datasource_type" : "API",
"content" : {
"url" : "http%3A%2F%2FVM6_ip%3A1080%2F0928njapi",
"api_method" : "GET",
"ApiAuthDetail" : {
"auth_method" : "none"
}
},
"description" : "testAPI",
"app_id" : "9dbd2cd2-9622-4a1b-ad47-31018cf44cbd"
}
Status Codes
|
Status Code |
Description |
|---|---|
|
201 |
Created |
|
400 |
Bad Request |
|
500 |
Internal Server Error |
Error Codes
See Error Codes.
Last Article: Data Source Management
Next Article: Querying Data Sources
Did this article solve your problem?
Thank you for your score!Your feedback would help us improve the website.