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

Author: Phil Wilkins Page 2 of 8

-- I work for Oracle, all opinions here are my own & do not necessarily reflect the views of Oracle -- Oracle Ace Director Alumni
TOGAF 9 Certified Architect
- https://blog.mp3monster.org

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

January 22 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
DevOps with FlexDeploy for Oracle Integration LHR customer case study Join the PaaS Partner Community Webcast January 25th 2022 (can still play recording post event)Jurgen KressOIC 
OIC ecosystem – Integration & OCI Services – an OverviewNiall CommiskeyOIC 
OCI Anomaly Detection Service & OIC – Part INiall Commiskey  
OIC invoking OCI Functions (python) Part 1, Part 2 Niall CommiskeyOICFunctions
Oracle Hospitality from Reservation to Check-In Part 1, Part 2Niall CommiskeyOICOracle Hospitality
While Loop in OIC / While ActionKabir YadavOIC 
Top 10 Oracle Integration Cloud (OIC) Interview Questions Mahir UI FayazOIC 
Using Synchronous BIP for Extracting Data? Don’tAngelo SantagataOICBIP

Book Birthday

I had an interesting conversation today, where it was pointed out to me that our book Implementing Oracle Integration Cloud Service, the first ever Oracle PaaS book is five years old today (according to Amazon). This website was also five years old back in August last year.

While some parts of the UI have become more sophisticated than shown in the book, and the choice of adaptors has grown significantly the core fundamentals of the book still hold true.

Of course the book is only as good as the technology, and Oracle Integration continues to fly in the Gartner Magic Quadrant.

So Happy Birthday us, and congratulations Oracle, and thankyou to our readers.

December 21 – New OIC Articles

December is always a quiet month having had updates in November, but this month has been particularly so. One bit of good news, the handy resource links have been updated with a lot more additional resources – see right of the page.

Article / LinkAuthorSubject MatterConnecting
CI/CD working with EiPaaS Oracle Integration (OIC)Cristian SilipigniOICCI/CD
Speed up your Accounting Closing Cycle with automated loading of Payable Invoices into Oracle ERP Cloud, using Oracle Integration CloudJuan CarlosOICCX/ ERP/ ServiceCloud
Quarterly UpdatesPhil WilkinsOIC 
Using the Oracle Cloud Infrastructure Streaming Service Adapter with Oracle IntegrationOICStreams
Build retry logic in Oracle IntegrationAnkur JainOIC 
Call VB Business Objects from Oracle IntegrationAnkur JainOIC 

Quarterly Updates

The update regime for Integration Cloud is well established in its quarterly pattern, but within that pattern are two update cycles, separated by two weeks. It is possible to choose which cycle your OIC instance update will be executed in. If you don’t specify which cycle then by default you will be put into the second cycle.

For production deployments of OIC that makes a lot of sense. But we would recommend that your non-production instance be part of the 1st update cycle. This allows you two weeks to validate and fix any issues in the event that the upgrade breaks any of your integrations. While that shouldn’t happen if you are exploiting an undocumented behaviour or something reported as a bug there is always a risk.

So the obvious question is how to define which update cycle should be used. For OCI Gen 2 (the majority of users should have migrated to now), the control is achieved by setting a freeform tag on the OIC instance. The tag needs to be called OIC_UPDATE_WINDOW1 (note – if you don’t read the Oracle documentation carefully you could end up omitting the numeral) and the value can be left blank. The tags are set on the OCI view for your OIC instance, which has a tabbed view as you can see below. Once the value is set then the OCI view will show an Updating status – this is not to be confused with the OIC instance being updated with the latest quarterly changes.

All of this shows up in blog (here and script fragment here) and a documentation (here). What is less apparent is the lead time needed for the tag to be in place. This is in the order of 7 or more weeks. This means you need to have your OIC dev instance in place almost a full quarter before the opportunity is available, and spinning up a new OIC instance and expecting it to immediately adopt the latest version during the maintenance window isn’t going to solve any problems.

How to confirm the instance version

The related question is where to look for the version of OIC is running. The information is only provided in the instance console rather then the OCI View of OIC. The version information is available as part of the drop down visible on the question mark icon at the top right of the UI, as the following screenshots show:

We do hope that Oracle will shorten this in the months to come.

Terraforming …

If you’re building your OIC deployment(s) using Terraform, then you could pass a variable into your Terraform module (hence the reference to var. or read from a configuration file in which case you will want a data block and the value becomes data.)

