Implementing Oracle Integration Cloud Service

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

Tag: Oracle Page 1 of 3

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 

March 20 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
How to schedule OIC integration and iCal ExpressionAmit Kumar SumanOIC (Scheduling) 
Oracle Field Service Adapter and another part hereNiall Commiskey (Oracle PM)OICOracle Field Service
OIC – Service Bus integrationNiall Commiskey (Oracle PM)OICSOA OSB
Manage Custom Object in Salesforce using Oracle Integration Salesforce Adapter !!!Manish Kumar Gupta (Red Thunder)OICSalesforce
OIC Space Management simplifiedSindhu Suresh (Oracle Tech Lead)OIC 
Use Global Variables and Data Stitch to log request payloadsThomas Hora (Oracle Snr Dir of Development)OIC 
Use Data Stitch to simplify integrationsThomas Hora (Oracle Snr Dir of Development)OIC 
HDL(HCM Dataloader)support in HCM cloud AdapterAsawari Pawar (Oracle Tech Team)OICHCM
Interfacing to EPBCS with OICBarry Goodsell (Zomy)OICEPBCS
Invoke a Co-located Integration from a Parent IntegrationDaniel Martins Teixeira (Oracle Tech Solution Engineer)OIC 
When and How to Create an Integration to Call a Service from a Process?Jan KettenisOIC 
Object Storage with Oracle Integration Cloud – Part 2 (Part 1 – Jan 20)Red ThunderOICOCI
Machine Learning in Digital Process Automation — Part II (Part 1)Ralf Mueller (Oracle)OICOracle Machine Learning
See How Easily You Can Access Integration’s metadataVenkatesh Mohanram (Oracle)OIC 
Trigger OIC Integration Using OAuth Client CredentialsGreg Mally (Oracle A-Team)OIC 
Obtaining All Rows from a REST Action using Recursive Action Chain CallsDuncan Mills (Oracle)VBCS 
Oracle Integration Cloud pricing explained – OCI vs ClassicRobert van Molken (Amis)OIC 
Access OIC REST based Integrations using OAuth Token (No Password Expiry For Basic Auth User Anymore)Manish Kumar Gupta (Red Thunder)OICREST
Extract data based on multiple columns from lookup in OICAnkur JainOIC 
Simplified Test Driven Development With Oracle Visual BuilderShay Shmeltzer (Oracle PM)VBCS 
ERP Adapter in Oracle Integration CloudAnkur JainOICERP Cloud
Subscribe Oracle ERP Business Events in Oracle IntegrationAnkur JainOICERP Cloud
Netsuite Custom Field DiscoverySandeep Deshpande (Oracle)OICNetsuite
Implementing Search-As-You-Type in Oracle Visual BuilderDuncan Mills (Oracle)VBCS 
New Features In Oracle Visual Builder – March 2020Shay Shmeltzer (Oracle PM)VBCS 
Boost Your WebForm Productivity with our New Expression Builder FeaturesNicolas Damonte, and Kalyn Chang (Oracle)PCS 
New March OIC Released Features include Kafka ,Slack , NetSuite adaptors (NOB Other additions covered by blogs)OracleOICKafka, Slack, NetSuite (Async)
Kafka Adapter for OICDaniel Martins Teixeira (Oracle)OICKafka
FastConnect and VPN with Oracle Integration CloudJack Desai (Oracle)OIC 
Processing an Incident in ServiceNowNiall Commiskey (Oracle PM)OICServiceNow
Netsuite adapter – processing CustomersNiall Commiskey (Oracle PM)OICNetsuite
Weblogic JMS adapterNiall Commiskey (Oracle PM)OICJMS
Visual Builder – Understanding Backends and ServersAparna Gaonkar (Oracle)VBCS/OIC 

February 20 – New OIC Articles

This month’s new articles about Oracle Integration Cloud …

