Oracle Cloud Infrastructure (OCI) REST call walkthrough with curl

  Introduction This post will walkthrough the elements required, and purpose of each, to make a curl request to Oracle Cloud Infrastructure (OCI) REST services. While there are a variety of tools offered that make this task far easier than manually constructing a curl request, the purpose of this post is to provide an explanation […]

Trigger OIC Integration Using OAuth

As businesses move to the cloud there is a high demand for securing/protecting their HTTP resources from unauthorized access. There are several approaches to protecting these resources which include SAML for SOAP service, OAuth for REST services, HTTP basic for both, and sometimes home grown proprietary mechanisms. It may not be widely known yet, but […]

Oracle GoldenGate Services Architecture: Silent Install and Deployment

Introduction In many organizations, users are not permitted to run the graphical user interfaces used to install the Oracle GoldenGate software and create Oracle GoldenGate Microservices Architecture (OGG-SA) Deployments. In this article we shall review the two response files required to silently install the OGG-SA application code and create a new Deployment. The concepts, scripts, and information presented in […]

Oracle GoldenGate Services Architecture: Configure Deployment Via REST API

Introduction The Oracle GoldenGate Microservices Architecture (OGG-SA) REST API may be used to configure Extracts, Replicats, and Distribution Paths, as well as create new parameter files or modify existing ones for a Deployment. In this article we shall use the REST API to configure a replication path and perform common modifications to Deployments; such as changing OGG_HOME after […]

OIC Connectivity Agent Installation Pointers

The connectivity agent has been a feature of Oracle’s integration cloud strategy from the beginning to address the challenge of the cloud/on-premise integration pattern. However, the implementation of the agent differs between Oracle Integration Cloud Service (ICS) and Oracle Integration Cloud (OIC). With both offerings, the pattern for setup remains the same: 1. Create Agent […]

ICS Connectivity Agent Concepts and Best Practices

ICS Connectivity Agent Concepts and Best Practices Introduction The on-premises connectivity agent enables you to create integrations between on-premises applications and Oracle Integration Cloud Service (ICS) Read all about agents in the documentation link below – Integration Cloud Service (ICS) Connectivity Agent In this blog, I wish to explain some problems that may be encountered […]

Advanced HCM data loader (HDL) processing using OIC HCM adapter.

Introduction Oracle Integration Cloud (OIC) Integration provides adapter for most popular SaaS applications, including Oracle HCM Cloud.  This post focuses on integrating with HCM data loader (HDL) tool of HCM using OIC HCM adapter, multiple HDL file processing and fault handling. Information in this post is applicable to release 18.3.1 of OIC. HCM Adapter basics […]

Engagement Cloud – an Introduction to calling REST Services

Introduction This article gives a brief introduction to calling REST services from Oracle Engagement Cloud. It assumes a basic understanding of Groovy, Application Composer, and the requirements of the REST services that you intend to call. It sets out the basic steps required to setup and make a REST call and describes a couple of […]

ICS to OIC Migration

Introduction Oracle Integration Cloud (OIC) and Integration Cloud Service (ICS) are iPaaS offerings from Oracle. ICS was released back in 2015 has now been superseded by OIC. Customers on ICS can choose to be on ICS or migrate to OIC to take advantage of new features and services built into OIC. The comparison of ICS […]

Integration Cloud – File Handling Primer

Introduction The objective of this blog is to introduce to the reader all available file-based options in Oracle Integration Cloud (OIC). The blog will cover the various tools and techniques available for developers for designing file-based integration solutions The Integration Cloud documentation does contain these in relevant sections. This blog intends to present only the […]

Render CEC Content Item with Images in Oracle Intelligent Bots

In one of the blog published by Dolf regarding Using CEC with Oracle Intelligent Bots, he demonstrated on how to use Oracle Intelligent Bots to retrieve the content items in CEC (Content and Experience Cloud Service) using the REST API. In this blog, I will extend this use case and provide a simple example of how to […]

GoldenGate Cloud Service (GGCS): How to run SSH Socks Proxy Server for Oracle GoldenGate (OGG)

Introduction In this article we shall discuss how to configure and run Secure Shell (SSH) Socks Proxy server needed for Oracle GoldenGate (OGG) replication between On-Premises and GoldenGate Cloud Service (GGCS) in the Oracle Public Cloud (OPC). The SSH Socks Proxy server is required in GoldenGate replication between On-Premises and OPC, only if there’s no […]

Oracle GoldenGate Best Practices: GoldenGate Capture from a DataGuard with Cascaded Redo Logs

  Introduction This paper provides guidance and examples for setting up downstream extraction from an Oracle DataGuard Standby system that has been configured with cascading redo logs. We outline how to configure the cascade log shipping from the standby to the mining database as well has how to configure the extract process on the mining […]

BI Cloud Connector – Deletion of Data Extract Files on UCM

Introduction This blog post is the continuation of the formerly shared article about BI Cloud Connector (BICC) Data Extraction File Downloading. In the previous blog post I gave an introduction into BICC and we discussed the options how to download the data extraction files from Storage Cloud or the internal built-in Universal Content Management (UCM) […]

Oracle Data Integration Platform Cloud (DIPC): Configure VPN as a Service (VPNaaS) for On-Premises Connectivity

Introduction This document will walk you through how to configure Virtual Private Network as a Service (VPNaaS) with Oracle Data Integration Platform Cloud (DIPC) for connectivity between On-Premises Oracle database and Oracle Public Cloud (OPC). One major requirement for DIPC to be configured with VPNaaS is; DIPC must be provisioned to use IP Network instead of […]

Oracle GoldenGate: DDL Replication To Oracle Targets With Dissimilar Data Structure

Introduction Oracle GoldenGate for Oracle Databases provides for the replication of DDL operations. In most environments DDL replication is used only where the source and target tables structures are the same. The challenge comes when the source and target tables have a dissimilar table structure; as may exist in a Data Warehouse or Reporting Database. In this […]

Accessing RSS Feeds in JavaScript

Introduction RSS (Really Simple Syndication I always called it but also Rich Site Summary) is an XML document containing headline or summary items. Consuming RSS feeds in JavaScript is more convenient with JSON data so we’ll take a look at tools to convert a feed to JSON. Then we’ll look at examples of using RSS data on […]

Calling an ICS/OIC service from BI Publisher

Introduction Although Oracle SaaS such as Oracle ERP Cloud, Oracle HCM, and Oracle Sales Cloud has a rich set of Webservices and APIs that can be called to retrieve data from these applications, there is always a need to generate data to downstream systems that are not available through these exposed Webservice and APIs. This […]

OIC and ICS File based integrations for Oracle HCM Cloud using UCM webservices

Introduction This blog details the solution using Oracle Integration Cloud (OIC) and Integration Cloud Service(ICS) for file based integrations using Universal Content Management (UCM) Webservices for Oracle HCM Cloud integration. Deprecation of SaaS sFTP servers for Oracle HCM Cloud and other Oracle Cloud applications was announced recently. Refer to the below MOS Support Doc Note for the announcement […]

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