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.
Tag: Integration Page 1 of 2
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.
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.
This month’s new articles about Oracle Integration Cloud …
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.
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 220.127.116.11 / 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|
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)
Oracle 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.
for more information on RPA and the adaptor the following links maybe of help:
- http://amysimpsongrange.com/tag/rpa/ – an introduction to RPA
- https://docs.oracle.com/en/cloud/paas/integration-cloud/uipath-rpa-adapter/using-uipath-robotic-process-automation-adapter-oracle-integration.pdf – documentation on the RPA adaptor
- http://niallcblogs.blogspot.com/2018/12/671-oic-1845-new-features-ui-path-rpa.html – Oracle PM introduction
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 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]
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 scheme – https://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.
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 …
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 …
This and related information can be found in a new presentation that can be seen at: