Implementing Oracle Integration Cloud Service

Understanding Oracle's Integration Cloud Service and how to get the most out of your implementation

Nov 20 – new OIC Articles

This month’s articles …

Article / LinkAuthorSubject MatterConnecting
Netsuite to Object StorageNiall CommiskeyOICNetsuite; Object Storage
DB Adapter –> Master/Detail InsertNiall CommiskeyOICDatabase
Complex SQL processingNiall CommiskeyOICDatabase
Netsuite adapter New FeaturesNiall CommiskeyOICNetsuite
new Monitoring/Mgt featuresNiall CommiskeyOIC
Data RetentionNiall CommiskeyOIC
Oracle Field Service via RESTNiall CommiskeyOICOracle Field Service
Generic Invoke for Scheduled JobsNiall CommiskeyOICSchedukler
How to configure Integration Properties in OICAmit Kumar SumanOIC
Oracle Integration Announcements On Home PageKundan VyasOIC
Recover unsaved changes for an Integration edit sessionVijay KendaiOIC
Oracle Integration November 2020 Update for Technical AdaptersPrakash MasandOICVarious
Track scheduled instances from submissionArya SanyalOIC
How to Invoke an OCI Function from the Oracle Integration CloudDaniel Martins TeixeiraOICFn
Oracle Integration: ICS to OIC Migration using an ATP DatabaseMichael MeinerOIC
Navigate between pages in Oracle Visual BuilderAnkur JainVBCS
OIC Health Check by OCI Monitoring and AlarmJin ParkOIC
OIC Log Management with VB Studio, OCI Bucket and OCI Logging AnalyticsJin ParkOIC

October 20 – New OIC articles

Article / LinkAuthorSubject MatterConnecting
OIC REST API for LookupsNiall CommiskeyOIC
OIC 4 Netsuite – Polling for New / Updated CustomersNiall CommiskeyOICBetsuite
Oracle Integration – Adapter Enhancements to Non Oracle ApplicationsArvind VenugopalOICNon Oracle
Security Improvements for Database & FTP AdaptersMichael MeinerOICDB & FTP
November 2020 UpdateAntony ReynoldsOIC
Oracle Integration November 2020 update for Oracle Applications AdaptersPrakash MasandOICOracle Apps
How to use the OCI Object Storage from the Oracle Integration CloudDaniel Martins TeixeiraOICOCI Object Store
Choosing Your Update WindowAntony ReynoldsOIC
Announcing The Visual Builder CookbookShay ShmeltzerVBCS
Connecting to API Gateway from Visual Builder with AuthenticationAparna GaonkarVBCS
Global Variable and Data Stitch in OICAmit Kumar SumanOIC
Configure OTM connection in OICAmit Kumar SumanOICOTM
Send attachment in OIC notificationAmit Kumar SumanOICEmail

September 20 – New OIC articles

