Best Practices to Design an Oracle Integration

Oracle

Share Post Now :

HOW TO GET HIGH PAYING JOBS IN AWS CLOUD

Even as a beginner with NO Experience Coding Language

Explore Free course Now

Table of Contents

Loading

Oracle Integration enables you to securely connect any application. Oracle Integration offers prebuilt connection to SaaS and on-premises systems, run-ready process automation templates, and a simple visual application builder for developing web and mobile apps.

In this blog we are going to describe about the best practices of integration. In order to know the best practices while integrating the integrations we need to understand the integration creation including the integration styles, common integration pitfalls and understand trigger and invoke connections.

Understand Integration Styles

You may choose integration style among the multiple styles from then select integration style window.

Integration Styles options

The list of the Integration styles and it’s description.

Table of Integration styles

Common Integration Style Pitfalls and Design Best Practices

When designing an integration, best practices and integration style pitfalls should be avoided.

Understand Trigger and Invoke Connections

When designing an integration, You enter the integration by dragging trigger (source) and invoke (target) adapter connections. The connection already has the information needed to connect to the application.

Trigger Connections

The trigger (source) connection communicates with Oracle Integration. The adapter connections listed below can be used as integration triggers.

Adapter For Information
AS2 Adapter Using the AS2 Adapter with Oracle Integration
Box Adapter Using the Box Adapter with Oracle Integration
File Adapter Using the File Adapter with Oracle Integration
IBM DB2 Adapter Using the IBM DB2 Adapter with Oracle Integration
IBM MQ Series JMS Adapter Using the IBM MQ Series JMS Adapter with Oracle Integration
Microsoft SQL Server Adapter Using the Microsoft SQL Server Adapter with Oracle Integration
MySQL Adapter Using the MySQL Adapter with Oracle Integration
Oracle Advanced Queuing (AQ) Adapter Using the Oracle Advanced Queuing (AQ) Adapter with Oracle Integration
Oracle Cloud Infrastructure Streaming Service Adapter Using the Oracle Cloud Infrastructure Streaming Service Adapter with Oracle Integration
Oracle Commerce Cloud Adapter Using the Oracle Commerce Cloud Adapter with Oracle Integration
Oracle CPQ Adapter Using the Oracle CPQ Adapter with Oracle Integration
Oracle CX Sales and B2B Service Adapter Using the Oracle CX Sales and B2B Service Adapter with Oracle Integration
Oracle Database Adapter Using the Oracle Database Adapter with Oracle Integration
Oracle E-Business Suite Adapter Using Oracle E-Business Suite Adapter with Oracle Integration
Oracle Eloqua Cloud Adapter Using the Oracle Eloqua Cloud Adapter with Oracle Integration
Oracle ERP Cloud Adapter Using the Oracle ERP Cloud Adapter with Oracle Integration
Oracle HCM Cloud Adapter Using the Oracle HCM Cloud Adapter with Oracle Integration
Oracle Hospitality Adapter Using the Oracle Hospitality Adapter with Oracle Integration
Oracle JD Edwards EnterpriseOne Adapter Using the JD Edwards EnterpriseOne Adapter with Oracle Integration
Oracle Logistics Adapter Oracle Logistics Adapter with Oracle Integration
Oracle Service Cloud (RightNow) Adapter Using the Oracle Service Cloud (RightNow) Adapter with Oracle Integration
Oracle Siebel Adapter Using the Oracle Siebel Adapter with Oracle Integration
Oracle WebLogic JMS Adapter Using the Oracle WebLogic JMS Adapter with Oracle Integration
Oracle Utilities Adapter Using the Oracle Utilities Adapter with Oracle Integration
REST Adapter Using the REST Adapter with Oracle Integration
Salesforce Adapter Using the Salesforce Adapter with Oracle Integration
SAP Adapter Using the SAP Adapter with Oracle Integration
SAP ASE (Sybase) Adapter Using the SAP ASE (Sybase) Adapter with Oracle Integration
ServiceNow Adapter Using the ServiceNow Adapter with Oracle Integration
Slack Adapter Using the Slack Adapter with Oracle Integration
SOAP Adapter Using the SOAP Adapter with Oracle Integration

Invoke Connections

Oracle Integration communicates with the invoked (target) connection by sending requests or information. In an integration, you can declare the following adapter connections as invokes. here are few adapters listed.

