GoldenGate Cloud Service (GGCS): Using VPN as a Service (VPNaaS) for Replication from On-Premises to Oracle Public Cloud (OPC)

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) using Virtual Private Network as a Service (VPNaaS). The VPNaaS is another way Oracle provides VPN connectivity between On-Premises and OPC. For a list of […]

Data Sync and the Autonomous Data Warehouse Cloud (ADWC)

For other A-Team articles by Richard, 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. In the latest release, the tool adds the ability to both load […]

Extracting Data from Oracle Analytics Cloud using SOAP

  Introduction This post provides a simple method of extracting data from Oracle Analytics Cloud (OAC) using web services. It uses Oracle Business Intelligence Web Services as documented in Fusion Middleware Integrator’s Guide for Oracle Business Intelligence Enterprise Edition This simple method (using HTTP) is not secure and should only be used in a development […]

GoldenGate Cloud Service (GGCS): How to configure Oracle GoldenGate (OGG) SOCKS Proxy Server via HTTP Proxy Server

Introduction In this article we shall discuss how to configure Oracle GoldenGate (OGG) replication between On-Premises and GoldenGate Cloud Service (GGCS) via HTTP Proxy Server. This discussion will include a sample configuration setup. This approach is very similar to configuring OGG Replication between On-Premises and GGCS via DMZ server, the only main difference is how […]

Commerce Product Catalog Modeling Principles

A proper product catalog model underpins the success of any online commerce solution. The key ingredients for good modeling are: simplicity. The catalog objects (items) must follow the precepts of good domain-driven design with bounded contexts. Each object should have a unique purpose and representation. coupling. Loose couplings should be used whenever possible, so as […]

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

GoldenGate Cloud Service (GGCS): Enable SSL SQLNet on GGCS to connect to Oracle Database

Introduction This document will walk you through how to enable SSL SQLNet connection on GGCS to connect to an Oracle Database. Enabling SSL communication between GGCS and the Oracle database is achieved by configuring credential wallet on both GGCS and the database which will store certificates and by modifying the configuration files used for SQLNet […]

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

Part 4 of 4 – SSSD Authentication: Known Problems and Troubleshooting Tips

Introduction In Part 3 of 4 – SSSD Linux Authentication: Implementation Step-by-Step Guideline I covered all the necessary step-by-step details on deploying SSSD, but nothing ever seems to go perfect the first time does it.  This is why I have included a final Part 4 that covers known problems I came across, though there could […]

Part 3 of 4 – SSSD Linux Authentication: Implementation Step-by-Step Guideline

Introduction In Part 2 of 4 – SSSD Linux Authentication: LDAP Identity Store Requirements all the aspects of the LDAP Identity Store requirements were covered. And before that in article Part 1 of 2 – SSSD Linux Authentication: Introduction and Architecture I covered an introduction and high-level architecture of SSSD, which will be very important […]

Part 2 of 4 – SSSD Linux Authentication: LDAP Identity Store Requirements

Introduction In Part 1 of 4 – SSSD Linux Authentication: Introduction and Architecture I covered an introduction on SSSD and an architecture overview with details on the flow of how it all works.  In this part I am going to cover the LDAP Identity Store details required for SSSD.   LDAP Identity Store Schema Requirements […]

Part 1 of 4 – SSSD Linux Authentication: Introduction and Architecture

Introduction This article provides the details needed to solve a real use case used to allow a user to authenticate to an Oracle Public Cloud Linux server in SaaS using a single or multiple LDAP Identity store that could be Active Directory 2012R2 (AD) or better, Oracle Internet Directory (OID), Oracle Unified Directory (OUD), Oracle […]

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

Adding New Fusion Applications Product Offerings using Incremental Provisioning

Introduction A product offering is a logical grouping of features and functionality of Oracle Fusion Applications. Customers who have excluded certain product offerings during their base installation and would like to add these or would like to add newly released product offerings can only do so during upgrade using Incremental Provisioning (IP) IP provides the ability to […]

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: Standalone Configuration

Introduction   This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Standalone 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 of Hadoop:  […]

Configuring Oracle Data Integrator for Oracle Big Data Cloud: Environment Configuration

Introduction   This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) – specifically – how to configure the BDC environment for ODI, so users can design Big Data workloads with ODI and execute them on BDC.  ODI offers out of the box integration with Big Data technologies […]