Oracle Essbase 11g SOAP Web Services Statement of Direction (Doc ID 2917496.1)

Last updated on DECEMBER 23, 2022

Applies to:

Hyperion Essbase - Version 11.1.2.0.00 to 11.1.2.4.048 [Release 11.1]
Hyperion Analytic Provider Services
Information in this document applies to any platform.

Details

This document provides a statement of direction for customers using the Essbase 11g Web Services feature and its replacement in the release of Essbase 21c and beyond.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle software license and service agreement, which has been executed and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

This document is for informational purposes only and is intended solely to assist you in planning for the implementation and upgrade of the product features described. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remain at the sole discretion of Oracle.

Due to the nature of the product architecture, it may not be possible to safely include all features described in this document without risking significant destabilization of the code.

Actions

Overview of Essbase 11g Web Services

Essbase SOAP Web Services, in version 11.1.2.4 supported access to and administration of Essbase applications and cubes. Essbase Web Services include the following modules:

Data source – used to identify and connect with Essbase servers, applications, cubes, and dimensions.
Administration – used to start, monitor, or stop Essbase Server, applications, and cubes and to perform operations, such as executing MaxL statements.
Data and metadata query – used to perform data and metadata queries, update data, and retrieve metadata from Essbase servers, applications, and cubes.

Replacement of Web Services Beyond 11g

Essbase 11g is the final version that will support the Essbase Web Services. This feature is replaced by the modern REST API in 19c and 21c. Customers using Web services can leverage the REST APIs starting with version 21c. For more details on the REST API capabilities, refer to the documentation. In addition, customers can also leverage CLI-based clients for additional Administration activities.

REST API replaces the Web Services functionality in the following ways:

Data source – Users can leverage API to connect to an Essbase instance via the instance connect URL. You can use the Applications, Dimensions, and other Database-related REST endpoints to get the required information.
Administration – Customers can use CLI or User Session-based REST endpoints for administration activities. Use the Applications REST endpoint to manage Essbase applications and databases. To execute MaxL, customers can use the MaxL client. Details can be found here.
Data and metadata query – use the Dimensions endpoint for metadata query, Outline Viewer endpoint for metadata stats and member info, Jobs endpoint for executing data loads, MDX, etc.

For more details on the various endpoints for REST API, refer to the 21c documentation.

REST API for Oracle Essbase - About the REST APIs

Migration Tools

Currently, there are no migration tools to directly move applications built using web services to REST API-based applications. Customers can create custom applications based on REST API manually.