Oracle Essbase · Schema

Oracle Essbase Connection

A data source connection in Oracle Essbase used for data loading and dimension building operations. Connections can be defined at the application level or globally. They store the configuration required to connect to external databases and data sources such as Oracle, SQL Server, and file-based sources.

AnalyticsBudgetingBusiness IntelligenceFinancial ConsolidationMulti-Dimensional DatabaseOLAPPlanning

Properties

Name Type Description
name string Connection name used to reference this connection in jobs and scripts.
description string Human-readable description of the connection purpose and target.
type string Connection type identifying the target data source technology (e.g., Oracle, SQL Server, file-based).
host string Database host address or server name.
port integer Database port number for the connection.
serviceName string Database service name or SID for Oracle connections.
user string Database username for authentication.
password string Database password for authentication. Write-only; not returned in API responses.
walletPath string Path to the Oracle wallet file for secure SSL/TLS connections.
links array HATEOAS navigation links.
View JSON Schema on GitHub

JSON Schema

oracle-essbase-connection-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "oracle-essbase-connection-schema.json",
  "title": "Oracle Essbase Connection",
  "description": "A data source connection in Oracle Essbase used for data loading and dimension building operations. Connections can be defined at the application level or globally. They store the configuration required to connect to external databases and data sources such as Oracle, SQL Server, and file-based sources.",
  "type": "object",
  "properties": {
    "name": {
      "type": "string",
      "description": "Connection name used to reference this connection in jobs and scripts."
    },
    "description": {
      "type": "string",
      "description": "Human-readable description of the connection purpose and target."
    },
    "type": {
      "type": "string",
      "description": "Connection type identifying the target data source technology (e.g., Oracle, SQL Server, file-based)."
    },
    "host": {
      "type": "string",
      "description": "Database host address or server name."
    },
    "port": {
      "type": "integer",
      "description": "Database port number for the connection."
    },
    "serviceName": {
      "type": "string",
      "description": "Database service name or SID for Oracle connections."
    },
    "user": {
      "type": "string",
      "description": "Database username for authentication."
    },
    "password": {
      "type": "string",
      "description": "Database password for authentication. Write-only; not returned in API responses."
    },
    "walletPath": {
      "type": "string",
      "description": "Path to the Oracle wallet file for secure SSL/TLS connections."
    },
    "links": {
      "type": "array",
      "description": "HATEOAS navigation links.",
      "items": {
        "$ref": "#/$defs/Link"
      }
    }
  },
  "required": ["name", "type"],
  "$defs": {
    "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."
        }
      }
    }
  }
}

Work with this as data

Every JSON Schema 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 schemas

4 MCP tools reach this
  • find_json_schemasBrowse and filter every JSON Schema in the catalog.
  • 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 JSON Schema
curl "https://apis.io/api/v1/json-schemas/oracle-essbase-connection"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"

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

Get an API key

Free tier, no email required.

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