Implementing Oracle Integration Cloud Service

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

Tag: Integration

Integration with APIless Systems – Leveraging RPA – Definitive Tip #10

Traditionally integrating with systems that don’t offer APIs or a shared storage mechanism (such as open tables) has been something of a headache often resulting in the ‘last mile’ of the integration process being manual. The manual steps often come because the cost of building and maintaining the means to integrate has not been cost effective or even an option (vendor has end of lifted a product, and not willing to add an integration mechanism).

The idea of ‘screen scraping’ isn’t new, but the cost of implementing such mechanisms has dropped and the new generation of Robotic Process Automation (RPA) tools such those provided by UiPath have made it significantly easier to integrate and automate UI driven processes. Whilst UI based integration isn’t recommended as a first option for integration, it shouldn’t be ruled out particularly as it gets easier and easier to generate and maintain the UI automation. There are several factors that need to be considered as to whether such an approach is appropriate, for example:

  • the ability to run a robot to execute the UI interaction,
  • the volume of data needing to be moved through the UI – you wont escape the latency issues that may exist with UI steps,
  • is the UI being automated changing rapidly (is there enough cost benefit for automating)

1Oracle have been working in partnership with one of the leading RPA product vendors – UiPath, which has resulted in an adaptor for Oracle Integration Cloud.  The adaptor allows you to pass data to the UiPath Orchestrator component which will run the processes in an unattended mode.  In the adaptor configuration you provide information about how many resources you want the Orchestrator to apply to the task, the queuing of the job and so on.

UIP_4698_WEBSITE-GRAPHICS_WEB_100518

UiPath’s Architecture

for more information on RPA and the adaptor the following links maybe of help:

Whilst Oracle’s roadmap in the RPA space is not entirely clear we have heard indications that Oracle are limiting themselves to just UiPath (this is what UiPath say about the partnership).

Regardless of the approach you’ll see that the adoption of RPA is important in Oracle’s vision, with their Agile Finance making a clear indication of its view (see the paper here).

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.

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

2 Minute Tech Tip

We have released a 2 minute tech tip through the Oracle Technology Network (OTN) which talks through the creation of a simple end to end integration using Oracle’s Integration Cloud Service (ICS).

 

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: October 24, 2018 at 9:55 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)

