Extracting Data from Oracle SaaS to Onprem or Other Clouds through Private High Speed Connection via Service Gateway


BI Cloud Extract is a standard tool for extracting data from SaaS (ERP, ...) either incremental or fully approaches. Data is exported to Object Storage as zipped files. Files stored in object storage are encrypted by a key provided by OCI Object Storage administrator role o keys managed by Oracle. Additionally Oracle encrypts data at … Continue reading Extracting Data from Oracle SaaS to Onprem or Other Clouds through Private High Speed Connection via Service Gateway

Oracle SaaS | Analysing the Structure and Morphology of the REST API Methods


Oracle SaaS API's have a structure that is equal for all the "business entities" across the different modules (Finance, Loyalty, Supply Chain, …) such as invoices, expenses, loyalty transactions and so on. Let's analyze the pattern. In this episode, we are focusing on the "Get all xxx" methods because it conforms a pattern that we'll … Continue reading Oracle SaaS | Analysing the Structure and Morphology of the REST API Methods

Near Real Time Data Driven SaaS Integration with Streaming | Part 2: Extracting/Publishing Data Changes to Streaming Topics


As we mentioned in a previous post, the idea here is to develop a construct that seeks for changes in the SaaS data system and publishes those changes to a stream for later consumption from other systems over there. Indeed, as we see in the diagram, there is a block in which we are executing a program … Continue reading Near Real Time Data Driven SaaS Integration with Streaming | Part 2: Extracting/Publishing Data Changes to Streaming Topics

Oracle SaaS Stories: Creating a Custom App Extension with Visual Builder | Part Three: Filtering Data


Next step after what we posted here is how to implement a mechanism to filter results. Taking a look to the REST APIs we can notice that the query parameter q is the one that can help us to implement what we are pretending: So the q parameter works as a field1<operator1>value1;fieldn<operatorn>valuen expression that can … Continue reading Oracle SaaS Stories: Creating a Custom App Extension with Visual Builder | Part Three: Filtering Data

Oracle SaaS Stories: Creating a Custom App Extension with Visual Builder | Part Two: Results Pagination


In this episode we are explaining how to list data results in a table located on a page. This is the typical use case in which we want to show business data to the user according to certain criteria. For now what we want to demonstrate is how to show results in paginated mode. The … Continue reading Oracle SaaS Stories: Creating a Custom App Extension with Visual Builder | Part Two: Results Pagination

Oracle SaaS Stories: Creating a Custom App Extension with Visual Builder | Part One: Connect Visual Builder to Fusion SaaS API Service Catalog


Visual Builder Cloud Service (aka VBCS), one of the 3 legs of Oracle Integration Cloud (aka OIC), is a low code development environment that is one of the main mechanisms for extending Oracle Fusion SaaS Apps. In this episode we are connecting VBCS to a SaaS instance, so we can get the different endpoints provided … Continue reading Oracle SaaS Stories: Creating a Custom App Extension with Visual Builder | Part One: Connect Visual Builder to Fusion SaaS API Service Catalog

Oracle SaaS Stories | Customisation Framework: Invoking a Service when an Entity is Created/Updated


In this episode we are explaining one of the many mechanisms for executing actions when changes happen in the Cloud App Environment. In this particular case, as an example, we are calling an external REST service hosted in a kubernetes cluster, that implements a counter. Every time we create or modify a Contact, the external … Continue reading Oracle SaaS Stories | Customisation Framework: Invoking a Service when an Entity is Created/Updated

Oracle SaaS Stories | Exporting Data to Cloud Object Storage with BI Cloud Extract Tool


Business Intelligence Cloud Extract is a tool that you can use to export data from Oracle SaaS. The tool is under /biacm service url, such as https://xxxx-envn.yy.dc.oraclezzz.com As the time of this writing the supported external storage repos are Oracle Cloud Object Storage "Classic" and UCM (Universal Content Manager. Update: Update 19C now supports OCI … Continue reading Oracle SaaS Stories | Exporting Data to Cloud Object Storage with BI Cloud Extract Tool