locals {
 updateWindow = (var.use_window1) ? "OIC_UPDATE_WINDOW1" : "--NOT-WINDOW1--"
}

resource "oci_integration_integration_instance" "test_integration_instance" {
    #Required
    compartment_id = var.compartment_id
    display_name = "ExampleOIC"
    integration_instance_type = var.integration_instance_integration_instance_type
    is_byol = false
    message_packs = 1

    consumption_model = var.integration_instance_consumption_model
    custom_endpoint {
        #Required
        hostname = var.integration_instance_custom_endpoint_hostname

        #Optional
        certificate_secret_id = oci_vault_secret.test_secret.id
    }

    freeform_tags = {"${local.updateWindow}"= ""}
    idcs_at = var.integration_instance_idcs_at
    is_file_server_enabled = var.integration_instance_is_file_server_enabled
    is_visual_builder_enabled = var.integration_instance_is_visual_builder_enabled
    network_endpoint_details {
        #Required
        network_endpoint_type = var.integration_instance_network_endpoint_details_network_endpoint_type


        }
        is_integration_vcn_allowlisted = var.integration_instance_network_endpoint_details_is_integration_vcn_allowlisted
    }
    state = var.integration_instance_target_state
}

As you can see in my example I have hardwired more values than the example provided by the Oracle Terraform documentation (here) as it helps show the legal values. Here to keep the declarations simple – I have set a freeform tag regardless, but changed in the local variable value to be used by the freeform tag depending on if a variable ( use_window1) is set.

November 21 – New OIC Articles

Another month and another raft of great content. Lot of activity springing up around the new Oracle Hospitality Integration Platform (OHIP) with its new OIC Adapter.

Article / LinkAuthorSubject MatterConnecting
Clone an Existing Integration Flow in OIC Basics of OICOIC 
OIC: Synchronous versus Fire-and-Forget Process to Process InvocationJan KettenisOIC 
Oracle Integration Cloud – Gmail AdapterDaniel TeixeiraOICGMail
Between Oracle Integration Cloud (OIC) And Oracle Cloud Infrastructure (OCI)Atul KumarOIC 
How to call the OCI AI Language Service from the Oracle Integration CloudDaniel TeixeiraOICOCI AI Language Service
Creating Custom Messages/Notifications in Visual BuilderShay ShmeltzerVBS 
FlexDeploy for Oracle Integration CloudJürgen KressOIC 
Connecting Opera Cloud to the World – PaaS Partner Community Webcast November 30th 2021Jürgen KressOICOPERA (Oracle Hospitality)
OIC November Release New Features – Oracle Hospitality AdapterNiall CommiskeyOICOPERA (Oracle Hospitality)
OIC November 21 Release New FeaturesNiall CommiskeyOIC 
DB adapter – overcoming 10 MB limitNiall CommiskeyOICDB
Leveraging OCI AI Language Service from Oracle Integration (Part 1) (Part 2)Niall CommiskeyOICAI Language Service
Fetch & update Integration lookup using Visual BuilderAnkur JainVBS & OIC 
OHIP and Oracle Integration Cloud: Simplifying hospitality integrations even moreLuis WeirOICOHIP (Hospitality Integration)
November 2021 New Third Party Application AdaptersMadhav PoosarlaOICSugar CRM, eBay
Delivering Real Customer Value with Agile Innovation: Heathrow rapidly moves to Oracle Cloud and connects with hybrid Integration – Webcast November 16th 2021Jürgen KressOIC 
November 2021 Oracle Integration UpdateAntony ReynoldsOIC 
Answers are never far away with Oracle AssistantKevin HopkeOIC 
Exporting Data from Oracle HCM Cloud using OICHemanth LavesattiOIC 
CI/CD for Oracle Visual Builder ApplicationsVijayaraj GovindharajVBSFlexDeploy
Decouple complex flows into simplified multiple resource REST flowMadhav PoosarlaOIC 

Oracle Hospitality OIC Adaptor

Oracle Integration Cloud is rich in adaptors for technology and major SaaS services both Oracle (E.g., HCM, ERP, CX) and non Oracle (e.g., Salesforce, ServiceNow). But the more observant may have noticed a new addition to the list of Oracle industry (vertical) adaptors joining the Utilities vertical is a new adaptor for Hospitality.

