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