Authors: Swathi Singamareddygari , Anand Sadaiyan
Section 1: Lifting and Shifting Application Roles
Section 2: Lifting and Shifting the Repository
Section 3: Lifting and Shifting the Web Catalogue
Section 4: Repository ADF and Consistency Checks
This document does not replace the Oracle Business Intelligence Cloud Service Documentation Library or other Cloud Services documents. It serves as a supplement for lifting and shifting Business Intelligence Applications Artifacts (BIAPPS / OBIA) to BI Cloud Service (BICS).
This document is written based on the BI cloud version 17.2.5. Screenshots included in this document might differ slightly from what you see on your screen.
Note: This is a supplementary document for installing Oracle BI Applications on Paas with Oracle BI Cloud Service (Doc ID 2136376.1).
It is always a good practice to take a snapshot of the current environment in Oracle BI Cloud Service, before performing any lift and shift activities. Ensure that you create a snapshot before proceeding.
Oracle BI Applications has delivered a BAR (obia_bics_v0.9.bar) file with the out of the box BIAPPS application roles. Download the BAR file from My Oracle Support (Doc ID: 2136376.1) and upload the application roles to Oracle BI Cloud Service environment.
Uploading the Application Roles BAR File:
Administrators can upload the on premises repository to Oracle BI Cloud Service using the steps mentioned below. While setting up Oracle BI Applications setup on the PaaS environment, the repository is provisioned with the required connection details. Administrators can obtain the Oracle BI Applications provisioned repository from the Compute environment.
For example : /u01/app/oracle/middleware/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository .
You can’t import the provisioned repository directly into Oracle BI Cloud Service because the severity of the consistency check has been increased in Oracle BI Cloud Service when compared to Oracle BI EE 18.104.22.168. Hence you must fix the consistency check issues before uploading the Repository to Oracle BI Cloud Service environment.
Fixing ADF and Consistency Check Issues:
You must fix the ADF and consistency check issues with the repository in your local environment and then upload the ‘fixed’ repository to Oracle BI Cloud Service. For the ease of use, all the changes are documented in the Section 4: Repository ADF and Consistency Checks. It is a mandatory requirement to fix the consistency check issues.
Steps to be followed for lifting and shifting of repository
Administrators can upload web catalogue artifacts from another Oracle BI Cloud Service or Oracle BI Enterprise Edition 22.214.171.124.0 or later.
Lifting and shifting the web catalogue mainly involves these two activities:
Lifting of Presentation catalog in the Compute node
Shifting the Presentation Catalogue in Oracle BI Cloud Service Environment
8. Select Unarchive from the Tasks pane, browse to the archive file created for each functional area, and select "Preserve" for the ACL option.
For the ease of use, all the consistency check issues have been documented in the attached spreadsheet (BICS_Lift_And_Shift_17x.xls). Detailed steps have been provided for fixing consistency check issue for “SET ID-based Security”. Follow similar steps to fix the consistency check issues for the other application roles mentioned in the attached spreadsheet.
For fixing the ADF Issues, follow the technote attached in the ARU 20780126.
If you are using the trimmed Oracle BI Applications repository then all the issues mentioned here might not be applicable. Fix only the applicable issues.
Any modifications to the repository should be done in the Local environment and it is your responsibility to maintain the repository.
Detailed Steps for fixing SET ID-based Security Application Role: