Uploading Data Models from Oracle BI Enterprise Edition 12c

Administrators can upload data models built with Oracle BI Enterprise Edition to Oracle BI Cloud Service. After uploading a data model file (.rpd) to the cloud, content authors can then build data visualizations, dashboards and analyses in the usual way.

Note:

Administrators can use snapshots to migrate content, as well as data models from Oracle BI Enterprise Edition. See Migrating Snapshot Data.

About Uploading Oracle BI Enterprise Edition Data Models to the Cloud

If you’ve modeled your business data with Oracle BI Enterprise Edition, then you don't need to start from scratch in Oracle BI Cloud Service. Simply upload your data model file (.rpd) to Oracle BI Cloud Service and start exploring your data through visualizations, analyses, and dashboards.

Oracle BI Cloud Service lets you upload a data model file (.rpd) with:

  • One or more data models

  • Connections to one or more instances of Oracle Database Cloud Service

You’ll need to validate your data model file and configure database connection details in Oracle BI Enterprise Edition.

Description of data_mod59-gif.gif follows
Description of the illustration data_mod59-gif.gif

Note:

Copy reports and dashboards built in Oracle BI Enterprise Edition to Oracle BI Cloud Service too.

See Uploading Content from a Catalog Archive in Using Oracle Business Intelligence Cloud Service

Getting Your Data Model File Ready for the Cloud

Take some time to ready your data model file (.rpd) for the cloud:

  • Verify that you’re using Oracle BI Enterprise Edition 11.1.1.6 or later
  • Validate the data model file

    Run consistency checks using Consistency Check Manager in Oracle BI Administration Tool.

  • Verify that the data model file includes connection details to an Oracle Cloud database instance

    Review connection pool settings from Oracle BI Administration Tool:

    • Data source name must point to the Oracle Database Cloud Service where the data is stored.
    • Call interface must be Oracle Call Interface (OCI).

    If your data model file connects to multiple Oracle Database Cloud Service instances, check connection pool settings one-by-one.

When the data model file (.rpd) is ready, you can upload it to Oracle BI Cloud Service. Before doing so, back up your current data model in case you need to restore this version. See Uploading Data Models from a File (.rpd) Using Console.

During the upload, existing data model information in Oracle BI Cloud Service is deleted and replaced with content from the uploaded file. Data models uploaded from the file become available to content authors through the Subject Areas pane.

Editing Data Models Uploaded to the Cloud

You can’t edit data models created with Oracle BI Enterprise Edition through Oracle BI Cloud Service. Data Modeler is disabled when you upload data models to Oracle BI Cloud Service from a .rpd file.

If you want to improve or update the model, make your updates in Oracle BI Administration Tool, re-run consistency checks, and upload the data model file again. Each time that you upload a data model, you delete and replace the existing model with the newly uploaded content.

Tip:

Model changes, such as deleting columns from the model, can affect existing content. Take time to check existing analyses and dashboards after uploading model updates.

Getting Your Data Model File Ready

Take some time to ready your data model file (.rpd) for the cloud.

  1. Verify that you’re using Oracle BI Enterprise Edition 11.1.1.6 or later.
  2. Validate the data model file (.rpd).
    Run consistency checks using Consistency Check Manager in Oracle BI Administration Tool.
  3. Verify that the data model file includes connection details to Oracle Database Cloud Service.

    Review connection pool settings from Oracle BI Administration Tool:

    • Data source name must point to the Oracle Database Cloud Service where the data is stored.
    • Call interface must be Oracle Call Interface (OCI).

    If your data model file connects to multiple Oracle Database Cloud Service instances, check connection pool settings one-by-one.

  4. Disable subject areas that you don't want to expose or any subject areas that don't have a working connection.

    If connection information is missing, users see the message Fetch subject areas failed error when they view subject areas in Data Visualization.

  5. Back up your cloud service, including the current data model, in case you need to restore this version.

When the data model is ready, you can upload it to Oracle BI Cloud Service.

Uploading Data Models from a File (.rpd) Using Console

Administrators can upload data models built with Oracle BI Enterprise Edition to Oracle BI Cloud Service. After migrating data models to the cloud, content authors can visualize data in the usual way.

When you upload data models from Oracle BI Enterprise Edition, you delete existing data model information in Oracle BI Cloud Service and replace it with content in the data model file (.rpd). The data models you upload become available to content authors through the Subject Areas pane.

  1. Verify the data model file (.rpd) and database connections.
  2. In Oracle BI Cloud Service, click Console.
  3. Select Snapshots.
  4. Take a snapshot of the current data model in case you need to restore this version.
  5. Click Replace Data Model.
  6. Click Browse and select the data model file (.rpd) that you want to upload.
  7. Enter the password for the file.
  8. Click OK.
  9. Go to the Home page, click Data Sources then Subject Areas to see the data models that you uploaded, available as subject areas in Oracle BI Cloud Service.
  10. Optionally, if the data model file that you uploaded defines permissions and data filters, create matching application roles in Oracle BI Cloud Service for the data security to work in the cloud.
    1. Create application roles with exactly the same names as those defined in Oracle BI Administration Tool.
    2. Assign users (and user roles) to the application roles as required.

Editing Data Models Uploaded to the Cloud

Metadata developers make updates to local data model files (.rpd) using BI Administration Tool.

You can’t use Data Modeler in Oracle BI Cloud Service to edit data models originally created with Oracle BI Enterprise Edition. Data Modeler is disabled when you upload data models from a file.

If you want to improve or update the model, make your updates in Oracle BI Administration Tool, re-run consistency checks, and upload the data model file again. Each time that you upload a data model, you delete and replace the existing model with the newly uploaded content.

Tip:

Model changes, such as deleting columns from the model, can affect existing content. Take time to check existing analyses and dashboards after uploading model updates.