Migrate Oracle Analytics Cloud Using Snapshots

Download and upload features enable you to save snapshots to your local file system and upload them back to the cloud. Use these features to migrate between two different services, and between development, test, and production environments.

About Oracle Analytics Cloud Migration

It's easy to migrate content and settings from one Oracle Analytics Cloud environment to another using snapshots. You can migrate an entire environment or you can migrate specific types of content.

Valid Migration Paths

When you use a snapshot, it doesn’t matter whether Oracle Analytics Cloud is deployed on Oracle Cloud Infrastructure or Oracle Cloud Infrastructure Classic.

Source Environment (Version 105.1.x or later) Target Environment (Version 105.1.x or later)
Oracle Analytics Cloud Oracle Analytics Cloud
Oracle Analytics Cloud - Classic Oracle Analytics Cloud

Prerequisites for Migration

Before you migrate content using snapshots, verify your source and target environment:
  • Check the source and target environments are using Oracle Analytics Cloud 105.1.x or later. Snapshots taken from earlier versions don't capture the entire environment.

    The version of your service is displayed in My Services. If you're not sure, check with your administrator.

  • If you want to migrate file-based data, check the source and target environments are up and running, and configured with valid storage credentials.

    Storage access issues can prevent data file migration using snapshots. If this happens, you can use the Data Migration utility to download and then upload your data files separately.

Content, Configuration, and Other Items Not Migrated

You can't include some items and non-Oracle Analytics Cloud artifacts in a snapshot.

Content, Configuration, and Other Items Not Migrated More Information
Virus scanner configuration Record the virus scanner configuration in your source environment and use it to configure your virus scanner on the target. See Set Up a Virus Scanner.
Mail server configuration Record the SMTP mail server configuration in your source environment and use it to configure your mail server on the target. See Set Up an Email Server to Deliver Reports.
Other snapshots available in the source environment.

Download individual snapshots and then upload them to your target environment, as required. See Upload Snapshots.

Job history

Available in a future release.

Users (and groups)

Use export and import features in Oracle Identity Cloud Service to migrate users and roles from one identity domain to another. See Manage Oracle Identity Cloud Service Users and Manage Oracle Identity Cloud Service Groups.

Other Oracle Identity Cloud Service configuration Use Oracle Identity Cloud Service in your target environment to reconfigure any user (or group) application role assignments that you configured on the source, reconfigure single sign-on (SSO), and so on.
Network configuration Set up your network requirements in the target environment, as required.

Typical Workflow to Migrate Oracle Analytics Cloud

You use snapshots to migrate Oracle Analytics Cloud to another environment. Here's what you need to do.

Task Description More Information
Understand how to migrate using snapshots Understand what you can and can't migrate in snapshots and any prerequisites.

About Oracle Analytics Cloud Migration

Take a snapshot on the source

Capture the content you want to migrate on the source system.

Take a Snapshot

Download the snapshot locally

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

Download Snapshots

Upload the snapshot to the target

Sign in to the target system and upload the snapshot.

Upload Snapshots

Restore the snapshot content

Select the newly uploaded snapshot in the list of saved snapshots and restore the content in the snapshot.

Restore from a Snapshot

Migrate data files

(Only if the restore process fails due to connection issues) Use the Data Migration utility to migrate and restore data files from another environment.

Migrate File-based Data

Reconfigure your virus scanner Record the virus scanner configuration in your source environment and use it to configure your virus scanner on the target.

Set Up a Virus Scanner

Reconfigure your mail server

Record the SMTP mail server configuration in your source environment and use it to configure your mail server on the target.

Set Up an Email Server to Deliver Reports

(Optional) Migrate other snapshots Download individual snapshots that you want to migrate and then upload them to your target environment, as required.

Download Snapshots

Upload Snapshots

Migrate users and groups Use export and import features in Oracle Identity Cloud Service to migrate users and roles from one identity domain to another. Manage Oracle Identity Cloud Service Users
Migrate other Oracle Identity Cloud Service configuration Use Oracle Identity Cloud Service in your target environment to reconfigure any user (or group) application role assignments that you configured on the source, reconfigure single sign-on (SSO), and so on.  

Migrate File-based Data

Users can upload data files, such as spreadsheets, to Oracle Analytics Cloud to create data sets. When you migrate to a new Oracle Analytics Cloud environment, you can take all the data files with the rest of your content, by including them in the snapshot with the rest of your other content. Sometimes when you restore the snapshot, data files aren't restored due to network connectivity or storage access issues. For such cases, Oracle Analytics Cloud offers a Data Migration utility that enables you to move your data files to the new location. Any map-related plug-ins and extension files for data visualization that users uploaded are moved too.

