1 Learn About Migrating to Oracle Cloud Infrastructure

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 Service

Latest version (19.2.2 or later)

Oracle Analytics Cloud

Latest version (105.3 or later)

Cloud Database Oracle Database Cloud Schema Service on Oracle Cloud Infrastructure Classic

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:
  • Universal Credits
  • Fixed Oracle Analytics Cloud Subscription
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

Task Description More Information
Plan your new service Plan your Oracle Analytics Cloud deployment on Oracle Cloud Infrastructure. Think about what you want before you start.

Plan Your Service on Oracle Cloud Infrastructure

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.

Sign In For the First Time

Create a service on Oracle Cloud Infrastructure Create an Oracle Analytics Cloud instance with the required size and shape on Oracle Cloud Infrastructure.

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.

Create a Service with Oracle Analytics Cloud (APAC and LAD)

Create a Service with Oracle Analytics Cloud (North America and Europe)

Create a 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.

Migrate Users and Roles from Oracle BI Cloud Service

Reconfigure single sign-on (Optional) If SAML Single Sign-on (SSO) is configured in your source environment using samlssodocker, set up SSO in your target environment between your identity provider and Oracle Identity Cloud Service.

Add an Identity Provider

Integrating Oracle Identity Cloud Service with Microsoft Active Directory Federation Services

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:
  • Reconcile Microsoft Active Directory with Oracle Identity Cloud Service

  • Configure Oracle Identity Manager and synchronize users with Oracle Identity Cloud Service

  • Configure Office 365 users with Oracle Identity Cloud Service

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

Task Description More Information
Understand snapshot options Understand what you can include or exclude when you take a snapshot.

Understand Snapshot Options

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.

Take a Snapshot on the Source

Download the snapshot locally

Download the snapshot that you want to migrate to your local file system.

Download the Snapshot

Upload the snapshot to the target

Sign in to the target system and upload the snapshot.

Upload the Snapshot on the Target

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.

Restore the Snapshot on the Target

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.

Migrate File-based Data

Verify application role assignments Verify that users and groups in your target service have the correct application roles in Oracle Analytics Cloud.

Verify and Configure Service Settings

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 and configure service settings Verify various administrative settings on the target service.

Verify and Configure Service Settings

Activate deliveries

Enable deliveries to start delivering content from the target service.

Restore and Enable Delivery Schedules

Complete Post-Migration Tasks

Task Description More Information
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.