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

Tag: Integration Page 5 of 6

Nov 20 – new OIC Articles

This month’s articles …

Article / LinkAuthorSubject MatterConnecting
Netsuite to Object StorageNiall CommiskeyOICNetsuite; Object Storage
DB Adapter –> Master/Detail InsertNiall CommiskeyOICDatabase
Complex SQL processingNiall CommiskeyOICDatabase
Netsuite adapter New FeaturesNiall CommiskeyOICNetsuite
new Monitoring/Mgt featuresNiall CommiskeyOIC
Data RetentionNiall CommiskeyOIC
Oracle Field Service via RESTNiall CommiskeyOICOracle Field Service
Generic Invoke for Scheduled JobsNiall CommiskeyOICSchedukler
How to configure Integration Properties in OICAmit Kumar SumanOIC
Oracle Integration Announcements On Home PageKundan VyasOIC
Recover unsaved changes for an Integration edit sessionVijay KendaiOIC
Oracle Integration November 2020 Update for Technical AdaptersPrakash MasandOICVarious
Track scheduled instances from submissionArya SanyalOIC
How to Invoke an OCI Function from the Oracle Integration CloudDaniel Martins TeixeiraOICFn
Oracle Integration: ICS to OIC Migration using an ATP DatabaseMichael MeinerOIC
Navigate between pages in Oracle Visual BuilderAnkur JainVBCS
OIC Health Check by OCI Monitoring and AlarmJin ParkOIC
OIC Log Management with VB Studio, OCI Bucket and OCI Logging AnalyticsJin ParkOIC

October 20 – New OIC articles

Article / LinkAuthorSubject MatterConnecting
OIC REST API for LookupsNiall CommiskeyOIC
OIC 4 Netsuite – Polling for New / Updated CustomersNiall CommiskeyOICBetsuite
Oracle Integration – Adapter Enhancements to Non Oracle ApplicationsArvind VenugopalOICNon Oracle
Security Improvements for Database & FTP AdaptersMichael MeinerOICDB & FTP
November 2020 UpdateAntony ReynoldsOIC
Oracle Integration November 2020 update for Oracle Applications AdaptersPrakash MasandOICOracle Apps
How to use the OCI Object Storage from the Oracle Integration CloudDaniel Martins TeixeiraOICOCI Object Store
Choosing Your Update WindowAntony ReynoldsOIC
Announcing The Visual Builder CookbookShay ShmeltzerVBCS
Connecting to API Gateway from Visual Builder with AuthenticationAparna GaonkarVBCS
Global Variable and Data Stitch in OICAmit Kumar SumanOIC
Configure OTM connection in OICAmit Kumar SumanOICOTM
Send attachment in OIC notificationAmit Kumar SumanOICEmail

September 20 – New OIC articles

