Guidelines when moving Integration Workloads from SOA to Oracle Integration by Shreenidhi Raghuram

image

Introduction

The aim of this blog is to guide customers when they set out to migrate their integration solutions from SOA to Oracle Integration (OIC). 
The focus in this blog is to help customers during the creation, configuration of Oracle Integration service instances, and also provide best practices for choosing the right OIC features and integration patterns when developing SOA equivalent integrations on Oracle Integration Cloud.

The existing SOA workloads could be running in customer data-centers, on-premise or on Oracle cloud. The blog aims to provide high level guidelines when moving integration workloads from SOA to Oracle Integration Cloud.

To start with the SOA Suite installations could be any of the below –

  • SOA on-premise – Where SOA is installed and managed on-premise or within customer datacenter
  • SOACS on OCI – these are SOACS installation running on customer OCI tenancy in one of the OCI regions worldwide
  • SOACS Marketplace – This is the newer installations which run on OCI and are installed using the SOA images available in Oracle market place
  • SOACS on OCI Classic – These are legacy SOACS installations running on OCI Classic datacenters

SOA to OIC is not an upgrade or an automatic migration. The two integration products have different design-time and runtime environments. Hence the integrations need to be re-developed in the target OIC platform. Although, the high level integration concepts remain same for both platforms, a sound knowledge of Oracle Integration Cloud’s features, wide range of adapters and a good idea of cloud integration concepts are key to get all the benefits of Oracle Integration during the migration from SOA. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

OIC -> DB adapter – overcoming 10 MB limit by Niall Commiskey

image

This is an issue with many customers – I execute a SELECT against my on-premise Oracle DB from OIC and a humungous amount of data is returned. This exceeds the 10 MB limit and causes an error. Here is a simple example of avoiding such. Here is my test table -  I can use SQL with OFFSET –

SELECT orderNr, customer, value FROM orders ORDER BY ordernr OFFSET 2 ROWS FETCH NEXT 3 ROWS ONLY;

I wrap this SQL in a stored procedure -  Now to my integration, which will invoke the Stored Procedure. This is a scheduled orchestration – First step is to do a SELECT COUNT(1) FROM ORDERS – this returns 16 in my case. Now for my simple example I will process these in batches of 5. You can extrapolate from this e.g. 200 rows is well within my 10MB limit. I then divide my count by the batch size – using the ceiling function.

ceiling(16 / 5) = 4 iterations.

Next step is to leverage the DB adapter to invoke the PL/SQL stored procedure -  Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Oracle Integration Cloud – Gmail Adapter by Daniel Teixeira

imageAs part of a wider use case involving OIC, ODA and OCI AI Services, I need to be able to get emails. For that I will try out the OIC Google Gmail Adapter.

All about it here.

Pre-Requisites

On the Google side we need to configure a couple of things.

Under your google account go to https://console.developers.google.com/

Choose an existing project or create a new one. Under the option Library, search for Gmail API.

Enable it. Create an OAuth ID type of credentials, Add your callback URL

Create a connection

Pick up the Gmail Adapter from the list and provide a Client ID, Client Secret, and the Scope.

Once that is done Provide Consent, which will finalize the connection. Make sure your user is added in the Gmail OAuth consent list. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

My private corner – Happy New Year 2022

imageStart the New year with a free Oracle certification! Due to the high demand the offer was extended until the end of February 2022. Oracle Cloud Certification credentials are valid for a period of 18 months from the date you earn the credential. Don’t wait until all exams are booked out again – schedule your Oracle Integration certification today. Are you certified? Let us know! #PaaSCommunity!

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Top tweets PaaS Partner Community January 2022

January imagetop tweets by PaaSCommunity

Send your tweets @soacommunity #PaaSCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress, Twitter

Integration & Process Partner Community Newsletter January 2022

Dear PaaS Partner Community,

Happy New Year! Thanks for the excellent collaboration. Gartner named Integration as a key success factor in 2021. To accelerate digital transformation Gartner recommends CIOs to use an adaptive strategy, take a modern approach to integration of data and systems and scale the use of digital enables. Since June last year 900 consultants achieved the Oracle Application Integration 2021 Specialist. Due to the high demand the free offer was extended until the end of February 2022. Oracle Cloud Certification credentials are valid for a period of 18 months from the date you earn the credential. Don’t wait until all exams are booked out again – schedule your Oracle Integration certification today. To get started with Oracle integration we will offer 10 hands-on bootcamps in the next 5 months. Registration is open for the trainings in Asia, US & Canada and Europe Middle East & Africa. For registration please visit our community website here (free membership required).