Article / Link Author Subject Matter Connecting
Visual Builder Apps run on servers other than Oracle cloud Shay Shmeltzer (Oracle Prod. Mgmt) VBCS
Showing Parent/Child in a Single Table in Visual Builder Shay Shmeltzer (Oracle Prod. Mgmt) VBCS
A Simple Guide to Connect to a Private FTP Server using FTP adapter Dinesh Pant (Oracle) OIC FTP
OIC Feature Flag – Data Stitch Niall Commiskey (Oracle Product Mgmt) OIC Box
Automate Employees On-Boarding Business Process Between Workday and Net Suite Shalindra Singh OIC Netsuite, Workday
Export table data to Excel in Oracle Visual Builder Ankur Jain VBCS Excel
Oracle Cloud Platform Application Integration 2019 Associate Ankur Jain OIC Certification
How to embed CDATA into XML Ankur Jain OIC
Oracle Integration Cloud – OIC – Introduction Bipul Shukla (Fusion Practices) OIC
One Stop Solution for OIC Certificate Management Shubham Agrawal (Snr Oracle Tech Staff) OIC
Introducing the Box Adapter in Oracle Integration Yogesh Sontakke, and Tuck Chang (Oracle Prod Mgmt) OIC Box
Oracle Integration info Guide Gary Hostt (Oracle Solution Engineer) OIC
ERP Integration using File Based Data Import Ankur Jain OIC File
Managing Oracle Process Cloud Service (PCS) Application Ankur Jain PCS
Découvrons Oracle Cloud Platform for Integration (French Series of posts) Sanae Bekkar OIC
OIC for Oracle SaaS on OIC Gen 2 Niall Commiskey (Oracle Product Mgmt) OIC
OIC – DocuSign adapter Niall Commiskey (Oracle Product Mgmt) OIC DocuSign
Oracle Cloud Security – WAF et al – DDos protection for OIC Niall Commiskey (Oracle Product Mgmt) OIC
Latest Connectivity Certification Matrix Oracle OIC
How to develop Sample Echo Integration in OIC Amit Kumar Suman OIC
Lookup integration testing Amit Kumar Suman OIC
Monitoring HCM Data Load jobs in OIC Barry Goodsell OIC HCM

Recent Articles About OIC

Update

The catalogue of articles we’ve been maintaining here has become substantial and a bit unwieldy to maintain (and we think to use). So we’re going see how periodic posts for the latest resources works.  We’ve added a new post category to the blog called CollectedArticles, which will make it easy to filter out all but these posts.

We’ll continue to include the references to who the post was from, and the aspect of OIC that is relevant.

Latest Articles

As we haven’t updated the resources for a while, this is going to be a bit larger than normal.

Article / Link Author Subject Matter Connecting
SOA Suite 12.2.1.4 / OIC interoperability Nial Commisky (Oracle Prod. Mgmt) Adaptors SOA Suite
OIC NetSuite Adaptor Nial Commisky (Oracle Prod. Mgmt) Adaptors Net Suite
New Connector for Box Nial Commisky (Oracle Prod. Mgmt) Adaptors Box
Object Storage with Oracle Integration Cloud Red Thunder Adaptors
Using Visual Builder for Process Task Forms Nial Commisky (Oracle Prod. Mgmt) VBCS / PCS
OIC Feature Flags Nial Commisky (Oracle Prod. Mgmt) Core
CPQ Integration (Part 1, Part 2) Nial Commisky (Oracle Prod. Mgmt) Adaptors Oracle CPQ
Fusion ERP Batch Imports with OIC Nial Commisky (Oracle Prod. Mgmt) Adaptors ERP
Why and How to Integrate Oracle Policy Automation with Oracle Integration Cristian Silipigni (Oracle Solution Engineer) Adaptor Oracle Policy Automation
Testing REST trigger-based Integrations in OIC Console Sumit Tomar (Oracle Snr Technical Staff) Adaptors
Encrypt/Decrypt capabilities in Stage Files Bipin Kumar (Oracle Tech Lead) Adaptors
Integration Patterns – Publish/Subscribe (Part 1, Part 2) Daniel Martins Teixeira (Oracle Tech Solution Engineer) Core
Using the next generation Activity Stream Mamta Sangwan (Oracle Snr Tech Staff) Core
Send Notification with attachment Ankur Jain (Oracle Ace Associate) Adaptor
Editable Table in VBCS Ankur Jain (Oracle Ace Associate) VBCS
Oracle ATP Adaptor Ankur Jain (Oracle Ace Associate) Adaptor Autonomous Transaction Processing
Defining and using constants Jans Kettenis Core
Auto-Mapping Elements in the Data Mapper Jans Kettenis Core
Progressive Web App UI Experience Harish Vinayachandran (Oracle) Core
ICS – XSLT parameters that are not found but are being used ??? Marcel van de Glind Core
How Much Oracle Integration Cloud Do I Need? Rubicon Red Core

 

