Fetch all data stores

get/admin/dataStores/all
Internal-Use Only

Retrieves a list of all available data stores.

Request Samples

1

Response Samples

1[
2 {
3 "id": 103000,
4 "createdBy": "videmo",
5 "createdAt": "2018-08-29T12:51:58.254Z",
6 "lastUpdatedBy": "videmo",
7 "lastUpdatedAt": "2018-08-29T12:51:58.254Z",
8 "name": "MyOracleDatabase",
9 "type": "RELATIONAL",
10 "defaultSchemaName": "MySchema",
11 "version": 0,
12 "connectionType": "oracle",
13 "host": "example.com",
14 "port": "15658",
15 "username": "MyUserName",
16 "reindexRequired": false,
17 "isCasDistributedDataLoadSupported": true,
18 "password": "*****",
19 "databaseNameOrServiceName": "MyOracleServiceName",
20 "schema": "MY_SCHEMA",
21 "initialSize": 1,
22 "handle": "MyOracleDatabasenRXFB",
23 "urlAppendedParameters": "FailoverPreconnect=false;JavaDoubleToString=false",
24 "advancedProperties": {
25 "ConnectionRetryCount": "5",
26 "ConnectionRetryDelay": "1",
27 "EnableBulkLoad": "1"
28 }
29 }
30]

Query Parameters

NameTypeRequiredDescription
includeInternal
string
true

Specifies whether to include internal data stores. Internal data stores are used by Data Hub or other components of SAS Visual Investigator.

Default:
false

Responses

StatusMeaningDescription
200OKThe request succeeded. An array of data stores is returned.Schema