Within an on-premise scenario, the OBIEE development life-cycle was quite simple:
- connect to a data warehouse and import the warehouse tables (metadata import to physical layer)
- build OBIEE metadata model (RPD)
- upload the RPD into Weblogic using the Deployment screen
Within a cloud scenario the BICS development life-cycle is quite the same, but requires some additional steps and some decisions on the development model: either using web-based BICS developer or upload of full RPD file developed using OBIEE Admin Tool.
While it’s possible to develop the complete metadata model within the cloud using the BICS web-based Modeller, like below:
the capabilities of this web-based Modeller are more limited. Due to this, there is no possibility to edit/change an uploaded RPD file within the web-based BICS modeller afterwards. The process to upload a locally developed (OBIEE) metadata model (.rpd file) to the BICS Cloud is called “lift&shift”.
The required setup for this OBIEE to BICS development life-cycle using lift & shift is described in below diagram:
For the BICS development life-cycle, the data of the Fusion Cloud e.g. HCM or ERP is assumed to be already present within a Oracle Database Cloud (DBaaS/DBCS). For the BI setup, all components (formally probably referred to as “server” components) are provisioned on the Oracle Public Cloud while the development tools still are installed on a developer machine (like a desktop/laptop).
The following integrations need to be setup:
|Integration point||Integration point||Description||documentation/links|
|BICS||DBaaS||Connect the BI Cloud (BICS) to the Database Cloud (DBaaS) to analyse the stored data e.g. extracted Fusion HCM data||How Does Oracle BI Cloud Service Integrate with Oracle Database Cloud Service?|
|(local) SQL Developer||DBaaS||Connect the local SQL Developer e.g. installed on a Computer or Laptop to the Database Cloud (DBaaS)||Accessing a Database Cloud Service instance using Oracle SQL Developer|
|(local) BI Admin Tool (RPD file)||BICS||upload the local developed .rpd file (using the OBIEE Admin Tool) into the BI Cloud (BICS)||Uploading Data Models from Oracle BI Enterprise Edition|
To create Backup as part of the development life-cycle refer to the following article:
To connect between DBaaS and the Fusion Application Cloud (SaaS):
The above scenario uses the Oracle Database Cloud for storing the data. If the Data is not stored in the Oracle Database Cloud, but the Oracle Schema Cloud Service which is bundled for-free with BICS then the data must be loaded into BICS using the BICS Data Sync tool:
Within the all above scenario the (“server”) components are provisioned on the Oracle Public Cloud. For a scenario where some components like the Database still reside on-premise the following tool needs to be installed on the server hosting the Oracle Database:
as described in this article from Oracle.