Oracle Integration Cloud (aka OIC) is like the glue or mortar that makes the different parts of an ecosystem of technology puzzle start to look that they fit. OIC is good for hybrid, multi cloud integration and extensions framework. So, which are those 3 legs or components that OIC provides? With OIC (and sometimes other … Continue reading Explaining the Three Legs of Oracle Integration Cloud (OIC) for Dummies
Oracle DB has been supporting JSON for quite some time, but you probably didn't know it! Let's se how easy is to start puting and geting json data in it. The most quick way to get a JSON db up and running is creating an Autonomous Transaction Processing instance. Create the instance and forget there … Continue reading Experiencing JSON in Oracle Autonomous Database for Cloud Native Geeks in less than 15 Minutes
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
Photo by Lukáš Kováčik on Pexels.com The method for geting this info is under the Engagement REST API here. The call includes a parameter which is filtering by the Member Name as follows: curl -X GET -k -H 'Authorization: Basic whatever' -i 'https://serverdomain/crmRestApi/resources/11.13.18.05/serviceRequests?q=LoyMemberName="menbernamehere"&onlyData=true' Example: curl -X GET -k -H 'Authorization: Basic am9ob........DM3Mzg=' -i 'https://xxxx-xxxx-xx-ext.oracledemos.com/crmRestApi/resources/11.13.18.05/serviceRequests?q=LoyMemberName="ad pepelu"&onlyData=true' … Continue reading Oracle Loyalty Cloud | REST API | Get Service Requests of a Member + Update SR
ORDS is a piece of software that acts as an intermediary between Oracle Database and the layers where business logic is implemented and/or consumed. NOTE: If your database hasn't been set up for ORDS just google for it or take a look at this post. With ORDS you expose database objects as REST. ORDS can be … Continue reading Deploy ORDS (Oracle Rest Data Services) to Kubernetes Cluster
Do you want to generate the client code needed for consuming some REST endpoint in your preferred programming language? Follow this steps: Locate the REST documentation you are interested in docs.oracle.com Click download icon Click Swagger button Select and copy the swagger code Go to editor.swagger.io Clear the editor Paste the clipboard content Accept the … Continue reading Generate clients for your preferred programming language from Oracle Cloud REST API’s
