Introduction While it is possible to view a BI Publisher (BIP) report in a page using an iFrame, there are times when this may not be suitable or possible. This...
Introduction While it is possible to view a BI Publisher (BIP) report in a page using an iFrame, there are times when this may not be suitable or possible. This article shows an alternative method that can be used to view a BIP report without the use of an iFrame, using Visual Builder (VB) as the "hosting" application. While the example assumes that the VB server and BIP are federated, it is also possible to perform this configuration using non federated instances by using...
Introduction While it is possible to view a BI Publisher (BIP) report in a page using an iFrame, there are times when this may not be suitable or possible. This article shows an alternative method...
Co-Author: Saunnie Bell, Technical Manager, Oracle Consulting Content validated on 12/18/2020 with ODI Version 12.2.1.4.200304.2238 ADW Version Oracle...
Co-Author: Saunnie Bell, Technical Manager, Oracle Consulting Content validated on 12/18/2020 with ODI Version 12.2.1.4.200304.2238 ADW Version Oracle Database 19c Enterprise Edition Release - Production Version 19.5.0.0.0 Background This blog is part of a series covering topics on how to utilize Oracle Analytics / ETL / Data Integration tools to extract data from various data sources. Future blog topics will cover extracting from: Oracle SaaS Applications, Oracle...
Co-Author: Saunnie Bell, Technical Manager, Oracle Consulting Content validated on 12/18/2020 with ODI Version 12.2.1.4.200304.2238 ADW Version Oracle Database 19c Enterprise Edition Release -...
Introduction Oracle Visual Builder (VB) has out of box support for calling REST services and can be configured to make calls directly from the client, or via...
Introduction Oracle Visual Builder (VB) has out of box support for calling REST services and can be configured to make calls directly from the client, or via the server proxy. There is no obvious support for making SOAP calls. While it is possible to make client side SOAP calls from javascript, without the VB Connection framework, the authentication would need to be handled by the client code and there is a high chance of a CORS error. This post shows how the VB Service...
Introduction Oracle Visual Builder (VB) has out of box support for calling REST services and can be configured to make calls directly from the client, or via the server proxy. There is no...
Validated September 30, 2020 Introduction Oracle Analytics for Applications (FAW / OAX) is built on top of Oracle Analytics Cloud (OAC) and is powered by Oracle...
Validated September 30, 2020 Introduction Oracle Analytics for Applications (FAW / OAX) is built on top of Oracle Analytics Cloud (OAC) and is powered by Oracle Autonomous Data Warehouse (ADW). FAW extracts and loads data from your Oracle Fusion Applications Cloud into an instance of ADW and provides a semantic model with prebuilt KPIs, dashboards, and reports in OAC. The Oracle document here lists the currently regions available for provisioning. This post describes the OCI...
Validated September 30, 2020 Introduction Oracle Analytics for Applications (FAW / OAX) is built on top of Oracle Analytics Cloud (OAC) and is powered by Oracle Autonomous Data Warehouse (ADW). FAW...
Introduction into existing BICC Automation BI Cloud Connector offers a broad bandwidth of options to automate the extraction of data. In various other blogs...
Introduction into existing BICC Automation BI Cloud Connector offers a broad bandwidth of options to automate the extraction of data. In various other blogs we’ve shared information how to download extraction files, log information or to delete extracts. Those scripts can be scheduled on the client side via the tools of choice. The built-in capabilities in BICC provide more and more automation as the product evolves. Scheduling frequent extraction runs was a feature that...
Introduction into existing BICC Automation BI Cloud Connector offers a broad bandwidth of options to automate the extraction of data. In various other blogs we’ve shared information how to download...
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * Write-back is powerful feature that has been available in Oracle Business...
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * Write-back is powerful feature that has been available in Oracle Business Intelligence (OBI) since its early inception. It was made available in Oracle Analytics Cloud (OAC) in Release 105.2 - March 2019. Note: Currently write-back is not supported with Data Gateway (DG) using an on-premises databases. This blog will be updated if / when on-premise support becomes available. Write-back...
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * Write-back is powerful feature that has been available in Oracle Business Intelligence (OBI) since its early...
Matthieu Lombard CLOUD SOLUTIONS ARCHITECT, DATA MANAGEMENT, A-TEAM * This blog was last tested on ODI V12.2.1.4.201011 + Fusion 20D (11.13.20.10.0) + ADW 18c *...
Matthieu Lombard CLOUD SOLUTIONS ARCHITECT, DATA MANAGEMENT, A-TEAM * This blog was last tested on ODI V12.2.1.4.201011 + Fusion 20D (11.13.20.10.0) + ADW 18c * Background This article walks though the steps to configure Oracle Data Integrator on Oracle Cloud Marketplace (ODI) with Business Intelligence Cloud Connector (BICC) to replicate data from Fusion SaaS into an Autonomous Data Warehouse (ADW) database. This blog is the first in a series covering topics on how to...
Matthieu Lombard CLOUD SOLUTIONS ARCHITECT, DATA MANAGEMENT, A-TEAM * This blog was last tested on ODI V12.2.1.4.201011 + Fusion 20D (11.13.20.10.0) + ADW 18c * Background This article walks though...
Introduction In this blog I want to discuss about an interesting usecase that showcases how IDCS Appgate can be used to enable SSO security for legacy...
Introduction In this blog I want to discuss about an interesting usecase that showcases how IDCS Appgate can be used to enable SSO security for legacy applications when migrating to the cloud. Many customers who are looking to migrate their workloads into the cloud find that they have legacy systems in their portfolio that are not necessarily amenable to modernisation. An example of one of these legacy systems is Oracle Discoverer. Oracle BI Discoverer is a business...
Introduction In this blog I want to discuss about an interesting usecase that showcases how IDCS Appgate can be used to enable SSO security for legacy applications when migrating to the cloud....
Introduction EXTRACT JSON files Since end of 2018 SaaS Cloud provides a new feature to track the status of a data extraction run in BI Cloud Connector (BICC)....
Introduction EXTRACT JSON files Since end of 2018 SaaS Cloud provides a new feature to track the status of a data extraction run in BI Cloud Connector (BICC). Every single run to extract data or keys will produce a JSON file with log information that can be used for monitoring purposes. The naming style per file looks like shown below: EXTRACT_STATUS_DATA_SCHEDULE_<Schedule ID>_REQUEST_<Request ID>.JSON BICC Extract log file for VO data if been chosen in run definition...
Introduction EXTRACT JSON files Since end of 2018 SaaS Cloud provides a new feature to track the status of a data extraction run in BI Cloud Connector (BICC). Every single run to extract data or keys...