© 2015-2024. MindStreamAnalytics.com


Migrating from OBIEE to OAC: Easier Than Ever!

When Oracle Analytics Cloud (OAC) was released in March of 2017, Oracle made a de facto proclamation that this suite of tools would be the heir apparent to the more than a decade old Oracle Business Intelligence Enterprise Edition (OBIEE) . As has been the case with practically all of Oracle's new cloud-based applications, the users of the on-premise community were then left to attempt to figure out how to make the cloud offering work within their individual environments. It was clear that OAC looked fantastic as a tool, but it was less clear how a real-world use case would pan out.

Now that we are past the first anniversary of OAC's public availability, so much has been made clearer that it makes sense to review the relevant pieces of information regarding migrating an existing OBIEE implementation to the cloud.

What Tools are Included in OAC?

Migrating OBIEE to OAC requires you to subscribe to either the Enterprise or Data Lake Editions of OAC. OAC's BICS component is not available to the Standard edition.

Either the Enterprise or Data Lake Edition will also provide you with Data Visualization, the Enterprise version of Essbase in the Cloud, and Day by Day (Oracle's very nifty mobile app).

Maybe more importantly to OBIEE on-premise users, the OAC edition of BICS now includes a cloud version of BI Publisher that is in full parity with the on-premise application. This update was released in December of 2017 and provides a tool with robust operational and narrative reporting capabilities. Sometime in the first quarter of 2018, OAC's BICS component also received BI Delivers capability.

Since OAC's initial release, BI Delivers was one of the most commonly requested features and its absence was often cited by on-premise clients as to why they didn't want to migrate to the cloud just yet. With BI Delivers, along with BI Publisher, OAC's BI component now has the major pieces an enterprise suite of tools would need to complete a migration without feeling a significant regression in capability.

Do I have to move all my data to the cloud?

Some clients I have worked with have had the mistaken notion that to take full advantage of OAC, they would need to not only migrate their BI Tools from OBIEE to OAC but also move their on-premise data warehouses and data marts to Oracle's Cloud Databases . While you can take on that migration if Oracle's cloud DB offering is appealing to you, you also definitely are NOT required to do so.

Oracle supports using a VPN as a Service to connect OAC to your on-premise environments in a secure manner. This means your data can live in its current home and the processes by which it is maintained and updated can remain in place. This gives you flexibility in a migration plan to move the toolset to the cloud and determine the next steps in your road map. Some organizations may benefit from leaving the data on-premise perpetually, while others may choose to move individual data sets one at a time over the course of a few years.

How long does a migration take?

The honest answer, as always, is "it depends."

If you aren't migrating your data and processes to the cloud, the process of migrating a web catalog, RPD file, and security roles is straight forward. Planning the cloud architecture in terms of the size of your environments and what technologies you will leverage (including what methods of authentication and VPN options, if necessary) will take considerable effort and care to nail down. The actual act of exporting objects from OBIEE and importing them to OAC can likely be done in a few days in most cases, or even in a few hours. But that's time that will be sandwiched between extensive planning and configuring environments and regression testing your dashboards and analyses in the cloud.

How do I migrate?

OBIEE 12c introduced the concept of taking snapshots of an environment and producing a "BAR" file. This could be used to migrate between 12c environments or even as a method to backup and restore. The OAC migration leverages this process and functionality so that you can use your 12c environment to generate a BAR file with all your environment's content. Then you will place that new file on the OAC server and run a script to import it into the OAC environment. This means you will need the tools and access to SSH into the OAC server and understand rudimentary Linux commands to navigate the file structure and start the scripts.

If you migrated from OBIEE 11g to 12c at any point, you will be familiar with the process to migrate from OBIEE 11g to OAC. OAC's administration page provides a link to download a .jar file that you can use to generate an export from the OBIEE 11g server. Thus, you take the file downloaded from OAC, place it on the OBIEE 11g server, and use java to run the process that creates the export file. From here, the process is the same as migrating from 12c: you take the file with all the BI content, place it on the OAC server, and import it using the import scripts provided.

You can read more detailed steps on this migration here.

Follow up steps

Once your content is imported, you will restart your service and then your dashboards, reports, and RPD file will all be available. You will then need to validate/modify your data connections to point to your data sources. This likely means creating ODBC connections on the OAC server, or potentially pointing your connection pools to new sources if your source data has also moved.

Next, of course, is to regression test and validate the content moved correctly, retains any security settings, and the data ties out to the on-premise environments.

While the above is clearly simplified to a degree, the important thing to note is that the actual export/import process is quick and straightforward, it is imperative to allow ample time to plan your infrastructure (including any VPN or other network considerations) and for your final rounds of regression testing. With that in mind, OAC is now at a place where the application's capabilities are nearly in parity with OBIEE and enterprises can begin exploring migrating to it as the next step in upgrading BI programs. Not only will you get the latest and greatest features and functionality from Oracle for BI, but you'll also be able to take advantage of the additional tools in the suite like Data Visualization and the new Essbase Cloud Service .

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 their 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