Monday, December 2, 2019

OIC - App Driven Orchestration Integration Style

Here I will show you the following:
  • Use of App Driven Orchestation Style
  • SOAP connection to DB Insert
  • Create a assign variable and store Country code-name using lookup
  • Enrich calling REST service (get department name from Department id)
Designer⇾Integrations⇾Create
Choose App Driven Orchestration style
Provide the name and package details

Drag and drop the soap connection






Drag and drop the db connection







Add a For Each


Re-position the components

Map


Do the instance tracking

Activate and test





Now create a variable and map the country name from country code using lookup
















Map the assign variable for country name







activate and test

Now drag and drop REST service








Map the input for department id

Map the output as Department Name


Done and now activate and test.

No comments:

Post a Comment

Featured Post

End to End Securing Data in Oracle Integration Cloud (OIC) with OCI Vault: AES for Encryption & Decryption & RSA for Signing and verification | Implement message-level encryption in Oracle Integration using OCI Vault

Scenario: A company is integrating Oracle Integration Cloud (OIC) with an external financial system to exchange sensitive payroll data secur...