Quick reference to Oracle Utilities Analytics (OUA) 2.7.0.1. Customers to upgrade from Oracle Business Intelligence Enterprise 12c to Oracle Analytics Server on Linux
(Doc ID 2677251.1)
Last updated on MAY 01, 2023
Applies to:
Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.1.0 and laterLinux x86-64
Details
**Disclaimer:** This KM article may include the following abbreviations:
OUA - Oracle Utilities Analytics
OBIEE - Oracle Business Intelligence Enterprise Edition
OAS - Oracle Analytics Server
Applies To
Oracle Utilities Analytics (OUA) 2.7.0.1 customers.
Purpose
This document describes, with reference to the Oracle Analytics Server (OAS) documentation, the steps to upgrade the OBIEE 12.2.1.4 technology, used with OUA 2.7.0.1, to OAS 5.5.0
Prerequisites
Upgrading from Oracle Business Intelligence to Oracle Analytics Server 5.5.0 requires careful preparation, planning, and testing. Please read the Migrating and Upgrading to Oracle Analytics Server document, in its entirety, before starting the exercise.
Upgrade Paths
OUA 2.7.0.1 customers have perform their OBIEE 12.2.1.4 upgrade to OAS in-place or via a fresh install.
In place upgrade to OAS
This option involves upgrading the existing OBIEE installation in the OUA environment. This would retain all of their configuration settings and OBIEE artifacts as-is.
Upgrade to OAS via fresh install
This option involves setting up the OAS installation separate from the existing OBIEE installation. This will come in handy if customers cannot afford downtimes in their existing OUA environment. This option would require that the configuration settings, from the OBIEE environment to be redone in OAS. It also requires migrating BI metadata artifacts from OBIEE to OAS.
The steps for each upgrade path are described below.
Actions
In Place upgrade to OAS
- Follow the instructions on how to upgrade from OBIEE 12.2.1.4 to OAS on Linux as described in the OAS document Migrating and Upgrading to Oracle Analytics Server
- OUA utilizes the OBIEE Write Back template functionality to enable users to update some configurations and make some label related changes back to the database. The UI screens for these are available as part of the OUA Administration dashboards. Write Back template is an xml file which takes user inputs and writes it directly to the database using SQL commands. They are stored $DOMAIN_HOME/ bidata/service_instances/ssi/metadata/content/msgdb/l_en/customMessages in the directory. Identify the below Write Back template files in the older location $DOMAIN_HOME/ bidata/service_instances/ssi/metadata/content/msgdb/l_en/customMessages
- Base_Field_Update_Template.xml
- Configuration_Update_Template.xml
- Custom_Field_Delete_Template.xml
- Custom_Field_Insert_Template.xml
- Custom_Field_Update_Template.xml
- ETL_Job_Control_Update_Template.xml
- Map_Profile_Update_Template.xml
The location to store the Write Back template files in OAS is different from OBIEE. Therefore copy the template files to the OAS location at $DOMAIN_HOME/bi/bifoundation/web/msgdb /l_en/custommessages/. Restart the OAS services once the above write back templates are deployed.
Upgrade to OAS via fresh install
- Follow the instructions on Installing and Configuring Oracle Analytics Server
- After installing and configuring OAS, migrate the BI Application Archive (BAR File) from OBIEE to OAS. BAR files are the compressed archive file that contains a cohesive set of BI metadata artifacts (data model, content model, and authorization model). For more information on BAR files, refer BAR file. Follow the instructions to export and import BAR file in OAS.
- To complete the installation of the OUA dashboard components in OAS it is necessary to configure MapViewer and enabling Write Back. Follow the instructions in the OUA 2.7.0.1 Installation Guide, Chapter 4: Installing Oracle Utilities Analytics - Initial Installation, the section on Installing Oracle Utilities Analytics Dashboards Component :
a. Section Configuring and Deploying the MapViewer
b. Section Updating MapViewer Configuration
c. Section Enabling WriteBack
4. OUA utilizes the OBIEE Write Back template functionality to enable users to update some configurations and make some label related changes back to the database. The UI screens for these are available as part of the OUA Administration dashboards. Write Back template is an xml file which takes user inputs and writes it directly to the database using SQL commands. They are stored $DOMAIN_HOME/ bidata/service_instances/ssi/metadata/content/msgdb/l_en/customMessages in the directory. Identify the below Write Back template files in the older location $DOMAIN_HOME/ bidata/service_instances/ssi/metadata/content/msgdb/l_en/customMessages
- Base_Field_Update_Template.xml
- Configuration_Update_Template.xml
- Custom_Field_Delete_Template.xml
- Custom_Field_Insert_Template.xml
- Custom_Field_Update_Template.xml
- ETL_Job_Control_Update_Template.xml
- Map_Profile_Update_Template.xml
The location to store the write Back template files in OAS is different from OBIEE. Therefore copy the template files to the OAS location at $DOMAIN_HOME/bi/bifoundation/web/msgdb /l_en/custommessages/. Restart the OAS services once the above write back templates are deployed.
Contacts
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Details |
Applies To |
Purpose |
Prerequisites |
Upgrade Paths |
Actions |
In Place upgrade to OAS |
Upgrade to OAS via fresh install |
Contacts |