Oracle Essbase

Oracle Essbase Connections API

Manage global and application-level connections

GitHub OpenAPI

Operations 12

GET /applications/{applicationName}/connections Oracle Essbase List Application Connections #
POST /applications/{applicationName}/connections Oracle Essbase Create Application Connection #
GET /applications/{applicationName}/connections/{connectionName} Oracle Essbase Get Application Connection #
PUT /applications/{applicationName}/connections/{connectionName} Oracle Essbase Update Application Connection #
DELETE /applications/{applicationName}/connections/{connectionName} Oracle Essbase Delete Application Connection #
POST /applications/{applicationName}/connections/{connectionName}/actions/test Oracle Essbase Test Saved Application Connection #
POST /applications/{applicationName}/connections/actions/test Oracle Essbase Test New Application Connection #
GET /connections Oracle Essbase List Global Connections #
POST /connections Oracle Essbase Create Global Connection #
GET /connections/{connectionName} Oracle Essbase Get Global Connection #
PUT /connections/{connectionName} Oracle Essbase Update Global Connection #
DELETE /connections/{connectionName} Oracle Essbase Delete Global Connection #

Documentation

📖
Documentation
https://docs.oracle.com/en/database/other-databases/essbase/21/essrt/index.html
📖
Authentication
https://docs.oracle.com/en/database/other-databases/essbase/21/erest/op-rest-v1-sessions-post.html
📖
GettingStarted
https://docs.oracle.com/en/database/other-databases/essbase/21/essrt/api-essbase.html

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/openapi/oracle-essbase-connections-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-application-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-database-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-job-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-user-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-session-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-dimension-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-connection-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-script-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-filter-schema.json

Other Resources

🔗
Reference
https://docs.oracle.com/en/database/other-databases/essbase/21/essrt/rest-endpoints.html
🔗
JSONLDContext
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-ld/oracle-essbase-context.jsonld

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/oracle-essbase-connections-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

oracle-essbase-connections-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Oracle Essbase REST Application Configuration Connections API
  description: RESTful API for managing and interacting with Oracle Essbase applications, databases, and performing analytical operations. Enables automation of Essbase resource management with endpoints for applications, databases, calculations, data loads, user management, sessions, jobs, files, scripts, filters, partitions, connections, datasources, dimensions, outline viewer, locks, scenarios, server properties, and more. All communication occurs over secured HTTP.
  version: 21.0.0
  contact:
    name: Oracle Support
    url: https://support.oracle.com
  license:
    name: Oracle Technology Network License
    url: https://www.oracle.com/legal/terms/
  x-provider: oracle-essbase
servers:
- url: https://{host}:{port}/essbase/rest/v1
  description: Oracle Essbase REST API server
  variables:
    host:
      default: localhost
      description: Essbase server hostname
    port:
      default: '9001'
      description: Essbase server port
security:
- basicAuth: []
- bearerAuth: []
tags:
- name: Connections
  description: Manage global and application-level connections
