About the Migration Task Flow

You use migration tools to migrate content from Oracle Business Intelligence Enterprise Edition to Oracle Analytics Cloud. Before you start the migration, you need to prepare and set up a target Oracle Analytics Cloud instance on Oracle Cloud Infrastructure (Gen 2). Here's what you need to do.

Prepare to Migrate

Task Description More Information
Understand differences between your source and target environments

Compare the features in Oracle BI Enterprise Edition and Oracle Analytics Cloud, and understand any differences.

Feature Availability and Comparison
Plan your new service Plan your Oracle Analytics Cloud deployment on Oracle Cloud Infrastructure (Gen 2). 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 Universal Credits subscription to deploy Oracle Analytics Cloud services on Oracle Cloud Infrastructure (Gen 2).

As Cloud Account Administrator, you can complete all setup tasks.

Signing in for the First Time

Create a service on Oracle Cloud Infrastructure (Gen 2) Create an Oracle Analytics Cloud instance with the required size on Oracle Cloud Infrastructure (Gen 2).

Create a Service with Oracle Analytics Cloud

Verify your service Verify that your service is up and running on Oracle Cloud Infrastructure and that you can sign in. Verify Your Service and Sign In
Migrate users and groups

Migrate users and groups to Oracle Cloud Infrastructure.

Migrate Users and Groups from Oracle BI Enterprise Edition
Reconfigure connections to your data

Update connection information on the target Oracle Analytics Cloud instance.

Recommended: Move data from your on-premise database to Oracle Cloud Infrastructure.

Connect to Your Data
Include the IP of your service in data source allowlists If you added the IP of your Oracle BI Enterprise Edition environment in any allowlists, you must perform this task again for the Oracle Analytics Cloud instance on Oracle Cloud Infrastructure. Include the IP Address for Oracle Analytics Cloud in Allowlists
Move custom files and update fmap function references If you referenced local files (such as images and help files) using the fmap function you must move them to a location that Oracle Analytics Cloud can access and update your fmap references to point to the new location. Move Custom Files and Update fmap Function References

Migrate Your Service

Task Description More Information
Check your target is ready for migration and take a backup Verify that the required users and groups are available in your target service and take a snapshot in case you need to roll back. Back Up Your Target Service Before Migration

Export content from the source

Delete any old content in Oracle BI Enterprise Edition that you don't need anymore and then capture the content you want to migrate to Oracle Analytics Cloud.

Export Content from Oracle BI EE 11g

Export Content from Oracle BI EE 12c

Edit database connections and clean up your semantic model .rpd file

Update connection strings in your semantic model .rpd file and remove the content you don't want to migrate.

Clean Up and Reconfigure Your Semantic Model .rpd File

Import content on the target

Sign in to the target system and import the content.

Import Content from Oracle BI EE 11g

Import Content from Oracle BI EE 12c

Reconfigure service settings Verify various administrative settings on the target service.

Configure Service Settings

Activate deliveries

Disable deliveries in Oracle BI Enterprise Edition and 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 Analytics Cloud and everything works as you expect. Test Your Service