Oracle Open World 18

Oracle Open World 2018 is upon us, and here are some suggested sessions:

  • Antipatterns for Integration: Common Pitfalls [PRO6175]
  • Deep Dive: Application Integration on Oracle Cloud [TRN6458]
  • Enhance your CX Applications with Oracle Integration Cloud [HOL6299]
  • Oracle SOA Suite Hybrid Options with Oracle Integration Cloud [TIP4530]
  • Accelerate DigitalOps with Oracle Integration Cloud and UiPath RPA [THT6590]
  • The Future of Integration with Machine Learning and Artificial Intelligence [TIP1372]
  • Extending and Connecting Applications with Oracle Integration Cloud [HOL6298]
  • FedEx Hybrid Cloud Integration Strategy [CAS3614]
  • Integrating Your ERP and HCM with Oracle Integration Cloud [HOL6314]
  • Simplify and Accelerate Digital Transformation with Oracle Integration Cloud [PRO4539]
  • The Path to a Digital Workforce with Oracle Integration Cloud [PRO4515]
  • American Red Cross Modernizes Disaster Relief with Oracle Integration Cloud [CAS4877]
  • Unleash Your Business Processes Your Way with Oracle Integration Cloud [PRO4536]
  • Quick Wins Your Business Will Love Using Oracle Integration Cloud [THT6824]
  • Simplify and Accelerate Digital Transformation with Oracle Integration Cloud [PRO4518]
  • Application Integration on Oracle Cloud [TRN6352]
  • DevOps: Oracle SOA, Oracle WebLogic, Oracle Integration Cloud, Oracle Java Cloud Service [CAS3896]
  • Get Insight into Oracle Integration Cloud/Oracle Java Cloud Service Performance [PRO4478]
  • AI-Powered Oracle Integration Cloud and Oracle API Platform Cloud Service [PRO6176]
  • Connect with Oracle ERP Cloud or Oracle HCM Cloud with Oracle Integration Cloud [PRO4538]
  • Oracle Integration Cloud Customer Panel: Real-World Digital Transformation Uses Cases [CAS5691]
  • Simplifying Oracle HCM Cloud Integrations [PRM3890]
  • Integrating with Oracle ERP Cloud Using Oracle Integration Cloud Service [THT6831]
  • Oracle Integration Cloud Best Practices Panel: Transforming to Hybrid Cloud [CAS5215]
  • Oracle Integration Cloud Customer Panel: Integrating SaaS into Your Application Network [CAS4491]
  • Broader, Better, Faster: Capgemini’s Blueprint for Oracle Cloud in UK Police [CAS3273]
In addition to the core ICS/ OIC / AIC sessions self service integration cloud is well covered this year.

ICS to OIC

We have had a number of interesting conversations of late about the transition from ICS to OIC and to spice the discussion whether it should be OIC or Autonomous OIC. The reality of the situation is that the transition between ICS and OIC is a relatively straight forward one using the export and import tooling.

The real challenge is the impact to organisations appears to be the change in licensing models as OIC works with the newer Universal Credit Model (UCM) where as ICS is in the older arrangement of traditional accounts where you buy the use of specific services, in some ways not too different from traditional Oracle traditional product licensing. For organisations that operate with corporate level buying teams this is organisationally more challenging. As just buying credits can feel like your giving the IT children pocket money and you don’t trust them to ensure the money is spent wisely and they don’t come running back a day later when they say spent all the money can we have some more.

IOC or Autonomous OIC

