Gets a list of supported database types

get/admin/dataStores/supportedDatabaseTypes
Internal-Use Only

Retrieves a list of supported database types. This endpoint requires the "svi.administration.core_metadata" capability.

Request Samples

1

Response Samples

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]

Query Parameters

NameTypeRequiredDescription
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 true.

Default:
false

Responses

StatusMeaningDescription
200OKThe request succeeded. A list of supported database types is returned.Schema