OIC - Publish to OIC and Subscribe to OIC

Usecase: Here, I will show you how to publish a SOAP meesge to a OIC inbuilt JMS topic and then subscribe message from that topic.

Publish to OIC:
Designer⇾Integrations⇾Create

 Select Publish to OIC Style

 Provide Name and description

 Pulish canvas opened

 Drag and Drop the Trigger SOAP connection. Click here oic-soap-trigger-type-connection for steps.

Provide Endpoint Name and Function details.

Next

Next

Next

Use the Tracking field

Publish to OIC is ready

Subscribe to OIC:
Create

Select Subscribe to OIC Style

Provide Name and Description

Select the Publish integration.

Select the DB connection

Here I choose "Perform an Operation On a Table"

Select Table

Create a Map

Mapping done for each employee

Publish and Subscribe are ready. Just activate

Open the publish WSDL in SOAPUI

Add New basic Authorization

Test

Notes:

1. The messages are pushed to JMS topic that means one published message can be subscribed by more than one subscriber.
2. Suppose we have more than one subcriber and one or couple of subscribes are down, then if we publish any messgae that will be lossed permanently for those inactive subscribers. This is really a reliability concern while using a PUB SUB model in OIC.

OIC - Tracking an Instance

Go to Monitoring⇾Tracking⇾Track Instances

 Open one instance

 Right side corner⇾Action ⇾we can see view audit trails,activity stream,View Errors etc.

 Audit Trail

View Error(sample)

If we set the input payload checkbox while activating the integration, we can also track all input payloads in this section(view activity stream and audit trails sections).

OIC - Create an Integration (Rest to DB data fetch)

Designer⇾Integrations⇾Create

 Select Basic Routing Style

 Provide the Name, package and description

 Integrations canvas opened

Drag the created DB Trigger and invoke type connection in target
Steps to create DB trigger and invoke connection oic-create-db-connection

Provide the name and Run a SQL Statement option.

Provide your SQL query to fetch the department name from department id.

 Validate SQL Query

 Next

 Target is ready

Now drag and drop created trigger rest connection.
Steps to create trigger rest connection oic-create-trigger-type-rest-connection

 Provide the details

 Provide the input field details

 here i selected JSON sample as response

 Provide the response JSON part

 Next

 Source and Target is ready

 Now map the inbound flow

 Map the outbound flow

 Provide Tracking details

 Activate

 Take the endpoint and create a rest project in SOAPUI

 Add the input parameters

 Add Authorization

 Test

OIC - Create Trigger type Rest connection

Designer⇾Connections⇾Create

 Select REST Adapter

 Provide Name and Role as Trigger type

 Test it

 Rest Trigger is created.