Integration to Subscribe to Oracle Integration Cloud Service

In my previous blog, we have learned how to create an Integration that publish the message into ICS queue. Now this blog will show you how to subscribe messages in ICS.

We can create an integration that enables us to subscribe to messages from Oracle Integration Cloud Service. Message subscription is achieved through use of Oracle Integration Cloud Service Messaging.

ICS provides Subscribe To ICS Style pattern that allows us to create an integration that subscribe to ICS queue.

In this blog we have learned to how to subscribe to an integration that publish the message and save the same message into Oracle database table.

Let's go step by step on how to create such type of integration.

• Login into ICS console and Click on Integration tile from the home page
• Click on Create button from upper right corner and select  Subscribe To ICS Style/Pattern

• Enter information in the opened dialog box and click Create button

• Select TEST_Publish integration that we have created in my previous blog and select Use button

• Drag & Drop the TEST_DB_Conn that we have created in one of my blog and drop onto the Invoke

• Enter below information and Click Next
• Enter endpoint name in What do you want to call your endpoint
• Select Run a SQL Statement from What operation do you want to perform drop down

• Enter below insert query in SQL query box and Click Validate SQL query to validate the entered query and Click Next button 

INSERT INTO apps.employee_info(employee_id, first_name,last_name,qualificatoin,designation) values(#employee_id,#first_name,#last_name,#qualification,#designation)

• Click Done
• Click on Map to InsertEmployee mapper and click Add button
• Map the source and target field as shown in the below scree shot. Click Validate and Close button

• Select Action icon and click on Tracking. This is mandatory step and can’t activate integration without this step. Basically this allows us to track the Instance with configured parameter. In our case we will select employeeId field. 

• Activate the integration

Now we are ready with Integration. It's time to publish a message and see the Oracle database. Data should be inserted into the table as we will test the Publish integration.

Test the Publish integration

• We will use the POSTMAN tool to test the integration
• Get the end point URLfor the Publish integration. Click on the info icon and click on the Endpoint URL 

• Open POSTMAN and past the URL
• We have to add Basic Auth as ICS service is automatically secured. We need to provide ICS console credentials.

• Enter payload and hit Submit button

• Open database and check record should be inserted into the database

That's complete the Pub and Sub Integration in Oracle ICS.