Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part III

Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field Service Cloud […]

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part II

  Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field Service […]

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part I

Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including support for RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field […]

A python REPL for accessing the ICS via REST API

What it is This is a small set of python, wrapped into a REPL for easy interaction with ICS in bulk. It has the ability to be fed simple scripts that can perform various tasks, as well as interactive capability. It is the culmination of much playing around with the ICS REST API over the […]

Using Business Events in E-Business Suite to send messages to other applications via ICS

Introduction In this article, I will discuss and demonstrate the use of Business Events in E-Business Suite (EBS) to integrate it with other applications using Integration Cloud Service (ICS). The Oracle Workflow Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems. This functionality is leverage […]

ICS Connectivity Agent stdout Log Rotation

When monitoring and/or troubleshooting the ICS Connectivity Agent server, it is important to not only have the standard logs (e.g., AdminServer-diagnostic.log) but also the standard out/error (stdout/stderr).  One of the big challenges of capturing the stdout is not exhausting the disk storage over time.  Since the ICS Connectivity Agent is a WebLogic server installation, there […]

Integrating with ERP Cloud using ICS

Introduction Integration Cloud Service (ICS) is a PaaS cloud offering from Oracle that provides capabilities of integrating applications both on-cloud and on-premise (on-prem). ICS provides rich set of connectors/adapters to connect to Oracle’s SaaS and on-prem applications and many third-party cloud and on-prem applications. One such connector that ICS provides is the Oracle ERP Cloud […]

GoldenGate Cloud Service (GGCS): Replication from Amazon RDS Oracle Database to Oracle DBCS

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication from Amazon Relational Database Service (RDS) Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Amazon Web Services (AWS) Elastic Compute Cloud (EC2) and Oracle GoldenGate Cloud Service (GGCS). The following topics are not included […]

Integrating with Taleo Enterprise Edition using Integration Cloud Service (ICS)

Introduction Integration Cloud Service (ICS) provides Oracle SaaS customers with pre-defined to connections to most SaaS subscriptions and zero-code integration features to quickly connect SaaS applications. Oracle Taleo provides talent management functions as Software as a service (SaaS). Taleo often needs to be integrated with other human resource systems. For customers looking to use ICS for […]

GoldenGate Cloud Service (GGCS): 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) via GoldenGate Cloud Service (GGCS). Installation of Oracle GoldenGate for Oracle Database on the On-Premises and the provisioning of Oracle GGCS and DBCS are not […]

Connecting ICS and Apache Kafka via REST Proxy API

Introduction Apache Kafka (Kafka for short) is a proven and well known technology for a variety of reasons. First it is very scalable and has the capability of handling hundreds of thousands of messages per second without the need of expensive hardware; and close to zero fine tuning, as you can read here. But another […]

Invoking IDCS REST API from PL/SQL

This post shows a way to make REST API calls to IDCS from an Oracle Database using PL/SQL.  The idea is that a PL/SQL application can manage and search for user and group entities directly in IDCS. In the sample code we’ll see how to obtain an access token from IDCS and make calls to create […]

Using Oracle Managed File Transfer (MFT) to Push Files to ICS for Processing

Introduction In a previous article I discussed the use of the Enterprise Scheduler Service (ESS) to poll for files, on a scheduled basis, to read from MFT.  In that article we discussed how to process many files that have been posted to the SFTP server.  At the end of that article I mentioned the use […]

ICS Connectivity Agent – Update Credentials

When installing the Connectivity Agent, there are several mandatory command-line arguments that include a valid ICS username (-u=[username]) and password (-p=[password]). These arguments are used to verify connectivity with ICS during installation and are also stored (agent credentials store) for later use by the agent server. The purpose of storing them is to allow the […]

IDCS and Weblogic Federation with Virtual Users and Groups

Introduction Federation is a well-known pattern and has been discussed at length on this blog. Almost every vendor or cloud provider out there supports Federation and it’s been around for quite some time now. In this blog post, I will talk about Federation again, but this time in combination with Weblogic’s Virtual Users and Groups. […]

Understanding the Enterprise Scheduler Service in ICS

Introduction   In many enterprise integration scenarios there is a requirement to initiate tasks at scheduled times or at user defined intervals. The Oracle Integration Cloud Service (ICS) provides scheduling functionality via the Oracle Enterprise Scheduler to satisfy these types of requirements.  The Oracle Enterprise Scheduler Service (ESS) is primarily a Java EE application that […]

Using Process Cloud Service REST API Part 2

Introduction In Part 1 we looked at using the Process Cloud Service REST API and making REST calls from an HTML page using jQuery/AJAX. In Part 2 we’ll take the next step by using and presenting data retrieved from PCS. We started out stuffing the string representation of the JSON data into an HTML <div> […]

Integrating Oracle GoldenGate Cloud Service (GGCS) with Oracle Business Intelligence Cloud Service (BICS)

Introduction This article describes an overview of how to integrate Oracle GoldenGate Cloud Service (GGCS) in terms of populating or loading data into Oracle Business Intelligence Cloud Service (BICS) from On-Premises. Both GGCS and BICS are Platform as a Service (PaaS) services that runs in the Oracle Public Cloud (OPC). For GGCS to be integrated with […]

Integrating Sales Cloud and Service Cloud using ICS – troubleshooting issues with security configuration

Introduction This blog talks about a few “gotchas” when integrating Oracle Sales Cloud (OSC) and Oracle Service Cloud (OSvC) using Oracle’s iPaaS platform, the Integration Cloud Service(ICS). The idea is to have a ready reckoner for some common issues faced, so that customers can hit the ground running when integrating between OSvC and OSc using […]

Integrating Oracle Project Cloud with Documents Cloud Service using REST APIs and business object-level security.

Introduction Oracle Documents Cloud Service (DCS) enables collaboration through rich set of social and mobile-optimized features. Customers often come across requirements to integrate DCS to Oracle Applications cloud. Such integration improves productivity by taking advantage of features of DCS Service. In this post, let’s take a look at integrating Project Management Cloud, a part of Oracle […]