Recent Posts


Considerations for Migrating On-Premise Oracle BI Enterprise Edition (OBIEE) to Oracle BI Cloud Service (BICS)
Posted on July 13, 2016
Author: John McGale, Performance Architects

As of the date when this was written, the only items that can be migrated from Oracle Business Intelligence Enterprise Edition (OBIEE) on-premise to Oracle Business Intelligence Cloud Service (BICS) are the OBIEE RPD and the underlying relational data.  This is a one-way move because the RPD cannot be moved back to on-premise OBIEE from BICS.  Reports created against the on-premise RPD cannot be migrated to the BICS environment, and will instead need to be recreated in BICS.  There are plans to add this functionality in the future (hopefully very soon).

The OBIEE to BICS RPD migration summary process

Once an RPD is published to BICS, the BICS Data Modeler tool cannot be used.  The RPD is essentially a ‘read only’ model in BICS.  If model changes are required, these should be made with the local copy of the RPD in the OBIEE BI Administration tool, and then uploaded again in the BICS “Service Console.” This assumes you have a more sophisticated enterprise development shop in-house maintaining an on-premise RPD for an OBIEE instance.

We recommend that you create a snapshot of your BICS system before attempting this migration.  If it is necessary to revert to using the BICS Data Modeler tool, restore a snapshot of the system that you created previous to the on-premise RPD migration.

If you are required to house data in multiple schemas in BICS, you must additionally subscribe to a full Database as a Service (DBaaS) instance of the Oracle database. In future releases of BICS it should be possible to use the DB Schema Service that comes with BICS, but this is not currently supported. You will need to use Version or later of the OBIEE BI Administration tool on-premise to create the RPD. The RPD must pass the consistency check within the BI Administration tool.

Another consideration is the need for continuous data refresh from an on-premise environment.  Loading on-premise relational sources and files to the cloud can now be achieved with a brand-new tool called Oracle BICS Data Sync.  Oracle BICS Data Sync is a separate tool that you download and install locally.

The Data Synch Utility (on-premise tool)

This is a wizard-driven utility that enables you to upload on-premise relational sources or CSV files to Oracle Database Cloud and keep the data in synch by performing incremental data loads or rolling deletes.  You can perform “insert-only” or “append” strategies and merge data from multiple sources.  You can replace, append, and update data in tables by scheduling data loads and using the “Load Strategy” option in this utility.


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Leave a Reply

Your email address will not be published. Required fields are marked *