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.

scheduler1

Select Schedule as the Trigger.

scheduler2

Select the connector that you want your scheduler to kick off and drop it between Schedule and the end-point.

schedule3

schedule4

The configuration screen pops up. I entered the values for my REST connector, which requires a POST and a payload of what to be texted and clicked [Next].

schedule5

My REST API requires a JSON payload so I am going to paste in a sample JSON.

schedule6

schedule7

Now to do some mapping. Select the SendSMS map.

schedule8

I pop open the mapper and drag a “concat” function to merge 2 strings.

Using String1 = “Scheduled SMS at:” and drag over startTime (with comes with the Scheduler) as the 2nd string.

schedule9

I map a phone number into “to” and this is my final mapping.

schedule10

To complete the integration, I will need to setup a tracking field.

schedule11

Save and exit the integration. I’m turning on tracing as I’m in Development Mode.

schedule12

You can now choose to “Activate and Schedule” or Activate and add it later. I’ll select “Activate and Schedule”. The Orchestration is activated and I can select the frequency.

I’ll select every 10min to quickly see some output.

schedule13

Exit the Scheduler

schedule15I select [Start Schedule] and now all my future runs are displayed. You can pause the scheduler at any time. For adhoc runs click on [Submit Now].

schedule16

Click on Past Runs to see what has occurred. You can view Messages around the run or if an error has occurred, re-submit the run.

schedule17

Keen to play more? Goto https://cloud.oracle.com/integration and hit [Try It] to get a trial account.

 

 

Author: Serene Tan

I'm a Cloud Solutions Architect for Oracle based in Melbourne. My focus is our Platform-as-a-Service (PaaS) offerings.

One thought on “First play with the Oracle Integration Cloud Service (ICS) Scheduler”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s