Implementing Oracle Integration Cloud Service

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

Tag: cloud

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.

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

Selecting which iPaaS Product(s) to use – ICS Definitive Tip #4

In the last few years Oracle’s iPaaS offerings have progressed significantly from one or two solutions such as Mobile Cloud Service to in excess of 35 offerings. This makes it challenging to decide which product(s) to use. The means for selection depends upon a range of factors including:

  • Most suitable licensing model (ICS provides a lower cost of entry than SOA CS as you’re paying by message volumes)
  • Development skills and desire to resilience or invest in people (SOA on-premises to SOA CS is easier than a technology change such as ICS)
  • The amount of control you have in an environment – JCS offers more control than ACCS for example

Read More

Consolidated References of 3rd Party Information on ICS and OIC

Last updated: March 22, 2018 at 8:28 am

Online 3rd Party ResourcesWe have consolidated all the 3rd Party references we know of regarding ICS into this single page.

As we encounter new information we will update the details, and if you encounter useful information missing from this list, please let us know (tweet @ImplementingICS with #ICS)

3rd Party References & Resources

TitleSourceDate
(YY/MM)
Subject AreaProduct/ OIC Component
Promoting Integrations from dev to productionOracle A Team16/02Config MgmtICS
ICS scripts for cleaning up environmentsOracle A Team16/06Config MgmtICS
SOA Myth Busters intro to ICSSOA Myth Busters Blog16/05OverviewICS
Cloud Adaptors introductionNiall Commiskey (Oracle PM)15/06AdaptersICS
On Premise AgentOracle A Team16/11AgentICS
Enhancing ICS Mappings with Java ClassesOracle A Team17/01Core ICSICS
ICS IntroAMIS (Oracle Partner)15/05OverviewICS
Developer’s 1st ImpressionAMIS (Oracle Partner)16/03OverviewICS
ICS connectivity AgentAMIS (Oracle Partner)16/03AdaptersICS
ICS and SalesforceAntonis Antoniou (Ace director)15/12AdaptersICS
eBS Adapter with ICSOracle A Team16/04AdaptersICS
ICS with TwitterAMIS (Oracle Partner)16/03AdaptersICS
ICS for offering REST versions of SOAP APIsAMIS (Oracle Partner)16/02AdaptersICS
ICS Security & ComplianceOracle A Team16/05Core ICSICS
ICS Use case: Closed Loop Order ManagementOracle Community Blog16/08Core ICSICS
Oracle Integration Cloud Service (ICS) – How to use Upsert OperationShalindra Singh15/10Core ICSICS
Oracle Integration Cloud Service – How to keep all data residing in your applications in syncesentri16/05Core ICSICS
Eloqua ICS IntegrationOracle A Team17/01AdaptersICS
Understanding the Enterprise Scheduler Service in ICSOracle A Team17/01Core ICSICS
Teaching how to use the Integration Cloud Service Connectivity AgentSolutions ANZ
(Oracle Australia)
17/02AgentICS
Using ICS to offer APIs on integrationsSolutions ANZ
(Oracle Australia)
17/02Core ICSICS
Integrating Sales Cloud and Service Cloud using ICS – troubleshooting issues with security configurationOracle A Team17/01AdaptersICS
ICS Connectivity Agent – Update CredentialsOracle A Team17/02AgentICS
Oracle ICS and Twilio: Publish-Subscribe Integration PatternRubicon Red17/02Core ICSICS
Help! What Integration Solution is Best for Me?Oracle Community16/07Core ICSICS
Oracle ICS + TwitterS&P Solutions16/04AdaptersICS
Oracle Integration Cloud Service Linkedin adapter.Oracle Radio16/10AdaptersICS
Oracle Integration Cloud Service Linkedin adapter (Spanish version)Oracle Tech Network16/12AdaptersICS
Integrate Your Applications in the CloudOracle Community16/07OverviewICS
Integrate Your HR System with a Talent Management System in the CloudOracle Community16/07AdaptersICS
Using Oracle Managed File Transfer (MFT) to Push Files to ICS for ProcessingOracle A Team17/02AdaptersICS
ICS 17.1.3 – Javascript LibrariesNiall Commiskey (Oracle PM)17/02Core ICSICS
Connecting ICS and Apache Kafka via REST Proxy APIOracle A Team17/02AdaptersICS
Teaching how to use Developer Cloud Service to promote ICS Integrations into new EnvironmentsSolutions ANZ
(Oracle Australia)
17/02config MgmtICS
Custom 2-legged OAuth with Oracle Integration Cloud Service (ICS)Solutions ANZ
(Oracle Australia)
17/02Core ICSICS
Integrating with Taleo Enterprise Edition using Integration Cloud ServiceOracle A Team17/03AdaptersICS
Oracle Public Cloud – Invoking ICS endpoints from SOA CS – configure SSL certificate and basic authenticationAMIS (Oracle Partner)17/03Config MgmtICS
Lifecycle management – Test 2 ProductionNiall Commiskey (Oracle PM)17/02Config MgmtICS
PCS 17.1.3 leveraging ICSNiall Commiskey (Oracle PM)17/04AdapterICS
ICS Execution AgentNiall Commiskey (Oracle PM)16/01AgentICS
ICS Part 1 (Spanish)Avanttic (Spanish Partner)17/02OverviewICS
ICS Part 2 (Spanish)Avanttic (Spanish Partner)17/03OverviewICS
Suggested ICS Naming standardsGowrishankar’s Blogspot17/02Config MgmtICS
Some ICS Best Practises (naming and eror handling)Gowrishankar’s Blogspot17/02Core ICSICS
ICS Connectivity Agent stdout Log RotationOracle A Team17/03AgentICS
Integrating with ERP Cloud using ICSOracle A Team17/03AdaptersICS
Global Fault HandlingNiall Commiskey (Oracle PM)17/03Core ICSICS
Using Business Events in E-Business Suite to send messages to other applications via ICSOracle A Team17/04AdaptersICS
ICS 17.1.3 Release FeaturesOracle Integration Blog17/03OverviewICS
ICS Command Line ToolOracle A Team17/04Config MgmtICS
Automate ERP Cloud Batch Uploads using Oracle MFT and Integration Cloud ServiceSolutions ANZ
(Oracle Australia)
17/04AdaptersICS
Comparing Oracle ICS connectors with Workday, Mule, Boomi and AzureSOA4U
(Luis Weir Ace Director)
16/08AdaptersICS
ICS 17.1.3 FTP adapter and File StagingNiall Commiskey (Oracle PM)17/03AdaptersICS
Un repaso a Oracle Integration Cloud service, la nube de integración (An ICS review in Spanish)Oracle Technet16/10Core ICSICS
USING ORACLE CLOUD ADAPTER FOR SERVICENOW.COM ON ICSShalindra Singh17/03AdaptersICS
Automate ERP Cloud Batch Uploads using Oracle MFT and Integration Cloud ServiceSolutions ANZ
(Oracle Australia)
17/04AdaptersICS
Teaching how to integrate Twitter with Integration Cloud ServiceSolutions ANZ
(Oracle Australia)
17/05AdaptersICS
Integrating with Oracle Field Service Cloud using ICS REST adapterOracle A Team17/05AdaptersICS
Integrity check, content validation and encryption of files over ICS FTP adapterOracle A Team17/05AdaptersICS
Monitoring REST APIsNiall Commiskey (Oracle PM)17/05AdaptersICS
SOAP & REST with the Connection AgentNiall Commiskey (Oracle PM)17/04AgentICS
REPL Based Management UtilityNiall Commiskey (Oracle PM)17/04Config MgmtICS
Integrate Sugar CRM & Eloqua in few hours using Oracle Integration Cloud Service (ICS)Ramanandh (Ram) Sankaralingam
Digital Prime at Oracle Australia
17/06AdaptersICS
Rest API call of Post method by passing the Query parameters as a request in Oracle Integration Cloud ServiceInnovacx17/07AdaptersICS
Handling multiple responses dynamically in ICS OrchestrationInnovacx17/07Core ICSICS
FAQ: Integrating E-Business Suite using Integration Cloud ServiceOracle A Team17/07AdaptersICS
Docker image for the Oracle Integration Cloud (ICS) Execution AgentJeroen Ninck Blok via SOA Community17/07AgentICS
Oracle Mobile Cloud Service (MCS) and Integration Cloud Service (ICS): How secure is your TLS connection?AMIS (Oracle Partner)17/07Core ICSICS
How to write files using ICS file adapterAnkur Jain17/07AdaptersICS
ICS File handling options and tipsOracle A Team17/08AdaptersICS
ICS - API Platform IntegrationNiall Commiskey (Oracle PM)17/08AdaptersICS
ICS Map My Data labNiall Commiskey (Oracle PM)17/08Core ICSICS
17.2.5 New FeaturesNiall Commiskey (Oracle PM)17/06Core ICSICS
Management & Monitoring EnhancementsNiall Commiskey (Oracle PM)17/06Core ICSICS
ICS File handling options and tipsOracle A Team17/08AdaptersICS
2 MTT Transport Layer Security in ICS and MCSAMIS (Oracle Partner)17/08Core ICSICS
ICS SOAP Connection – Retrieve File Uploaded WSDLOracle A Team17/08AdaptersICS
How to read file using ICS file adapterAnkur Jain17/09AdaptersICS
CS On-Premise Monitor – Agent PingOracle A Team08/17AgentICS
Consuming HCM atom feeds in ICSOracle A Team09/17AdaptersICS
Test driven SOA: Tool kit for comprehensive automated test coverageThe Middle Tier09/17TestingICS
Exception handling(Global Fault Handler) in Oracle ICSAnkur Jain10/17Core ICSICS
Read large CSV file in Integration Cloud ServiceAnkur Jain10/17AdaptersICS
Uploading SSL certificate in Oracle Integration Cloud Ankur Jain10/17Core ICSICS
Last Run Date and Time in Oracle ICS (Integration Cloud Service)Ankur Jain10/17Core ICSICS
ICS Best Practices : Before going live and post go-liveOracle A Team10/17Config MgmtICS
Microsoft Calendar Adapter in Oracle Integration Cloud Service (ICS)Ankur Jain10/17AdaptersICS
Convert UTC Date & time to another timezone in Oracle Integration Cloud Service(ICS)Ankur Jain10/17Core ICSICS
Bind query parameter in database adapter in Oracle Integration Cloud ServiceAnkur Jain11/17AdaptersICS
Using Business Events in Fusion-based SaaS with Oracle Integration Cloud Service – Part 1Oracle A Team12/17CoreICS
Using Business Events in Fusion-based SaaS with Oracle Integration Cloud Service – Part 2Oracle A Team12/17CoreICS
OIC Trial - adding Integration InsightNiall Commiskey (Oracle PM)12/17OIC InsightICS
Oracle Integration Cloud Public PageNiall Commiskey (Oracle PM)12/17OICICS
NetSuite Adapter in actionNiall Commiskey (Oracle PM)12/17OIC AdaptersICS
Oracle Integration Cloud (OIC) - the cloud platform for Integration and AutomationNiall Commiskey (Oracle PM)11/17OICICS
File Upload Process in Integration Cloud Services REST APIAnkur Jain12/17AdaptersICS
Conditional Mapping in Oracle ICSAnkur Jain12/17CoreICS
Adding WAIT functionality to an ICS/OIC orchestrationNiall Commiskey (Oracle PM)01/18CoreICS
How do I test my integration on Oracle Integration Cloud ServiceKevin King01/18CoreICS
Using Oracle Integration Cloud and Twilio to send SMS with RESTKollin Brandenburg03/18AdaptersICS
ICS Maven PluginKevin King03/18ToolsICS Tools
Custom function in ICS to extend transformation capabilitiesAnkur Jain02/18CoreICS
Database polling in Oracle Integration Cloud ServiceAnkur Jain11/17AdaptersICS
ICS / OIC development guidelinesNiall Commiskey (Oracle PM)03/18ToolsICS
Oracle Integration Cloud (OIC) and Robotic Process Automation (RPA)Niall Commiskey (Oracle PM)02/18RPAICS
OIC Quickstart and User CreationNiall Commiskey (Oracle PM)02/18ToolsICS
Oracle ICS/OIC Prebuilt integrationsNiall Commiskey (Oracle PM)01/18IntegrationsICS
Adding WAIT functionality to an ICS/OIC orchestrationNiall Commiskey (Oracle PM)01/18CoreICS
NetSuite Adapter in action

OIC - NetSuite example enriched

Niall Commiskey (Oracle PM)12/17AdaptersICS
OIC and ICS File based integrations for Oracle HCM Cloud using UCM webservicesShreenidhi Raghuram - Oracle A Team02/18AdaptersICS
Extending analytics for Integration cloud using Elastic stack.Mani Krishnan (Oracle A Team)03/18ToolsICS
NetSuite Integration Series: Part 1: Using User Event Scripts for real time integration using Integration Cloud Naveen Nahata (Oracle A Team)02/18AdaptersICS
Oracle Integration Cloud Service for EPM Part 1 Part 2, Part 3 Vijay Kurian02/18AdaptersICS
Introducing Jarvis PizzeriaJarvis Pizzeria Team08/17PCS
AVIO Releases an ICS Maven PluginAvio03/18ToolsICS
Oracle ICS - Advanced XSLT Mapping in JDeveloperAvio04/18ToolsICS
How to install the Oracle Integration Cloud on premises connectivity agentAMIS04/18AgentOIC
Fitter email Message of a Folder using Microsoft Email adapter in Integration Cloud ServiceAnkur Jain04/18AdaptorsICS
Integration instance tracing in OICNiall Commisky04/18CoreOIC
Customer Managed Cloud PatchingJan Kettenis03/18CoreOIC
Selecting Maintainence DatesOracle Support04/18CoreICS
Oracle University - Free Training VideosOracle University04/18CoreICS
Dynamic Process, Conditions and ScopeJan Kettenis05/18CoreOIC
New Data MapperJan Kettenis04/18CoreOIC
TYerraform OIC DeploymentRed Thunder03/18ToolsOIC
Installing Connectivity Agent 18.1.3AMIS04/18AgentOIC
Visual Builder connecting to Autonomous OICNiall Commisky06/18Visual BuilderOIC
Autonomous OIC - The Value AddNiall Commisky05/18AutonomousOIC
Eloqua ConnectivityNiall Commisky05/18AdaptorsOIC
Instance Tracibng in OICNiall Commisky04/18CoreOIC

ICS Useful 3rd Party Resources

Oracle Document Reference Links…

ResourceDescription - Link
Adapter CertificationOracle Adapter Certification Matrix
ICS Cloud Documentation HomeICS Cloud Latest Edition Documentation
Oracle Online LearningOLL - YouTube ICS Training Playlist
Eloqua ICS Connectivity (Eloqua Help Center)Eloqua Cloud Herlp Centre
All A-Team ICS Postshttp://www.ateam-oracle.com/category/cloud/paas/paas-ics/
Oracle Integration BlogBlog covering all Oracle's Integration offerings
OIC Analyst ReportOIC analyst Report

Tools That May Help …

ToolLink
Online WSDL pretty print/viewerhttps://www.wsdl-analyzer.com/online-wsdl-viewer
Web Services Directoryhttp://www.webservicex.net/New/
Apiary (Swagger / Open API & API Blueprint designer)https://apiary.io/
Mockable - Endpoint Mockinghttps://www.mockable.io/

Oracle Messaging Cloud Service (OMCS) on Trial

This post provides a fairly detailed introduction to registering and creating a trial instance of Oracle Messaging Cloud Service. We have written this as in our book Introducing Oracle Integration Cloud Service (ICS) we use Oracle Messaging Cloud  Service(OMCS) in chapter 8 to illustrate message based integration outside  of ICS. Whist we describe the process for OMCS, the mechanics are similar for a number of the iPaaS offerings from Oracle including ICS, PCS but not SOA CS as this is a far more complex product and the fee charging structure is rather different.

In the screenshots of the process that follows, we have blurred out key credentials, this is purely for personal security reasons.

The first step is to create the trial of OMCS, to do this you need an Oracle account. This can be done from the main Oracle site. If you already have an account with Oracle Technology Network (OTN) or Oracle community then you are already sorted as Oracle operates a single sign on.

Read More

Powered by WordPress & Theme by Anders Norén