paths:
  /applications/{applicationName}/connections:
    get:
      operationId: listApplicationConnections
      summary: Oracle Essbase List Application Connections
      description: Returns all connections defined for the specified application.
      tags:
      - Connections
      parameters:
      - $ref: '#/components/parameters/applicationName'
      responses:
        '200':
          description: Connection list returned successfully.
          content:
            application/json:
              schema:
                type: object
        '400':
          description: Bad request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
    post:
      operationId: createApplicationConnection
      summary: Oracle Essbase Create Application Connection
      description: Creates a new connection for the specified application for use with data loads and dimension builds.
      tags:
      - Connections
      parameters:
      - $ref: '#/components/parameters/applicationName'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ConnectionInput'
      responses:
        '200':
          description: Connection created successfully.
        '400':
          description: Failed to create connection.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
  /applications/{applicationName}/connections/{connectionName}:
    get:
      operationId: getApplicationConnection
      summary: Oracle Essbase Get Application Connection
      description: Returns details of the specified application connection.
      tags:
      - Connections
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - name: connectionName
        in: path
        required: true
        description: Connection name.
        schema:
          type: string
      responses:
        '200':
          description: Connection details returned successfully.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Connection'
        '400':
          description: Bad request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
    put:
      operationId: updateApplicationConnection
      summary: Oracle Essbase Update Application Connection
      description: Updates the specified application connection.
      tags:
      - Connections
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - name: connectionName
        in: path
        required: true
        description: Connection name.
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ConnectionInput'
      responses:
        '200':
          description: Connection updated successfully.
        '400':
          description: Failed to update connection.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
    delete:
      operationId: deleteApplicationConnection
      summary: Oracle Essbase Delete Application Connection
      description: Deletes the specified application connection.
      tags:
      - Connections
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - name: connectionName
        in: path
        required: true
        description: Connection name.
        schema:
          type: string
      responses:
        '200':
          description: Connection deleted successfully.
        '400':
          description: Bad request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
  /applications/{applicationName}/connections/{connectionName}/actions/test:
    post:
      operationId: testSavedApplicationConnection
      summary: Oracle Essbase Test Saved Application Connection
      description: Tests an existing saved application connection to verify connectivity.
      tags:
      - Connections
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - name: connectionName
        in: path
        required: true
        description: Connection name.
        schema:
          type: string
      responses:
        '200':
          description: Connection test completed successfully.
        '400':
          description: Connection test failed.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
  /applications/{applicationName}/connections/actions/test:
    post:
      operationId: testNewApplicationConnection
      summary: Oracle Essbase Test New Application Connection
      description: Tests a new application connection configuration before saving it.
      tags:
      - Connections
      parameters:
      - $ref: '#/components/parameters/applicationName'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ConnectionInput'
      responses:
        '200':
          description: Connection test completed successfully.
        '400':
          description: Connection test failed.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
  /connections:
    get:
      operationId: listGlobalConnections
      summary: Oracle Essbase List Global Connections
      description: Returns a list of global connections available across all applications.
      tags:
      - Connections
      responses:
        '200':
          description: Global connection list returned successfully.
          content:
            application/json:
              schema:
                type: object
        '400':
          description: Bad request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
    post:
      operationId: createGlobalConnection
      summary: Oracle Essbase Create Global Connection
      description: Creates a new global connection available across all applications.
      tags:
      - Connections
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ConnectionInput'
      responses:
        '200':
          description: Global connection created successfully.
        '400':
          description: Failed to create connection.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
  /connections/{connectionName}:
    get:
      operationId: getGlobalConnection
      summary: Oracle Essbase Get Global Connection
      description: Returns details of the specified global connection.
      tags:
      - Connections
      parameters:
      - name: connectionName
        in: path
        required: true
        description: Connection name.
        schema:
          type: string
      responses:
        '200':
          description: Connection details returned successfully.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Connection'
        '400':
          description: Bad request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
    put:
      operationId: updateGlobalConnection
      summary: Oracle Essbase Update Global Connection
      description: Updates the specified global connection.
      tags:
      - Connections
      parameters:
      - name: connectionName
        in: path
        required: true
        description: Connection name.
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ConnectionInput'
      responses:
        '200':
          description: Connection updated successfully.
        '400':
          description: Failed to update connection.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
    delete:
      operationId: deleteGlobalConnection
      summary: Oracle Essbase Delete Global Connection
      description: Deletes the specified global connection.
      tags:
      - Connections
      parameters:
      - name: connectionName
        in: path
        required: true
        description: Connection name.
        schema:
          type: string
      responses:
        '200':
          description: Connection deleted successfully.
        '400':
          description: Bad request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
components:
  parameters:
    applicationName:
      name: applicationName
      in: path
      required: true
      description: Essbase application name.
      schema:
        type: string
  schemas:
    ConnectionInput:
      type: object
      description: Input for creating or updating a connection.
      required:
      - name
      - type
      properties:
        name:
          type: string
          description: Connection name.
        description:
          type: string
          description: Connection description.
        type:
          type: string
          description: Connection type.
        host:
          type: string
          description: Database host or server address.
        port:
          type: integer
          format: int32
          description: Database port number.
        serviceName:
          type: string
          description: Database service or SID name.
        user:
          type: string
          description: Database username.
        password:
          type: string
          format: password
          description: Database password.
    Link:
      type: object
      description: HATEOAS navigation link.
      properties:
        rel:
          type: string
          description: Link relation type.
        href:
          type: string
          format: uri
          description: Link URL.
        method:
          type: string
          description: HTTP method for this link.
        type:
          type: string
          description: Media type of the linked resource.
    Error:
      type: object
      description: Error response from the Essbase REST API.
      properties:
        message:
          type: string
          description: Human-readable error message.
        errorCode:
          type: string
          description: Machine-readable error code.
        details:
          type: string
          description: Additional error details.
    Connection:
      type: object
      description: A data source connection for data loading and dimension building.
      properties:
        name:
          type: string
          description: Connection name.
        description:
          type: string
          description: Connection description.
        type:
          type: string
          description: Connection type (e.g., Oracle, SQL Server, file-based).
        host:
          type: string
          description: Database host or server address.
        port:
          type: integer
          format: int32
          description: Database port number.
        serviceName:
          type: string
          description: Database service or SID name.
        user:
          type: string
          description: Database username.
        walletPath:
          type: string
          description: Path to the wallet file for secure connections.
        links:
          type: array
          items:
            $ref: '#/components/schemas/Link'
  securitySchemes:
    basicAuth:
      type: http
      scheme: basic
      description: HTTP Basic Authentication using Essbase username and password.
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: OAuth 2.0 Bearer token authentication for cloud deployments on Oracle Cloud Infrastructure.