Get a list of data connectors for a CAS server
get/servers/{serverName}/dataConnectors
Returns a collection of data connectors for the respective CAS server. Standard paging, filtering, and sorting options are provided. The members of this collection use the application/vnd.sas.data.engine media type representation.
1{2 "links": [3 {4 "method": "GET",5 "rel": "up",6 "href": "/casManagement/servers/cas-shared-default/",7 "uri": "/casManagement/servers/cas-shared-default/",8 "type": "application/vnd.sas.cas.server"9 },10 {11 "method": "GET",12 "rel": "self",13 "href": "/casManagement/servers/cas-shared-default/dataConnectors?sessionId&start=0&limit=100",14 "uri": "/casManagement/servers/cas-shared-default/dataConnectors?sessionId&start=0&limit=100",15 "type": "application/vnd.sas.collection",16 "itemType": "application/vnd.sas.data.engine"17 },18 {19 "method": "GET",20 "rel": "collection",21 "href": "/casManagement/servers/cas-shared-default/dataConnectors",22 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",23 "type": "application/vnd.sas.collection",24 "itemType": "application/vnd.sas.data.engine"25 }26 ],27 "name": "dataConnectors",28 "accept": "application/vnd.sas.data.engine",29 "count": 15,30 "items": [31 {32 "name": "db2",33 "nickname": "DB2",34 "legalName": "SAS Data Connector to DB2",35 "providerId": "cas",36 "dataSourceId": "cas-shared-default",37 "licensed": true,38 "hasDefinition": true,39 "links": [40 {41 "method": "GET",42 "rel": "up",43 "href": "/casManagement/servers/cas-shared-default/dataConnectors",44 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",45 "type": "application/vnd.sas.collection",46 "itemType": "application/vnd.sas.data.engine"47 },48 {49 "method": "GET",50 "rel": "self",51 "href": "/casManagement/servers/cas-shared-default/dataConnectors/db2",52 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/db2",53 "type": "application/vnd.sas.data.engine"54 },55 {56 "method": "GET",57 "rel": "definition",58 "href": "/casManagement/servers/cas-shared-default/dataConnectors/db2/definition",59 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/db2/definition",60 "type": "application/json"61 }62 ],63 "version": 164 },65 {66 "name": "default",67 "nickname": "DEFAULT",68 "providerId": "cas",69 "dataSourceId": "cas-shared-default",70 "licensed": true,71 "hasDefinition": true,72 "links": [73 {74 "method": "GET",75 "rel": "up",76 "href": "/casManagement/servers/cas-shared-default/dataConnectors",77 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",78 "type": "application/vnd.sas.collection",79 "itemType": "application/vnd.sas.data.engine"80 },81 {82 "method": "GET",83 "rel": "self",84 "href": "/casManagement/servers/cas-shared-default/dataConnectors/default",85 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/default",86 "type": "application/vnd.sas.data.engine"87 },88 {89 "method": "GET",90 "rel": "definition",91 "href": "/casManagement/servers/cas-shared-default/dataConnectors/default/definition",92 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/default/definition",93 "type": "application/json"94 }95 ],96 "version": 197 },98 {99 "name": "dnfs",100 "nickname": "DNFS",101 "providerId": "cas",102 "dataSourceId": "cas-shared-default",103 "licensed": true,104 "hasDefinition": true,105 "links": [106 {107 "method": "GET",108 "rel": "up",109 "href": "/casManagement/servers/cas-shared-default/dataConnectors",110 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",111 "type": "application/vnd.sas.collection",112 "itemType": "application/vnd.sas.data.engine"113 },114 {115 "method": "GET",116 "rel": "self",117 "href": "/casManagement/servers/cas-shared-default/dataConnectors/dnfs",118 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/dnfs",119 "type": "application/vnd.sas.data.engine"120 },121 {122 "method": "GET",123 "rel": "definition",124 "href": "/casManagement/servers/cas-shared-default/dataConnectors/dnfs/definition",125 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/dnfs/definition",126 "type": "application/json"127 }128 ],129 "version": 1130 },131 {132 "name": "esp",133 "nickname": "ESP",134 "providerId": "cas",135 "dataSourceId": "cas-shared-default",136 "licensed": true,137 "hasDefinition": true,138 "links": [139 {140 "method": "GET",141 "rel": "up",142 "href": "/casManagement/servers/cas-shared-default/dataConnectors",143 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",144 "type": "application/vnd.sas.collection",145 "itemType": "application/vnd.sas.data.engine"146 },147 {148 "method": "GET",149 "rel": "self",150 "href": "/casManagement/servers/cas-shared-default/dataConnectors/esp",151 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/esp",152 "type": "application/vnd.sas.data.engine"153 },154 {155 "method": "GET",156 "rel": "definition",157 "href": "/casManagement/servers/cas-shared-default/dataConnectors/esp/definition",158 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/esp/definition",159 "type": "application/json"160 }161 ],162 "version": 1163 },164 {165 "name": "hadoop",166 "nickname": "HADOOP",167 "providerId": "cas",168 "dataSourceId": "cas-shared-default",169 "licensed": true,170 "hasDefinition": true,171 "links": [172 {173 "method": "GET",174 "rel": "up",175 "href": "/casManagement/servers/cas-shared-default/dataConnectors",176 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",177 "type": "application/vnd.sas.collection",178 "itemType": "application/vnd.sas.data.engine"179 },180 {181 "method": "GET",182 "rel": "self",183 "href": "/casManagement/servers/cas-shared-default/dataConnectors/hadoop",184 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/hadoop",185 "type": "application/vnd.sas.data.engine"186 },187 {188 "method": "GET",189 "rel": "definition",190 "href": "/casManagement/servers/cas-shared-default/dataConnectors/hadoop/definition",191 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/hadoop/definition",192 "type": "application/json"193 }194 ],195 "version": 1196 },197 {198 "name": "hdfs",199 "nickname": "HDFS",200 "providerId": "cas",201 "dataSourceId": "cas-shared-default",202 "licensed": true,203 "hasDefinition": true,204 "links": [205 {206 "method": "GET",207 "rel": "up",208 "href": "/casManagement/servers/cas-shared-default/dataConnectors",209 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",210 "type": "application/vnd.sas.collection",211 "itemType": "application/vnd.sas.data.engine"212 },213 {214 "method": "GET",215 "rel": "self",216 "href": "/casManagement/servers/cas-shared-default/dataConnectors/hdfs",217 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/hdfs",218 "type": "application/vnd.sas.data.engine"219 },220 {221 "method": "GET",222 "rel": "definition",223 "href": "/casManagement/servers/cas-shared-default/dataConnectors/hdfs/definition",224 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/hdfs/definition",225 "type": "application/json"226 }227 ],228 "version": 1229 },230 {231 "name": "impala",232 "nickname": "IMPALA",233 "legalName": "SAS Data Connect to Impala",234 "providerId": "cas",235 "dataSourceId": "cas-shared-default",236 "licensed": true,237 "hasDefinition": true,238 "links": [239 {240 "method": "GET",241 "rel": "up",242 "href": "/casManagement/servers/cas-shared-default/dataConnectors",243 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",244 "type": "application/vnd.sas.collection",245 "itemType": "application/vnd.sas.data.engine"246 },247 {248 "method": "GET",249 "rel": "self",250 "href": "/casManagement/servers/cas-shared-default/dataConnectors/impala",251 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/impala",252 "type": "application/vnd.sas.data.engine"253 },254 {255 "method": "GET",256 "rel": "definition",257 "href": "/casManagement/servers/cas-shared-default/dataConnectors/impala/definition",258 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/impala/definition",259 "type": "application/json"260 }261 ],262 "version": 1263 },264 {265 "name": "lasr",266 "nickname": "LASR",267 "providerId": "cas",268 "dataSourceId": "cas-shared-default",269 "licensed": true,270 "hasDefinition": true,271 "links": [272 {273 "method": "GET",274 "rel": "up",275 "href": "/casManagement/servers/cas-shared-default/dataConnectors",276 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",277 "type": "application/vnd.sas.collection",278 "itemType": "application/vnd.sas.data.engine"279 },280 {281 "method": "GET",282 "rel": "self",283 "href": "/casManagement/servers/cas-shared-default/dataConnectors/lasr",284 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/lasr",285 "type": "application/vnd.sas.data.engine"286 },287 {288 "method": "GET",289 "rel": "definition",290 "href": "/casManagement/servers/cas-shared-default/dataConnectors/lasr/definition",291 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/lasr/definition",292 "type": "application/json"293 }294 ],295 "version": 1296 },297 {298 "name": "odbc",299 "nickname": "ODBC",300 "legalName": "SAS Data Connect to ODBC",301 "providerId": "cas",302 "dataSourceId": "cas-shared-default",303 "licensed": true,304 "hasDefinition": true,305 "links": [306 {307 "method": "GET",308 "rel": "up",309 "href": "/casManagement/servers/cas-shared-default/dataConnectors",310 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",311 "type": "application/vnd.sas.collection",312 "itemType": "application/vnd.sas.data.engine"313 },314 {315 "method": "GET",316 "rel": "self",317 "href": "/casManagement/servers/cas-shared-default/dataConnectors/odbc",318 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/odbc",319 "type": "application/vnd.sas.data.engine"320 },321 {322 "method": "GET",323 "rel": "definition",324 "href": "/casManagement/servers/cas-shared-default/dataConnectors/odbc/definition",325 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/odbc/definition",326 "type": "application/json"327 }328 ],329 "version": 1330 },331 {332 "name": "oracle",333 "nickname": "ORACLE",334 "legalName": "Data Connector to Oracle",335 "providerId": "cas",336 "dataSourceId": "cas-shared-default",337 "licensed": true,338 "hasDefinition": true,339 "links": [340 {341 "method": "GET",342 "rel": "up",343 "href": "/casManagement/servers/cas-shared-default/dataConnectors",344 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",345 "type": "application/vnd.sas.collection",346 "itemType": "application/vnd.sas.data.engine"347 },348 {349 "method": "GET",350 "rel": "self",351 "href": "/casManagement/servers/cas-shared-default/dataConnectors/oracle",352 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/oracle",353 "type": "application/vnd.sas.data.engine"354 },355 {356 "method": "GET",357 "rel": "definition",358 "href": "/casManagement/servers/cas-shared-default/dataConnectors/oracle/definition",359 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/oracle/definition",360 "type": "application/json"361 }362 ],363 "version": 1364 },365 {366 "name": "path",367 "nickname": "PATH",368 "providerId": "cas",369 "dataSourceId": "cas-shared-default",370 "licensed": true,371 "hasDefinition": true,372 "links": [373 {374 "method": "GET",375 "rel": "up",376 "href": "/casManagement/servers/cas-shared-default/dataConnectors",377 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",378 "type": "application/vnd.sas.collection",379 "itemType": "application/vnd.sas.data.engine"380 },381 {382 "method": "GET",383 "rel": "self",384 "href": "/casManagement/servers/cas-shared-default/dataConnectors/path",385 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/path",386 "type": "application/vnd.sas.data.engine"387 },388 {389 "method": "GET",390 "rel": "definition",391 "href": "/casManagement/servers/cas-shared-default/dataConnectors/path/definition",392 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/path/definition",393 "type": "application/json"394 }395 ],396 "version": 1397 },398 {399 "name": "postgres",400 "nickname": "POSTGRES",401 "legalName": "Data Connector to PostgreSQL",402 "providerId": "cas",403 "dataSourceId": "cas-shared-default",404 "licensed": true,405 "hasDefinition": true,406 "links": [407 {408 "method": "GET",409 "rel": "up",410 "href": "/casManagement/servers/cas-shared-default/dataConnectors",411 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",412 "type": "application/vnd.sas.collection",413 "itemType": "application/vnd.sas.data.engine"414 },415 {416 "method": "GET",417 "rel": "self",418 "href": "/casManagement/servers/cas-shared-default/dataConnectors/postgres",419 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/postgres",420 "type": "application/vnd.sas.data.engine"421 },422 {423 "method": "GET",424 "rel": "definition",425 "href": "/casManagement/servers/cas-shared-default/dataConnectors/postgres/definition",426 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/postgres/definition",427 "type": "application/json"428 }429 ],430 "version": 1431 },432 {433 "name": "redshift",434 "nickname": "REDSHIFT",435 "legalName": "Data Connector to Amazon Redshift",436 "providerId": "cas",437 "dataSourceId": "cas-shared-default",438 "licensed": true,439 "hasDefinition": true,440 "links": [441 {442 "method": "GET",443 "rel": "up",444 "href": "/casManagement/servers/cas-shared-default/dataConnectors",445 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",446 "type": "application/vnd.sas.collection",447 "itemType": "application/vnd.sas.data.engine"448 },449 {450 "method": "GET",451 "rel": "self",452 "href": "/casManagement/servers/cas-shared-default/dataConnectors/redshift",453 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/redshift",454 "type": "application/vnd.sas.data.engine"455 },456 {457 "method": "GET",458 "rel": "definition",459 "href": "/casManagement/servers/cas-shared-default/dataConnectors/redshift/definition",460 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/redshift/definition",461 "type": "application/json"462 }463 ],464 "version": 1465 },466 {467 "name": "s3",468 "nickname": "S3",469 "providerId": "cas",470 "dataSourceId": "cas-shared-default",471 "licensed": true,472 "hasDefinition": true,473 "links": [474 {475 "method": "GET",476 "rel": "up",477 "href": "/casManagement/servers/cas-shared-default/dataConnectors",478 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",479 "type": "application/vnd.sas.collection",480 "itemType": "application/vnd.sas.data.engine"481 },482 {483 "method": "GET",484 "rel": "self",485 "href": "/casManagement/servers/cas-shared-default/dataConnectors/s3",486 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/s3",487 "type": "application/vnd.sas.data.engine"488 },489 {490 "method": "GET",491 "rel": "definition",492 "href": "/casManagement/servers/cas-shared-default/dataConnectors/s3/definition",493 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/s3/definition",494 "type": "application/json"495 }496 ],497 "version": 1498 },499 {500 "name": "teradata",501 "nickname": "TERADATA",502 "legalName": "SAS Data Connect to Teradata",503 "providerId": "cas",504 "dataSourceId": "cas-shared-default",505 "licensed": true,506 "hasDefinition": true,507 "links": [508 {509 "method": "GET",510 "rel": "up",511 "href": "/casManagement/servers/cas-shared-default/dataConnectors",512 "uri": "/casManagement/servers/cas-shared-default/dataConnectors",513 "type": "application/vnd.sas.collection",514 "itemType": "application/vnd.sas.data.engine"515 },516 {517 "method": "GET",518 "rel": "self",519 "href": "/casManagement/servers/cas-shared-default/dataConnectors/teradata",520 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/teradata",521 "type": "application/vnd.sas.data.engine"522 },523 {524 "method": "GET",525 "rel": "definition",526 "href": "/casManagement/servers/cas-shared-default/dataConnectors/teradata/definition",527 "uri": "/casManagement/servers/cas-shared-default/dataConnectors/teradata/definition",528 "type": "application/json"529 }530 ],531 "version": 1532 }533 ],534 "limit": 100,535 "version": 2536}
| Name | Type | Required | Description |
|---|---|---|---|
serverName | string | true | The CAS server name for which to obtain data connectors. |
| Name | Type | Required | Description |
|---|---|---|---|
filter | string<filter-criteria> | false | Filter criteria for returned data connectors. The valid filter fields are the top-level fields returned for items in the collection. For example, name, nickname, legalName, and so on. The supported functions are and, or, not, eq, lt, le, gt, ge, contains, startsWith, endsWith, and isNull. Sample queries include the following: Search by nickname starting with: filter=startsWith(nickname, 'TERA') Search by name: filter=eq(name, 'impala') Search for multiple items: filter=in(name, 'hdfs', 'dnfs') Search by name ending with: filter=endsWith(name, 'fs') |
limit | integer | false | Maximum number of data connectors to return in this page of results. The actual number of returned data connectors might be less if the collection has been exhausted. Defaults to 10. |
sessionId | string | false | Session ID to use when connecting to retrieve the list of data connectors. If not specified, a temporary session will be used. |
sortBy | string<sort-criteria> | false | Sort returned items. The sort criteria supports the top-level fields returned for items in the collection such as name, nickname, and legalName. Sample sorts include the following: Sort ascending by name: sortBy=name:ascending Sort descending by nickname: sortBy=nickname:descending The default sort is by name in ascending order. |
start | integer | false | The starting index of the first data connector in a page. Defaults to 0. |
| Status | Meaning | Description | ||
|---|---|---|---|---|
| 200 | OK | The request succeeded. | Schema | |
| 400 | Bad Request | The request was invalid. An invalid filter or combination of request parameters was provided. | Schema | |
| 404 | Not Found | No data connector exists at the requested path. | Schema |