Showing posts with label Oracle ICS webservice. Show all posts
Showing posts with label Oracle ICS webservice. Show all posts

Wednesday, February 17, 2016

Invoke Web service hosted at Oracle Integration Cloud Service (ICS) using SOAPUI - Part 2

This post is in continuation with my previous post, you can find the part 1 here

Let's continue with steps

Step 5:
This will open a new Pop up, Select Basic, then click on OK.

Step 6:
Provide your Username and Password.

Step 7:
Now Right Click on the Request tab. You will see a window similar to below. Select 'Add WSS Username Token'

Step 8:
Select 'Password Text' and Click OK. This will add a Security Header in your Request.

Step 9:
Now again Right Click on Request Tab. Then Select "Add WS-Timestamp"

Step 10:
Select 60 in new pop up window Then click Ok. 
This will Add Timestamp to your request

Step 11:
Now click on Test button, to execute the request. This button is highlighted in yellow 

Step 12:
Thats all, you will receive the response from your ICS service

Congrats !, You have successfully invoked Web service hosted at Oracle ICS

For More Integrations and Design patterns, Please refer to My Other posts on ICS webservice integrations

1. Integration using Oracle ICS - Source ( Webservice ) to Target (Webservice)

2. Oracle Integration Cloud Service (ICS) - Monitoring and Tracking Messages & Errors

3. Oracle Integration Cloud Service (ICS)

Integration using Oracle ICS - Source ( Webservice ) to Target (Webservice) Part 2

This post is in continuation with previous post, you can find part 1 at

Lets continue with steps :

Create Integration using Source and Target Connection, Create Mapping:

Navigate to Integrations Screen and Click on 'Create New Integration'
A Screen similar to below will be seen

Step 1 :
Select 'Map My Data'. Screen shown Below will appear. Provide Name of the Integration and Click Create.

Step 2 :
Now Drag and Drop connections from Right Side Pane to Source .A screen as below will be shown. Provide Name of your Source, Then Click Next

Step 3 :
Select Operation from Available Operations. Then Click Next. As Shown below

Step 4 :
Verify the Summary, and Click Done

Step : 5
A Screen as shown below will appear.

Step 6:
Repeat Step 2 to Step 4 for Target connection. A Screen as below will appear

Step 7:
Now Click on 'Create Map' A + button will appear. Click on it, as shown below

Step 8:
You will be naviagated to Mapper Screen. Create a Source to target Mapping by Drag and Drop.
As Shown below

Step 9 :
Click on Save, and Exit Mapper. Shown below

Step 10:
Repeat Step 8 and Step 9 for Response Mapping.
A screen as below will be shown

Step 11:
Now Click on Tracking to add any field for Audit and tracking purpose. Then click on Done.
Shown below

Step 12 :
Now Click on save and Exit Integration Editor.

Step 13:
Now Click on Activate to deploy your integration.

Step 14:
Select tracing checkbox to Enable Deep data tracing.

This is all, We have successfully created and Deployed our integration using Oracle ICS.

More Learnings on ICS

1. Oracle Integration Cloud Service (ICS)

Wednesday, February 10, 2016

Oracle Integration Cloud Service (ICS) - Monitoring and Tracking Messages & Errors

In this post I am going to discuss about the Monitoring & Message tracing functionality of the Oracle Integration Cloud service (ICS).

Before we begin, Here are few previous posts on ICS which may interest you :

1. Oracle Integration Cloud Service (ICS)

Let's Start with Monitoring of ICS:

Login to your ICS portal, you will see a homepage similar to this

Click on Monitoring, this will navigate to Dashboard. you will see a dashboard similar to below

Dashboard contains monitoring information about your active integrations. Last 3 days data is available for these integrations.
Monitoring Data presents various insights about the integrations and their Runtime behaviour.
At the Bottom, there are two Tabs, Integrations (It list all Integrations, shown in above Screen), Activity Streams (It list recent transactions at Source request, target request, response etc with Instance ID, Shown in Below Screen)

Now, we will take a look at Tracking Tab.

