© 2015-2024. MindStreamAnalytics.com

Oracle Analytics Cloud

Connecting OAC to On-Premise Sources

When I first planning for migrating to Oracle's Cloud suite of projects for Business Intelligence , I would get that sort of imaginary heartburn that you get when thinking of a daunting task that you don't quite understand how to do it, or more importantly, why to do it.

Why upend the existing BI ecosystem I've worked for years to complete? Why undo all the processes I've worked, not only in the developmental sense but also in the business sense of negotiating accesses, earning buy-in from stakeholders, proving out the value by demonstrating key functionality? Moving to the cloud would remove the result of all that effort and cause me to take significant steps backward before being able to take the step forward that cloud technology was supposed to offer... right?

This line of thinking turns out to have a key, fundamental flaw: migrating to Oracle Analytics Cloud does NOT require a full cloud-based architecture.

I learned quickly that migrating from OBIEE on-premise (either from 11g or 12c) to Oracle Analytics Cloud doesn't mean having to re-engineer or recreate your data warehouse and the processes that maintain it, but rather in most cases, OAC can connect to the existing warehouse to provide a hybrid cloud/on-premise solution that allows BI programs like the ones I've worked in to move in a practical, reasonable manner.

Established BI programs can take advantage of the benefits of OAC: namely not having to own and upkeep hardware and the costs associated with it, having easy access to the latest version of the tools, getting the earliest access to the newest features and tools, and being mobile ready and accessible from nearly anywhere.

To understand how this works, it's key to first understand that OAC is offered as a Platform as a Service (PaaS). This means Oracle provides the cloud space and the services required to operate the environment, but you, as the administrator within your organization, are responsible for standing it up, maintaining and administering it (including using Oracle's streamlined patching tools to keep both the virtual environments and the application itself up to date via patching as needed). This is different than Software as a Solution (SaaS) offerings where you simply are provided the front end of a tool and Oracle takes care of everything on the back end autonomously.

One of the benefits of being in a PaaS model is having greater flexibility with controlling how your environments are configured, especially concerning networking and general connectivity options.

Note: Before moving on, I have to emphasize heavily here to be sure to loop your network/security/infrastructure resources into conversations around these options AS SOON AS POSSIBLE in your project design phase. Any time you talk about connecting internal data and/or systems to applications in the public cloud, you must be able to have the relevant conversations with the folks in charge to get their valuable, expert input on the best methods to use in the best interest of security, to get their signoff on the final solution, and avoid situations where a solution is put in place only to find later that it doesn't meet the requirements of the organization or violates some sort of internal policy.

That said, here are the most common options used to create a hybrid cloud/on-premise solution for Oracle Analytics Cloud :

Remote Data Connector

If your on-premise data source is an Oracle database, then the easiest method of connecting it to OAC is to use a Remote Data Connector. This is a plugin provided by Oracle that essentially makes the on-premise DB visible from the Cloud. It has a built-in process to keep your data secured while OAC submits queries. Since this doesn't require any complex networking configurations, it is the best solution to deploy if your requirements support using it.

Click here to learn more about Remote Data Connector

But what if your data sources aren't an Oracle DB? What if they're SQL Server, Teradata, or some sort of application you connect to for real-time reporting?

VPN as a Service

Oracle offers a VPN as a Service option for cloud deployments as well, and it is the first and likely most commonly used method of connecting OAC to on-premise data sources that aren't an Oracle DB. Establishing a VPN connection between your OAC environment and your internal data center will allow the tools within OAC to consume the data just as they do today in the on-premise world.

Click here to learn more about VPN as a Service

Fast Connect

Additionally, Oracle also supports technology like Fast Connect to establish direct connections between your data center and the cloud environment. This may be beneficial if your data volume is exceedingly large or if your requirements are abnormally stringent regarding speeds of data transfer.

You can read more about Oracle's Fast Connect options here.

Finally, I know I am repeating the point noted above, but I cannot stress just how critical it is when considering these options to involve a representative from your internal networking and security teams as early as possible. This will allow them to get an understanding of the objectives you are trying to achieve as well as the technology and methods being proposed. After all, any network or security designs are going to ultimately need their support and approval before being implemented.

If you are considering upgrading and migrating to Oracle Analytics Cloud but are unsure how it impacts your existing data marts, or if you simply do not want to move that set of data any time soon, rest assured that Oracle has options to provide flexibility to facilitate hybrid cloud solutions .

