Gets a list of supported database types
get/admin/dataStores/supportedDatabaseTypes
Retrieves a list of supported database types. This endpoint requires the "svi.administration.core_metadata" capability.
1[2 {3 "type": "postgres",4 "requiredFields": [5 "name",6 "host",7 "port",8 "username",9 "password",10 "databaseName",11 "schema",12 "handle",13 "version"14 ]15 },16 {17 "type": "oracle",18 "requiredFields": [19 "name",20 "host",21 "port",22 "username",23 "password",24 "databaseName",25 "schema",26 "handle",27 "version"28 ]29 },30 {31 "type": "teradata",32 "requiredFields": [33 "name",34 "host",35 "port",36 "username",37 "password",38 "databaseName",39 "handle",40 "version"41 ]42 },43 {44 "type": "db2",45 "requiredFields": [46 "name",47 "host",48 "port",49 "username",50 "password",51 "databaseName",52 "schema",53 "handle",54 "version"55 ]56 },57 {58 "type": "MySQL",59 "requiredFields": [60 "name",61 "host",62 "port",63 "username",64 "password",65 "schema",66 "handle",67 "version"68 ]69 },70 {71 "type": "SQL Server",72 "requiredFields": [73 "name",74 "host",75 "port",76 "username",77 "password",78 "databaseName",79 "schema",80 "handle",81 "version"82 ]83 }84]
Name | Type | Required | Description |
---|---|---|---|
includeAll | boolean | false | By default, this operation returns only manageable types. These are the types that you can add/modify/delete in the SAS Visual Investigator Administration user interface. To force all the types to be returned, set this property to Default: false |
Status | Meaning | Description | ||
---|---|---|---|---|
200 | OK | The request succeeded. A list of supported database types is returned. | Schema |