For the smaller customers where they’re generating less than 5000 Messages per hour (think Integration triggers where each message is <50k – which is fairly big for most needs. Although be aware but moving large files is going to eat through your messages as the transfer cost is file size / 50k = no. messages used (consumed or sent), of effectively 250MB per hour. The autonomous option is a no brainer for smaller use cases in terms of cost as it means on current pricing you have your integrations operating for a lot less than £500 per month (£0.5867 x 24 x 30 – using standard with the flex schemehttps://cloud.oracle.com/en_US/OIC/pricing). With that the SaaS adaptors are also included – that means you could operate say Workday to Oracle Financials for an SME without much problem.

Note: Presently June 2018 Edition of Oracle PaaS and IaaS Universal Credits Service Descriptions - does not clearly define KB and mixes KB and Kb. Having raised this with product management it has been confirmed to mean KiloBytes and NOT Kilobits

As the volumes increase, the differences are going to change, whilst we haven’t done the maths, we’d expect the increasing volumes to eventually favour traditional OIC.

The rules do go beyond simple messages when the Visual Builder (VBCS) and Process (PCS) elements gets involved. The formulas do boil down to users and message counts so the maths are relatively managable. Note the explination for concurrent users is a little more complex than may first appear, and worthy of a blog explination in its own right.

There are other considerations as well for Autonomous OIC vs standard OIC, such as whether you want to have more or less control on the processes such as absorbing updates, handling backups, whether you need to isolate the data from everyone else – and this is a question that is likely to be driven by compliance over anything else for most. Whilst we’ve just highlighted the list prices, when doing the calculations of the cost benefit, you need to factor in the skill sets involved in the different options and the ability to respond to dynamic demand.

Just to link it back to the book, whether its OIC or Autonomous OIC the integration engeine is essentially still the same as ICS. So reading about ICS is still going to help, of course there will be some cosmetic differences, but the fundamentals remain the same.

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.

Read More

Continued Evolution of OIC and this site

The transformation of Oracle Integration Cloud Service (ICS) into Oracle Integration Cloud (OIC) continues to progress. If you’ve read our earlier posts (such as this) on the subject you’ll remember that ICS becomes part of OIC, and depending on which version of OIC you take you will also see other components including:

  • Visual Builder Cloud Service (VBCS)
  • Process Cloud Service (PCS)
  • Insights

Whilst the product is evolving, the heart of  our book remains very relevant to the integratiobn capabilities of OIC, even if the screen shots have changed a little.  But what does this all mean to this website?  As authors we’ve been a bit preoccupied with our current writing projects as they come to a close (Implementing API Platform and Blockchain Across Oracle). But worry not, we will be adding content.  At the very least in the immediate time we have continued to capture and maintain the list of external articles we think are helpful and informative here.

On the subject of the of this catalogue, as the scope of OIC has grown and we’ll start to see lots of material around the PCS capabilities under the OIC title, and of course PCS in its pre-OIC form are still very relevant.  In the coming days we’ll incorporate into the catalogue an additional filter to separate sections to cover the different underlying products/capabilities and add start to pickup related content. it maybe necessary to go as far as plitting the catlogue as we already have over 100 referenced entries.

As for articles on this stie, we’ll continue to focus on the integration side of things.  For a good look at PCS, we’d recommend checking out the award winning Jarvis Pizzaria material – check it out here.

 

Oracle Integration Cloud Update

As previously mentioned, ICS is going to be incorporated into Oracle Integration Cloud.  Since we have had the announcement we have had some more information about OIC released.

The keypoints here are:

OIC Standard Edition

OIC Enterprise Edition

What we used to know as Integration Cloud Service, which includes …

  • Various integration patterns including Orchestration
  • All tech and SaaS adaptors available – more flexibility (not a licensing factor now)
  • MFT style features

Visual Cloud Builder – ability to build simple UIs

Standard Edition plus ..

Process Cloud capabilities

Analytics features – Streams and Insight product

Enterprise Solutions Adaptors – e.g. Seibel, EBS etc

Requires a DB Requires a DB

To support Integration and Stream Analytics …

  • Oracle Event Hub (Kafka)
  • Big Data Cloud Service – Compute Edition
  • Oracle Big Data Cloud Service – Compute Edition (needed for Spark)

 

This and related information can be found in a new presentation that can be seen at:

Integration Cloud Service, SOA Cloud Service or Integration Cloud, are you confused?

Oracle have announced Oracle Integration Cloud, the next evolution in their cloud integration capabilities. So how does it relate to the existing Cloud based integration products and what is the future of different products?

Read More

Page 1 of 3

Powered by WordPress & Theme by Anders Norén