Create and Manage Integrations(Integrations) >> ICS / OIC
Launch the design-time environment for integrations. Create and activate integrations, as well as their connections and orchestrations. work with look ups, packages, agents, and adapters.
Build Automated Process Applications(Process Biulder) >> PCS
Launch the design-time environment for process applications. Create process applications from scratch or by using quick start apps. Model processes in the process editor, and create web forms and decisions. Perform design-time administration such as playing, testing and deploying applications.
Develop Web & Mobile Applications(Visual Builder) >> VBCS
Create and publish web and mobile applications.
Use cases:
SAAS to SAAS:
All cases created in Salesforce are being synchronized with ServiceNow as incidents.
SAAS to On-Premise:
Update of opportunities in Salesforce propagated to on-premise Order Management.
Aspects of OIC Integrations:
Connections:- Connections define information about the instances of each configuration you are integrating.
- OIC includes a set of predefined adapters, which are the types of applications on which you can base your connections such as Oracle Sales Cloud, Oracle Right Now and others.
- A connection is defined as any endpoint(Source or target) that is implemented within an integration flow. These connections are based on defined adapters.Adapters allows for easy connectivity to applications. insulating the developer from complexities that can occur when interacting with an application.
- OIC includes different kind of adapters like Oracle adapters, Non Oracle adapters, Technology specific adapters and social networking adapters etc.
Integrations:
- Integrations are the main ingredient of a oracle integration cloud. An integration includes at least a trigger(source) connection (for requests sent to Oracle Integration Cloud) and invoke (target) connection (for requests sent from OIC to the target) and fields mapping between those two connections.
- Integrations are processes that utilize connections to implement a business process. Using drag and drop capabilities, an integration can easily be defined. The functions defined within the VETO(validate, Enrich, transform and operation) integration design pattern are available for implementation.
Prebuild Integrations:
Apart from developing your own integrations in Oracle ICS, one can also leverage integrations build by others.
Lookups:
- Use lookups in your integrations to create reusable tables that map the different terms used to describe the same item across your applications.
- A bit like DVMs in SOA Suite, can cross-reference values of the same attribute/element when mapping from one system to another.
Packages:
Packages allow for grouping of integrations,providing the abilities to import and export packages between environments.
Agents:
Agents are used to connecting to On-premise applications, For example, if you are using On-premise systems like ERP/SAP and also using Oracle OIC in the same implementation, you would have to use an agent to connect to the OIC application. Two types of ageents arw available:
- Connectivity agent
- Execution agent
Libraries:
Libraries is a file or a collection of multiple files bundled in a JAR containing JavaScript functions. Library is used within an Integration and is executed by a JavaScript engine on the server as a part of integration flow.
Adapters:
Use an adapter to connect to an application in your integration. Oracle adapters are ready to use and pre-built block of code for the specific technology.
Basic Integration flow:
Integration patterns or styles:
App Driven Orchestration
Create an integration that uses an event or a business object to trigger the integration. For example, you create an integration with an Oracle RightNow Adapter as a trigger and an Oracle Engagement Cloud Adapter as an invoke. The Oracle RightNow Adapter subscribes to an event from the Oracle RightNow application to trigger the integration.
Orchestration integrations include features such as the following:
- Switch activities to create multiple routing expressions.
- For-each activities for looping over repeating elements.
- Assign activities for assigning values to scalar variables.
- Ad-hoc mappings on switch branches.
- Callback activities (to end a process and respond back to the sender) and end activities (to end a process without responding back to the sender) in asynchronous integrations.
Scheduled Orchestration
Create an integration that uses a schedule to trigger the integration instead of an adapter. For example, you add an initial invoke adapter to read a trigger file and a second FTP adapter to download the file for further processing. After designing this integration, you schedule when to run it.
File Transfer
Create an integration to move files across a network.
Basic Routing
Create an integration with a blank trigger and invoke in which to add your own adapters. You can also create a single routing expression and request and response enrichments, as needed. You cannot create multiple routing expressions. If your integration requires this feature, create an orchestrated integration.
Publish to OIC
Create an integration in which you add a trigger adapter to publish messages to Oracle Integration through a predefined Oracle Integration Messaging invoke. No configuration of the invoke subscriber is required.The publisher and subscribers participating in this integration pattern can be activated and deactivated independently of each other.
Subscribe to OIC
Create an integration in which you add an invoke adapter to subscribe to messages from Oracle Integration through an Oracle Integration Messaging trigger. You are prompted to select the publisher to which to subscribe. You must have already created a publisher to which to subscribe. The publisher does not need to be active, but must already be completely configured.
Any business identifiers defined on fields in the published integration are copied to the subscriber. Any changes made to the published integration’s business identifiers after copying are not reflected in the subscriber. The publisher and subscribers participating in this integration pattern can be activated and deactivated independently of each other.
Mapper:
A Visual Mapper is provided that enables you to map fields between applications with different data structures by dragging source fields onto target fields.
Monitoring:
OICS dashboard displays information about the current sate of all running integrations, successful messages ratio, connections etc.
Check all Oracle Services:
https://www.oracle.com/cloud/free/
Register for oracle cloud:
https://myservices.us.oraclecloud.com/mycloud/signup
With Oracle subscription:
- 30 days free trial having $300free credits.
- Access to a wide range of Oracle cloud services for 30 days including database, analytics compute and container engine for kubernates
- up to eight instances across all available services.
- up to 5 TB of storage,
- Autonomous transaction processing or autonomous data warehouse 2 database total each with 1OCPU and 20 GB storage.
- 2 block volumes 100 GB total, 10 GB object storage 10 GB Archive storage,
Select Basic Routing Style
Provide the Name, package and description
Integrations canvas opened
Drag the created DB Trigger and invoke type connection in target
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.
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
