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

Category: General Updates Page 1 of 2

May 21 – New OIC articles

Article / LinkAuthorSubject MatterConnecting
Integrate ICS with a third party OAuth Protected REST service using the generic REST adapter (Part 2) (Part 1)Anuj KaushalOIC 
Oracle Integration Latest FeaturesAntony ReynoldsOIC 
Integration Insight for Process automationSandhya Lakshmi GopalanPCS, Insights 
DevOps and Release Automation for Oracle Integration Cloud – Webcast May 13th 2021Juergen KressOICFlexDeploy
Help! I can’t find my OIC instances anymoreSimone GeibOIC 
May 2021 Oracle Integration Enterprise Messaging Adapters ImprovementsPrakash MasandOICMessaging
May 2021 Oracle Integration Fusion Application Adapters ImprovementsPrakash MasandOICApps
May 2021 Oracle Integration Database Adapter ImprovementsPrakash MasandOICDB
Oracle Integration Cloud – Kafka Adapter with Apache AVRODaniel TeixeiraOICKafka
Process Automation with Process Cloud Service (PCS) – Part 5 – (Publish & Activate) (Part 1, Part2, Part3, Part4)Daniel TeixeiraPCS 
Integration Insight – Business Analytics for the Oracle Integration CloudDaniel TeixeiraOIC, Insights 
Private connectivity to Oracle Integration Cloud next generationOmid IzadkhastiOIC 
Package in OIC |Add package for IntegrationKabir YadavOIC 
Package Migration or Multiple Integration Migration |OIC Integration MigrationKabir YadavOIC 
Run OIC scheduled integration using RESTAnkur JainOIC 
OIC Connectivity Agent PatternsNiall CommiskeyOIC 
SOA Suite to OIC – how easy is it? Part 1 Part 2 Part 3Niall CommiskeyOICSOA Suite
New Recipes – FTP to Netsuite File CabinetNiall CommiskeyOICNetSuite
ATP Bulk Data ImportNiall CommiskeyOICATP
Integration Insight AlertsNiall CommiskeyInsights 
Integration Insight -> embed Dashboards in Visual BuilderNiall CommiskeyInsights 
Process & Integration InsightNiall CommiskeyInsights, PCS 
B2B support for UN EDIFACT Part 1, Part 2Niall CommiskeyOIC 

Reflecting on community

If you’ve attended an Oracle conference or just aware of the wider Oracle ecosystem, then you’ll know of the Oracle APEX community and probably one of the communities’ highly respected and much-loved contributors, Joel Kallman. Sadly, Joel has passed on, another victim of Covid19. Our thoughts go out to Joel’s family and the community who have lost someone they value so much.

https://apex.oracle.com/pls/apex/apex_pm/r/joel/memories

March 21 – New OIC articles

Time flies, with a 1/4 of a year behind us already including the first quarterly release. Last month we’ve seen a lot of attention around Oracle Hospitality Integration Platform (OHIP) which brings together different Hospitality cloud services as well as using technologies such as Integration Cloud to make it easy to interface 3rd party solutions.

Article / LinkAuthorSubject MatterConnecting
OIC and Oracle Hospitality (OHIP) – Getting the most out of Opera APIsNiall CommiskeyOICOracle Hospitality
OIC –> Netsuite & HubSpot – User Events calling OIC to sync Price changesNiall CommiskeyOICNetSuite, HubSpot
OIC –> HubSpot to Netsuite – Product SyncNiall CommiskeyOICNetSuite, HubSpot
Accessing Object Storage from Oracle Integration   
    
How to define a Repeating Global VariableJorge HerreriaOIC 
Connecting HubSpot with Netsuite Part 1 & Part 2Niall CommiskeyOICNetSuite, HubSpot
Connecting to NetSuite using Token Based AuthenticationSubhani Sahib ItalapuramOICNetSuite
OIC & OCI NotificationsNiall CommiskeyOICNetSuite, HubSpot
Using Aggregate Functions Sum(), Count() while Processing Larger FilesPhaneendra BommisettyOIC 
OIC Scheduling REST APIsSumeet SinghOIC 
Defining OIC SchedulesSumeet SinghOIC 
Introduction to Trading Partner ManagementArvind Venugopal and Sunil ApteOIC 
B2B Tracking for Wire and Business Transactions in Oracle IntegrationArvind Venugopal and Sunil ApteOIC 
DocuSign Adaptor in Oracle Integration Cloud – Configuring & Automating WorkflowBhumika GogiaProcessDocusign
DocuSign Adaptor in Oracle Integration Cloud – Setup & IntegrationBhumika GogiaOICDocusign
Throw New Fault Action TestingKabir Yadav (alias Amit Suman)OIC 
Create Calculator SOAP connectionKabir Yadav (alias Amit Suman)OIC 
Somewhat “Hidden” Feature: Reusable SubprocessJan KettenisOIC 
OIC Process Correlation: Take Good Care of Your PropertiesJan KettenisOIC 

Beating OIC’s FTP File Limits

OIC has for some time now provided an FTP adaptor and more recently included a full FTP server capability. But both have limits on the file size and capacity. The file constraints (1GB for a file and 500GB for the FTP server) shouldn’t be an issue for day to day activities. But OIC is often used to support SaaS Financials and other cloud solutions which do have monthly process cycles which can generate significant data volumes, for example, payroll data. The question is how to handle such data with such constraints?

