Understanding Integration Cloud and how to get the most out of your implementation

Tag: API

December 2023 – New Additions

As we enter 2024, we wish you all the best for the coming year. There is much to look forward to – Niall Commiskey’s 1000th blog post on Oracle Integration. will land soon.

The Oracle Integration Community continues to thrive – we continue to discover new people writing about the subject, and the PaaS Community – which has been there from the birth of what started as ICS remains the touchstone for all things Oracle Integration related from Visual Builder to Process Orchestration in the caring hands of Jürgen Kress.

Article / LinkAuthorSubject MatterConnecting
Oracle OIC Ariba Adapter Capabilities.BiCOICAriba
How To Use Schedule Parameters In OICRaj Baghel OIC 
OIC – ERP – Payables invoice callback – Custom reportSanddyOICERP
OIC – ERP – How to download Import Payables Invoices Report using ERP cloud Adapter SanddyOICERP
OIC – ERP – When to use Fusion Accounting Hub (FAH) vs GL Journal integrationSanddyOICERP
OIC – ERP – Import AP Invoice to Cloud ERP using FBDISanddyOICERP
OIC – Create a resuable integration to write or move and delete files from AWS S3 using RestSanddyOICAWS S3
Publishing OIC endpoints to OCI API Gateway in detailNiall CommiskeyOICAPI Gateway
OIC 23.12 Release New FeaturesNiall CommiskeyOIC 
Fusion Applications Integration with Microsoft Teams : Channel Naming in OICGreg MallyOICMS Teams
Fusion Applications Integration with Microsoft Teams : Custom Header Message in OICGreg MallyOICMS Teams
Oracle Integration Cloud : 5 mistakes to avoid in order to improve your ecosystemAntoine RenciotOIC 
40+ Oracle Integration Cloud OIC Interview Questions 2024Mahir FayazOIC 
Oracle Integration Cloud to SnowflakeFredrik FilipssonOICSnowflake
Create FTP Adapter Connection In OIC Integration 3: Step-By-Step Guide Murari Kalluri OIC3FTP

July 2023 – New Articles

Article / LinkAuthorSubject MatterConnecting
How to become a certified Oracle Cloud expert? Advance your Career – free training and free certification!Jurgen KressOICEverything
Change Oracle Integration request parameters and Authentication using API GatewayOmid IzadkhastiOICAPI
OIC – How to use DB sequence (insert, access)SanddyOICDB
Exposing rest service supporting a file as attachment and JSON request SanddyOIC 
UCM using Oracle ERP Cloud adapter (download, upload)SanddyOICUCM
Transfer file to UCM using tech adaptors (REST upload, ErpIntegrationService SOAP Upload, ErpIntegrationService SOAP Download)SanddyOICUCM
ERP Integration Patterns – Bulk ImportDaniel TeixeiraOICERP
OIC3 OAuth with OCI DomainsNiall CommiskeyOIC3OCI
counting OIC messages for subsidiaries within an organizationNiall CommiskeyOIC 
OIC Projects RBAC – a simple exampleNiall CommiskeyOIC 
OIC & SFDC Streaming API and Platform EventsNiall CommiskeyOICSalesForce
Visual Builder invoking OCI Process AutomationNiall CommiskeyOICVB, OPA
What’s New in Oracle Integration 23.08Niall CommiskeyOICVarious
Oracle Cloud and the power of community in driving digital evolutionJurgen KressOIC 
Oracle Cloud Applications Integration (Part 1, Part 2, Part 3)Su Patel, Mike IsermanOICSaaS
Importing of Data into Oracle ERP Cloud using REST Services through OICRevanth RampellyOICERP

Training provision for OIC appears to be growing:

February 22 – New OIC Articles

Another month passed already, so here are Feb’s posts.