Adapter For Information
Adobe Sign Adapter Using the Adobe Sign Adapter with Oracle Integration
Apache Kafka Adapter Using the Apache Kafka Adapter with Oracle Integration
AS2 Adapter Using the AS2 Adapter with Oracle Integration
Automation Anywhere Adapter Using the Automation Anywhere Adapter with Oracle Integration
Box Adapter Using the Box Adapter with Oracle Integration
DocuSign Adapter Using the DocuSign Adapter with Oracle Integration
eBay Marketplace Adapter Using the eBay Marketplace Adapter with Oracle Integration
Eventbrite Adapter Using the Eventbrite Adapter with Oracle Integration
Evernote Adapter Using the Evernote Adapter with Oracle Integration
Facebook Adapter Using the Facebook Adapter with Oracle Integration
File Adapter Using the File Adapter with Oracle Integration
FTP Adapter Using the FTP Adapter with Oracle Integration (Basic Routing Integration)Using the FTP Adapter with Oracle Integration (App Driven Integration)
Google Gmail Adapter Using the Google Gmail Adapter with Oracle Integration
Google Calendar Adapter Using the Google Calendar Adapter with Oracle Integration
Google Tasks Adapter Using the Google Tasks Adapter with Oracle Integration
HubSpot Adapter Using the HubSpot Adapter with Oracle Integration
Jira Adapter Using the Jira Adapter with Oracle Integration
IBM DB2 Adapter Using the IBM DB2 Adapter with Oracle Integration
IBM MQ Series JMS Adapter Using the IBM MQ Series JMS Adapter with Oracle Integration
LinkedIn Adapter Using the LinkedIn Adapter with Oracle Integration
Mailchimp Adapter Using the Mailchimp Adapter with Oracle Integration
Marketo Adapter Using the Marketo Adapter with Oracle Integration
Microsoft Office 365 Calendar Adapter Using the Microsoft Office 365 Calendar Adapter with Oracle Integration
Microsoft Office 365 People Adapter Using the Microsoft Office 365 People Adapter with Oracle Integration
Microsoft Office 365 Outlook Adapter Using the Microsoft Office 365 Outlook Adapter with Oracle Integration
Microsoft SQL Server Adapter Using the Microsoft SQL Server Adapter with Oracle Integration

Best Practices when designing an Integration

  • Best Practices of  Synchronous Integration
  • Long-running or time-consuming integrations should be designed as asynchronous flows.
  • Service Call Time Outs During Synchronous Invocations
  • Parallel Processing in Outbound Integrations

Best Practices of  Synchronous Integration

A synchronous integration that communicates with any asynchronous request response service:

  • It is permissible to call asynchronous fire and forget (one-way).
  • Oracle Integration presently does not support modelling an asynchronous request response service. However, all scheduled orchestration patterns implement an asynchronous request response internally. As a result, synchronous integration through scheduled orchestration is an anti-pattern.

Oracle WebLogic Server reports a stuck thread when a synchronous integration calls numerous services for more than 5 minutes.

Synchronous vs Asynchronous

Long-running or time-consuming integrations should be designed as asynchronous flows.

Long-running or time-consuming integrations should not be exposed as synchronous flows. This action may cause client apps (as well as other integrations) to time out. A server-side time out is also present in synchronous integrations. Model any synchronous integration that takes more than two minutes as an asynchronous flow.

Service Call Time Outs During Synchronous Invocations

You may encounter instances in which synchronous Oracle Integration invocations (including calls to other integrations) are blocking calls that must be completed within 300 seconds.

Because the call may involve one or more proxies, each proxy may have a time out that is comparable. The default proxy on Oracle Public Cloud, for example, has a time out value of 120 seconds. If the call is to an on-premises service that is protected by a firewall, the proxy configured may have its own time out value.

When multiple layers of time outs are established, the service invocation fails at the initial time out.

Parallel Processing in Outbound Integrations

While there is no particular integration architecture that allows an outbound integration to deliver data to many third-party systems at the same time, there are integration design techniques that allow for this scenario.

Divide the integration into many integrations:

  • Create a primary parent integration that only receives and processes data.
  • To perform the different outbound REST invocations, create distinct child integrations.

What is Outbound Integrations?

Outbound integrations enable business process authored in Process Designer to interact with other systems, such as a web service, a content management system, or an external database.

These are the  Best Practices for an Integration, when designing an integration.

Related / References Links:

Next Task For You

Do you want to learn more about Oracle and confuse where to start or which certification is right for you? Then, click on the register now button below to register for a Free Masterclass on Oracle [1Z0-1042] Certified Cloud Integration Expertwhich will help you better understand and choose the right path and clear the certification exam.

Free class OIC gif

Picture of mike

mike

I started my IT career in 2000 as an Oracle DBA/Apps DBA. The first few years were tough (<$100/month), with very little growth. In 2004, I moved to the UK. After working really hard, I landed a job that paid me £2700 per month. In February 2005, I saw a job that was £450 per day, which was nearly 4 times of my then salary.