Article / LinkAuthorSubject Matter Connecting
Replace Existing Connection with New Connection in OIC IntegrationAmit Kumar SumanOIC
OIC: How to configure endpoints of ORDS Connections in OIC?Jan KettenisOICDBaaS/DB
Zero loss of service, smoothly migration from Salesforce to Oracle Apps CX with Oracle Integration Cloud Salesforce Adapter plus helper technology tools such as an Autonomous Database, Data Integration and Object StorageJavier MuguetaOICSalesforce
Oracle Integration Cloud August 2020 new features: Accelerators, Recipes and Couple of Brand new Adapters, and more..Javier MuguetaOIC
How to Configure the New Oracle Integration Cloud (OIC) Streams AdapterJohn GravesOICStreams
Inbound EDI message to Oracle Integration for B2B WorldSubhani Sahib ItalapuramOICB2B
How to create a XSLT map that reads many correlated payloadsJorge HerreriaOIC
Creating Complex Local Temporary Variables in OICJohn GravesOIC
How to Keep Exactly One OIC Integration Instance running 24/7John GravesOIC
Oracle Intelligent AutomationMilomir VojvodicOICIA under the hood
An Advanced Guide to OIC Notification via EmailsRenukaradhya DakshinamurthyOICOCI email
Create a B2B Document to Define Custom Definitions in Oracle Integration(OIC)Subhani Sahib ItalapuramOICB2B
Introducing B2B in Oracle Integration(OIC)Subhani Sahib ItalapuramOICB2B
Extending OOTB OIC Recipe – Extract New Hire Info (part1, part2)Kishore KattaOICHCM
Update Lookups in Oracle Integration CloudAnkur JainOIC
Oracle Integration Cloud New Home PageAnkur JainOIC
[Creating Journal Entries in Netsuite via OICNiall CommiskeyOICNetsuite
Oracle Integration (OIC) Recipes – HCM Directory SynchronisationNiall CommiskeyOICHCM
OIC Technical Accelerator – Alert NotificationsNiall CommiskeyOIC
OIC Technical Accelerators – Re-sequencerNiall CommiskeyOIC

July 20 – New OIC Articles

Its been a busy month when it comes to blogging for the folks at Oracle, as July saw a new quarterly release with new usability improvements and connectors.

Article / Link Author Subject Matter Connecting
Sugar CRM 2 Netsuite Integration with OIC REST Adapter Niall Commiskey (Oracle PM) OIC Sugar CRM, Netsuite
OIC integrating BigCommerce with Netsuite Niall Commiskey (Oracle PM) OIC BigCommerce, Netsuite
Shopify: (Adaptor Pagination, Product Inventory Updates) Niall Commiskey (Oracle PM) OIC Shopify
OIC – SurveyMonkey 2 Netsuite Synchronisation Niall Commiskey (Oracle PM) OIC Survey Monkey, Netsuite
OIC moving to a Quarterly Release Cycle Niall Commiskey (Oracle PM) OIC
OIC 4 Netsuite – Implementing a Generic Error Handler Niall Commiskey (Oracle PM) OIC Netsuite
See how OIC integrations are behaving at runtime Ankur Jain OIC
Oracle Integration Connectivity Updates August 2020 Prakash Masand (Oracle) OIC Various
Enhanced Integration with your Business Partners using OIC AS2 Adapter Michael Meiner (Oracle) OIC B2B
Convert Basic Routing style Integration to Orchestration style. Renukaradhya Dakshinamurthy (Oracle) OIC
User Friendly Names in Mapper Ishruthilaya Malarvizhi OIC
PeopleSoft Integration using Oracle Integration Cloud (Part 1, Part 2) Prakash Masand, & Jin Park (Oracle) OIC Peoplesoft
Jump-start your Integrations with the new Oracle Integration Home Page Michael Meiner (Oracle) OIC
Leveraging Oracle Integration File Server For File Based Integrations Kundan Vyas (Oracle) OIC
Promoting Your Code Antony Reynolds (Oracle) OIC
Adding Your Own Application Templates to Oracle Visual Builder Duncan Mills (Oracle) VBCS
Using OCI API signature authentication from Visual Builder Aparna Gaonkar (Oracle) VBCS
Invoking One Integration From Another – Call integration Action Harshit Yadav OIC
Visual Builder Studio Features (Part 1) Javier Mugueta VBCS/OIC
Integration b/w Oracle Engagement Cloud, Oracle CPQ & Oracle EBS Atul Kumar OIC Oracle Engagement Cloud, Oracle CPQ, EBS

OIC and Integrating Oracle SaaS

Handling integration between Oracle SaaS applications and modules has been something of an evolutionary journey. A couple of years ago if you wanted to intgrate say HCM and ERP you needed to ICS or OIC to perform the integration.

In many respects this wasn’t such a terrible thing. Technically as it meant that the back end database schema development for each app was not going to be slowed by needing to be mutually dependent with each other. As a result avoiding the complexities of managing a canonical model and ensuring any changes to that model are delivered in a manner that aligns across multiple development teams plans.

Although you can see from a marketing position it might not have seemed so great, as the customer incurs more cost and development effort to realize a process of managing people (HCM) and paying them (ERP) for example.

Things have moved on, and as long as SaaS apps reside in a Global Single Instance (GSI) (i.e. same region, account and deployment) then for the major products (e.g. ERP, CX, HCM, etc) are internally integrated so a person change in HCM will propagate to ERP as necessary. This certainly reduces the need for integration, saving effort (and the cost of needing OIC).

The problem now is understanding which entities in the SaaS apps are integrated out the box if you deploy using the GSI manner. If you have been working from an integration/technology view point with ICS and OIC for a while it is very easy to get sucked into thinking you need to repeat the integration. After all explicitly integrating the apps is how we started out.

Oracle also want to make it very easy for non Oracle products to integrate, so OIC documentation and the many very good blogs from product management and the engineering team focus on external integration which does (for me atleast) lead to thinking about the older way of working.

Recommendation

Look to see if you’re working with GSI deployment or not. If it isn’t a GSI setup then the old way of working is required. If it is, then determine whether the entity or processes are out the box integrated. This is probably best approached from the SaaS documentation today.

Useful Links:

June 20 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
 Ankur JainOICERP
Identity Propagation In Structured ProcessJan KettenisOIC / PCS 
Use Oracle Integration to Add Attachments to a Process InstanceBogdan EremiaOIC / PCS 
Oracle Integration Cloud (OIC) Notification ActivityHarshit YadavOIC 
Oracle Integration Cloud (OIC) ADW/ATP AdapterHarshit YadavOICADW/ATP
Our best blogs for Oracle Integration CloudHarshit YadavOIC 
Managing & Monitoring Integration/Errors In Oracle Integration CloudAtul KumarOIC 
Sugar CRM 2 Netsuite Integration with OICNiall CommiskeyOICSugar CRM, Netsuite
Netsuite REST APINiall CommiskeyOICNesuite
Netsuite Asynchronous Request ProcessingNiall CommiskeyOICNesuite
Invoking Netsuite Saved Searches / MiscellaneousNiall CommiskeyOICNesuite
OIC June 2020 release UI updatesNiall CommiskeyOIC 
OIC Packages – cool feature I didn't know we hadNiall CommiskeyOIC 
OIC –> Shopify Adapter now supporting EventsNiall CommiskeyOICShopify
OIC –> Date ManipulationNiall CommiskeyOIC 
embedding VB CS app in HCMNiall CommiskeyVBCSHCM
Data Stitch Assign operation for Elements with AttributesJorge HerreriaOIC 
Oracle Integration (OIC) Generation 2 is now available in all cloud tenanciesSimone GeibOIC 
Data Stitch: Append and Assign for repeating elementsJorge HerreriaOIC 
Empower your Business Users with Integration InsightSimone GeibOIC (Insights) 
How to use the Dynamic Invoke feature in OIC OIC 
Integration Monitoring and Scheduling pages – Progressive Web App UI ExperienceArya SanyalOIC 
Data Stitch: Repeating element path does not have a predicate for selecting 1 instance – WarningJorge HerreriaOIC 
Big Changes are AfootAntony ReynoldsOIC 
HCM Data loader in Oracle IntegrationAnkur JainOICHCM
Oracle Integration Cloud HCM adapterAnkur JainOICHCM
Global Variables and Data Stitch in Oracle IntegrationAnkur JainOIC 

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

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.

Page 5 of 6

Powered by WordPress & Theme by Anders Norén