Article / LinkAuthorSubject MatterConnecting
Automating Accounting Hub Cloud Integration with Oracle IntegrationKishore KattaOICAccounting Hub
OIC – API Gateway – Logging –> the value add of OCINiall CommiskeyOICAPI Gateway, OCI Logging
OIC + OHIP + Simphony (part 1, part 2, part 3)Niall CommiskeyOICOracle Hospitality, Simphony, OHIP
OIC ecosystem – Integration & OCI Services – an OverviewNiall CommiskeyOICOCI
February 2022 Oracle Integration UpdateAntony ReynoldsOICMagento Commerce Cloud, Oracle Unity, Oracle Hospitality
New Third Party Application AdapterMadhav PoosarlaOICMagento Commerce Cloud
Oracle Integration Business Accelerator for Siebel Loyalty and CrowdTwistPrakash Masand & Venkat BhatOICSiebel
How to call the OCI AI Language Service from the Oracle Integration CloudDaniel Martins TeixeiraOICOracle AI Language Service
Oracle Hospitality Integration Platform (OHIP) Developer Portal gets a faceliftAmy Simpson-GrangeOHIP 
Integration to upload file to the UCM Server in HCM CloudKabir YadavOICHCM UCM
Steps to fetch Oracle Cloud SaaS Application CertificatesKabir YadavOIC 
How-to Do Error Handling When Integrating With Fusion ERPJan KettenisOICFusion ERP
Parallel Gateway and Multi-Threading, the Work-AroundJan KettenisOIC 
Token Based Authentication (TBA) Policy configuration for Oracle Integration Cloud NetSuite AdapterManish Kumar GuptaOICNetSuite
Publish messages in Stream using Oracle Integration & Connect Stream using OCI Streaming adapter in Oracle IntegrationAnkur JainOICStreams

Deploying OIC – Definitive Tip #9

cloud-stack_CloudStack-cloud-270When ICS was launched it delivered on of the values of PaaS namely you didn’t need to worry about setting up storage, database and compute, it was all sorted out for you. Admittedly it come with a lack of elasticity when it came to resilience and scaling. In contrast Services such as SOA CS which required you to go through each of the layers, but gave you a degree of flexibility. The whilst simpler than building SOA on-premises it still represents a laborious and fiddly process that took time.

When OIC (Oracle Integration Cloud) arrived and the introduction Universal Credits we had a pricing model that made it a lot easier to be elastic in terms of approach to resourcing, but a deployment model that following SOA CS rather than ICS. To an extend, one step forward, and another back.

Fortunately we are seeing head way that means we have recovered that backward step.

Using REPL to Simplify ICS Mgmt Tasks – Definitive Tip 10

The REPL tool was built against ICS running on OCI Classic. As this is no longer available the tool has been withdrawn

Oracle A Team

Earlier in 2017, the Oracle A-Team released a Python library that abstracts the ICS REST API to make some management tasks that you may wish to perform easier. For example, identifying a set of integrations and activating or deactivating them, or simply importing and exporting them. In this Definitive Tip, we will look at the REPL tool and its benefits. The REPL tool can be downloaded here.

Getting setup on Windows at least is a little fiddly as you need to install Python and then depending upon your version of Python update the installer and retrieve a number of additional libraries. REPL itself is available here.

Applying configuration management and related dev practises – ICS Definitive Guide #3

Good development practises such as  configuration management and naming conventions have been a topic of conversation a number of times recently for us when it comes to ICS. In this post we will look at what configuration management means to ICS and the application of naming standards.

Why Configuration Management?

So why do we need configuration management with a tool such as ICS? The question depends on what stage of the software lifecycle you are, but a few reasons:

  • As a developer there have been occasions where we have tried to optimise something and then decided to reverted back to the last secured state in configuration control.
  • Deleted something and then regretted it, whilst desktops have the concept of paper basket to recover from, not so in ICS.
  • If your providing packages of ICS functionality you may have different released versions – so need to keep master copies of every version available to refer to.
  • Sometimes we get ‘configuration drift’ – and therefore need to have a reference point to compare to. This allows us to determine the drift and if it is appropriate to reset an environment. Whilst this may sound less significant, it is enough of a problem for tools like Puppet to incorporate the ability.
  • Tracking what versions of integrations are running in a development vs production environment.

Powered by WordPress & Theme by Anders Norén