Article / LinkAuthorSubject Matter Connecting
Replace Existing Connection with New Connection in OIC IntegrationAmit Kumar SumanOIC
OIC: How to configure endpoints of ORDS Connections in OIC?Jan KettenisOICDBaaS/DB
Zero loss of service, smoothly migration from Salesforce to Oracle Apps CX with Oracle Integration Cloud Salesforce Adapter plus helper technology tools such as an Autonomous Database, Data Integration and Object StorageJavier MuguetaOICSalesforce
Oracle Integration Cloud August 2020 new features: Accelerators, Recipes and Couple of Brand new Adapters, and more..Javier MuguetaOIC
How to Configure the New Oracle Integration Cloud (OIC) Streams AdapterJohn GravesOICStreams
Inbound EDI message to Oracle Integration for B2B WorldSubhani Sahib ItalapuramOICB2B
How to create a XSLT map that reads many correlated payloadsJorge HerreriaOIC
Creating Complex Local Temporary Variables in OICJohn GravesOIC
How to Keep Exactly One OIC Integration Instance running 24/7John GravesOIC
Oracle Intelligent AutomationMilomir VojvodicOICIA under the hood
An Advanced Guide to OIC Notification via EmailsRenukaradhya DakshinamurthyOICOCI email
Create a B2B Document to Define Custom Definitions in Oracle Integration(OIC)Subhani Sahib ItalapuramOICB2B
Introducing B2B in Oracle Integration(OIC)Subhani Sahib ItalapuramOICB2B
Extending OOTB OIC Recipe – Extract New Hire Info (part1, part2)Kishore KattaOICHCM
Update Lookups in Oracle Integration CloudAnkur JainOIC
Oracle Integration Cloud New Home PageAnkur JainOIC
[Creating Journal Entries in Netsuite via OICNiall CommiskeyOICNetsuite
Oracle Integration (OIC) Recipes – HCM Directory SynchronisationNiall CommiskeyOICHCM
OIC Technical Accelerator – Alert NotificationsNiall CommiskeyOIC
OIC Technical Accelerators – Re-sequencerNiall CommiskeyOIC

August 20 – New OIC Articles

Despite it being traditionally holiday season, there have been lots of articles written about OIC, including the prolific Niall Commiskey covering a lot of new OIC features …

Article / LinkAuthorSubject MatterConnecting
Integration Pick action full-circle now with Process using it!Jan KettenisOIC 
Fault handling in OICJan KettenisOIC 
The Magic Of Correlation SetsMartien Van Den AkkerOIC 
OIC DB adapter – approaches for processing new rowsNiall CommiskeyOICDatabase
OIC DB Adapter – some more adventures…Niall CommiskeyOICDatabase
OIC August 2020 Release New FeaturesNiall CommiskeyOIC 
OIC Shopify Adapter improvements – August Release New FeatureNiall CommiskeyOICShopify
Design Time variables – August Release New FeatureNiall CommiskeyOIC 
Import/Export – August Release New FeatureNiall CommiskeyOIC 
PayPal AdapterNiall CommiskeyOICPaypal
OCI Streaming AdapterNiall CommiskeyOICOracle Streams
Syncing Netsuite customers and contacts with EloquaNiall CommiskeyOICEloqua & Netsuite
Error Handling GuideShreenidhi RaghuramOIC 
How to use the new Import/Export feature in Oracle IntegrationSteve TindallOIC 
How to externalize properties using Integration Properties in OIC?Samir SahuOIC 
Embedded File Server (SFTP) in Oracle IntegrationSubhani Sahib ItalapuramOIC 
PGP Encryption/Decryption using StageAnkur JainOIC 
Manage User & Roles Oracle Integration CloudAnkur JainOIC 
Oracle Integration Cloud Connectivity Agent Download And Set UpHarshit YadavOIC 
B2B In Oracle Integration CloudHarshit YadavOIC 

July 20 – New OIC Articles

Its been a busy month when it comes to blogging for the folks at Oracle, as July saw a new quarterly release with new usability improvements and connectors.

Article / Link Author Subject Matter Connecting
Sugar CRM 2 Netsuite Integration with OIC REST Adapter Niall Commiskey (Oracle PM) OIC Sugar CRM, Netsuite
OIC integrating BigCommerce with Netsuite Niall Commiskey (Oracle PM) OIC BigCommerce, Netsuite
Shopify: (Adaptor Pagination, Product Inventory Updates) Niall Commiskey (Oracle PM) OIC Shopify
OIC – SurveyMonkey 2 Netsuite Synchronisation Niall Commiskey (Oracle PM) OIC Survey Monkey, Netsuite
OIC moving to a Quarterly Release Cycle Niall Commiskey (Oracle PM) OIC
OIC 4 Netsuite – Implementing a Generic Error Handler Niall Commiskey (Oracle PM) OIC Netsuite
See how OIC integrations are behaving at runtime Ankur Jain OIC
Oracle Integration Connectivity Updates August 2020 Prakash Masand (Oracle) OIC Various
Enhanced Integration with your Business Partners using OIC AS2 Adapter Michael Meiner (Oracle) OIC B2B
Convert Basic Routing style Integration to Orchestration style. Renukaradhya Dakshinamurthy (Oracle) OIC
User Friendly Names in Mapper Ishruthilaya Malarvizhi OIC
PeopleSoft Integration using Oracle Integration Cloud (Part 1, Part 2) Prakash Masand, & Jin Park (Oracle) OIC Peoplesoft
Jump-start your Integrations with the new Oracle Integration Home Page Michael Meiner (Oracle) OIC
Leveraging Oracle Integration File Server For File Based Integrations Kundan Vyas (Oracle) OIC
Promoting Your Code Antony Reynolds (Oracle) OIC
Adding Your Own Application Templates to Oracle Visual Builder Duncan Mills (Oracle) VBCS
Using OCI API signature authentication from Visual Builder Aparna Gaonkar (Oracle) VBCS
Invoking One Integration From Another – Call integration Action Harshit Yadav OIC
Visual Builder Studio Features (Part 1) Javier Mugueta VBCS/OIC
Integration b/w Oracle Engagement Cloud, Oracle CPQ & Oracle EBS Atul Kumar OIC Oracle Engagement Cloud, Oracle CPQ, EBS

OIC and Integrating Oracle SaaS

Handling integration between Oracle SaaS applications and modules has been something of an evolutionary journey. A couple of years ago if you wanted to intgrate say HCM and ERP you needed to ICS or OIC to perform the integration.

In many respects this wasn’t such a terrible thing. Technically as it meant that the back end database schema development for each app was not going to be slowed by needing to be mutually dependent with each other. As a result avoiding the complexities of managing a canonical model and ensuring any changes to that model are delivered in a manner that aligns across multiple development teams plans.

Although you can see from a marketing position it might not have seemed so great, as the customer incurs more cost and development effort to realize a process of managing people (HCM) and paying them (ERP) for example.

Things have moved on, and as long as SaaS apps reside in a Global Single Instance (GSI) (i.e. same region, account and deployment) then for the major products (e.g. ERP, CX, HCM, etc) are internally integrated so a person change in HCM will propagate to ERP as necessary. This certainly reduces the need for integration, saving effort (and the cost of needing OIC).

The problem now is understanding which entities in the SaaS apps are integrated out the box if you deploy using the GSI manner. If you have been working from an integration/technology view point with ICS and OIC for a while it is very easy to get sucked into thinking you need to repeat the integration. After all explicitly integrating the apps is how we started out.

Oracle also want to make it very easy for non Oracle products to integrate, so OIC documentation and the many very good blogs from product management and the engineering team focus on external integration which does (for me atleast) lead to thinking about the older way of working.

Recommendation

Look to see if you’re working with GSI deployment or not. If it isn’t a GSI setup then the old way of working is required. If it is, then determine whether the entity or processes are out the box integrated. This is probably best approached from the SaaS documentation today.

Useful Links:

June 20 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
 Ankur JainOICERP
Identity Propagation In Structured ProcessJan KettenisOIC / PCS 
Use Oracle Integration to Add Attachments to a Process InstanceBogdan EremiaOIC / PCS 
Oracle Integration Cloud (OIC) Notification ActivityHarshit YadavOIC 
Oracle Integration Cloud (OIC) ADW/ATP AdapterHarshit YadavOICADW/ATP
Our best blogs for Oracle Integration CloudHarshit YadavOIC 
Managing & Monitoring Integration/Errors In Oracle Integration CloudAtul KumarOIC 
Sugar CRM 2 Netsuite Integration with OICNiall CommiskeyOICSugar CRM, Netsuite
Netsuite REST APINiall CommiskeyOICNesuite
Netsuite Asynchronous Request ProcessingNiall CommiskeyOICNesuite
Invoking Netsuite Saved Searches / MiscellaneousNiall CommiskeyOICNesuite
OIC June 2020 release UI updatesNiall CommiskeyOIC 
OIC Packages – cool feature I didn't know we hadNiall CommiskeyOIC 
OIC –> Shopify Adapter now supporting EventsNiall CommiskeyOICShopify
OIC –> Date ManipulationNiall CommiskeyOIC 
embedding VB CS app in HCMNiall CommiskeyVBCSHCM
Data Stitch Assign operation for Elements with AttributesJorge HerreriaOIC 
Oracle Integration (OIC) Generation 2 is now available in all cloud tenanciesSimone GeibOIC 
Data Stitch: Append and Assign for repeating elementsJorge HerreriaOIC 
Empower your Business Users with Integration InsightSimone GeibOIC (Insights) 
How to use the Dynamic Invoke feature in OIC OIC 
Integration Monitoring and Scheduling pages – Progressive Web App UI ExperienceArya SanyalOIC 
Data Stitch: Repeating element path does not have a predicate for selecting 1 instance – WarningJorge HerreriaOIC 
Big Changes are AfootAntony ReynoldsOIC 
HCM Data loader in Oracle IntegrationAnkur JainOICHCM
Oracle Integration Cloud HCM adapterAnkur JainOICHCM
Global Variables and Data Stitch in Oracle IntegrationAnkur JainOIC 

May 20 – New OIC Articles

Plenty of good articles published in the last month …

Article / Link Author Subject Matter Connecting
Automate ERP Purchase Order creation using Oracle Integration Ankur Jain OIC ERP
HCM Data Extract Processing Pattern Niall Commiskey (Oracle Product Mgmt) OIC HCM
OIC for Netsuite –> mapping Custom Fields Niall Commiskey (Oracle Product Mgmt) OIC Netsuite
OIC May 2020 release – New Features Niall Commiskey (Oracle Product Mgmt) OIC
Integration, Process & Insight – Netsuite Data Sync Use Case Niall Commiskey (Oracle Product Mgmt) OIC, Insights Netsuite
Basic Error Handling in OIC & Testing of Basic Error Handling in OIC Amit Kumar Suman OIC
Oracle E-Business Suite Integrated SOA Gateway (ISG) In Oracle Cloud (OIC) Atul Kumar OIC EBS & SOA
Use REST Adapter With Multiple Resources & Verbs In Oracle Integration Cloud (OIC) Atul Kumar OIC
How To Export Business Data & Visual Builder Cloud Service (VBCS) & How To Import Business Data In Visual Builder Cloud Service (VBCS) Atul Kumar VBCS
Slack Adapter for OIC Daniel Martins Teixeira (Oracle) OIC Slack
Conditional Mappings in Oracle Integration Thomas Hora (Oracle) OIC
https://blogs.oracle.com/integration/4-ways-to-innovate-your-connected-erp-and-hcm-initiatives-with-accenture-and-oracle Daryl Eicher (Oracle) OIC HCM, ERP
Triggering an OIC integration via OCI Events – the Oracle Functions Approach Stan Tanev OIC OCI
How to configure REST adaptor to extract bulk leads from Marketo Shalindra Singh OIC Marketo
How to Find Human Task by Correlation and How to Abort a Parallel Task Jan Kettenis PCS
OIC May 2020 release – New Features Niall Commiskey (Oracle Product Mgmt) OIC

April 20 – New OIC Articles

April has been a relatively quiet month article wise after a couple of bumper months. we’re seeing lots of new content already for May.

Article / LinkAuthorSubject MatterConnecting
Token required to provision an Oracle Integration Cloud instanceAnkur JainOIC 
Why is iPaaS adoption growing to handle integrations in cloud architectures?Daryl Eicher (Oracle)OIC 
Creating net new apps on top of Netsuite with OIC Visual BuilderNiall Commisky (Oracle)VBCS + OICNetSuite
Monitoring API – Getting Activity Stream dataNiall Commisky (Oracle)OIC 
Triggering an OIC integration via OCI Events – the Notifications Service ApproachStan Tanev (Red Thunder Blog)OICOCI
The 5 Pillars of Intelligent Invoice ProcessingDaryl Eicher (Oracle)OIC/ArcivateRPA
B2B – EDI Translation supportNiall Commisky (Oracle)OICEDI
B2B Document ManagementNiall Commisky (Oracle)OICEDI
Process large file (above 10MB) in Oracle Integration Cloud Service (OIC)Harshit Yadav (K21 Academy)OIC 
SOAP Vs REST APIs In Oracle Integration Cloud (OIC)Harshit Yadav (K21 Academy)OIC 

OIC has support for EDI now

A couple of days ago the updates for OIC included a new feature B2B (April 2020 new). Specifically, support for EDI X12. Whilst this doesn’t mean SOA Suite B2B is redundant yet (as that still offers a broad range of other complex exchange protocols HL7, EDIFACT, SAP iDoc – complete list here). I wouldn’t be surprised if Oracle considers leaving behind support for one or two of the more complex file formats such as EDIEL. But with X12 cracked, I wouldn’t be surprised to see EDIFACT follow soon.

SOA CS

SOA CS future?

So where does the leave SOA CS given one of the differentiators to OIC was the existence of the B2B and MFT elements? OIC has not yet fully displaced SOA and SOA CS, there are use cases that OIC can not yet fully address. For example in the MFT space OIC has caps on filesize (whilst MFT does not). MFT also supports Applicability Statement (AS) standards (IETF specification for AS2). Unlike some of the payload formats, particularly the metadata-driven ones we may see fall away more quickly, the AS standards provide the means for communications to be responded with a ‘Message Disposition Notification‘ (MDN) which means the receiver will tell the sender the receiver has safely and fully received the communicated payload – non-repudiation. We have seen banks and other data-sensitive organizations continue to use such standards (after all you want your employer saying they told their bank to pay your salary, and the bank say, nope not got anything or transfers between the bank and the tax man).

How quickly these gaps will be addressed in OIC is not clear, or whether these cases will be addressed, or whether SOA will continue to answer these edge cases until superseding standards and techniques make them redundant.

The bottom line is there are too many customers with legacy estates on-prem for SOA CS to be retired any time soon. However, I would not be surprised if SOA follows the route of ODI when it comes to Oracle Cloud. Oracle has developed ODI on Oracle Cloud Marketplace, which provides an on-prem style deployment configured (and presumably tuned) to run on Oracle Cloud as an IaaS Virtual Machine. This potentially simplifies the BYOL license model leaving the customer responsible for a level of patch maintenance (be that take a new ODI Marketplace instance spin it up and apply the configuration, then drop the old one, or run the traditional patch processes).

We will see SOA continue to be patched and maintained for a long time to come. But I wouldn’t surprised if Oracle makes it more and more attractive for SOA customers to use OIC – possibly combining OIC and their SOA Suite instances with a view that when customers need to update migrations, they consider the port.

Whilst this may sound like Oracle are potentially leaving customers without the infamous paddle. However, our experience in the partner space is that Oracle seeks to enable them and recognize that most partners are very capable. Not to mention, when the heat is on, partners with middleware Aces can usually find their way through the Oracle organization to get what is needed.

I think we’ll continue to see a number of Oracle’s specialist partners file the gap with tooling adapted from on-premise solutions. It is these partners that also have the wealth of expertise on knowing to get the most out of SOA Suite and keep it secure.

Finally …

So OIC will continue to absorb capabilities that had separated it from SOA suite cementing it as the mainstream offering. But the old warhorse will be around for a long time (remember many older companies still use Cobol successfully) yet. To use a car analogy, those sticking with their trusty vintage Mark 1 Golf that has done 500,000 miles will have to stop looking to the manufacture for service and parts and enlist the support of a passionate specialist.

To be clear, this is only our opinion, and not informed or confirmed by Oracle.

Page 1 of 5

Powered by WordPress & Theme by Anders Norén