1.) What is Oracle Integration Cloud (OIC)?
Oracle Integration Cloud is a PaaS provided by Oracle under the purview of Its OCI (Oracle cloud infrastructure). It allows integrating multiple systems like SaaS, Cloud or On-premise systems. It can support integrating Oracle or Non Oracle systems. It is a up to date product that supports Adapter based or API based connections. It is best solution for variable demand as the billing is based on integration volume.
2.) What Patterns/Models of integrations are supported to be built by OIC?
The Patterns of integrations include:
a.) Application :
These are based on trigger of a business event. These are used when the integration is to be called via a third party system. For example, If an invoice is updated in the source system and it needs to be updated in the target system as well. A payload is generally passed to such Integrations via the source system. These are preferred for real-time Integrations.
b.) Schedule :
These are type of integrations which are needed to be executed at a Regular intervals. For example, Upload of bank statements every hour. These are preferred for Batch based integrations.
c.) Event :
These are used for Decoupled integrations. This type of integration is used either when one needs to publish to a Event as a JSON or XML payload available to be picked up by the target system. Also, this is used when subscribing to events from a source system.
3.)What are lookups in Oracle Integration Cloud and where are they Used?
Navigation: Design> Lookups
Lookups are used to design Mappings which can be used in integrations. These are static data which can have updation and addition in future. Hence, this data when maintained directly in the Integration can cause frequent changes in the integrations.
Thus, It enables easy mapping creation between values from source and target systems.
Example: Mapping of Country codes from source and target systems.
4.) What are Adapters In Oracle Integration Cloud ? Give a few Examples of OIC adapters
Adapters are Specialized connectors to be able to utilize and connect to different systems like Oracle ERP Cloud, Sales force Etc.
Few examples of OIC connectors are:
a.) REST adapters:
They utilize REST Web services which are exposed through different systems. They generally utilize JSON Payloads. The Versatility of being able to connect to any system makes it an exceptionally popular choice.
b.) SOAP Adapters:
They connect to different systems using SOAP web services which generally utilize XML Payloads. SOAP Webservices are better than REST in Security and Reliability.
c.) Oracle ERP Adapters:
It is a specialized connector for fast and robust connection to Oracle ERP. This Natively provided Adapter provides multiple operations like Supplier import etc. This combines multiple steps to be performed in one operation through a single Adapter.
d.) Salesforce Adapter:
It is specifically used to connect to Salesforce systems which are becoming very popular these days.
5.) What is Error Handling in Oracle integration Cloud? What are the various ways Errors can be handled in OIC?
Error Handling is the process of defining the action plan in case of an Expected Failure or an unexpected failure situation occurs. The action plan could be to send a Notification or a callback etc.
Types of Error Handling:
a.) Scope Level :
This level of Error Handling is when Error handling is defined in a particular scope. This is generally used for Known Failure cases as the Flow of the integration continues after the Error.
b.) Global Level :
These are generally used for known and Unknown Errors anywhere in an integration. Generally, a Notification or Callback is included here.
6.) What are Packages in Oracle integration Cloud (OIC)?
Packages are a group of similar integrations to organize them into bundles making it easier for them to be exported and imported as a Whole. They are exported as .par files different from the integrations which are exported as .iar files.
7.) What are the Business Identifiers of Oracle Integration Cloud (OIC)?
They are identifiers which uniquely identify an OIC transaction (Instance). For example: for Update/insert of a supplier. This would be the Supplier number of the supplier from the source system. These can be used to search the instances in tracking dashboard. It is possible to add three business identifiers but it is mandatory to add at least one. One of the business identifiers is assigned to be the primary one.