Oracle SaaS applications provide, among others, a comprehensive set of REST APIs. Oracle Autonomous Database and the entire family of Oracle database product offerings provide rich and easy-to-invoke API mechanisms. Let's see an example: Creating a sales order With a simple PL/SQL block of code we are showing down here how easy is to create … Continue reading Invoking SaaS REST API from an Autonomous Database
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 | Part One
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
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
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
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
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
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
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
