Oracle Updated OUA…So How Do You Benefit From It?

Oracle Updated OUA…So How Do You Benefit From It?image

By Gokuleshwar Raju Nannapuraju, HEXstream BI/ETL consultant

As you may have heard, Oracle has released version 2.9 of its Oracle Utilities Analytics Warehouse (OUA), bringing several new features and improvements. Let’s break down these updates in an easy-to-understand way for non-technical readers…

Support for Microservices Architecture for Configuring Oracle GoldenGate

Starting with version 2.9, OUA now supports the Microservices Architecture for Oracle GoldenGate. This is a modern way to configure and manage Oracle GoldenGate, a tool that helps move data between different databases.

So what does this actually mean? 

  • Simpler and more efficient: Microservices make the configuration and management of data transfers more streamlined and scalable.
  • Out with the old: The older "Classic" architecture for setting up Oracle GoldenGate is no longer supported. The configuration module "JKM BI Oracle to Oracle GoldenGate" has been updated to work with this new architecture.

Support for Oracle Analytics Server 2024

OUA 2.9 is now compatible with Oracle Analytics Server version 2024 (version 7.6). It also continues to support the 2023 version. This is important, primarily, because of the enhanced analytics; with this support, users can leverage the latest features and improvements in Oracle Analytics Server 2024, providing better data analysis and visualization capabilities.

Updated Supported Platforms

The release includes updates on the platforms that are supported, ensuring compatibility with the latest server and client-side technologies.


  • Operating System (Server): Oracle Linux 7.x, 8.x (64-bit), Oracle Solaris 11.4 on
    SPARC (64-bit)
  • FMW App Server: WebLogic
  • JDK: JDK 8u411
  • Oracle Database: Enterprise Edition 19.x, Client for Linux 19
  • Oracle Analytics Server: 7.0 (2023) and 7.6 (2024)
  • Oracle Data Integrator (ODI):
  • Apex: 23.2
  • Oracle GoldenGate Microservices: 19.1
  • Oracle REST Data Service: 21.4.3


  • Client Operating System: Windows 10 (64-bit)
  • Browser Versions:
    • Microsoft Edge 120.0.2210.77
    • Mozilla Firefox 121.0
    • Google Chrome 120.0.6099.109

Supported Source Application Versions

The following source application versions are supported in this Oracle Utilities Analytics Warehouse release:

  • Customer Care and Billing:
  • Customer to Meter:
  • Network Management System:,
  • Work and Asset Management:
  • Meter Data Management:
  • Mobile Workforce Management:, 2.2.0.x.x

Supported Upgrade Paths

The following upgrade path is available for Oracle Utilities Analytics Warehouse in this release:

  • From: V2. To: V2.


Existing clients are encouraged to upgrade to OUA 2.9 because the new release supports all the latest versions of source applications and integrates seamlessly with new applications used in OUA. This upgrade will not only resolve existing bugs, but also introduce new features, providing a more robust and efficient analytics solution.

As for me, I'm excited to see these upgrades in action across utilities, as they will not only resolve existing issues, but also enhance compatibility with the latest OAS versions and new source applications. This will be incredibly beneficial for end users.

Click here for the official Oracle documentation. 

And click here to connect with HEXstream to learn how we can help you take advantage of this upgrade. 

Let's get your data streamlined today!