Enable Microsoft Entra ID (Azure AD) SSO to Oracle Hyperion via Datawiza

About 2 min

Overview

This tutorial shows how to enable Microsoft Entra ID (formerly known as Azure Active Directory) Single Sign-On (SSO) and Microsoft Entra ID Multi-Factor Authentication (MFA) for an Oracle Hyperion application using Datawiza Access Proxy (DAP).

Benefits of integrating applications with Microsoft Entra ID using DAP include:

Proactive security with Zero Trust through Microsoft Entra ID SSO.
Easy authentication and authorization in Microsoft Entra ID with no-code Datawiza. Use of web applications such as: Oracle JDE, Oracle E-Business Suite, Oracle Sibel, Oracle Peoplesoft, Oracle Hyperion, and home-grown apps.
Use the Datawiza Cloud Management Consoleopen in new window to manage access to applications in public clouds and on-premises.

Background

This document focuses on Oracle Hyperion application integration using HTTP authorization headers to manage access to protected content.

For legacy applications, due to the absence of modern protocol support, a direct integration with Microsoft Entra ID SSO is difficult. Datawiza Access Proxy bridges the gap between the legacy application and the modern ID control plane, through protocol transitioning. DAP lowers integration overhead, saves engineering time, and improves application security.

Architecture

The solution has the following components:

Microsoft Entra ID (Azure AD) : The Microsoft cloud-based identity and access management service, which helps users sign in and access external and internal resources.
Datawiza Access Proxy (DAP): A lightweight container-based reverse-proxy that implements OpenID Connect (OIDC), OAuth, or Security Assertion Markup Language (SAML) for user sign-in flow. It transparently passes identity to applications through HTTP headers.
Datawiza Cloud Management Console (DCMC): A centralized console to manage DAP. DCMC has UI and RESTful APIs for administrators to configure Datawiza Access Proxy and access control policies.
Oracle Hyperion application : Legacy application going to be protected by Microsoft Entra ID and DAP.

Prerequisites

Ensure the following prerequisites are met:

An Azure subscription. If you don't have one, you can get an Azure free accountopen in new window
A Microsoft Entra ID tenant linked to the Azure subscription.
- See, Quickstart: Create a new tenant in Microsoft Entra IDopen in new window.
Install Dockeropen in new window and Docker Composeopen in new window
User identities synchronized from an on-premises directory to Microsoft Entra ID, or created in Microsoft Entra ID and flowed back to an on-premises directory.
- See, Microsoft Entra Connect Sync: Understand and customize synchronizationopen in new window.
An account with Microsoft Entra ID and the Application administrator role
- See, Microsoft Entra built-in rolesopen in new window.
An Oracle Hyperion environment. Supported versions include: v11.2.8.0 or later.
(Optional) An SSL web certificate to publish services over HTTPS. You can also use default Datawiza self-signed certs for testing.

Getting started with DAP

To integrate Oracle Hyperion with the Microsoft Entra ID:

Sign in to Datawiza Cloud Management Consoleopen in new window.
The Welcome page appears.
Select the orange Getting started button.
In the Name and Description fields, enter the relevant information.
Select Next.

On the Add Application dialog, use the following values:

Property	Value
App Type	Web
Name	Enter a unique application name.
Application URL	For example: `https://hyperion-external.example.com`. For testing, you can use localhost DNS. If you aren't deploying DAP behind a load balancer, use the Public Domain with the port.
Listen Port	The port that DAP listens on.
Upstream Servers	The Oracle Hyperion implementation URL and port to be protected.

Select Next.
On the Configure IdP dialog, enter the relevant information.
Info
DCMC has one-click integration to help complete Microsoft Entra ID configuration. DCMC calls the Microsoft Graph API to create an application registration on your behalf in your Microsoft Entra ID tenant.
Select Create.
The DAP deployment page appears.

Install and run Datawiza Access Proxy

Once clicking on the Create button, the basic configuration on the management console is finished. You will see the final step of the guide, which presents you with a page showing the simple steps to deploy Datawiza Access Proxy (DAP) with your application. Note down the commands for your deployment. The first command will download Docker and Datawiza Access Proxy image, and the second command will create a Docker Compose file and run Datawiza Access Proxy. You can refer to Install and Run Datawiza Access Proxy by command for more information.

DAP Docker Compose File

SSO and HTTP headers

The DAP gets user attributes from IdP and passes them to the upstream application via header or cookie.

For the Oracle Hyperion application to recognize the user correctly, there's another configuration step. Using a certain name, it instructs DAP to pass the values from the IdP to the application through the HTTP header.

Such configuration will be done in the Applications tab on the left panel and go to Attribute Pass sub-tab. For Oracle Hyperion, please refer to the screenshot below to configure the attribute pass:

Property	Value
Field	Username
Expected	HYPLOGIN
Type	Header

Oracle Hyperion Entra ID (Azure AD) SSO and MFA | Attribute Pass

Info

This configuration uses the Microsoft Entra ID displayName as the sign in username used by Oracle Hyperion. Please make sure that the displayName is as same as the name in Hyperion user directories. To use another user identity, go to the Mappings tab.

SSL Configuration

Select the Advanced tab.
Select Enable SSL.
From the Cert Type dropdown, select a type.
For testing purposes, we'll be providing a self-signed certificate.
Info
You have the option to upload a certificate from a file.
Click Save.

Click Advanced Options.
Input /workspace/index.jsp in both Login Redirect URI and Logout Redirect URI
Click Save.

(Optional) Enable MFA on Microsoft Entra ID (Formerly Azure AD)

To provide an extra level of security for sign-ins, sometimes you might want to enforce MFA for user sign-in. There are several ways to achieve this. The simplest and easiest way is to enable MFA on the Azure portal.

Sign in to the Azure portal as a Global Administrator.
Select Microsoft Entra ID > Manage > Properties.
Under Properties , click the Manage security defaults.
Under Enable Security defaults, select Yes and then Save.

Enable SSO in the Oracle Hyperion Console

To enable SSO in the Oracle Hyperion environment:

Log into to Hyperion Shared Service Console http://{your-hyperion-fqdn}:19000/workspace/index.jsp as a System Administrator.

Enable SSO

Select Navigate, and then Shared Services Console.
Select Adminstration, and then Configure User Directories.
Click Security Options.
In the Single Sign-On Configuration section:
1. Select the Enable SSO check box.
2. From SSO Provider or Security Agent drop-down list, select Other.
3. From SSO Mechanism drop-down list, select Custom HTTP Header and then specify the name of the header that the security agent passes to EPM System, which is HYPLOGIN.
Click OK.

Update Post Logoff URL setting in EPM Workspace

Select Navigate, then Workspace Settings, and then Server Settings.
In Workspace Server Settings, change POST Logoff URL to the URL of the web page that you want users to see when they log out of EPM System, which is /datawiza/ab-logout.
Click OK.

Test an Oracle Hyperion application

To confirm SSO and MFA for Oracle Hyperion application work correctly, a prompt should appear to use an Identity Provider account for signing in. Credentials and optional MFA are checked and the Oracle Hyperion home page appears.

Note

For security purpose, organizations using this model in production environment should block all direct access to the application, thus forcing the use of a strict path through the Datawiza Access Proxy.