action clearblade_create_external_db { label: "DATABASES - Create a external database connection" description: "## Description:\nCreates an external database connections for that system. This is a developer only endpoint.\n\n### List of database types supported:\n\n|Database Name|db_type|\n|-------------|-------|\n|MONGO|mongodb|\n|POSTGRES|postgres|\n|MYSQL|mysql|\n|MSSQL|mssql|\n|COUCHDB|couchdb|\n\n\n\n### Database Credentials\n\n|Field|Type|Database|Description|Options|Default|\n|-----|----|-----|-------|-------|----|\n|user|string|All|The external database username|\n|password|string|All|The external database password|\n|address|string|All|The external database IP address|\n|port|string|All|The port used to connect to the external database||27017 (Mongo), 3306 (MySQL), 5432 (Postgres), 1433 (MSSQL)|\n|dbname|string|All|The name of the external database|\n|connection_type|string|Mongo|The external database DNS connection type|srv and standard|standard|\n|tls|boolean|Mongo and Postgres|Setting the tls to `true` allows for transport encryption. This field is optional|True and false|True (Mongo) False(Postgres)|\n|authMechanism|string|Mongo|Database authentication method. This field is optional|SCRAM-SHA-256, SCRAM-SHA-1, MONGODB-CR, PLAIN, GSSAPI, MONGODB-X509|SCRAM-SHA-1|\n|authSource|string|Mongo|Database authentication source. This field is optional||admin|\n|replicaSet|string|Mongo|Allows for use of Replication Methods such as `rs.reconfig() `.This field is optional||empty string|\n|encryption|string|MSSQL|Setting the encryption to `true` allows for secure encryption|disable and true|\n" provider: clearblade method: POST path: "/api/v/4/external-db/{systemKey}" encoding: json input: { type: "object" properties: { "ClearBlade-DevToken": { type: "string" } systemKey: { type: "string" } } required: ["ClearBlade-DevToken", "systemKey"] additionalProperties: false } output: { type: "object" additionalProperties: true } }