(Oct 18) Big batch of additional resources added to the table

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
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/04Adapters (ERP)ICS
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/03Adapters (FTP)ICS
Un repaso a Oracle Integration Cloud service, la nube de integración (An ICS review in Spanish)Oracle Technet16/10Core ICSICS
Using Oracle Cloud Adaptor for ServiceNow on ICSShalindra Singh17/03Adapters (Service Now)ICS
Automate ERP Cloud Batch Uploads using Oracle MFT and Integration Cloud ServiceSolutions ANZ
(Oracle Australia)
17/04Adapters (ERP)ICS
Teaching how to integrate Twitter with Integration Cloud ServiceSolutions ANZ
(Oracle Australia)
17/05Adapters (Twitter)ICS
Integrating with Oracle Field Service Cloud using ICS REST adapterOracle A Team17/05Adapters (Field Service)ICS
Integrity check, content validation and encryption of files over ICS FTP adapterOracle A Team17/05Adapters (FTP)ICS
Monitoring REST APIsNiall Commiskey (Oracle PM)17/05Adapters (REST)ICS
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/06Adapters (Eloqua)ICS
Rest API call of Post method by passing the Query parameters as a request in Oracle Integration Cloud ServiceInnovacx17/07Adapters (REST)ICS
Handling multiple responses dynamically in ICS OrchestrationInnovacx17/07Core ICSICS
FAQ: Integrating E-Business Suite using Integration Cloud ServiceOracle A Team17/07Adapters (EBS)ICS
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/07Adapters (File)ICS
ICS File handling options and tipsOracle A Team17/08Adapters (File)ICS
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/08Adapters (file)ICS
2 MTT Transport Layer Security in ICS and MCSAMIS (Oracle Partner)17/08Core ICSICS
ICS SOAP Connection – Retrieve File Uploaded WSDLOracle A Team17/08Adapters (SOAP)ICS
How to read file using ICS file adapterAnkur Jain17/09Adapters (File)ICS
CS On-Premise Monitor – Agent PingOracle A Team08/17AgentICS
Consuming HCM atom feeds in ICSOracle A Team09/17Adapters (HCM)ICS
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/17Adapters (File)ICS
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/17Adapters (MS Calendar)ICS
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/17Adapters (DB)ICS
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/17Adapters (Netsuite)ICS
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/17Adapters (File)ICS
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/18Adapters (Twilio)ICS
ICS Maven PluginKevin King03/18ToolsICS Tools
Custom function in ICS to extend transformation capabilitiesAnkur Jain02/18CoreICS
Database polling in Oracle Integration Cloud ServiceAnkur Jain11/17Adapters (DB)ICS
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/17Adapters (Netsuite)ICS
OIC and ICS File based integrations for Oracle HCM Cloud using UCM webservicesShreenidhi Raghuram - Oracle A Team02/18Adapters (HCM)ICS
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/18Adapters (Netsuite)ICS
Oracle Integration Cloud Service for EPM Part 1 Part 2, Part 3 Vijay Kurian02/18Adapters (EPM)ICS
Introducing Jarvis PizzeriaJarvis Pizzeria Team08/17PCSPCS
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/18Adaptors (MS Exchange)ICS
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/18CoreOIC
Eloqua ConnectivityNiall Commisky05/18Adaptors (Eloqua)OIC
Instance Tracibng in OICNiall Commisky04/18CoreOIC
Securely Connect to REST APIs from Oracle Integration CloudAnuj Kaushal (Oracle)10/18Adaptors (REST)OIC
How to invoke an Integration From another Integration in OIC without creating a connectionArif Rafique (Oracle)10/18CoreOIC
A simple guide to use nested scope in orchestrationArif Rafique (Oracle)10/18CoreOIC
Timezone functionality in OIC SchedulesArya Sanyal (Oracle)10/18CoreOIC
API-Key Based Authentication: Quickly and EasilyAnuj Kaushal (Oracle)10/18AdaptorsOIC
Scaling Oracle Integration CloudAntony Reynolds (Oracle)08/18CoreAutonomous OIC
How to enable and use Tracing in less than 5 minMuthu Palanisamy (Oracle)09/18CoreOIC
How to use Litmus to create OIC Integration unit tests automatically and run them to catch regressionsMuthu Palanisamy (Oracle)09/18Litmus aka AsserterOIC
Enabling the Future Today - Feature Flags in Oracle Integration CloudAntony Reynolds (Oracle)09/18CoreOIC
Using a Library in OICHarish Vinayachandran (Oracle)09/18CoreOIC
Integration Cloud – File Handling Primer Shreenidhi Raghuram (Oracle A-Team)06/18CoreOIC
Introduction to Cloud Application IntegrationArijit Chakraborty06/18CoreAutonomous OIC
Some Tips for Working with Visual Builder UI Components in Oracle Integration CloudSiming Mu (A-Team Oracle)06/18Visual BuilderOIC
ICS to OIC MigrationAbhay Kumar (A-Team Oracle)07/18CoreICS/OIC
Agent Group Existance Check Failed, Recheck ICS Username, ICS Password and Proxy Username, Proxy Password or Contact Customer SupportAnkur Jain06/18AgentsICS
Oracle Autonomous Integration Cloud (AIC): Read ZIP files using FTP adapter and load data into on-premise applicationAnkur Jain10/18Adaptor (FTP)AIC
Salesforce integration in Autonomous Integration Cloud (AIC)Ankur Jain10/18Adaptor (Salesforce)AIC
Oracle Integration Cloud Service AgentAnkur Jain10/18AgentICS
CRUD Operation in Oracle Integration Cloud Ankur Jain09/18CoreOIC
Provisioning the Oracle Integration Cloud (OIC) InstanceAnkur Jain08/18CoreOIC
Date Time by adding / subtracting n number of days / hours / minutes in ICSAnkur Jain08/18CoreICS
Leverage Microsoft Email Adapter to send email using Oracle Integration Cloud (OIC) Ankur Jain08/18Adaptors (MS Exchange)ICS
CASDK-0007 Unable to establish a secure connection to oracleebs.com. SSL protocol related exception occurredAnkur Jain07/18AdaptorsICS
OIC 18.4.1 New FeaturesNiall Commiskey (Oracle PM)10/18CoreOIC
OIC --> File Transfer Pattern ala MFT pass by referenceNiall Commiskey (Oracle PM)10/18Adaptor (MFT)OIC
VB CS / Process Integration - Surfacing the Task Payload in VB CSNiall Commiskey (Oracle PM)09/18Visual Builder / PCSOIC
Building your First VBCS ApplicationJohn Ceccarelli (Oracle)05/18Visual BuilderOIC
OIC integration with Fusion HCM & the efficacy of BI reports & HCM REST APIsNiall Commiskey (Oracle PM)08/18Adaptors (HCM)OIC
OIC Insight REST APINiall Commiskey (Oracle PM)08/18InsightsOIC
OIC Integration 101 Part IV - Error NotificationNiall Commiskey (Oracle PM)08/18CoreOIC
OIC Integration 101 Part II --> Orchestrations and MonitoringNiall Commiskey (Oracle PM)08/18CoreOIC
Decisions in OIC (Process)Niall Commiskey (Oracle PM)07/18PCSOIC
SSI invoking OICNiall Commiskey (Oracle PM)07/18Adaptors (SSI)OIC
New JET based OIC MapperNiall Commiskey (Oracle PM)07/18CoreOIC
Autonomous OIC --> Process REST APINiall Commiskey (Oracle PM)06/18CoreAIC
VB CS --> Integration Connectivity with Autonomous Integration CloudNiall Commiskey (Oracle PM)06/18Visual BuilderAIC
Uncovering Booking Fraud with Oracle Process Cloud Service (PCS) and Decision Model Notation (DMN)Arun Pareek (Rubicon Red)05/18PCSOIC
Patient Health Monitoring with Oracle IoTCS and PCSArun Pareek (Rubicon Red)04/18PCSOIC
Teaching How to Provision Oracle Integration Cloud (OIC) with Cloud Stack and TerraformCarlos Rodriguez Iturria (Red Thunder - Oracle)07/18ProvisioningOIC
PeopleSoft Integration using Oracle Integration CloudJin Park (Red Thunder - Oracle)07/18Adaptors (PeopleSoft)OIC
Building iOS Mobile App on Oracle Autonomous Visual Builder Cloud Service (VBCS) vijaykumaryenne (Red Thunder Oracle)08/18Visual BuilderOIC
Embed Process Automation into Oracle Service CloudSerene Tan (Red Thunder - Oracle)05/18PCSOIC
Migration from Oracle BPM to Oracle Autonomous Integration Cloud — Streamlining Process Automation in the CloudAndre Boaventura - Oracle06/18InsightsOIC
Upgrade on premise ICS agentAnkur Jain12/18AgentOIC
Change connection in the Integrations: Oracle Integration CloudAnkur Jain12/18ConnectorOIC
Poll File from Agent server leveraging File Adapter: Integration CloudAnkur Jain12/18Adaptor (File)OIC
Implement Pagination in REST Service: Integration CloudAnkur Jain12/18Adaptor (REST)OIC
#674 OIC DB Adapter for Oracle Database 18cNiall Commiskey (Oracle PM)12/18Adaptor (Oracle DB)OIC
#673 - OIC Integrations - re-submittable errorsNiall Commiskey
(Oracle PM)
12/18CoreOIC
#672 OIC 18.4.5 New Features - ProcessNiall Commiskey
(Oracle PM)
12/18AllPCS
#671 OIC 18.4.5 New Features - UI Path RPA adapterNiall Commiskey
(Oracle PM)
12/18Adaptor (RPA, UIPath)OIC
How to migrate from ICS to OIC? - Using Internal StorageMuthu Palanisamy
Sr Director Software Development Oracle
10/18ICSOIC
Rename or Delete a Swimlane RoleJan Kennenis01/19ProcessPCS
VB CS leveraging Integrations - required configurationNiall Commiskey
(Oracle PM)
03/19AppVBCS
Subscribing to Fusion ERP EventsNiall Commiskey
(Oracle PM)
02/19Adaptor (ERP)OIC
Oracle Field Service OIC adapter supportNiall Commiskey
(Oracle PM)
02/19Adaptor (Field Service)OIC
Oracle Asserter - Regression testing in Oracle Integration (OIC)Niall Commiskey
(Oracle PM)
02/19CoreOIC
HCM Integration & HCM adapter in depthNiall Commiskey
(Oracle PM)
01/19Adaptor (HCM)OIC
Consume HCM Atom Feeds in Oracle IntegrationNiall Commiskey
(Oracle PM)
01/19Adaptor (HCM)OIC
Integrations - re-submittable errorsNiall Commiskey
(Oracle PM)
12/18CoreOIC
How to use Pick action in OIC OrchestrationSumeet Singh
(Oracle Tech)
03/19CoreOIC
Integrating Oracle Integration Cloud Integration with UIPathSiming Mu
(Oracle A-Team)
03/19Adaptor (RPA, UIPath)OIC
OIC Integration with Logistics Cloud – Things to Know and Best PracticesShreenidhi Raghuram
(Oracle A-Team)
02/19Adaptor (Logistics Cloud)OIC
Cloud Integration Patterns Using Oracle PaaSAbhay Kumar
(Oracle A-Team)
01/19CoreOIC
Fetch Email attachments using Microsoft Email adapter in Oracle Integration CloudAnkur Jain03/19Adaptor (MS Exchange)OIC
Gmail adapter in Oracle integration cloudAnkur Jain03/19Adaptor (GMail)OIC
Oracle Integration Cloud REST API to get the Integration StatisticsAnkur Jain03/19Adaptor (REST)OIC
The Power of Process Automation: The Linchpin to Digitization and AI AdoptionDaryl Eicher 03/19RPAOIC
Dive Deep into Wells Fargo’s Best Practices for Cloud ERP IntegrationDaryl Eicher 04/19CoreOIC
Integration: Heart of the Digital Economy - Podcast Series Vika Mlonchina 03/19CoreOIC
OIC makes integration easy with ODIRed Thunder03/19CoreOIC
Oracle Service Cloud to Eloqua – Bulk Opportunity Import using Service Cloud ROQL and OICRed Thunder04/19Adaptors (Eloqua, Service Cloud)OIC
OIC Integration with Netsuite - initial setup and basic troubleshootingNiall Commiskey
(Oracle PM)
05/19Adaptors (Netsuite)OIC
OIC Taleo EE (OTAC) - Create RequisitionNiall Commiskey
(Oracle PM)
05/19Adaptors (Taleo)OIC
Oracle Process Cloud - linking to a process instanceNiall Commiskey
(Oracle PM)
05/19CorePCS
Syncing Customers/Contacts from your CRM to NetsuiteNiall Commiskey
(Oracle PM)
05/19Adaptors (Netsuite)OIC
OIC Integration with Netsuite - initial setup and basic troubleshootingNiall Commiskey
(Oracle PM)
05/19Adaptors (Netsuite)OIC
OIC REST API for Connectivity Agent DRNiall Commiskey
(Oracle PM)
05/19AgentOIC
Oracle Integration now with Automation Anywhere (RPA) adapterNiall Commiskey
(Oracle PM)
04/19Adaptors / RPAOIC
Creating/changing Integration Artifacts via the OIC REST APINiall Commiskey
(Oracle PM)
04/19APIOIC
BOT Orchestra by Oracle IntegrationNicolas Damonte 04/19Adaptors / RPA / RPOOIC
ntegration between FTP - Sharepoint (Upload documents): Oracle Integration CloudAnkur Jain05/19Adaptors (FTP/Sharepoint)OIC
OAuth Custom Three Legged Security Policy in REST Connection: Oracle Integration CloudAnkur Jain05/19SecurityOIC
Access Sharepoint online REST APIsAnkur Jain05/19Adaptors (REST/Sharepoint)OIC
OAuth Custom Two Legged Security Policy in REST connection: Oracle Integration CloudAnkur Jain05/19SecurityOIC
Copy files from one SFTP to another SFTP: Oracle Integration Cloud ServicesAnkur Jain05/19Adaptors (FTP)OIC
HTTP error responses in REST API: Oracle Integration CloudAnkur Jain05/19Adaptors (REST)OIC
Change date time format in Oracle Integration CloudAnkur Jain04/19CoreOIC
Download CSV file from REST service Response Content: Oracle Integration CloudAnkur Jain04/19Adaptors (REST)

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/

Public FTP Services that could be used with Chapter 9

In chapter 9 of the book we work through a number of examples of using ICS with FTP.  If you don’t have a web provider that already offers you an FTP server to use you, we’ve found a few services you might consider using. We provide no guarantees for their trustworthiness and reliability. But they maybe sufficient to enable to run the scenarios described in the book:

The alternate option is to exploit the fact that website hosting compaies usually provide FTP access to upload content. Here are a couple of options:

Powered by WordPress & Theme by Anders Norén