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

oracle bi solutions

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

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 its 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. Learn more about Oracle Cloud Solutions

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

Before Scenario & Business Requirements
Prior to 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 reduce the total cost of ownership of their enterprise analytics solution, the customer wanted to keep the data warehouse and data sources on-premise (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 before state of our client’s IT framework. Their Oracle JD Edwards data was visually displayed in Oracle BI Publisher dashboards, while 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:
After weighing up 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
  4. Prepare and clean up the on-premise metadata
  5. Lift and shift on-premise metadata and configurations to OAC
  6. Test and validate reports, dashboards and security
  7. Import the metadata from non-Production instance to Production OAC instance
  8. Perform integration testing for final signoff
After Scenario
The following diagram illustrates the after state of our client’s IT framework



The Benefits and Business Value Delivered
Our customers can attest, when you chose Jade, you are choosing a personalized delivery experience and a rapid return on your investment. We believe in clear and timely communication as well as transparency to ensure all engagements are successfully completed on time. For this client, Jade was able to reduce their overall IT spend 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 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 of on-premise servers, and utilized well-tuned Oracle’s PaaS that is specifically configured for reporting and analytics needs
  3. Software Cost Reduction: When the customer retired 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. Learn more about Oracle cloud integration services.
  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 on-premise OBIEE footprint


Original blog source: https://www.jadeglobal.com/blog/oracle-paas-migration-using-oracle-analytics-cloud-oac-reduces-20-of-total-cost-of-ownership-for-oil-gas-customer

Comments

Post a Comment

Popular posts from this blog

Whitepaper - Mobile Application Testing

With the advent of smartphones, a mobile phone has evolved from being just a communication device to a highly sophisticated business utility equipment. With smartphones no longer remaining a conspicuous consumption, they have become an efficient tool for handling finances, managing mails & agendas, and executing other business functions. Statistics highlight that 1.6 billion smart phones are sold at a rate of 1.8 to 2 million devices a day since 2007, and 1.5 billion smartphones will be shipped in 2016 – a 5.7 percent increase from 2015 – and will reach 1.92 billion by 2020. Download whitepaper - Mobile application testing
Read more

Tableau CRM features and Setup guide

Image
What is Tableau CRM? Many enterprises have leveraged Salesforce out-of-the-box reports and dashboards to understand their data and performance for years. However, data size has been increasing rapidly daily; analyzing the data manually has become a bigger challenge; subsequently, analytics have become more critical than ever before. Learn more about Salesforce CRM implemetation   Tableau CRM (Formerly known as Einstein Analytics) was introduced to address this challenge. It's an AI (Artificial intelligence) powered advanced analytics solution which works with any data source. The AI-powered Einstein Discovery, Einstein Analytics apps analyze billions of data combinations and provide predictive insights and prescriptive recommendations to the users. Tableau CRM provides analytic experiences in sales, service, and marketing to quickly take business decisions and actions. This platform is also optimized for mobile use. Why Tableau CRM? The key differences between Tableau C...
Read more

5 Things You Must Know About Cyber Security in the Cloud

Image
At first cloud computing and cyber security look like they are not related to each other. However, we can see that they are related and the reason behind it is that the first requires storing your data off-site and the second requires building virtual walls around it, protecting your data at all costs. Cloud computing means outsourcing, trusting a vendor to keep your data and transactions safe. Cyber security means keeping it all close, trusting the staff, procedures and protocols to do the job. Check more information about Oracle Cloud Managed Services . Cloud Security is the new Cyber Security With every passing year, the number of businesses migrating to the cloud increases–and the number of cyberattacks increases, as if keeping pace. By end of 2018, almost 96 percent of organizations started using cloud computing in some way, according to CIO.com. At the same time, cyberattacks were on the rise, with almost twice as many ransomware attacks in 2017 (160,000) as compared t...
Read more