Only run the Data Migration utility if you see the message Restore succeeded with errors - data restore failed or similar when you try to restore a snapshot that contains data files.

The Data Migration utility allows you to move data files directly from one environment to another in a single step. Or if you prefer, you can download your file-based data to a ZIP file and then upload the data files to your chosen environment in two separate steps.

  1. Check some environment details.
    • Check your local environment. You need Java 1.8 or later to run the migration utility.

    • Verify that the source and target Oracle Analytics Cloud both use the latest version of Oracle Analytics Cloud (105.1.x or later). The Data Migration utility isn't available in earlier versions.

      The version of your service is displayed in My Services. If you're not sure, check with your administrator.

    • Check you can access Oracle Analytics Cloud (both source and target) from the local environment where you plan to run this utility.
    • Check that the target Oracle Analytics Cloud environment has access to the source environment where the data files are stored.
  2. Download the Data Migration utility.
    1. In Oracle Analytics Cloud, click Console, Service Administration, and then click Manage Snapshots.
    2. Click the Page menu Page menu , select Migrate, then Download Data Migration Utility. Follow the instructions to save the migrate-oac-data.zip file locally.
  3. Unzip migrate-oac-data.zip.
    • migrate-oac-data.jar
    • config.properties
    • readme
  4. If you want to migrate data files stored in your source environment directly to the target in a single step, configure the section [MigrateData] in config.properties.
    [MigrateData]
    #MigrateData : Migrate Oracle Analytics Cloud (OAC) data files to different target environment
        # Source OAC URL
          SOURCE_OAC_URL=http://<Source Oracle Analytics Cloud Hostname>:<Source Port>
        # Source OAC Username
          SOURCE_OAC_USERNAME=<Source Oracle Analytics Cloud Username>
        # Source OAC Bar Path, created with 'includedata' option
          BAR_PATH=<Source OAC BAR Path>
        # Target OAC URL
          TARGET_OAC_URL=http://<Target Oracle Analytics Cloud Hostname>:<Target Port>
        # Target OAC Username
          TARGET_OAC_USERNAME=<Source Oracle Analytics Cloud Username>
  5. If you want to download data from your source Oracle Analytics Cloud to your local environment and subsequently upload the data to the target Oracle Analytics Cloud environment, configure sections [DownloadDataFragments] and [UploadDataFragments] in config.properties.
    [DownloadDataFiles]
    #Download Data Files: Download data files from Oracle Analytics Cloud storage to a local repository
        # Source OAC URL
          SOURCE_OAC_URL=http://<Source Oracle Analytics Cloud Hostname>:<Source Port>
        # Source OAC Username
          SOURCE_OAC_USERNAME=<Source Oracle Analytics Cloud Username>
        # Source OAC Bar Path, created with 'includedata' option
          BAR_PATH=<Source OAC BAR Path>
        # Data fragment directory. Make sure you have enough space to download data files 
          DATA_FRAGMENTS_DIRECTORY=<Data Fragments Directory>
         # Data Fragment Size. Default is 500MB
          MAX_DATA_FRAGMENT_SIZE_IN_MB=500
    [UploadDataFragments]
    #Upload Data Files: Upload data files to Oracle Analytics Cloud 
        # Target OAC URL
          TARGET_OAC_URL=http://<Target Oracle Analytics Cloud Hostname>:<Target Port>
        # Target OAC Username
          TARGET_OAC_USERNAME=<Source Oracle Analytics Cloud Username>
        # Data fragment directory. 
          DATA_FRAGMENTS_DIRECTORY=<Data Fragments Directory>
         # Data Fragment Size. Default is 500MB
          MAX_DATA_FRAGMENT_SIZE_IN_MB=500
  6. Run the migrate-oac-data.jar file in your local environment.

    Usage:

    migrate-oac-data.jar [-config configfile] [-d] [-help] [-m]  [-u]

    Where:

    • -config configfile : Name of the config.properties file

    • -d : Downloads data locally using information in config.properties

    • -help : Prints help

    • -m : Migrates data using source and target information in the config.properties file

    • -u : Uploads data using information in the config.properties file

    For example, to migrate data files in a single step:

    java -jar migrate-oac-data.jar -m -config config.properties

    For example, to download data files locally:

    java -jar migrate-oac-data.jar -d -config config.properties

    For example, to upload data files:

    java -jar migrate-oac-data.jar -u -config config.properties
  7. Sign in to your target Oracle Analytics Cloud.
  8. To expose the data files you must restore the same snapshot that failed earlier.
    1. Open the Console, click Service Administration, and then Manage Snapshots.
    2. Select the snapshot containing your data files.
    3. Select the Custom restore option, and then select the option File-based data.
    4. Click Restore.
  9. Verify that your data files are available.