You remember, while designing a integration, we had added input field for tracking purpose. Tracking Tab keeps details like InstanceID, Time of Request, Status, Value of Tracking field etc.

Now if you want to dig down a particular instanceID, Click on the Source Field, It will open a graphical representation of that IntanceID. Shown Below

Now if you want to see your Business Identifiers, which was added during Integrations design, Click on the Business Identifiers button at top of Screen,

If you want to See a Audit trail of Message flow, Click on 'Actions' on top right corner, then Select 'View Audit trail', It will show trail of message flow like below

Lets head back to Dashboard, Now if you want to look for any failed or Errored out instance, Click on the Error as shown below. 

 One of the Legacy Logs like feature is also included in ICS. Since we are familiar with Logs in Weblogic Servers and SOA systems. If you want to download Logs of the Integrations and Instances. Go to Dashboard. Now open 'Activity Stream' Tab at bottom. Here you will find a option to Download Logs.

These Logs are Legacy Weblogic Style logs.
Since Oracle ICS uses Oracle Service Bus 11g at Backend for Integrations, Hence these logs are similar to OSB tracing Logs.

Tuesday, February 09, 2016

Invoke Web service hosted at Oracle Integration Cloud Service (ICS) using SOAPUI

In this post we will invoke a Web service using SOAPUI, The web service is hosted at Oracle Integration Cloud Service (ICS).

If you want to go through the the Introduction of Oracle ICS, refer my previous post at:

1. Oracle Integration Cloud Service (ICS)

2. Oracle Integration Cloud Service (ICS) - Monitoring and Tracking Messages & Errors

3. Oracle Integration Cloud Service (ICS) - Monitoring and Tracking Messages & Errors

Lets start with testing steps for ICS web service.

Note: Since Oracle ICS is publically hosted cloud at Internet, hence ICS webservice will always be a secured service i.e. protected by some security policy.

There could be two possible ways, how you get a web service hosted Oracle ICS.

Scenario 1: 

Some target system provides you the WSDL and WSDL URL of target service and Security credentials. This service is not developed by you.
You can also download wsdl from URL given. A URL will look something similar to below one

Scenario 2 : 

You have created a Integration using Oracle ICS, either for Demo purpose or Actual Integration.
Here are steps to Get the WSDL URL from your ICS designer portal.

Step 1:
Login to your Oracle ICS portal. Home page look similar to below. Click on Integrations

Step 2:
Locate your Integration (In  previous Post we created, Demo_Airport_Integration). Click on the 'i' button located at right side of screen in the same box as your integration. A pop up window will appear. Copy the Endpoint URL from pop up window.

Now lets start with creating a project in SOAPUI. (Recommended SOAPUI version is 5.2.1)

SOAPUI testing :

Step 1:
Launch SoapUI, Click on File --> New SOAP Project. This will launch new project wizard

Step 2 :
Provide Project Name, and enter WSDL URL in 'Initial WSDL' field.
Then Click OK button. This will take sometime to download to WSDL and create a new project.

Step 3:
Click on the 'Auth' Button at Bottom of the request tab. This will open a small window at bottom.

Step 4:
In the newly opened wind at bottom, Select 'Add New Authorization' from drop down against authorization.

Saturday, February 06, 2016

Oracle Integration Cloud Service (ICS)

1          Introduction

Oracle Integration Cloud Service (ICS) is a simple and powerful integration platform in the cloud to maximize the value of organizations investments in SaaS and on-premises applications. Oracle Integration Cloud Service is Oracle's integration platform as a service (iPaas) and includes an intuitive web based integration designer for point and click integration between applications, a rich monitoring dashboard that provides real-time insight into the transactions, all of it running on a mature runtime platform on Oracle Cloud.
Oracle Integration Cloud Service simplifies development of integrations between your applications in the cloud and between applications in the cloud and on premises, all without needing to write code or install and manage infrastructure or middleware.

2        Features

With Oracle Integration Cloud Service:
 • Connect securely to applications and services in the cloud and on premises
• Point and click to create integrations between your applications with a powerful browser-based visual designer—it even runs on tablet
• Select from a growing list of integrations built by Oracle and Oracle partners
• Monitor and manage your integrations
• Manage errors

