Background Write-back is powerful feature that has been available in Oracle Business Intelligence (OBI) since its early inception. It was made available in...
Background 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. This blog was tested on OAC 105.4.0-161. 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 currently supports ADW as well as ATP...
Background 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...
Matthieu Lombard CLOUD SOLUTIONS ARCHITECT, DATA MANAGEMENT, A-TEAM Background *** 12/16/19 - This feature is in early release. The A-Team continues to...
Matthieu Lombard CLOUD SOLUTIONS ARCHITECT, DATA MANAGEMENT, A-TEAM Background *** 12/16/19 - This feature is in early release. The A-Team continues to collaborate with Oracle Development on these configuration steps and will update the blog accordingly as new information is made available *** ~ 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...
Matthieu Lombard CLOUD SOLUTIONS ARCHITECT, DATA MANAGEMENT, A-TEAM Background *** 12/16/19 - This feature is in early release. The A-Team continues to collaborate with Oracle Development on these...
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...
Introduction In various blog posts we discussed the usage of BI Cloud Connector (BICC) in Oracle SaaS. In our cloud applications for ERP, HCM, EX etc exist...
Introduction In various blog posts we discussed the usage of BI Cloud Connector (BICC) in Oracle SaaS. In our cloud applications for ERP, HCM, EX etc exist various options to store flexible data as we know. One option follows the concept of flexible fields as known as Flexfields. Those are either Key Flexfields (KFF), Descriptive Flexfields (DFF) or Extensible Flexfields (EFF). These data are stored in database tables where the structures are fixed (columns named SEGMENT,...
Introduction In various blog posts we discussed the usage of BI Cloud Connector (BICC) in Oracle SaaS. In our cloud applications for ERP, HCM, EX etc exist various options to store flexible data as we...
For other A-Team articles about BICS, OAC, and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and...
For other A-Team articles about BICS, OAC, and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into BI Cloud Service (BICS), Oracle Analytics Cloud Service (OAC), and other relational databases. I have previously written about the tool's ability to extract data from OTBI, both cloud and on-premise, and to load into BICS or OAC (that article is here). New functionality has...
For other A-Team articles about BICS, OAC, and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data...
Introduction The Oracle Fusion based SaaS offerings provide an interesting tool to extract data and to store them in CSV format on a shared resource like the...
Introduction The Oracle Fusion based SaaS offerings provide an interesting tool to extract data and to store them in CSV format on a shared resource like the Fusion SaaS built-in UCM server or a Storage Cloud: BI Cloud Connector (BICC). The extracted data can be copied from these cloud resources and downloaded to local resources, before post-processing operations like transformations and loads into Data Warehouses or other databases can be initiated. Perhaps this built-in...
Introduction The Oracle Fusion based SaaS offerings provide an interesting tool to extract data and to store them in CSV format on a shared resource like the Fusion SaaS built-in UCM server or...
Background This article provides a set of sample code snippets for loading data from Oracle Data as a Service for Customer Intelligence (DaaS for CI) into an...
Background This article provides a set of sample code snippets for loading data from Oracle Data as a Service for Customer Intelligence (DaaS for CI) into an Oracle Business Intelligence Cloud Service (BICS) Schema Service Database. "Oracle Data as a Service for Customer Intelligence (DaaS for CI) enables you to analyze your own unstructured text as well as public social data, so you can translate insights into actions that benefit you and your customers. DaaS for CI...
Background This article provides a set of sample code snippets for loading data from Oracle Data as a Service for Customer Intelligence (DaaS for CI) into an Oracle Business Intelligence Cloud...
Background This article describes how to integrate Oracle Sales Cloud (OCS) with Oracle Database as a Service (DBaaS) using PL/SQL. The code snippet provided...
Background This article describes how to integrate Oracle Sales Cloud (OCS) with Oracle Database as a Service (DBaaS) using PL/SQL. The code snippet provided uses the REST API for Oracle Sales Cloud to create a new OSC contact from DbaaS. The PL/SQL uses UTL_HTTP commands to call the REST API for Oracle Sales Cloud. A sample use case for this code snippet could be: Displaying a list of contacts in an Oracle or an external application. Then allowing the application consumer...
Background This article describes how to integrate Oracle Sales Cloud (OCS) with Oracle Database as a Service (DBaaS) using PL/SQL. The code snippet provided uses the REST API for Oracle Sales Cloud...
