Hello Oracle Integration Service

To get a better understanding of the Oracle Integration Service, it’s helpful to examine the sample integrations.

Oracle also provide a way to connect integrations together.

So the 3 sample processes that Oracle provide are:

Hello World — Example describing simple log and notification actions. This sample demonstrates how to use simple log and email notification actions with a REST Adapter in an orchestrated integration. The REST Adapter is triggered when you specify a URL.

Hello World Invoke — Example shows how to call/invoke a simple REST webservice. This sample demonstrates how to call and invoke a simple REST web service in an orchestrated integration. The REST Adapter is triggered when you specify a URL. The Hello World REST Adapter you previously used in the Hello World sample is invoked in the integration.

Hello World Map Data Invoke — Example shows how to call/invoke a simple REST webservice using Map Data pattern. This sample demonstrates how to call and invoke a simple REST web service using the Map Data integration pattern. The REST Adapter is triggered when you specify a URL. The Hello World Invoke REST Adapter is invoked in the integration.

Together the samples showcase the following:

• how one integration can connect and pass information to another.
• the 2 different methods of calling a simple REST webservice.

We will setup the Hello World Invoke integration to connect to the Hello World integration.

Also we will setup the Hello World Map Data Invoke integration to connect to the Hello World integration.

Let’s see how this works.

The Hello World integration

The Hello World integration needs to be setup first as the other 2 integrations (ie Hello World Invoke, and Hello World Map Data Invoke) will connect to it.

This means that the Hello World integration will be a dependency for the others. ie Hello World Invoke, and Hello World Map Data Invoke.

So after the Hello World integration is activated, you’ll see the status marked as active.

A description of the process flow of the Hello World integration is as follows:

This sample demonstrates how to use simple log and email notification actions with a REST Adapter in an orchestrated integration. The REST Adapter is triggered when you specify a URL. A switch activity with two rules is defined. If you provide an email address and name when triggering the REST Adapter, a browser response and email response are sent to you. If you provide only a name when triggering the REST Adapter, only a browser response is sent to you. With either switch rule, a logging message is created and logged to the activity stream for viewing.

It’s also helpful to see the process flow of the Hello World integration as a visual. Selecting the view option from the integration will return this.

The integration features a REST adapter:

A REST Adapter is configured as a trigger (inbound) connection in the integration. The REST Adapter is configured with a resource endpoint of /names{name} and a GET operation. The REST Adapter is triggered when you specify the URL in How to Run.

More details of the branches of the Hello World integration is as follows:

A switch activity with two rules is defined:

If an email address and name are provided in the invocation URL (upper rule), a logging message is created and logged to the activity stream and a notification action is configured with parameters for your name and email address. The message body of the email is also defined in the notification action. A browser response and email response are sent to you.

If only a name is provided in the invocation (lower rule), a logging message is created and logged to the activity stream. A browser response is sent to you.

Of course the best way to understand the operation of the Hello World integration is to perform a test.

Clicking on the test button will return a response.

By default there is no email address, so we don’t receive an email from the integration.

However there is a response similar to what the contents of the email would be.

{
  "Hello" : "{name}",
  "Message" : "\"Welcome to OIC!!!\"",
  "Email" : "\"Email address was not provided.\""
}

So if I provide a name (eg Santa Clause) and legitimate email address, then press the test button, I get an email like this:

In summary, we have tested the Hello World integration, and we know if a legitimate email is specified then we receive an email.

The Hello World Invoke integration

The next stage in our journey through the Integration service is to connect the Hello World Invoke integration to the Hello World integration.

When we try to activate the Hello World Invoke integration, we get the following warning.

Before you can activate and run this sample, you must configure the connection and security properties of the Sample Hello World Invoke REST Adapter used in this sample.

We need to create a connection.

This is easy to do from the Connections menu.

Click on ‘Sample Hello World Invoke’.

Now enter the Connection URL, but specify the real hostname and port of the Hello World sample.

The URL will resemble something similar to the following:

https://<<<servername>>>.integration.ocp.oraclecloud.com:443/ic/api/integration/v1/flows/rest/HELLO_WORLD_INVOKE/1.0/metadata/swagger

Then in the security section, enter your cloud credentials.

Important — your username will be the full user name (eg full email address)

Now proceed to save the connection configuration.

When you save you’ll get a confirmation.

Now it’s possible to activate the Hello World Invoke sample integration.

Once ready, both the Hello World and Hello World Invoke sample integrations will be active.

Looking at the steps of the flow of the Hello World Invoke integration:

We can see that there is a reference to the Hello World integration.

Now we can go through the previous steps as for the Hello World integration to test the Hello World Invoke integration.

If all is well, then we will receive the same email.

The Hello World Map Data Invoke integration

With the 2 previous integrations enabled, there is one more to go.

The Hello World Map Data Invoke integration needs to be connected to the Hello World integration.

Then the Hello World Map Data Invoke integration can be activated, and tested.

Putting it all together through a browser

So we should have the following setup with the 3 sample integrations activated.

Now we can trigger each one to execute, as they should through a browser.

Hello World

In your browser, you’ll enter something similar to this:

https://<<<servername>>>.integration.ocp.oraclecloud.com:443/ic/api/integration/v1/flows/rest/HELLO_WORLD/1.0/names/Santa?flowid=&email=santa%40gmail.com

For security purposes you’ll be asked to login with your cloud credentials.

You’ll then get this result in the browser:

And this email arrives in your inbox.

Hello World Invoke

With the Hello World Invoke integration connected to the Hello World integration, we will trigger the integration in a similar same way.

https://<<<servername>>>.integration.ocp.oraclecloud.com:443/ic/api/integration/v1/flows/rest/HELLO_WORLD_INVOKE/1.0/info?name=Santa&email=santa%40gmail.com

Need to login again, if your browser did not cache your credentials from before. You will now get this response in the browser:

And this email arrives:

Hello World Map Data Invoke

With the Hello World Map Data Invoke integration connected to the Hello World integration, we will trigger the integration in a similar same way as before.

https://<<<servername>>>.integration.ocp.oraclecloud.com:443/ic/api/integration/v1/flows/rest/HELLO_WORLD_MAP_DATA_INVOKE/1.0/info?name=Santa&email=santa%40gmail.com

Then get this in the browser:

Then in your inbox:

With the Oracle Integration service it’s clear all your Christmases come at once!

Paul Guerin is an international consultant that specialises in Oracle database. Paul is based from a global delivery center in South East Asia, but has clients from Australia, Europe, Asia, and North America. Moreover, he has presented at some of the world’s leading Oracle conferences, including Oracle Open World 2013. Since 2015, his work has been featured in the IOUG Best Practices Tip Booklet, and in publications from AUSOUG, Oracle Technology Network, Quest, and Oracle Developers (Medium). In 2019, he was awarded as a most valued contributor for the My Oracle Support Community. He is a DBA OCP, and continues to be a participant of the Oracle ACE program.