3        Development Lifecycle

With Oracle Integration Cloud Service quickly develop and activate integrations between the applications. Major steps are:
• Configure Adapters - The first step in integration design is to identify the applications which needs to integrate, and then configure the connection details.
• Design Integrations - After adapters are in place, create integrations by dragging and dropping those adapters into the designer. Designer is similar to MFT 12c and Jdeveloper SOA Designer.
• Map Data – After Design, Use the graphical Mapper (Similar to XSLT mapper) in Oracle Integration Cloud Service to map data between applications. After mapping, integration is ready to activate. This also supports Lookups similar to x-ref.
• Monitor Runtime – Oracle Integration Cloud Service has Dashboard to view stats that gives details of integrations running. This can be used to pinpoint bottlenecks, monitor errors, and see details for each running integration.

4       Common Design Examples

Oracle Integration Cloud Service caters to various key integration use-cases spanning across SaaS and on-premise applications.
Some of the common Examples, which can be addressed using Oracle Integration Cloud Service:
• Oracle Marketing Cloud sends a notification that a lead has become an opportunity for Oracle Sales Cloud.
• Oracle Sales Cloud publishes a customer-created event, and Oracle Service Cloud and Oracle Marketing Cloud subscribe to these events.

5        How to Get Start

Getting started with the Oracle Integration Cloud Service, can be broadly divided into three steps:

• Subscribe – To get start with Oracle Integration Cloud Service, Subscription of the service is required. There are various options available for the subscription.

• Learn – There are various documentation available at Oracle website at location

• Do – Features available with the this steps
•         Start Integration Cloud Service
•         Create connections
•         Create integrations
•         Map data
•         Create lookups
•         Monitor integrations

For More Integrations and Design patterns Please refer to My Other posts. ICS webservice integration post at 

1. Integration using Oracle ICS - Source ( Webservice ) to Target (Webservice)

2. Oracle Integration Cloud Service (ICS) - Monitoring and Tracking Messages & Errors

3. Invoke Web service hosted at Oracle Integration Cloud Service (ICS) using SOAPUI

Integration using Oracle ICS - Source ( Webservice ) to Target (Webservice)

Lets Start with Oracle ICS

The High Level Steps are :
1. Create Target Connection
2. Create Source Connection
3. Create Integration using Source and Target Connection, Create Mapping.
4. Activate your Integration.

Login to Your ICS account at using your ICS credentials

Once you have successfully Logged In, Below screen will be shown

Create a Target Connection :

Step 1 :
Click on "Create Connections", You will see next Screen as Below 

Step 2 :
Now Click on 'Create New Connection' at Right Hand Side of Page, This will take you to Connection creation Wizard.

Step 3 :
Select SOAP, since we are creating a connection to Target Service which is a SOAP Web service 

Step 4 :
Provide name of this Connection, then click on Create button

Step 5 :
A screen like below will be visible. 

Step 6 :
Now Click on 'Configure Connectivity'. 

Step 7 :
New screen will ask you for WSDL file. Either upload a WSDL file from your Local machine or Provide a WSDL URL available on web.Then Click OK.

Step 8 :
Now Click on 'Configure Credentials' If you Target service is Secured then Provide Credentials. For this Demo, Target Service is not Secured hence I will choose 'No Security Policy' Then Click on OK.

Step 9 :
Now click on Save .

Step 10 :
Now Click on Test button, to test your target connection. If you have provided all details correctly. You will see a screen as below :

Step 11 :
Now Save all changes, and exit from connection. Your connection to Target is created.
Target Connection Name for this Demo is Demo_Airport_001.
A Screen Similar to below will be shown.

Create a Source Connection :

Now follow Same Step1 to Step 10, to Create a Connection for Source. 
Only with a change at Step 4 - Give Different Name 
E.g Demo_Airport_001_ Source

A screen similar to below should be seen.

Continue reading the Steps of this Post in Part 2 at below location

Integration using Oracle ICS - Source ( Webservice ) to Target (Webservice) Part 2