Article / Link | Author | Subject Matter | Connecting |
---|---|---|---|
OIC & OAuth 2.0 (Part 1, Part 2, Part3) | Niall Commiskey | OIC | |
OIC Responsys Adapter | Niall Commiskey | OIC | Responsys |
OIC On OCI Status Page | Elizabeth Earle | OIC | |
Create Schedule Service SOAP Connection | Kabir Yadav | OIC | |
Schedule BI Publisher Report through OIC | Kabir Yadav | OIC | BI Publisher |
Subscribe to HCM Updates ( via ATOM Feed ) | Kabir Yadav | OIC | HCM |
Configure Oracle HCM Cloud Adapter Connection | Kabir Yadav | OIC | HCM |
Subscribing to Business Events in OIC | Yan Scorrer | OIC | |
Split a CSV file into multiple based on a column in OIC | Ankur Jain | OIC | |
https://www.techsupper.com/2022/04/how-to-call-oracle-saas-ess-job-using-oracle-integration.html | Ankur Jain | OIC | |
How to create and test custom ESS job in Oracle SaaS | Ankur Jain | OIC | |
Reading the latest file from SFTP in OIC | Ankur Jain | OIC |
Tag: Oracle Page 3 of 7
Another month passed already, so here are Feb’s posts.
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 / Link | Author | Subject Matter | Connecting |
---|---|---|---|
CI/CD working with EiPaaS Oracle Integration (OIC) | Cristian Silipigni | OIC | CI/CD |
Speed up your Accounting Closing Cycle with automated loading of Payable Invoices into Oracle ERP Cloud, using Oracle Integration Cloud | Juan Carlos | OIC | CX/ ERP/ ServiceCloud |
Quarterly Updates | Phil Wilkins | OIC | |
Using the Oracle Cloud Infrastructure Streaming Service Adapter with Oracle Integration | – | OIC | Streams |
Build retry logic in Oracle Integration | Ankur Jain | OIC | |
Call VB Business Objects from Oracle Integration | Ankur Jain | OIC |
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.
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.
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.
Article / Link | Author | Subject Matter | Connecting |
---|---|---|---|
Field Level Encryption with Oracle Integration and OCI Vault | Stan Tanev | OIC, Vault | |
Process Excel files with OIC + Oracle Functions | Stan Tanev | OIC | Excel |
Setup Email Notifications with the Oracle Integration Cloud | Daniel Teixeira | OIC | OCI Email |
Oracle Integration Cloud – Twilio Adapter for SMS and WhatsApp | Daniel Teixeira | OIC | Twilio |
Visual Builder – A Crash Course by Shay Shmelzer | Shay Shmelzer | VBCS | |
Configuring OIC Notifications | Niall Commiskey | OIC | OCI Notifications |
Leveraging Grafana for OIC Metrics | Niall Commiskey | OIC | |
Using OIC Logging Analytics for searching OIC Activity Stream log | Niall Commiskey | OIC | OCI Log Analytics |
Surfacing OIC Design Time audit logs in OCI Logging Analytics | Niall Commiskey | OIC | OCI Log Analytics |
Using OCI Logging for searching OIC Activity Stream Log | Niall Commiskey | OIC | OCI Log Analytics |
OIC docs link for restricting access to OIC instances | Niall Commiskey | OIC | |
Create a fixed-length file in Oracle Integration | Ankur Jain | OIC |