Category: General Updates Page 1 of 2
If you’ve attended an Oracle conference or just aware of the wider Oracle ecosystem, then you’ll know of the Oracle APEX community and probably one of the communities’ highly respected and much-loved contributors, Joel Kallman. Sadly, Joel has passed on, another victim of Covid19. Our thoughts go out to Joel’s family and the community who have lost someone they value so much.
Time flies, with a 1/4 of a year behind us already including the first quarterly release. Last month we’ve seen a lot of attention around Oracle Hospitality Integration Platform (OHIP) which brings together different Hospitality cloud services as well as using technologies such as Integration Cloud to make it easy to interface 3rd party solutions.
OIC has for some time now provided an FTP adaptor and more recently included a full FTP server capability. But both have limits on the file size and capacity. The file constraints (1GB for a file and 500GB for the FTP server) shouldn’t be an issue for day to day activities. But OIC is often used to support SaaS Financials and other cloud solutions which do have monthly process cycles which can generate significant data volumes, for example, payroll data. The question is how to handle such data with such constraints?
There is a school of thought that points to the possibility when handling such large data volumes we should consider using Data Integration rather than a more event-centric integration tool. Personally, I think there is a lot of validity in the argument, and anyone dealing with such bulky data activities should review and question if it is a better answer.
That said, there are cases where it does stand-up. For example:
- If an organization is transitioning to a more event-driven or at least micro-batch model, you have to start the transition somewhere, but trying to line up changes everywhere can be problematic, so we have to start somewhere. Building an integration process so you have an event model developed, but in the interim, you need to take that bulk mechanism and convert it to a small stream of events.
- You may be working with a bulk data extract and only need a small subset of the data provided, it won’t help if the data is also represented using a verbose notation such as XML.
How to overcome the constraint? Oracle databases aren’t so constrained, and SQLLoader can provide an easy means to ingest the data into a staging table. The benefit of this is:
- if you’re only needing a subset of the data you can pull just those columns from the table.
- the bulk of the use of XML to be self-describing can be shed through using the DB schema as being more prescriptive.
- SQL scripts can handle the checksum records removing that data and overhead from the integration process, leaving you to concentrate more on the business process.
If the data is still substantial once in the database there are a number of strategies to consume the data in more manageable chunks, such as
- Running SQL script on the database that takes each row and calls the OIC as a restful API point. This approach is potentially very interesting as it may then mean if you’re moving towards an event process in the future the API endpoint represents the future state and the database stored procedure is mimicking the future client behaviour.
- Use polling strategies and result set limits to control how much data is processed in a single execution of the integration. This approach does mean the integration needs to tag which records have been processed to avoid re-reading them.
This month’s articles …
|Article / Link||Author||Subject Matter||Connecting|
|OIC REST API for Lookups||Niall Commiskey||OIC|
|OIC 4 Netsuite – Polling for New / Updated Customers||Niall Commiskey||OIC||Betsuite|
|Oracle Integration – Adapter Enhancements to Non Oracle Applications||Arvind Venugopal||OIC||Non Oracle|
|Security Improvements for Database & FTP Adapters||Michael Meiner||OIC||DB & FTP|
|November 2020 Update||Antony Reynolds||OIC|
|Oracle Integration November 2020 update for Oracle Applications Adapters||Prakash Masand||OIC||Oracle Apps|
|How to use the OCI Object Storage from the Oracle Integration Cloud||Daniel Martins Teixeira||OIC||OCI Object Store|
|Choosing Your Update Window||Antony Reynolds||OIC|
|Announcing The Visual Builder Cookbook||Shay Shmeltzer||VBCS|
|Connecting to API Gateway from Visual Builder with Authentication||Aparna Gaonkar||VBCS|
|Global Variable and Data Stitch in OIC||Amit Kumar Suman||OIC|
|Configure OTM connection in OIC||Amit Kumar Suman||OIC||OTM|
|Send attachment in OIC notification||Amit Kumar Suman||OIC|
Despite it being traditionally holiday season, there have been lots of articles written about OIC, including the prolific Niall Commiskey covering a lot of new OIC features …
Plenty of good articles published in the last month …
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 / Link||Author||Subject Matter||Connecting|
|Token required to provision an Oracle Integration Cloud instance||Ankur Jain||OIC|
|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 Builder||Niall Commisky (Oracle)||VBCS + OIC||NetSuite|
|Monitoring API – Getting Activity Stream data||Niall Commisky (Oracle)||OIC|
|Triggering an OIC integration via OCI Events – the Notifications Service Approach||Stan Tanev (Red Thunder Blog)||OIC||OCI|
|The 5 Pillars of Intelligent Invoice Processing||Daryl Eicher (Oracle)||OIC/Arcivate||RPA|
|B2B – EDI Translation support||Niall Commisky (Oracle)||OIC||EDI|
|B2B Document Management||Niall Commisky (Oracle)||OIC||EDI|
|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|