OPERA, and it’s integration service OHIP have been developing to bring first of all its 3000+ APIs upto date as RESTFUL and self service enabled as the OPERA product becomes a SaaS delivered solution. Not to mention provide a good developer experience with Apiary and resources such as Postman collections (more about this here).

The latest step (from 21.4.2) has been to further the simplify the development process through the use of low code integration OIC provides. You can read some initial blogs about it here, and I’m sure there will be more to come.

Today the Adaptor just supports the Property Management System (PMS) that is for us uninitiated the system element handling the hotels core operations such as rooms, housekeeping and associated tasks – the heart of a hotel based business. Areas such as marketing, cruise ships, point of sale (PoS) etc fall out side of PMS and are not covered today.

Why OHIP and OIC

OHIP and OIC really comes into its own because it is very easy to wire the hotel management solution to common services such as ERP and HCM functions.

For example if you’re operating a group of hotels, then each hotel will use an OPERA instance, but the group may well make use of ERP Cloud for the overall accounting, taking the costs etc identified in the hotel operations via OPERA and then those figures are put into the group ERP to provide the overall financial controls and picture.

Adaptor Foundations

The OIC Adaptor builds on top of the OHIP APIs, as a result the same restrictions on invocations, security needs exist as going to the native API. Like all OIC integration development we need to establish a connection definition which needs the URL of you OHIP instance, plus the same credentials you would use for a rest connection.

Connection Palette in OIC with oracle Hospitality highlighted

October 21 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
Field Level Encryption with Oracle Integration and OCI VaultStan TanevOIC, Vault 
Process Excel files with OIC + Oracle FunctionsStan TanevOICExcel
Setup Email Notifications with the Oracle Integration CloudDaniel TeixeiraOICOCI Email
Oracle Integration Cloud – Twilio Adapter for SMS and WhatsAppDaniel TeixeiraOICTwilio
Visual Builder – A Crash Course by Shay ShmelzerShay ShmelzerVBCS 
Configuring OIC NotificationsNiall CommiskeyOICOCI Notifications
Leveraging Grafana for OIC MetricsNiall CommiskeyOIC 
Using OIC Logging Analytics for searching OIC Activity Stream logNiall CommiskeyOICOCI Log Analytics
Surfacing OIC Design Time audit logs in OCI Logging AnalyticsNiall CommiskeyOICOCI Log Analytics
Using OCI Logging for searching OIC Activity Stream LogNiall CommiskeyOICOCI Log Analytics
OIC docs link for restricting access to OIC instancesNiall CommiskeyOIC 
Create a fixed-length file in Oracle IntegrationAnkur JainOIC 

September 21 – New OIC Articles

Latest updates, lots about use of Streaming with OIC ….

August 21 – New OIC articles

Article / LinkAuthorSubject MatterConnecting
Oracle Assistant for OICNiall CommiskeyDigital Assistant to help with using OICN/A
OIC & Blue Prism Part 3 – Invoking an OIC Integration from Blue PrismNiall CommiskeyOICRPA (Blue Prism)
Tracing and Monitoring Business Objects in Visual BuilderShay ShmeltzerVBCS 
New Features in Visual Builder – August 2021Shay ShmeltzerVBCS 
OIC Activity Stream to OCI Log analyticsShreenidhi RaghuramOICLog Analytics
Extending Oracle Fusion SaaS with OCI – IntegrationAngelo SantagataOICHCM, CX, ERP
Extending Oracle Fusion SaaS with OCI – User InterfaceAngelo SantagataOICHCM, CX, ERP
Extending Oracle Fusion SaaS – Best PracticesAngelo SantagataOICHCM, CX, ERP
Advisor Webcast: OIC JDeveloper PluginTanya HeiseOIC 
Migrate Your Oracle Integration Cloud Classic Services to Oracle Cloud Infrastructure (OCI)Elizabeth EarleOIC 
CI/CD for Oracle Integrations with Visual Builder StudioShay ShmeltzerOICOVBS
OIC Integration Lifecycle Using REST EndpointsAmy Simpson GrangeOIC 
Create Free Trial OIC Instance for one MonthKabir YadavOIC 
Tips and Tricks for handling numbers in BPEL or OICPranav DavarOIC 
Convert JSON to String in Oracle IntegrationAnkur JainOIC 
https://oracle-integration.cloud/2021/08/26/oic-scheduling-for-end-of-month-style-processes-tip-11/Phil WilkinsOIC 

Page 2 of 8

Powered by WordPress & Theme by Anders Norén