If you're interested in learning more about OAC or any of Oracle's Cloud offerings, visit us at mindstreamanalytics.com , or find us on LinkedIn, Facebook, Twitter, or YouTube. We would love to assist your organization in advancing to the next stage of your Business Intelligence and EPM evolution.

Partner SpotLight


Oracle has the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce cost..

Oracle Profile

Case Studies


Thanks to the intervention of MindStream Analytics, Accumen's Finance department can now model their business with a new, more organized structure that isn't conventionally available in NetSuite.

Acme Brick

Acme Brick turned to MindStream Analytics for help implementing OneStream to replace their outdated TM1 solution.


Alterra sought the expertise of MindStream to address the challenges they faced in their Capital Planning process.

ATCO Group

Energy conglomerate ATCO operates worldwide in utilities, power generation, and related services.


Working with MindStream Analytics, Avalon Healthcare Solutions adopts NetSuite Planning and Budgeting to accelerate budgeting and forecasting processes.

Bayer Health Care

Bayer Healthcare implemented Hyperion Planning and Workforce Planning in 10 weeks to dramatically streamline their Income Statement budget and Workforce Planning process..


MindStream Analytics' partnership with BluEarth Renewables epitomizes the power of technology and collaboration.


An Oracle Hyperion Planning Upgrade provides multi-national organization Hyperion Application optimization and stabilization.

Cleaver Brooks

OneStream XF was chosen as the platform that would transform Cleaver-Brooks' Finance processes.


The collaboration between CoorsTek and MindStream resulted in significant improvements in CoorsTek's financial consolidation and reporting processes.

Elite Body Sculpture

MindStream Analytics' collaboration with Elite Body Sculpture encapsulates the transformative potential of targeted tech solutions in streamlining administrative processes.


Enlyte, a merger of Mitchell, Genex, and Coventry, faced challenges with disparate financial solutions and the need for combined reporting.


MindStream Analytics collaborated with Flanders to implement OneStream Consolidation and Reporting solution.

Foley Products

Foley Products was facing a significant challenge with its Excel-based actual management reporting system.

Harte Hanks

The collaboration between MindStream Analytics and Harte Hanks culminated in a highly customized, user-friendly NetSuite implementation.


Interface used a complex, manual, excel-based FP&A process for monthly review, and the summary data was loaded in OneStream.

Kymera International

Thanks to Mindstream Analytics' assistance, Kymera was able to load all of their data into OneStream and validate it successfully.

MacLean Fogg

MacLean-Fogg partnered with MindStream, a leading implementor specializing in modernizing and optimizing enterprise systems.


MindStream's expertise and experience were sought to conduct a vendor selection initiative focusing on MEPPI's F2023 planning process.


MindStream Analytics and OUAI's collaboration showcases the transformative power of strategic technological intervention.


By migrating to OneStream, Plaskolite has achieved a material reduction in consolidation time and overall Financial Close cycle, eliminated the hours spent compiling and verifying data in Excel, streamlined its Planning, Budgeting and Forecasting model and delivered flexible and timely reporting that enables more strategic analysis of their financial data.


Understanding the nuances of Redwire's challenges, MindStream Analytics devised a holistic approach to overcome them. The implementation of NetSuite was just the beginning.


Simon's existing corporate Hyperion Financial Management (HFM) production application was consolidating at a rate of seven hours, a performance issue causing great headache to corporate Accounting.

Source Code

The successful transition to OneStream revolutionized Source Code's financial reporting.


Subway collaborated with MindStream Analytics for the NetSuite Analytics Warehouse implementation.


MindStream Consulting and AppCare team members are proud be working side by side with UPenn university in accomplishing this implementation and along with continuing our AppCare services after go-live.


USG was an Oracle Hyperion customer realizing that it needed more specialized support for its various Oracle Hyperion applications.


Dividing a hyperion planning application, expanding the hyperion footprint to forecast on the business? Customer categories.

Versant Health

Versant Health engaged MindStream to help resolve the challenges they were experiencing with their consolidation, close, and financial reporting processes.

Virginia Spaceport Authority

The MindStream team implemented the Standard + Workforce NetSuite Planning & Budgeting.


MindStream Analytics determined that the best solution was to implement Oracle Essbase Cloud as part of the Oracle Analytics Cloud (OAC) platform-as-a-service


Innovative use of essbase to streamline and connect hyperion financial management for enhanced financial analysis.

XY Planning

MindStream Analytics, well-versed in addressing such challenges, presented a comprehensive Netsuite solution for XY Planning.

Related Links