2 Prepare to Migrate Oracle Analytics Cloud - Classic Instances
Before you migrate Oracle Analytics Cloud - Classic instances to Oracle Cloud Infrastructure plan and prepare for migration.
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. |
|
Migrate users and groups |
|
|
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 identity providers |
(Optional) Integrate with external 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 |
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 on Oracle Cloud Infrastructure (Gen 2). 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 on Oracle Cloud Infrastructure and that you can sign in. | Verify Your Service and Sign In |
Reconfigure connections to your data |
Update connection information on 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 address of your Oracle Analytics Cloud - Classic instances 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 |
About Downtime Requirements
The migration process doesn't affect the availability of your existing Oracle Analytics Cloud - Classic instance on Oracle Cloud Infrastructure Classic. Users can continue to sign in and use the service.
Note:
If you do allow users to access and make changes after you've taken the final snapshot for migration, you might need to take another snapshot and repeat the migration if you want to include any changes that they make.After a service instance is migrated successfully, you can reroute users to the new instance in Oracle Cloud Infrastructure.
Plan Your Service on Oracle Cloud Infrastructure
Take some time to plan your service on Oracle Cloud Infrastructure before you create it. Consider the size, shape, and location of your current deployment and decide what you want your Oracle Cloud Infrastructure to look like, before you start. If it helps, use a checklist similar to the one shown here.
Planning checklist - an example
Use a checklist similar to this one to help you decide.
Description of the illustration checklist.jpg
Which type of subscription do you need?
If you subscribe through Universal Credits, you create Oracle Analytics Cloud services on Oracle Cloud Infrastructure (Gen 2) . If you have a non-metered subscription, you use Oracle Analytics Cloud Subscription to create services on Oracle Cloud Infrastructure.
-
Oracle Analytics Cloud (Universal Credits): Oracle Cloud Infrastructure (Gen 2)
-
Oracle Analytics Cloud Subscription: Oracle Cloud Infrastructure (Gen 1)
Which feature set do you need?
Check which edition and feature set you used to create the service on Oracle Cloud Infrastructure Classic. In most cases, you use the same feature set to create your target deployment on Oracle Cloud Infrastructure.
- Data Visualization: Self-service data visualization, preparation and smart discovery (Professional Edition)
- Business Intelligence: Enterprise data modeling, reporting features, and data visualization (Enterprise Edition)
- Essbase: Collaborative data collection, scenarios and what-if analysis (Professional Edition or Essbase Edition)
Feature set options available on Oracle Cloud Infrastructure:
- Self-Service Analytics: Suitable if you want to offer only data visualization and migrate only data visualization artifacts (Professional Edition).
- Enterprise Analytics: Suitable if you want to offer data visualization, plus enterprise modeling and reporting features. Required if you want to migrate analyses, dashboards, pixel-perfect reports, and data visualizations (Enterprise Edition).
- Essbase Edition: Required if you want to migrate an Essbase instance. *This guide doesn’t describe how to migrate Oracle Analytics Cloud - Classic services deployed with Essbase.
Use this table to determine which feature set you need to migrate Oracle Analytics Cloud - Classic services deployed with data visualization and business intelligence:
Oracle Analytics Cloud - Classic | Oracle Analytics Cloud | Oracle Analytics Cloud Subscription | |
---|---|---|---|
Edition | Feature Set | Feature Set | Edition Required |
Professional Edition | Data Visualization | Self-Service Analytics | Professional Edition |
Enterprise Edition | Data Visualization | Self-Service Analytics | Professional Edition |
Business Intelligence | Enterprise Analytics | Enterprise Edition |
What sizing options are available to you?
When you create an Oracle Analytics Cloud service, you either specify the number of Oracle Compute Units (OCPUs) you want to deploy or the number of people you expect to use the service.
Size Options | Oracle Analytics Cloud (Universal Credits) | Oracle Analytics Cloud Subscription |
---|---|---|
Number of OCPUs |
Yes |
Yes |
Number of Users |
Yes |
Yes |
How many OCPUs do you think you’ll need?
Verify the current compute shape of your service on Oracle Cloud Infrastructure Classic. Consider whether or not the size of your current deployment meets your current requirements. For example, if your compute shape on Oracle Cloud Infrastructure Classic is OC6 (8 OCPUs and 60 GB memory) you might want your deployment on Oracle Cloud Infrastructure to have a similar number of OCPUs, more OCPUs, or less OCPUs. The decision is yours.
Oracle Cloud Infrastructure offers a range of compute sizes (OCPUs) to suit different scenarios. The larger the compute size, the greater the processing power. For more guidance, read the topic: How many OCPUs do you think you’ll need?
How many users will use the service?
Alternatively, you can specify how many people you expect to use the service. Verify how many people are using your service on Oracle Cloud Infrastructure Classic and consider whether or not this number of users is likely to increase.
For more guidance, read the Oracle Analytics Cloud on Oracle Cloud Infrastructure topic: How many people do you expect to use the service?
Where do you want to deploy your service?
Verify the region where you deployed your current service on Oracle Cloud Infrastructure Classic.
Oracle Cloud Infrastructure is hosted in similar geographic areas, also called regions. If multiple regions are available to you, decide where you want to deploy your service. For example, Phoenix, Ashburn, Frankfurt, London. To find out which regions are available, see www.oracle.com/cloud/data-regions.html.
What name do you want for your service?
Think about a suitable name for your service. The name that you specify is displayed in Oracle Cloud Infrastructure Console and in the URL for your service. If you want, you can use the same name as your current service on Oracle Cloud Infrastructure Classic.
Name restrictions on Oracle Cloud Infrastructure:
-
Must contain between 1 and 25 characters.
-
Must start with an ASCII letter: a to z or A to Z.
-
Must contain only ASCII letters or numbers.
-
Mustn't contain any other special characters.
-
Must be unique within the identity domain.
Migrate Users and Roles from Oracle Analytics Cloud - Classic
Before you migrate to Oracle Cloud Infrastructure, you must migrate your users and groups from Oracle Cloud Infrastructure Classic. The way you migrate depends on whether you're using Oracle Identity Cloud Service or an embedded WebLogic LDAP server. If you subscribe to Oracle Analytics Cloud - Classic through Universal Credits, you manage users in Oracle Identity Cloud Service. If you subscribe to Oracle Analytics Cloud - Classic through a traditional metered or unmetered subscription, you might be using an embedded WebLogic LDAP server.
Migrate Users and Groups from Oracle Identity Cloud Service
Use export and import features in your identity management system to migrate users and groups from an identity domain on Oracle Cloud Infrastructure Classic to another identity domain on Oracle Cloud Infrastructure.
-
Oracle Cloud Infrastructure Identity and Access Management (IAM) Identity Domains
-
To migrate users, see Export Users from IDCS in Administering Oracle Identity Cloud Service and Import Users to IAM Identity Domains in Oracle Cloud Infrastructure documentation.
-
To migrate user groups, see Export Groups from IDCS in Administering Oracle Identity Cloud Service and Import Groups to IAM Identity Domains in Oracle Cloud Infrastructure documentation.
-
-
Oracle Identity Cloud Service
-
To migrate users, see Export Users from IDCS and Import Users to IDCS in Administering Oracle Identity Cloud Service.
-
To migrate user groups, see Export Groups from IDCS and Import Groups to IDCS in Administering Oracle Identity Cloud Service.
-
Migrate Users and Groups from Embedded WebLogic LDAP Server
If you subscribe to Oracle Analytics Cloud - Classic through a traditional metered or unmetered subscription you might be using an embedded WebLogic LDAP server for identity management. The way you migrate users and groups to Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2) depends whether your target environment offers Oracle Cloud Infrastructure Identity and Access Management (IAM) identity domains or Oracle Identity Cloud Service (IDCS).
If your service uses an embedded WebLogic LDAP server, use the
wls_ldap_csv_exporter
script to export users and groups to CSV
files so you can migrate to Oracle Cloud
Infrastructure (Gen 2). Prepare both CSV files so they contain all the information required and
then import them on the target environment.
Create Your Service on Oracle Cloud Infrastructure
As Cloud Account Administrator, you can create services 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.
Topics
-
Create a Service with Oracle Analytics Cloud
Oracle recommends that you deploy new services on Oracle Cloud Infrastructure Gen 2. If you don't have access yet, see When and how do I access the new administration console for Oracle Cloud Infrastructure (Gen 2)?
Create a Service using the Console
You can use Oracle Cloud Infrastructure Console to set up a service instance with Oracle Analytics Cloud.
You must belong to an OCI group that is granted the required policies to create an Analytics instance. See Give Users Permissions to Manage Analytics Cloud Instances.
Create a Service with Oracle Analytics Cloud Subscription
You use Oracle Cloud Infrastructure Console to set up a service with Oracle Analytics Cloud Subscription. Follow these steps if you have a non-metered subscription.
Description of the illustration activity-page_sub.jpg
Verify Your Service and Sign In
Oracle sends an email to the designated email address when your Oracle Analytics Cloud service is ready. Navigate to your service in Oracle Cloud Infrastructure Console, obtain the service URL, and then sign in to verify your Oracle Analytics Cloud service is up and running.
Connect to Your Data
The way you connect your Oracle Analytics Cloud deployment on Oracle Cloud Infrastructure to your data is similar to your existing service on Oracle Cloud Infrastructure Classic. The steps you need to follow depend where your data is stored.
If you're currently using Oracle Analytics Cloud - Classic to analyze data in an Oracle Database on Oracle Cloud Infrastructure Classic, you must first move your data to Oracle Cloud Infrastructure before you migrate your Oracle Analytics Cloud - Classic instance.
Where is Your Data Stored? | Description | More Information |
---|---|---|
On-premises database | You can keep your data in on-premises databases such
as Oracle Database, Oracle Essbase, MS SQL Server, Teradata, and IBM
DB2.
Use Data Gateway to access your on-premises data from the new Oracle Analytics Cloud instance on Oracle Cloud Infrastructure. If your remote on-premises data source is Oracle Essbase, you must continue to use the legacy Remote Data Connector. |
Connect to Data on On-premises Databases |
Oracle Database on Oracle Cloud Infrastructure Classic |
First, migrate your data to a database on Oracle Cloud Infrastructure. Reconfigure the database connection to point to the new database before you migrate your Oracle Analytics Cloud Classic instance. There are two ways to do this:
|
Move Data from Oracle Cloud Infrastructure - Classic |
Oracle Database on Oracle Cloud Infrastructure | You can keep your data in the same database.
You must reconfigure the database connection on the new Oracle Analytics Cloud instance on Oracle Cloud Infrastructure. |
Connect to Data on Oracle Cloud Infrastructure |
Other cloud databases | You can keep your data in the same database.
You must reconfigure the database connection on the new Oracle Analytics Cloud instance on Oracle Cloud Infrastructure. |
Connect to Data on Other Cloud Databases |
Connect to Data on On-premises Databases
You can keep data in your on-premises database. If you haven’t done so already you need to install Data Gateway on the network where you host the data and set up a connection to the target Oracle Analytics Cloud instance on Oracle Cloud Infrastructure.
Note:
If your remote on-premises data source is Oracle Essbase, you must continue to use Remote Data Connector.Connect to Data on Oracle Cloud Infrastructure
If your new Oracle Analytics Cloud instance on Oracle Cloud Infrastructure connects to a database on Oracle Cloud Infrastructure, you must add the IP address of the new Oracle Analytics Cloud instance to the database's allowlist.
Add IP Address Details for Oracle Analytics Cloud to Allowlists
If you added the IP or endpoint of your Oracle Analytics Cloud - Classic instance on Oracle Cloud Infrastructure Classic to one or more allowlists, you must perform this task again for the Oracle Analytics Cloud instance on Oracle Cloud Infrastructure.