Using Business Events in Fusion-based SaaS with Oracle Integration Cloud Service – Part 3: Event Filter Expressions

In the previous two posts, Part 1 and Part 2, we gave an overview which Business Events are available in R13 and how you can subscribe to events with external applications using Oracle ICS/OIC. In this part, we will show how to filter events using XPath expressions. Use Cases for Filtering Business Events The approach […]

Using Business Events in Fusion-based SaaS with Oracle Integration Cloud Service – Part 2: Step-by-Step Example

Following the overview in Part 1, I will now show detailed steps how to create the event subscriptions. In our example, we will use an “Item Creation” event (from SCM cloud). Prerequisite: Register CSF Key in SaaS In a FA-based SaaS instance, the outbound call of a webservice uses a OWSM security policy which retrieves the […]

Using Business Events in Fusion-based SaaS with Oracle Integration Cloud Service – Part 1: Overview

Introduction For integration with all Oracle Fusion based Cloud services – like Oracle Sales Cloud and Oracle SCM Cloud, each service provides Business Events which external applications or integrations can subscribe to. Oracle Integration Cloud Service (ICS) or the new offering Oracle Integration Cloud (OIC) allow very easily to receive (subscribe) to these events and […]

IDCS Integrations Series Part III: Integrating on-prem applications to IDCS

Overview As more and more customers move Identity to the cloud, we will run into applications that cannot be migrated in short term or cannot be migrated at all to cloud for various reasons including security. That leads to the question, how do we integrate those on-prem applications to cloud Identity solution? There are a […]

SSO “like” functionality with Oracle Fusion JWT Tokens

Introduction There are many instances where customers want to extend Oracle’s Fusion SaaS applications with PaaS components. Depending on the Oracle PaaS components being used, they may get SSO with Fusion Applications pre-configured OOTB however sometimes this is not the case and they will need to manually setup SSO federation to achieve their needs. If […]

Oracle API Platform Cloud Service – Bulk API creation utility

Introduction This blog provides a utility for bulk creation & deployment of APIs in Oracle API Platform cloud service. It is useful to the first time users who have significant number of back-end services that needs to be published as simple API. Instead of creating individual API from API Portal this utility reads a template […]

Fusion Cloud IP-Whitelisting

Introduction With the increasing adoption of Oracle Cloud among customers, one of the key challenges the customers’ security teams face is managing network access for the newly purchased SaaS services. The security teams are firm on enforcing the rules and regulations around IT security that are already in place, and they expect their new SaaS […]

UTL_Match and Soundex for ‘Fuzzy’ Matching of Data in an Oracle Database

For other A-Team articles by Richard, click here Introduction In today’s data-centric world, the BI professional is often faced with the problem of joining data sets from different sources. In a normalized relational database, you can typically just join column A to column B, and be on your way. Unfortunately that’s always not the case.  Take the […]

Using Date Based Partitioning for OTBI Extracts with Data Sync to Improve Performance

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 […]

Configuring Oracle Data Integrator for Oracle Big Data Cloud: High-Availability Configuration

Introduction   This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Enterprise or High-Availability installation.  ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, Apache Pig, and Apache Kafka, among others.  ODI supports both distributions […]

Using Oracle Data Integrator with Big Data Cloud

Introduction   This article presents an overview of how to use Oracle Data Integrator (ODI) with Oracle Big Data Cloud (BDC). ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, and Apache Pig, among others. ODI supports both distributions of Hadoop: Hortonworks Data Platform (HDP), and […]

GoldenGate Cloud Service (GGCS): Replication from On-Premises to Oracle Public Cloud (OPC) via Oracle Cloud Gateway VPN

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication between On-Premises Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Oracle Cloud Gateway Virtual Private Network (VPN) using Corente Services Gateway. Installation of Oracle GoldenGate for Oracle Database on the On-Premises and the provisioning […]

Using Content and Experience Cloud with your Oracle Intelligent Bots chatbot

In this blog I will show how you can use the content items from Content and Experience Cloud in your Oracle Intelligent Bots chatbot. Why By using Content and Experience Cloud you can have a dedicated team working on the content with the appropriate business tools to manage the content lifecycle, next to the group that […]

API Platform Cloud Service – Application Key override rules

Introduction Consumers create Applications on the Developer Portal and register to the APIs that they intend to consume. The Developer portal generates a default Application Key (AppKey) as an identifier for every Application, during creation. Often, consumers/developers may wish to override the default AppKey far various purposes. A common use case is to allow for […]

Voice UI Demo for Content and Experience Cloud

The Evolving Landscape of Content Delivery Content is no longer just for web sites. As more and more people spend less and less time in front of a computer using a mouse and keyboard, content that traditionally surfaced in web apps now surfaces in numerous new and emerging channels. On the flip side, content creation is […]

Identity cloud service : Mobile clients and PKCE support

Introduction OAuth 2.0 has become very popular within the mobile development community mainly because it is simple to implement and the tokens are fairly compact. There are various implementation patterns to choose from and it is very important to choose the right one to make sure that the solution is secure. In this blog post I want to describe how […]

IDCS Integrations Series Part I: Integrating WebLogic Hosted Application with IDCS

Overview As you implement IDCS (Oracle IDentity Cloud Service) use cases, you would have started thinking, “how do you integration application X with IDCS?”, Specially the applications running on-premise or running somewhere other than Oracle public cloud. This blog talks about integration of weblogic hosted applications with IDCS running on-premise or running somewhere other than Oracle […]

ICS Best Practices : Before going live and post go-live

Integration Cloud Service, Oracle’s flagship iPaaS product, is increasingly being adopted by customers as their strategic integration platform, for implementing various Cloud-to-Cloud as well as Cloud-to-OnPrem integration projects. With every release of the product more and more features are being added, and there’s plenty of documentation available on using ICS for designing and developing various […]

Securing Subject Areas in Oracle Analytics Cloud

Introduction This post documents how to secure Oracle Business Intelligence Repository Metadata (RPD) subject areas in Oracle Analytics Cloud (OAC). It uses an example of two subject areas; Financials and Projects. The Projects subject area is secured via application roles and presentation services privileges. Only users with the correct role(s) can view the subject area […]

GoldenGate Cloud Service (GGCS): Network Connectivity Options for GGCS – On-Premises and Oracle Cloud

Introduction This article will discuss in high-level the different options available for network connectivity between Oracle GoldenGate (OGG) software running on-premises and GoldenGate Cloud Service (GGCS) instance running on the Oracle Cloud. The following topics are not included in the scope of this article: Installation and Configuration of Oracle GoldenGate (OGG) Software Provisioning of GoldenGate […]