Change date time format in Oracle Integration Cloud by Ankur Jain

We got a request from multiple folks saying they are struggling to change the date time format in Oracle Integration Cloud.

We are writing this article to see how to change the default date format(2019-04-13T05:09:05.049+00:00) to a different format.

Oracle Integration Cloud Service provides an Out of the box function(xp20:format-dateTime) which allows us to change the date time format. We are on ICS version (18.4.3.0.3) and the function is available(xp20:format-dateTime). Let us see how to apply this function and change the date format as per the requirement. The function(xp20:format-dateTime) takes below two arguments:

1. dateTime: Provide the DateTime input parameter as a string which needs to be the format
2. Format: Provide the format as a string as per the requirement

Example-1: Parse the date time in the format “dd-MM-yyyy“, below will be the syntax: 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 use Pick action in OIC Orchestration by Sumeet Singh

REST Adapter in its current version only publishes a single resource with a single verb in the inbound. Also, there can only be a single source within an integration flow. This is somewhat restrictive as the users have to create multiple integrations (each with a separate resource URI) for related resources and verbs.

Let’s say someone has a requirement to create, update and delete a resource. Naturally, the expectation is that there would be a single resource which can be manipulated with different HTTP verbs. This is not possible with REST adapter and in the current version, users are forced to create multiple integrations for performing these different operations.

Pick is a solution to this. Have a look at how your pick integrations will look in canvas.

PICK is protected with ‘ oic.cloudadapter.adapter.rest.mvrp ‘ feature flag. Check this link on how to enable feature flag. 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

Fetch Email attachments using Microsoft Email adapter in Oracle Integration Cloud by Ankur Jain

In the article, we’ll show how to fetch the attachments from email and dump the attachments on the SFTP server.

To complete this article, we should have in place:

1. MS email connection: If not created, use the post to create a connection with Microsoft outlook
2. FTP connection: If not created, use the post to create a connection with FTP

Below is the end to end use case which is demonstrated in the article:

• Fetch the emails from MS outlook
• Extract the attachments from each and every email
• Dump all attachments on the SFTP server

Let’s go ahead and see how to achieve this

• Create a scheduled integration with name "GetAttachments"

• Drop the Microsoft Email adapter just below the scheduled activity. The configuration wizard will be opened. On the very first screen enter below information and click the Next button. 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 Integration with Netsuite – initial setup and basic troubleshooting by Niall Commiskey

It’s always good to try new things, so here I am checking out OIC integration with Netsuite.
This post covers the following –

1. Creating a new user in Netsuite, giving them login permissions and assigning roles.
2. Activating that user in Netsuite for web services access.
3. Creating a connection to Netsuite in OIC, leveraging the user created.
4. Creating a simple integration to Netsuite – Contact Creation.
5. Troubleshooting – what permissions does my user need to create a contact in Netsuite. 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

Integration, Process and Visual Builder by Jin Park

OIC makes integration easy with ODI

We know OIC (Oracle Integration Cloud) is capable of file based integration for ERP over API.
And we do know that ODI (Oracle Database Integrator from Data Integration Platform Cloud) is capable of ingesting large file and processing it for ERP through the database layer aka ETL / ELT.

Okay, what if those cloud services work together and give you a simple pattern which can be applied to typical use case such as large number of big files integration with ERP through the database layer.

Following scenarios would be typical integration use case scenarios;

Financial transaction records from branches / retail merchants come in large number of big files
Files have to be ETL / ELT before cut-off time
Business / IT want to know what’s happened for last batch job processing or current job happening
Financial transaction records have to be kept for certain periods for internal audit and legislative requirements

Now let me show how those integration use cases are implemented by OIC and ODI.

Firstly ODI (Oracle Database Integrator) will do take heavy workloads such as ingesting large files, transforming raw transaction records and load them to target database. Luckily OdiInvokeWebService Tool is available for ODI as an API and Integration (from OIC) will invoke this API. 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

Full Podcast Series Now Available – Integration: Heart of the Digital Economy by Vika Mlonchina

Rapid cloud adoption, mobile devices, and AI technologies are rapidly changing the way customers interact with businesses. And organizations are quickly assembling ad-hoc solutions to meet these challenges. The result is a tangled mess of hardwired enterprise systems that can no longer support business needs. Modern applications and data infrastructures are needed to enable mission-critical business systems to work with big data systems. Cloud-agnostic integration platforms are required to support agile processes that can take advantage of new tools like AI and blockchain. In this podcast series, learn how organizations can leverage integration technologies to compete successfully in the digital age.

All six podcasts in this series are now available at the Oracle Cloud Café or you can listen directly in the links below:

• Simplifying Integration for Modern Applications and Data Infrastructure (17:00)
• Integration: Fuel for AI-Enabled Digital Assistants (16:11)
• Creating Modern Applications with API-First Integration (12:30)
• Blockchain Integration: Powering the Smart Economy (14:47)
• Moving Data into the Cloud (13:47)
• Integrating Data for Oracle and Autonomous Data Warehouse (9:22)

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

A brief look at the evolution of interface protocols leading to modern APIs by Luis Weir

Application interfaces are as old as the origins of distributed computing and can be traced back to the late 1960’s when the first request-response style protocols were conceived.  For example, according to this research, it wasn’t until the late 1980’s when the first popular release of RPC (described below) was introduced by SUN Microsystems (later acquired by Oracle), that internet-based interface protocols gained wide popularity and adoption.
This is perhaps why the term Application Programming Interface (API) even today can often result in ambiguity depending on who you ask and in what context. This is probably because of the fact that historically the term API has been used to (and to a degree continues to) describe all sorts of interfaces well beyond just web APIs (e.g. REST).
This article therefore attempts to demystify (to an extend) the origins of modern web-based APIs. This is done by listing and describing in chronological order (as illustrated below) the different interface protocols and standards that in my view have had major influence to modern web-based APIs as we know them today (e.g. SOAP/WSDL based web services, REST, GraphQL, gRPC to name a few). 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