Reporting on Oracle Cloud Applications with EBS

The first post in this series discussed the 9 biggest BI challenges in postmodern ERP era. This post discusses Magnitude’s approach to address Oracle E-Business Suite (EBS) customers who are increasingly adopting Oracle ERP Cloud applications (OCA).

Magnitude’s approach to Unified Business Analytics (UBA) builds on and extends the rich legacy of NoetixViews, NoetixAnalytics and RapidDecisions in addition to delivering the packaged business analytics for Oracle ERPs to accomplish following goals:

  • Data blending across ERPs – enables blending of business analytics across multiple Oracle ERPs (EBS, JDEdwards OneWorld, JDE EnterpriseOne, JDE World, PeopleSoft), as well as any other data sources.
  • Includes Oracle Cloud Applications – enables the inclusion and blending of Oracle Cloud Applications (OCA) with any other source to facilitate a gradual migration to OCA, while maintaining complete visibility across the business.
  • Flexible and rapid deployment – can be deployed in the cloud or on-premise, with a lightweight architecture for quick deployment. The flexible architecture allows support for all popular BI platforms, including Tableau, Microsoft PowerBI, Qlik and others for maximum deployment simplicity.

UBA is an exciting development for existing Magnitude Noetix and RapidDecision users. Furthermore, this will appeal to any OCA user wishing to blend OCA reporting with other on-premise Oracle ERPs.

Below represents UBA at a high-level in the context of EBS, OCA applications.

For OCA/EBS customers UBA overcomes typical challenges by providing a head start in data acquisition, management , and consumption aspects.

For extracting data from EBS, OCA source systems UBA primarily relies on HVR software log-based change data capture (CDC) capabilities. The requisite source data from EBS is replicated and kept in sync with on-premise, cloud target data platform of your choice (Microsoft Azure SQL DB, Snowflake, Amazon Redshift, Oracle Cloud database etc.). Oracle’s BI Cloud Connector (BICC) is leveraged in addition to HVR for replicating the OCA data on the target data platform’s landing zone. With the out-of- the-box extraction package, the configuration for accessing, replicating, and synchronizing the data from EBS, OCA sources is simplified.

Once data from EBS, OCA is available on the target data platform, for users who are looking to get a business centric view, UBA offers pre-built content. Here’s a schematic representation of UBA solution for organizations that implemented OCA Expense Cloud and maintain core financials in EBS.

UBA data models - Noetix Search

Like our proven products, UBA’s data models are metadata-based and integrate with Noetix Search, Noetix Generator products to accelerates data consumption. Noetix Search helps users to find the right  report via familiar easy-to-use search interface. Noetix Generator family of products automate building metadata models for leading BI platforms, giving you the freedom to choose the platform(s) that fit your users’ needs.

Magnitude UBA offers pre-built solutions for the fastest, lowest cost, and lowest risk BI implementations for Oracle ERPs including OCA. Request a Demo today!