Introduction Many integration use cases require the use of Autonomous database (ADB) as the parking lot datastore with Oracle Integration. Oracle Integration...
Introduction Many integration use cases require the use of Autonomous database (ADB) as the parking lot datastore with Oracle Integration. Oracle Integration provides various options to connect to ADB. The Oracle integration documentation table below summarizes these options. * Cloud Database Connectivity Support Options In summary, Connecting to ADB dedicated instances (ADB-D) and ADB shared private endpoint DB requires an OIC connectivity agent. Connecting to ADB Shared...
Introduction Many integration use cases require the use of Autonomous database (ADB) as the parking lot datastore with Oracle Integration. Oracle Integration provides various options to connect to...
* This blog was last tested on OAC Version 5.9 + ADW 18c * Background This article walks through the steps to invoke Oracle REST Data Services (ORDS) in...
* This blog was last tested on OAC Version 5.9 + ADW 18c * Background This article walks through the steps to invoke Oracle REST Data Services (ORDS) in Oracle Analytics Cloud (OAC) Data Visualization (DV). Possible Use Cases: * Write-back * Running DML statements (insert, update or delete etc.) * Passing pre-process dynamic parameters to selects statements or stored procedures * Passing parameters to a web service Functionality Covered: * DV Data Actions * Apex ORDS...
* This blog was last tested on OAC Version 5.9 + ADW 18c * Background This article walks through the steps to invoke Oracle REST Data Services (ORDS) in Oracle Analytics Cloud (OAC) Data...
This blog will explain a use case for extending SaaS approvals on a BPM platform and outline the steps to implement such an extension.
Introduction The aim of this blog is to guide customers when they set out to migrate their integration solutions from SOA to Oracle Integration (OIC). The...
Introduction The aim of this blog is to guide customers when they set out to migrate their integration solutions from SOA to Oracle Integration (OIC). The focus in this blog is to help customers during the creation, configuration of Oracle Integration service instances, and also provide best practices for choosing the right OIC features and integration patterns when developing SOA equivalent integrations on Oracle Integration Cloud. The existing SOA workloads could be...
Introduction The aim of this blog is to guide customers when they set out to migrate their integration solutions from SOA to Oracle Integration (OIC). The focus in this blog is to help customers...
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c + Oracle Analytics Client Tools 5.8.0 [aka Oracle BI Administration Tool...
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c + Oracle Analytics Client Tools 5.8.0 [aka Oracle BI Administration Tool Version 12.2.5.8.0] + SQuirreL SQL Client Version 4.1.0 + Windows 10 Pro 64-bit OS * This article walks through the steps to query an Oracle Analytics Cloud (OAC) and Oracle Fusion Analytics Warehouse (FAW) data model with SQuirreL (an open-source Java SQL Client). The blog demonstrates both Resource Owner and JSON Web...
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c + Oracle Analytics Client Tools 5.8.0 [aka Oracle BI Administration Tool Version 12.2.5.8.0] + SQuirreL SQL Client...
An article that explores Cloud-Native in the context of a strategic direction for CIO's, looking to evolve their IT approach.
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...
This blog was a collaborative effort between Greg Mally and Mike Muller of the A-Team. There is an effort under way to provide example assets for this blog and...
This blog was a collaborative effort between Greg Mally and Mike Muller of the A-Team. There is an effort under way to provide example assets for this blog and when those assets are available, this blog will be updated with details on how to get to them. One of the big challenges that Oracle Integration Cloud developers face is any outbound REST calls from Integration Cloud (IC) to Fusion Applications (FA) APIs require a user’s identity. On the surface this seems pretty...
This blog was a collaborative effort between Greg Mally and Mike Muller of the A-Team. There is an effort under way to provide example assets for this blog and when those assets are available, this...
On the topic of fault handling in Integration Cloud (IC), there are three types of Fault Actions that can be leveraged: 1. Re-throw Fault, 2. Throw New Fault,...
On the topic of fault handling in Integration Cloud (IC), there are three types of Fault Actions that can be leveraged: 1. Re-throw Fault, 2. Throw New Fault, and 3. Fault Return. More times than not, a discussion comes up around why faults thrown in IC are always HTTP 500. This is not necessarily true and this blog will clarify the behaviors of each of the Fault Actions. To illustrate the Fault behaviors, a simple integration will be used where URI Parameters control the...
On the topic of fault handling in Integration Cloud (IC), there are three types of Fault Actions that can be leveraged: 1. Re-throw Fault, 2. Throw New Fault, and 3. Fault Return. More times than...