Registration is open for the Partner Technical Forum, a one week conference for consultants, developers and architects. The goal is the update you on the last Oracle Cloud Platform services. Oracle Cloud Infrastructure has all the services you need to migrate, build, and run the IT of our joint customers. From existing enterprise workloads to new cloud native applications and data platforms. You can choose between 9 tracks including Integration to connect SaaS and Conversational AI to build bots with Oracle Digital Assistant.

Thanks to the community for sharing all the integration articles: Oracle Named a Leader in 2021 Gartner® Magic Quadrant™ for Enterprise Integration Platform as a Service for the Fifth Year in a Row & Quarterly Updates & Speed up your Accounting Closing Cycle with automated loading of Payable Invoices into Oracle ERP Cloud, using Oracle Integration Cloud & Build retry logic in Oracle Integration & November 2021 Oracle Integration Update, Salesforce and Jira Adapters Enhancements & Call VB Business Objects from Oracle Integration & Decouple complex flows into simplified multiple resource REST flow & November 2021 New Third Party Application & OIC: Bulk integration between HCM Oracle SaaS and Snowflake.

In the process & innovation section we published how to automate processes with Oracle Integration.

For a short summery of our monthly key information watch the PaaS Partner Updates on YouTube. The January edition highlights the Hands-on Oracle Integration Bootcamps and the Oracle Integration Update. In this month’s community webcast Phil Wilkins and Dan Goerdt will present How London Heathrow Airport succeeded with FlexDeploy and Oracle Integration. Please join the Partner Community Webcast January 25th 2022 2021. On-demand webcast recordings are available at the Oracle Video Hub.

Want to publish your best practice article & news in the next community newsletter? Please feel free to send it via Twitter @soaCommunity #PaaSCommunity. Visit the Community Website (membership required) for the latest Oracle Integration product information including sales kit, training and marketing material & slack channel!

To read the newsletter please visit https://bit.ly/paasnewsjanuary2022

Please like and share the newsletter at Twitter and LinkedIn.

Integration newsletter logo

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: newsletter,SOA Community newsletter,SOA Community,Oracle,OPN,Jürgen Kress

How to call the OCI AI Language Service from the Oracle Integration Cloud by Daniel Teixeira

imageThe OCI AI Language service is one of the new set of AI Services and it can provide valuable capabilities in the context of the OIC. I wrote about the language AI service in this post.

There are plenty of use cases where OIC could potentially benefit from AI Services, anomaly detection being an obvious one, but also language with the ability to detect sentiment, detect language and extract key words from text.

This post will focus for now on the technical side of setting this up in OIC. Later on I will bring more posts focusing on specific use cases.

Step 1: Create a Connection

This is similar to other Connections, like Object Storage and Functions.

The connection URL can be found here.

And here the usual required configuration details, like the OCID’s for user and tenancy, and the PrivateKey + Fingerprint. I covered this more in detail in previous posts (here). All the info is available in the documentation.

Step 2 : Create an Integration (Trigger)

For this example I will create an AppDriven Integration that takes a text as input, calls the AI Service for language detection (the simplest of all) and returns the result. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

OIC and OCI AI Language Service Part II by Niall Commiskey

image

Let’s look at some of the other apis offered – I start off with language detection. Above we see the structure returned by the api – in my example – 2 languages with over 90% probability that the text is in English. The invoke of the api is configured as follows -  Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Leveraging OCI AI Language Service from Oracle Integration by Niall Commiskey

image

Language provides you with the artificial intelligence and machine learning capabilities to detect the language in your unstructured text. Also, it provides other tools to help you further gain insights about your text.

First, a simple example of what’s possible here – I enter a text for analysis – This is my second order for this product, it is really cool.

As you can see – a positive sentiment and rightly so our iBike is the best in the virtual world! Now how can I invoke this from OIC? Imagine I have an order processing integration – the payload includes a comments field – where customer can open their hearts to us. Let’s implement this in OIC.

Step 1 – create a connection to OCI AI Service

Invoking AI is just like invoking other OCI services from OIC. The connection setup is similar to that for Object Storage etc. So I begin by cloning my existing Object Storage connection – Read the complete article here

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Oracle Integration Cloud – Gmail Adapter by Daniel Teixeira

image

As part of a wider use case involving OIC, ODA and OCI AI Services, I need to be able to get emails. For that I will try out the OIC Google Gmail Adapter.

All about it here.

Pre-Requisites

On the Google side we need to configure a couple of things.

Under your google account go to https://console.developers.google.com/

Choose an existing project or create a new one. Under the option Library, search for Gmail API.

Enable it. Create an OAuth ID type of credentials, Add your callback URL

Create a connection

Pick up the Gmail Adapter from the list and provide a Client ID, Client Secret, and the Scope.

Once that is done Provide Consent, which will finalize the connection. Make sure your user is added in the Gmail OAuth consent list. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress