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 Requirements
| 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 on Oracle Cloud InfrastructureFoot 1 |
| Cloud Subscription | Traditional metered subscription or nonmetered subscription to Oracle Cloud | Oracle Cloud subscription for Oracle
Analytics Cloud. Either:
|
| Identity Management | Traditional identity management through Oracle Cloud Infrastructure Classic Console (previously called My Services) | Either: |
Footnote 1 See "Not covered in this Guide".
Footnote 2 If your Oracle Cloud account offers IAM Identity Domains.
Footnote 3 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 |
Oracle Analytics Cloud doesn't include an Oracle Database. You must migrate your Oracle Database Cloud Schema Service (or Oracle Database Classic Cloud Service) on Oracle Cloud Infrastructure Classic to a suitable Oracle Database on 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. | |
| 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
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. |
|
| 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. | |
| 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
Oracle Identity Cloud
Service
|
| 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. | |
| 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. |
|
|
Import the snapshot to the target |
Sign in to the target system and import the snapshot. |
|
|
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. |
|
| 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. |
|
| 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 semantic model content and catalog content. | |
| Verify and configure service settings | Verify various administrative settings on the target service. | |
| Activate deliveries |
Enable deliveries to start delivering content from the target service. |
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.
- Oracle Analytics Client Tools: 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.