Convert JSON to String Oracle Integration by Ankur Jain

I have seen multiple target applications which accept the JSON data as a String in a single element. So, it is necessary to convert the JSON to String before you call the target endpoint.

Convert JSON to String Oracle Integration

For example:

Below is the JSON which you may get from the source system:

{

"firstname": "ankur",

"lastname": "jain"

}

and you need to map the above JSON as a string in the following single element:

{

"data" : "{\n \"firstname\" : \"ankur\",\n \"lastname\" : \"jain\"\n}"

}

So, in order to achieve this, first, you have to write the JSON to the temporary location using the Stage File action and read it using the opaque schema as a String.

Here is the opaque.xsd code which you need to use to read the JSON from the stage: 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

Leverage Oracle MySQL Database Service (MDS) with Oracle Integration Cloud by Arpit Narula

The primary objective of this blog is to detail out how Oracle’s MySQL DB can be provisioned on OCI Gen -2 and integrate it with Oracle Integration Cloud. MySQL Database Service on Oracle Cloud might prove out to be a very cost effective and performance enhancing solution for many use cases. A few such use cases are

· Custom Logging and Error Handling Frameworks

· Implementing Parking Lot Patterns for Integrations

· Building Data Stage for VBCS applications

So let’s jump into the fun sections where we will cover the following topics in detail.

a) Create an MDS Cloud Instance

b) Setup compute instance (that will connect to MDS)

c) Create an OIC Instance and Agent Setup

d) Build a sample integration 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

Ways to download connectivity agent Oracle Integration by Ankur Jain

The connectivity agent is used to establish the communication between SaaS and on-premises applications. Before you create the connection with on-premises applications in Oracle Integration, you must have to download the connectivity agent and install it on the host machine.

There are various ways to download the connectivity agent. So, in this short article, we’ll describe various options to download the connectivity agent of Oracle Integration.

1. Using Oracle Integration Console

The easiest way to download the connectivity agent is using the Oracle Integration console. To download it using the Oracle Integration console follow the below steps:

1. Login into the Oracle Integration Console.
2. Navigate to the Integrations -> Agents page
3. Click on the Download -> Connectivity Agent option from the upper right corner of the page. 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 Activity Stream to OCI Log analytics by Shreenidhi Raghuram

OIC Activity Stream to OCI Log analytics

Introduction

We know that Oracle Integration Activity stream logs can be downloaded from OIC using the Monitoring console. Here is the reference link – Monitoring OIC
A commonly implemented solution by customers is to automate the download of activity stream logs periodically using monitoring REST API and store them in repositories like FTP servers or Object storage for offline analysis and diagnosis.

However the Activity stream download  is governed by size of the activity stream log file. Refer – activity stream logs retention.
Due to this size limitation, customers could have an issue with the ability to reliably download activity stream logs for a definite period of time, say last 1 hour. For instance, during periods of heavy activity on the OIC instance the log file may only cover a portion of the period due to the size limitation.

Solution

Good news ! This requirement has now been addressed as part of the August 2021 release of Oracle Integration.
OIC now allows activity streams to be sent to OCI Logging service. OCI Logging service provides persistence as well as real time analysis on the OIC activity stream messages. 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

Business Identifiers in Oracle Integration by Ankur Jain

A Business identifier in Oracle Integration helps you to track the messages from the monitoring dashboard quickly and easily.

Without enabling the Business identifiers, you can not activate the integrations.

Max 3 business identifiers can be assigned during the design time. One is primary and the other two are secondary.

To understand how to enable Business Identifiers and how to use them to track the runtime integration, 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 Update Webcast September 2021 on-demand

Watch to get the latest updates and innovations on Oracle Integration release. Our Oracle Integration Product Manager Team will present new features, product roadmaps, discuss upcoming innovations and provide guidelines to help you adopt these quickly within your organization. Topics include:

• Welcome & announcements

• August release update Oracle Integration

• ERP / SCM Integration Best Practices from the A-Team

• Questions & Answers

Watch the on-demand webcast here and subscribe to the newsletter 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 & Blue Prism part 2 by Niall Commiskey

This post goes into a bit more detail, especially on the Blue Prism side. The use case today is that of updating an excel sheet – Here’s mine – today we are doing employee assessments and we will leverage Blue Prism to automatically assign performance values, based on the employee rating. Apologies to any Liam Mellows fans out there.

The employees have been rated – the performance fields just need to be updated. Our digital worker will take care of this.

The OIC process will invoke Blue Prism, passing the name of the excel sheet to be processed.

The Blue Prism process is as follows –

Thanks to the following page for the instructions on how to create the above.

The logic is simple enough –

• Open workbook – Open the excel sheet

• Get Collection – here we copy the workbook contents to the Employees collection

• Loop over each employee entry

  • Update each employee performance field based on their rating

• Write Data – update the Excel sheet

• Save Data – Save Excel Sheet

• Close Workbook – Close Excel Sheet

The process leverages the Blue Prism VBO(Visual Business Object) for Excel. This VBO is pre-seeded in the product. Think of this as an Excel adapter, providing us with functionality such as open close, write, save etc.

You see on the left a Data Item – Workbook Name. This is the variable which holds the name of the excel sheet to be processed. 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 Blue Prism RPA by Niall Commiskey

I downloaded the BluePrism trial this morning, along with a set of 10 beginner labs they make available online.

Blue Prism Design Time

The focus of this post is not on how to design automations with Blue Prism; the 10 labs do a great job of that. The focus here is on how to invoke such from OIC.

I will use the following process as an example – this is actually Lab4  Blue Prism offers a rich set of process design actions –

Some of these have been used to add robustness to the process model, very important for mission critical automations.

The process shown above is very simple – it opens the Blue Prism website in InternetExplorer and searches for a specific topic – e.g. Coca Cola

So it is doing the following, from an automation perspective –

1. open the page in IE

2. enter data – the search string – in the search box

3. press the search button.

I test this within the Blue Prism Design Studio and it works fine. The search value – Coca Cola – is hard coded, as you can see in the Data Items block above.

Now say I want to expose this functionality as a service – I will then need to define an input variable for the search string. This can be easily defined in the Start action. 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