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 update (19.2.2 or later)

Oracle Analytics Cloud

Latest update (5.3 or later)

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

Or, Oracle Database Classic Cloud Service on Oracle Cloud Infrastructure Classic.

Oracle Database Classic Cloud Service on Oracle Cloud Infrastructure
Cloud Subscription Traditional metered subscription or nonmetered subscription to Oracle Cloud Oracle Cloud account subscription to Oracle Analytics Cloud. Either:
  • Universal Credits
  • Fixed Oracle Analytics Cloud Subscription
Identity Management Traditional identity management through Oracle Cloud Infrastructure Classic Console (previously called My Services) Either:
  • Oracle Cloud Infrastructure Identity and Access Management (IAM) Identity DomainsFoot 1
  • Oracle Identity Cloud ServiceFoot 2

Footnote 1 If your Oracle Cloud account offers IAM Identity Domains.

Footnote 2 If your Oracle Cloud account doesn't offer IAM Identity Domains.

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 Classic Cloud Service) on Oracle Cloud Infrastructure Classic to Oracle Cloud Infrastructure. Migrate Databases Using the Migration Tools

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.

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

If you have a non-metered subscription, create the service with Oracle Analytics Cloud Subscription.

Create a Service with Oracle Analytics Cloud

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 the identity management system available in your Oracle 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.
Oracle Cloud Infrastructure Identity and Access Management Identity Domains
Integrate with external other identity providers

(Optional) Integrate with identity providers in your target environment. For example, Microsoft Active Directory and other identity providers that support the Security Assertion Markup Language (SAML) 2.0.

Oracle Cloud Infrastructure Identity and Access Management Identity Domains

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
Add the IP address of your service to allowlists If you registered the IP of your Oracle BI Cloud Service instance in any data source allowlists, you must perform this task again for the new Oracle Analytics Cloud instance on Oracle Cloud Infrastructure. Find the IP or Host Name of Your Oracle Analytics Cloud Instance

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

Import the snapshot to the target

Sign in to the target system and import the snapshot.

Import the Snapshot on the Target

Restore the snapshot content

Select the newly imported 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 semantic model connections, verify application role assignments, and more.

Restore the Snapshot on the Target

Edit semantic 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 Semantic Model Connections for Data Modeler
Edit semantic model connections

(Mandatory if you use BI Administration Tool to manage semantic model connections for Oracle BI Cloud Service and you migrated your data from Oracle Cloud Infrastructure Classic to Oracle Cloud Infrastructure)

Edit the semantic model .rpd file, add the new connection string, and then upload the updated semantic model to the target system.

Edit Connections in the .rpd File and Upload the Semantic 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 semantic 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 semantic models after you migrate to Oracle Cloud Infrastructure. Only required if you uploaded semantic model .rpd files built with the Oracle BI Enterprise Edition BI Administration Tool to Oracle BI Cloud Service.