Teaching how to use the Integration Cloud Service Connectivity Agent

I have been Integrating applications for the last 15+ years and normally every integration is a new challenge. It really doesn’t matter what technology or standards you use or have used in the past, the reality is that integrations come a new set of challenges. In the past few years the pre-built adapters have simplified in a way these challenges, but with hybrid architectures a new set of challenges comes to the picture, for example; connectivity, security, simplicity, message reliability, etc.

I was very excited when I learned the way Oracle Cloud is using to solve this problem. It is with something called Oracle ICS (Integration Cloud Service) Connectivity Agents, that basically get installed close to the Application being integrated, for example on-premise or in IaaS. Then using ICS in a browser, you can introspect into the backend application as if it was close to ICS, in fact with this solution ICS is completely oblivious of the location of the actual backend application. The Connectivity Agent will in this case connect internally with the back-end applications and communicate to ICS by pushing out messages via Messaging Cloud Service.

Continue reading “Teaching how to use the Integration Cloud Service Connectivity Agent”

First play with the Oracle Integration Cloud Service (ICS) Scheduler

As of Dec 2016 aka Release 16.4.5, the ICS Scheduler has finally arrived!

You cannot imagine how excited I am! As a regular integrator of SaaS systems, I’ve started noticing a trend where most SaaS softwares offer comprehensive REST/SOAP APIs, but wait… with a catch, they’re all passive. Meaning you can call them to get/put data, but you can’t trigger an activity from them when certain data has changed. Some of my peers have even commented that we’ve gone backwards in time before SOA where everything is batch processed.

Rant aside. To automate integration between 2 “passive” APIs, you will need some form of trigger, preferably a scheduler. ICS has had a scheduler function for File/FTP connectors for a while now. This new function applies on Orchestrations, which means you can pretty much schedule and integrate any connector.

Today I’m going to showcase creating a scheduler that will send SMSes to me every 10min. The SMS gateway is implemented using REST. You can practice this with any connection you can view the response with (Email/Database).

Configuration in ICS

Create a new Orchestration integration.

Continue reading “First play with the Oracle Integration Cloud Service (ICS) Scheduler”

Custom 2-legged OAuth with Oracle Integration Cloud Service (ICS)

Oracle ICS provides OAuth authentication for REST APIs using a curl-like syntax. Given the many implementations of OAuth are not exactly to spec, syntax pitfalls sometimes occur. ICS provides the flexibility configure using regex the values needed to pull out the tokens from the JSON payload.

This flexibility allows us to integrate with the gamut of OAuth-compliant REST APIs in the consumer apps market.

Today, we’re going to use TrackVia (https://developer.trackvia.com/livedocs)

TrackVia is pitched to LOB users as a low-code alternative to spreadsheets, legacy databases and complicated enterprise systems to track, manage and automate critical business processes or operational workflows with greater efficiency, speed and ease.

Continue reading “Custom 2-legged OAuth with Oracle Integration Cloud Service (ICS)”

Teaching how to run ICS APIs from a DevOps perspective

In this blog I am going to show you how to interact with ICS system APIs, in order to simplify the deployment of ICS Integrations being stored and retrieved out of version control repositories (e.g. Git). This can be applied as a Continuous Integration or Continuous Delivery task, removing with this, manual interventions to export, import, configure connectors, activate integrations, run tests, etc.

I am going to be running these APIs via CURL commands and JSON objects, so that these commands can be easily ported into shell scripts, perhaps part of a CI/CD step using Hudson or Jenkins, for example.

Continue reading “Teaching how to run ICS APIs from a DevOps perspective”

Teaching how to integrate with Twilio APIs

In this section we are going to build a simple REST API that calls a “Programmable Voice call and SMS” via using Twilio APIs.

This example is based in one of the samples provided by Twilio (see below).

Original Calling clicktocall-node NodeJS project.

Continue reading “Teaching how to integrate with Twilio APIs”

Teaching how to create an Orchestration in ICS

This section shows you how to use ICS to create an orchestration across multiple service-endpoints. For this, we are going to existing REST APIs for:

  • Post a message to Facebook
  • Post a message update to LinkedIn
  • Updates a Campaign description in Salesforce
  • Creates an event in Google Calendar

Continue reading “Teaching how to create an Orchestration in ICS”

Teaching how to integrate Google Calendar with ICS

This section shows you how to use the Google Calendar ICS Connector that comes out of the box.

Obtain your Google Calendar Connector in ICS

In order to create a Google Calendar Connector you need to get the client id and client secret of the Google Calendar Account you want to connect to. For this:

Continue reading “Teaching how to integrate Google Calendar with ICS”