OIC - Publish to OIC - Publish and Subscribe to Oracle Integration - Part-1

Aamir June 30, 2021

 
Publish to OIC

Introduction

Publish/subscribe or the pub/sub messaging is an a synchronous communication architecture

 

In a pub/sub model, any message published to a topic is immediately received by all of the subscribers to the topic. 

 

Publisher publish a message and all the subscribers subscribes to a publisher.

Oracle Integration provides a simple and managed solution for pub/sub communication. OIC provides “ICS Messaging Service Adapter” with quick configuration to achieve the objective.

 

And integrations that enable subscribers to subscribe to messages from Oracle Integration.

 

I will explain here with simple steps to build integrations that enable us to publish messages to Oracle Integration and as well subscribe to OIC

 

We will create 3 integrations

 

  •      Publish to OIC in this article 
  •      First Subscribe to OIC for FTP File creation
  •      2nd Subscribe to OIC Database Insert on-premise database


Publish to OIC will be a simple rest end point to push message to OIC. And IC Messaging service will take care of the rest.

Subscribe to OIC integrations which will use above Push integration and received the payload and consume respectively

 

Lets Implement Pub/Sub Integration in 3 Steps

1. Create a REST Connection

We will use a REST request as the Publisher.
 

Create a simple REST connection with trigger role

 From the connections under the Integration home page, click create

Connections

Creating connection - selecting adapter


REST connection

 

2.  Create an Integration.


From the Integrations, under the Integration home page, click create


We will select the Type Publish To OIC, which has the required structure ready.

Integration style

Enter the basic integration details

 

create new integration

Configure the REST endpoint details.

REST endpoint - Basic info


Select method as PUT and specify the rest document

REST Endpoint - Resource Configuration


select the Payload type as JSON and select <<<<inline>>>>

RESTT Endpoint - Request

{
  "PartyNumber" : "67895432541",
  "OrganizationName" : "CustomerA",
  "PartyUsageCode" : "EXTERNAL_LEGAL_ENTITY",
  "RawPhoneNumber" : "9199199199",
  "EmailAddress" : "bm@oracle.com",
  "URL" : "www.oracle.com",
  "Address" : [ {
    "AddressType" : "BILL_TO",
    "Address1" : "500 Oracle Parkway",
    "City" : "Redwood Shores",
    "Country" : "US",
    "County" : "San Mateo",
    "PostalCode" : "94065",
    "PostalPlus4Code" : "",
    "State" : "CA"
  } ],
  "CorpCurrencyCode" : "USD",
  "CurcyConvRateType" : "Corporate",
  "CurrencyCode" : "USD",
  "DUNSNumber" : "123456789"
}


Copy above sample JSON sample payload and put as below screen


Enter sample JSON

Review and Click Done.

REST Endpoint - Summary

Integration is done. You will see the integration as bellow.

REST connection is at the left side and automatically configured to IC Messaging Service

No need further configuration or any mapping

Just close and come back to main integrations grid.

integration grid

3. Activate Integration

Now lets activate it. select Enable tracing and include payload and select Activate  

Activating Integration


Our Push to OIC integration is completed.

In next step, we will create 2 simple Subscribe to OIC integrations which will use above Push integration and received the payload and consume respectively

In this 2nd article we will create one Subscribe to OIC integration for FTP file creation

Subscribe to OIC - FTP file Creation - Publish and Subscribe to Oracle Integration - Part-2

In 3rd article we will create 2nd Subscribe to OIC integration for inserting same data in a database table, for this we will use OIC Agent to connect to on premises EBS database

Subscribe to OIC - Database On-premise - Publish and Subscribe to Oracle Integration - Part-3

Thank for reaching to my blog. for further information please visit below oracle library 

Create Integrations to Publish and Subscribe to Oracle Integration


Tags:

Post a Comment

0 Comments

Post a Comment