Barrick Gold modernizes HCM with Oracle Integration – Webcast February 16th 2022

Connect HCM with Oracle Integration -  Vigilant & Oracle Webcast

Fortune favors the fast because growth requires agile delivery of innovations that are designed for enterprise scale. Join us to learn how Barrick Gold successfully simplified their recruit to pay processes with Oracle HCM Fusion and non-Oracle ERP using Oracle Cloud Infrastructure (OCI) integration services. Get the solution architect view into how end-to-end automation helps them save time and money while reducing project risk

In this session, you will gain practical insights into how cloud integration accelerates intelligent automation with real-world deep dives into HCM modernization best practices and a live demo with Q&A from technical architects and project leads at Vigilant Technologies.

Schedule: February 16th 2022 9:00 am PST (San Francisco)

For details please visit the registration page here.

PaaS Partner Community

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

Blog Twitter LinkedIn Facebook Wiki

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

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

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.

Blog Twitter LinkedIn Facebook Wiki

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

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

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.

Blog Twitter LinkedIn Facebook Wiki

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

Oracle Integration Cloud – Gmail Adapter by Daniel Teixeira

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.

Blog Twitter LinkedIn Facebook Wiki

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

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

The 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.

Blog Twitter LinkedIn Facebook Wiki

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

OIC and OCI AI Language Service Part II by Niall Commiskey

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.

Blog Twitter LinkedIn Facebook Wiki

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

Leveraging OCI AI Language Service from Oracle Integration by Niall Commiskey

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.

Blog Twitter LinkedIn Facebook Wiki

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