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 22.214.171.124 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.