How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

SERTICA Data Warehouse Connections API

The DataWarehouseConnections API from SERTICA — 9 operation(s) for datawarehouseconnections.

SERTICA Data Warehouse Connections API is one of 254 APIs that SERTICA publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include DataWarehouseConnections. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, an API reference, and authentication docs.

This API exposes 12 operations across 9 paths, and defines 17 schemas. It is described by OpenAPI 3.2.0, at version v1.

Requests are made against a single base URL, /api.

12 operations 9 paths 17 schemas 1 DELETE5 GET5 POST1 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
v1
Base URL
https://{sitename}.sertica.com/api
Authentication
HTTP Bearer
Resource Areas
1

Authentication & Security 1

SERTICA Data Warehouse Connections API declares 1 security scheme for authenticating requests. It accepts HTTP bearer tokens (Bearer).

  • Bearer — JWT Authorization header using the Bearer scheme

Paths & Operations 12

Across 9 paths, the API surfaces 12 operations — 1 DELETE, 5 GET, 5 POST, 1 PUT. Each is listed below with its method, path, parameters, and response codes.

DataWarehouseConnections 12
GET
/DataWarehouseConnections
Gets a list of DataWarehouseConnection
GetDataWarehouseConnections 2 params → 200401403500
POST
/DataWarehouseConnections
Creates a new dataWarehouseConnection record
CreateDataWarehouseConnection body → 201400401403500
GET
/DataWarehouseConnections/{connectionNo}
Gets a specific DataWarehouseConnection
GetDataWarehouseConnection 1 param → 200400404401403500
PUT
/DataWarehouseConnections/{connectionNo}
Updates an existing DataWarehouseConnection
UpdateDataWarehouseConnection 1 param body → 200400401403500
DELETE
/DataWarehouseConnections/{connectionNo}
Deletes an dataWarehouseConnection record
deleteDataWarehouseConnectionsByConnectionNo 1 param → 204400401403500
GET
/DataWarehouseConnections/{connectionNo}/history
Gets history for a specific DataWarehouseConnection
GetDataWarehouseConnectionHistory 3 params → 200400404401403500
POST
/DataWarehouseConnections/search
Search for dataWarehouseConnection Takes a SearchDefinition input, which can…
SearchDataWarehouseConnection 2 params body → 200401403500
POST
/DataWarehouseConnections/searchCount
Returns number of hits in a search for DataWarehouseConnection Takes a…
SearchCountDataWarehouseConnection body → 200401403500
POST
/DataWarehouseConnections/searchIndex/{dataWarehouseConnectionGuid}
Get index of a record in a search for DataWarehouseConnection Takes a…
SearchIndexDataWarehouseConnection 1 param body → 200401403500
GET
/DataWarehouseConnections/searchInfo
Returns structured information about what and how you can search for
SearchInfoDataWarehouseConnection → 200500
GET
/DataWarehouseConnections/{connectionNo}/copy
Copies an existing dataWarehouseConnection to a new object
CopyDataWarehouseConnection 1 param → 200400401403500
POST
/DataWarehouseConnections/{connectionNo}/test
Tests if the connection is valid
TestDataWarehouseConnection 1 param → 200400204401403500

Schemas 17

The contract defines 17 schemas that model the data the API accepts and returns. The most detailed are SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseConnection (16 properties), Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition (8 properties), SerticaWebApi.Models.BrokenRule (7 properties), Logihold.BusinessObjects.LogiholdObjModel.Search.SearchInfoField (5 properties). Each schema is shown below with its type and property counts.

Logihold.BusinessObjects.LogiholdObjModel.Search.SearchInfoField
object
5 properties
SerticaWebApi.Models.BrokenRule
object
7 properties
SerticaWebApi.Models.BrokenRuleType
string
Logihold.BusinessObjects.LogiholdObjModel.Search.SearchOperator
string
Logihold.BusinessObjects.LogiholdObjModel.Search.ValuesMatching
string
Logihold.BusinessObjects.LogiholdObjModel.SystemData_DataWarehouseConnectionType
string
Logihold.BusinessObjects.LogiholdObjModel.Search.SearchInfo
object
2 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.SearchCriteria
object
4 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.ForDeviceRequest
object
4 properties
SerticaWebApi.Models.ErrorReason
object
2 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDataType
string
Logihold.BusinessObjects.LogiholdObjModel.Search.SearchDefinition
object
8 properties
Logihold.BusinessObjects.LogiholdObjModel.View.SortDirection
string
SerticaWebApi.Models.Link
object
2 properties
Logihold.BusinessObjects.LogiholdObjModel.Search.OrderBy
object
2 properties
SerticaWebApi.Models.Analytics.DataWarehouse.DataWarehouseConnection
object
16 properties
SerticaWebApi.Models.ValidationResult
object
4 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

sertica-datawarehouseconnections-api-openapi.yml Raw ↑

Other APIs SERTICA publishes across the network.

SERTICA Accounting Dimensions API
SERTICA Accounting Dimensions Cache API
SERTICA Accounts API
SERTICA Activity Groups API
SERTICA Address Categories API
SERTICA Address Classifications API
SERTICA Addresses API
SERTICA AI Client API
SERTICA Analytics API
SERTICA Analytics Custom Menus API
SERTICA Analytics Custom Templates API
SERTICA Analytics Excel Templates API
Where this information came from

This is an independent, third-party profile of SERTICA Data Warehouse Connections API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.