Oracle Paas Migration using Oracle Analytics Cloud (OAC) Reduces 20% of Total Cost of Ownership for Oil & Gas Customer

Here at Jade Global, we’ve created a culture of transparency critical to ensuring 100% customer satisfaction. We understand that customer time and attention are scarce resources, so with each service we provide, we ensure open communication and unparalleled work ethic and keep all parties informed.

Success Story: Utilizing OAC Architecture

The following success story outlines our customer’s journey from early information gathering, where we learn about their challenges and business requirements, followed by Jade’s solution design, delivery, implementation, and beyond. This customer is a midsize innovative service provider in the petroleum industry. Jade ultimately migrated their reporting to Oracle PaaS utilizing an Oracle Business Intelligence Solution, Oracle Analytics Cloud (OAC). However, before we get to the solution, let’s begin with the background story.

About the Customer

This customer delivers real value in the Oil & Gas industry by supplying quality petroleum storage and dispensing equipment, innovative services, and dependable fueling site construction. They offer environmental consulting, waste solutions services, electrical contracting, and industrial coasting. Since the early 1970s, they have operated in the United States Midwest, Southern, and Mountain regions.

Before Scenario & Business Requirements

Before working with Jade, the customer utilized an on-premise Oracle Business Intelligence (BI) solution for their transactional and analytical reporting needs. They had been using Oracle Business Intelligence Suite Enterprise 11g. (OBIEE) for several years and implemented their own operational and financial reports. Their OBIEE and BI Publisher sourced data from multiple on-premise systems, including Oracle JDE, Astea (a field service management software), and other home-grown Microsoft SQL Server-Based ERP systems. To align their enterprise Cloud migration strategy and to reduce the total cost of ownership, the customer wanted to keep the data warehouse and data sources on-premises (without exposing the data in the public Cloud). Finally, they wanted to migrate the reporting layer to Platform as a Service (Oracle Paas), a set of services to build and manage modern applications on-premises or in the Cloud.

The following diagram illustrates the state of our client’s IT framework. Their Oracle JD Edwards data were visually displayed in Oracle BI Publisher dashboards. At the same time, their Microsoft SQL and Astea sourced data through a Microsoft SQL server into the data warehouse, which was then displayed through dynamic Oracle Business Intelligence dashboards.

Jade Global’s Solution:

Jade Global’s Solution:

After weighing the project costs, benefits, and client requests, Jade approached the customer with a best-fit hybrid Cloud strategy for their enterprise. For the customer to maintain their data and ETL on-premise, we proposed that they only migrate the reporting layer to Oracle Public Cloud utilizing Oracle Analytics Cloud (OAC). To enable the reporting in OAC for the customer, we followed the following steps:

1. Enable the Oracle DBaaS (Database Cloud Service) instances for Production and non-Production instances
2. Enable OAC Production and non-Production instances
3. Enable Oracle VPN as Service to secure the tunnel between Oracle Public Cloud servers and the customer’s on-premise VM machines

Prepare and clean up the on-premise metadata

Lift and shift on-premise metadata and configurations to OAC

Test and validate reports, dashboards, and security

Import the metadata from the non-Production instance to the Production OAC instance

Perform integration testing for final signoff

After Scenario

The following diagram illustrates the state of our client’s IT framework

The Benefits and Business Value Delivered

The Benefits and Business Value Delivered

Our customers can attest when you choose Jade, you choose a personalized delivery experience and a rapid return on your investment. We believe in clear, timely communication and transparency to ensure all engagements are completed on time. For this client, Jade was able to reduce their overall IT spending by getting rid of ongoing software support fees and eliminating the need for on-premise servers. In addition, our customer reduced 20% of their total cost of ownership after migrating to OAC and moving off of OBIEE. The below list outlines the key benefits of the project:

1. OPEX Vs. CAPEX: Hybrid Oracle Cloud approach helped the customer move towards the CAPEX spending model by eliminating upfront investment in their business intelligent solution
2. Hardware Cost Reduction: By migrating to Oracle Public Cloud, the customer eliminated the need for on-premise servers and utilized well-tuned Oracle’s PaaS that is configured explicitly for reporting and analytics needs
3. Software Cost Reduction: When the customer retired the on-premise OBIEE footprint, they also got rid of ongoing software support fees and utilized the latest and greatest Oracle BI features like data visualization, integration with Essbase Cloud, ad hoc data preparation, etc.
4. Maintenance Cost Reduction: Due to Oracle’s “Cloud First” strategy, OAC (PaaS) receives all the new features and updates even before it’s available to on-premise solutions like OBIEE
5. Lower TCO: Overall, our customer could reduce 20% of the total cost of ownership by migrating to OAC and retiring the on-premises OBIEE footprint

About Jade Global’s Oracle Partnership

Jade Global is a Cloud-focuseda integration, consulting & IT outsourcing Oracle Platinum Partner. Our services include implementations, upgrades, and custom development on the Oracle SOA suite. With more than 800 employees & 250+ Cloud-certified professionals, Jade has successfully delivered cutting-edge solutions for Oracle Cloud Financials, Supply Chain (SCM), Human Resources (HCM), Warehouse management (WMS), Project Management (PM), Hyperion, EPBCS, OACS, OBIEE & Database Services across diverse industries. Our industry-focused ERP and BI Software solutions improve visibility across entire enterprises in Hi-Tech, Manufacturing, Distribution, Hospitality, and more.

For more information and to better understand Jade Global’s offerings in migrating to Oracle PaaS/SaaS, please contact Info@jadeglobal.com or call us directly at 1 877-523-3448

LinkedIn: http://www.linkedin.com/company/jade

Facebook: https://www.facebook.com/jadeglobal/

Twitter: https://twitter.com/JadeGlobal