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

The administrator first uses the Replace Data Model option in the Console to upload the data model to the cloud. To make changes to the data model, the metadata developer uses BI Administration Tool to update the local data model, and the administrator then uses Console to repeat the upload process.

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

    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.

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

When the data model 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.

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.