Learn about how to migrate from Oracle BI Cloud Service to Oracle Analytics Cloud on Oracle Cloud Infrastructure.
About the Migration Scope
Before migrating from Oracle BI Cloud Service to Oracle Analytics Cloud on Oracle Cloud Infrastructure, consider the scope and constraints of this migration path.
Migration scenarios covered in this Guide
|Migration Scenario||Source Oracle BI Cloud Service||Target Oracle Analytics Cloud|
|Cloud Service||Oracle BI Cloud
Latest version (19.2.2 or later)
Latest version (105.3 or later)
|Cloud Database||Oracle Database Cloud Schema
Service on Oracle Cloud Infrastructure
Or, Oracle Database Cloud Service on Oracle Cloud Infrastructure Classic.
|Oracle Database Cloud Service on Oracle Cloud Infrastructure|
|Cloud Subscription||Traditional metered subscription or nonmetered subscription to Oracle Cloud||Cloud account subscription to Oracle
Analytics Cloud - Enterprise Edition. Either:
|Identity Management||Traditional identity management through Oracle Cloud Infrastructure Classic Console (previously called My Services)||Oracle Identity Cloud Service|
If you're not sure which versions are running in your source and target environments, ask your Oracle representative.
Not covered in this Guide
|Migration scenario||Description||More Information|
|Database migration||You must migrate your Oracle Database Cloud Schema Service (or Oracle Database Cloud Service) on Oracle Cloud Infrastructure Classic to Oracle Cloud Infrastructure.||Select a Method to Migrate Database Instances|
About the Migration Task Flow
You use a snapshot to migrate an Oracle BI Cloud Service instance to Oracle Analytics Cloud on Oracle Cloud Infrastructure. Before you start the migration, you need to prepare and set up a target Oracle Analytics Cloud instance on Oracle Cloud Infrastructure. Here's what you need to do.
Prepare to Migrate
|Plan your new service||Plan your Oracle Analytics Cloud deployment on Oracle Cloud Infrastructure. Think about what you want before you start.|
|Complete your order and sign in to your Oracle Cloud account||
You must have a subscription for Oracle Analytics Cloud (or Oracle Analytics Cloud Subscription) to create services on Oracle Cloud Infrastructure.
As Cloud Account Administrator, you can complete all setup tasks.
|Create a service on Oracle Cloud Infrastructure||Create an Oracle
Analytics Cloud instance with the required size and shape on Oracle Cloud
If you subscribe through Universal Credits, create the service with Oracle Analytics Cloud. The way you create new services on Oracle Cloud Infrastructure depends on which data regions are accessible to you.
If you have a non-metered subscription, create the service with Oracle Analytics Cloud Subscription.
|Verify your service||Verify that your service is up and running and that you can sign in.||Verify Your Service and Sign In|
|Migrate users and roles||Migrate users and roles from your traditional Oracle BI Cloud Service account to Oracle Identity Cloud Service available with your Cloud account.|
|Reconfigure single sign-on||(Optional) If SAML Single Sign-on (SSO) is
configured in your source environment using
|Integrate Oracle Identity Cloud Service with other identity providers||
(Optional) Use Oracle Identity Cloud Service in your target environment to integrate with your identity provider. For example:
|Reconfigure connections to your data||
Update connection information for the target Oracle Analytics Cloud instance.
If your data is stored in a database on Oracle Cloud Infrastructure Classic you must move the data to Oracle Cloud Infrastructure.
|Connect to Your Data|
|Whitelist the IP of your service on your data sources||If you whitelisted the IP of your Oracle BI Cloud Service instance, you must perform this task again for the new Oracle Analytics Cloud instance on Oracle Cloud Infrastructure.||IP Ranges and Gateway IPs for Oracle Analytics Cloud Instances|
Migrate Your Service
|Understand snapshot options||Understand what you can include or exclude when you take a snapshot.|
|Check your target is ready for migration and take a backup||Verify that the required users and roles are available in your target service and take a snapshot in case you need to roll back.||Back Up Your Target Service Before Migration|
Take a snapshot of the source
Capture the content you want to migrate on the source system.
Download the snapshot locally
Download the snapshot that you want to migrate to your local file system.
Upload the snapshot to the target
Sign in to the target system and upload the snapshot.
Restore the snapshot content
Select the newly uploaded snapshot in the list of saved snapshots and restore the content in the snapshot.
After restoring the snapshot you must perform additional tasks to complete the migration. For example, you must edit your data model connections, verify application role assignments, and more.
|Edit data model connections for Data Modeler||(Mandatory if you use Data Modeler)
Review, edit, and save all your database connections to activate them in Oracle Analytics Cloud.
Reconfigure the Default Connection if you used this in Oracle BI Cloud Service.
|Edit Data Model Connections for Data Modeler|
|Edit data model connections in the RPD file||
(Mandatory if you use BI Administration Tool to manage data model connections for Oracle BI Cloud Service and you migrated your data from Oracle Cloud Infrastructure Classic to Oracle Cloud Infrastructure)
Edit the data model file (RPD), add the new connection string, and then upload the updated data model to the target system.
|Edit Connections in the RPD File and Upload the Data Model|
Migrate data files
Use the Data Migration utility to migrate and restore data files from another environment.
|Verify application role assignments||Verify that users and groups in your target service have the correct application roles in Oracle Analytics Cloud.|
|Reconfigure search crawl users||Change the name of the users configured to index data model content and catalog content.|
|Verify and configure service settings||Verify various administrative settings on the target service.|
Enable deliveries to start delivering content from the target service.
Complete Post-Migration Tasks
|Test the migrated service||Check the content you migrated is available on Oracle Cloud Infrastructure and everything works as you expect.||Test the Migrated Service Instance|
|Clean up services on Oracle Cloud Infrastructure Classic||Remove any resources that you don't need.||Clean Up Infrastructure and Platform Resources in Oracle BI Cloud Service|
About the Migration Tooling
You use a snapshot to migrate your Oracle BI Cloud Service instance to Oracle Analytics Cloud on Oracle Cloud Infrastructure. In certain situations, you might also use the Data Migration Utility or Developer Client Tool.
- Snapshots: Migrates your content, file-based data, application role assignments, and other settings from your Oracle BI Cloud Service instance to Oracle Cloud Infrastructure.
- Data Migration Utility: Migrates your file-based data to Oracle Cloud Infrastructure. Only required if network connectivity or storage access issues prevents data file migration with the snapshot.
- Developer Client Tool for Oracle Analytics Cloud: Enables you to modify connection information for your data models after you migrate to Oracle Cloud Infrastructure. Only required if you uploaded data model files built with the Oracle BI Enterprise Edition BI Administration Tool (.rpd) to Oracle BI Cloud Service.