Uploading Data Models from Oracle BI Enterprise Edition

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 build reports in the usual way.

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).

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.

Uploading Data Models from a File (.rpd)

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.