Data Integration?

There is a school of thought that points to the possibility when handling such large data volumes we should consider using Data Integration rather than a more event-centric integration tool. Personally, I think there is a lot of validity in the argument, and anyone dealing with such bulky data activities should review and question if it is a better answer.

That said, there are cases where it does stand-up. For example:

  • If an organization is transitioning to a more event-driven or at least micro-batch model, you have to start the transition somewhere, but trying to line up changes everywhere can be problematic, so we have to start somewhere. Building an integration process so you have an event model developed, but in the interim, you need to take that bulk mechanism and convert it to a small stream of events.
  • You may be working with a bulk data extract and only need a small subset of the data provided, it won’t help if the data is also represented using a verbose notation such as XML.

Other Approaches

How to overcome the constraint? Oracle databases aren’t so constrained, and SQLLoader can provide an easy means to ingest the data into a staging table. The benefit of this is:

  • if you’re only needing a subset of the data you can pull just those columns from the table.
  • the bulk of the use of XML to be self-describing can be shed through using the DB schema as being more prescriptive.
  • SQL scripts can handle the checksum records removing that data and overhead from the integration process, leaving you to concentrate more on the business process.

If the data is still substantial once in the database there are a number of strategies to consume the data in more manageable chunks, such as

  • Running SQL script on the database that takes each row and calls the OIC as a restful API point. This approach is potentially very interesting as it may then mean if you’re moving towards an event process in the future the API endpoint represents the future state and the database stored procedure is mimicking the future client behaviour.
  • Use polling strategies and result set limits to control how much data is processed in a single execution of the integration. This approach does mean the integration needs to tag which records have been processed to avoid re-reading them.

Useful Links

Jan 21 – new OIC articles

Article / LinkAuthorSubject MatterConnecting
Invoke BI Report in OICKabir YadavOICBI
Read BI Report base64 encoded responseKabir YadavOICBI
OIC: The Micro Process Feature Making Life EasierJan KettenisOIC
API Gateway Integration: Quick and EasyVarinder KaurOICAPI
Automatic reactivation of Integration after a connection updateShubham AgrawalOIC
Replace Trigger in OrchestrationVijay KendaiOIC
Unlock new patterns of integration by controlling the HTTP Response status in OIC REST based integrationsAnuj KaushalOIC
February 2021 Oracle Integration UpdateAntony ReynoldsOIC
The OCI Designer Toolkit Documentation Generation (Not tested but assumed to also work with OIC)Andrew HopkinsonOCI
OIC February 21 New Features – B2B Trading Partner ManagementNiall CommiskeyOICB2B
OIC –> Process ArchivingNiall CommiskeyOICObject Storage
OIC –> JSON ObfuscationChris PeytierOIC
Simple Fusion ERP – OIC DemoNiall CommiskeyOICFusion Apps (ERP)
OIC – Tagging Instances for Feb 21 upgradeNiall CommiskeyOIC
OIC and Oracle Hospitality (OHIP)Niall CommiskeyOICOracle Hospitality
Protecting your OIC apis with OCI API GatewayNiall CommiskeyOICOCI API
Consolidate tasks from Oracle applications cloud and other applications into a single list of tasksMani KrishnanOICSaaS
Integration Insight in Oracle IntegrationThanos Terentes PrintziosOICInsights

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

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 

May 20 – New OIC Articles

Plenty of good articles published in the last month …

Article / LinkAuthorSubject MatterConnecting
Automate ERP Purchase Order creation using Oracle IntegrationAnkur JainOICERP
HCM Data Extract Processing PatternNiall Commiskey (Oracle Product Mgmt)OICHCM
OIC for Netsuite –> mapping Custom FieldsNiall Commiskey (Oracle Product Mgmt)OICNetsuite
OIC May 2020 release – New FeaturesNiall Commiskey (Oracle Product Mgmt)OIC 
Integration, Process & Insight – Netsuite Data Sync Use CaseNiall Commiskey (Oracle Product Mgmt)OIC, InsightsNetsuite
Basic Error Handling in OIC & Testing of Basic Error Handling in OICAmit Kumar SumanOIC 
Oracle E-Business Suite Integrated SOA Gateway (ISG) In Oracle Cloud (OIC)Atul KumarOICEBS & SOA
Use REST Adapter With Multiple Resources & Verbs In Oracle Integration Cloud (OIC)Atul KumarOIC 
How To Export Business Data & Visual Builder Cloud Service (VBCS) & How To Import Business Data In Visual Builder Cloud Service (VBCS)Atul KumarVBCS 
Slack Adapter for OICDaniel Martins Teixeira (Oracle)OICSlack
Conditional Mappings in Oracle IntegrationThomas Hora (Oracle)OIC 
https://blogs.oracle.com/integration/4-ways-to-innovate-your-connected-erp-and-hcm-initiatives-with-accenture-and-oracleDaryl Eicher (Oracle)OICHCM, ERP
Triggering an OIC integration via OCI Events – the Oracle Functions ApproachStan TanevOICOCI
How to configure REST adaptor to extract bulk leads from MarketoShalindra SinghOICMarketo
How to Find Human Task by Correlation and How to Abort a Parallel TaskJan KettenisPCS 
OIC May 2020 release – New FeaturesNiall 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 

Page 1 of 2

Powered by WordPress & Theme by Anders Norén