Simple App Orchestration flow with Oracle Integration Cloud

I want to demonstrate how easy is to create an App Orchestration flow with Oracle Integration Cloud Service. The flow will be very simple: every time a new temperature record is created into a database table, it will trigger a flow that will notify by email if the value of the temperature is over 30 degrees.

Oracle Cloud Trial

Log into the Oracle Cloud account and see the dashboard

Prepare the database

After having created a database cloud service go to the console and
take note of the public ip address and the connect string

Connect to the database through the SQL Developer

Create a table called CLAVEVALOR to store temperature data with and
status column ESTADO

Remote Agent Installation in DBCS VM

In order to capture database changes we need to install a remote agent
into the database VM.

Having already created "Autonomous" Integration Cloud Service (ICS)  
version 18.4.1.181017.0400-1756 , let's go to ICS console > Integrations

From here we will go to Agents menu for creating the agent group and
to download the agent needed to set up remote capture from the DBCS table
modifications

Create a database agent group.

https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user
/creating-agent-group.html

Download and install the remote agent installer into the DBCS VM

https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user
/downloading-and-running-premises-agent-installer.html
#GUID-3F36A9CE-BE4E-4A74-AE7E-C6005CC97A12

Copy the agent to the DBCS VM

Access to the DBCS VM through SSH connection and unzip
oic_connectivity_agent.zip

In the DBCS VM configure the InstallerProfile.cfg with the integration
cloud service information

Run the connectivity agent Agent Installer as a Background Process

https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user/
downloading-and-running-premises-agent-installer.html
#GUID-57125700-B6D9-472F-B8BE-248C6A3DD5E4

After installation, agent appears linket to the  gent group

Create connections

Connections already created

Oracle Database Cloud Service connection with the connection properties,
security user and agent group to capture database changes

Create the integration

Create an App Driven Orchestration integration style

Notification configuration

Database changes configuration

Basic info and next

Polling information indicating table to take into account and the review
polling strategy

Polling strategy and frecuency

Testing the integration

Inserting a new value into the table as unprocessed record

Record is inserted with unprocessed status

Once the polling frequency is accomplished the new record is processed

The temperature is over 30 degrees so an email is sent to my account
alerting about that circumstance.