Oracle Integration Cloud Service (Part 2 of 3)
In our previous post we showed the main characteristics of Oracle ICS, now we will learn how to publish a cloud integration service.
In our next post we will learn the integration of Taleo and PSFT. I am preparing this and I will publish it as soon as it is ready. Right now, lets do a simple example.
Lets consider that we have a need to call a service in the cloud and that we want to do it through Oracle ICS.
The first thing we need to do, is to identify the type of service / application that we need, since Oracle ICS offers a series of adapters that simplify the integration. Such adapters available as of today are the following:
- Oracle Sales Cloud
- Oracle Messaging Cloud Service
- Oracle Eloqua Cloud
- Oracle HCM Cloud
- Salesforce Cloud
- Oracle ERP Cloud
- Oracle CPQ Cloud
- Oracle SOAP Adapter
- Oracle REST Adapter
- Oracle NetSuite Cloud Adapter
- Integration Cloud Service Messaging
- Oracle FTP Cloud (in Using Oracle FTP Cloud Adapter)
- Oracle Google Calendar Cloud (in Using Oracle Google Calendar Cloud Adapter)
- Oracle Google Task Cloud (in Using Oracle Google Task Cloud Adapter)
- Oracle Siebel Cloud (in Using Oracle Siebel Cloud Adapter)
- Oracle E-Business Suite Cloud (in Using Oracle E-Business Suite Adapter)
- Oracle Database Cloud (in Using Oracle Database Cloud Adapter)
- Oracle SAP Cloud (in Using Oracle SAP Cloud Adapter)
- Oracle Evernote Cloud (in Using Oracle Evernote Cloud Adapter)
- Oracle Eventbrite Cloud (in Using Oracle Eventbrite Cloud Adapter)
- Oracle LinkedIn Cloud (in Using Oracle LinkedIn Cloud Adapter)
- Oracle Facebook Cloud (in Using Oracle Facebook Cloud Adapter)
- Oracle Commerce Cloud (in Using Oracle Commerce Cloud Adapter)
- Oracle Twitter Cloud (in Using Oracle Twitter Cloud Adapter)
- Oracle Gmail Cloud (in Using Oracle Gmail Cloud Adapter)
- Oracle Microsoft Email Adapter (in Using Oracle Microsoft Email Cloud Adapter)
- Oracle Microsoft Contact Adapter (in Using Oracle Microsoft Contact Cloud Adapter)
- Oracle Microsoft Calendar Adapter (in Using Oracle Microsoft Calendar Cloud Adapter)
- Oracle MySQL Database Adapter (in Using Oracle MySQL Database Cloud Adapter)
- Oracle MailChimp Adapter (in Using Oracle MailChimp Cloud Adapter)
- Oracle SurveyMonkey Adapter (in Using Oracle SurveyMonkey Cloud Adapter)
- Oracle RightNow Cloud
As you can see, there is a large list of connectors right now that provided by Oracle ICS. Applications such as Oracle Right Now, Oracle Siebel and Oracle EBS can be easily integrated with this cloud integration platform.
We will make the most basic example for the rest of the integrations.
Lets use the following public web service:
This is a web service that functions as an on line dictionary. Yo place a word and it returns different dictionaries definitions. In particular we will use the Define. operation
The first thing we need to do is to register it in Oracle ICS.
Once we click on create connection, we will see the following screen:
Select SOAP and once done we will receive the request about how we want to name it:
After this, we only need to configure the WSDL connection and since this WS does not request credentials for its use, we will need to specify that it does not request authentication. We will do it in the following screen:
Of the first button:
Of the second button:
Now we can save our connection and test it. We will do this by using the buttons at the top right side:
Once we Save and Test, we will see that the connection is at al 100%
Now we will create an integration, what we need to make is that Oracle ICS is the mechanism to invoque the Dictionary service. As simple as it is.
To do so, lets go to the integrations section and create one:
Once we click in the right button we sill see the following:
Lets use the one named Map My Data. This will take us to the following screen. Simply lets name our integration service, for example:
Once we click on create, it will take us to the following canvas:
Lets place our connection in both sides. I. e. in the source and the target. As I previously mentioned, the only thing we have to do is that Oracle ICS permits the communications with the web service and this will permit us to consult the definitions in the dictionary. As it is established in the Oracle Service Bus wording, I am publishing the proxy that recall a Business. Just that, lets keep it simple right now.
To make this, simply drag our connection in both sides of the canvas and follow the assistant instructions in both cases. As you will see, it is searching in the WSDL and showing us the available operations. Lets select only one.
Here is where we select the Define operation:
We will get a summary:
And finally we will se the integration as follows. This once we make the drag and drop in both sides of the canvas:
We only have to do the corresponding mappings between the source and the target- In this simple example. all the mappings are made one to one.
Lets make the first one by clicking on the first transformation:
The second one is a little bit more complex since we need to use an expression for-each to recover the definition of each one of the dictionaries that the WS offers us.
During these configurations, we can see the status that appears above in the right side advances, showing us the advance to have the integration ready:
Once the mappings are finished, we only need to enable the Tracking, this button is in the top right side. This will permit us to have the visibility of the messages and in some instance be able to identify any problems.
Once the integration is at 100%:
we can continue with the integration and testing.
The activation is done by clicking in the following button:
To test it, simply click in the icon
and recover the WSDL of this integration service:
Lets go to the SOAP UI and place the el WSDL to test it. We will see something like this:
All the services shown by Oracle ICS are protected with WSS, so it is necessary to add the credentials token and the time mark.
The access message will be as follows:
To add both entries, simply right click in the request space and there you will be able to add both or make it manually which is also valid.
Once you make this, simply select a word to search in the dictionary and you will see how the ICS recovers it for you. We will use: Tree. this is what it will respond:
It is as simple as this to integrate with Oracle Integration Cloud Service.