How to send email with attachments in OIC? By Niket Narang

image

Have you ever encountered a scenario where the requirement was to send attachments along with email notification in OIC and you could not? Well, now it is possible. The new feature makes it really easy to configure notification activity to add attachments along with the email.

Prerequisite

  • Enable feature flag: 
oic.ics.console.notification-attachment

Click here to learn on how to enable feature flag. The minimum Oracle Integration version required for the feature is 191020.0200.32001.

Step By Step Guide to Send Notification with Attachment

There are multiple ways in OIC to work with files. Some of the options are i) configure REST adapter to accept attachments as part of the request, ii) use Stage file activity to create a new file or iii) use FTP adapter to download the file to OIC from remote location for further processing. Any file reference(s) created by upstream operations can be used to configure attachments in the notification activity. Let us learn how we can configure notification action to send email with attachments in simple steps:

  • For this blog, we will clone the sample integration ‘Hello World’ that is available with OIC.
  • Navigate to the integration landing page, clone the ‘Hello World’ integration and name it ‘Hello World with Attachment’. 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

Top tweets PaaS Partner Community May 2020

imageMay top 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

Using Stage File Read/Write operation to encrypt/decrypt files by Namratha Narayan

image

You may have a scenario where the requirement is to retrieve an encrypted file from sFTP server and send that to external REST endpoint in encrypted/unencrypted mode with additional capabilities such as processing in the middle.

The new feature makes it easy to configure PGP keys in Stage File Read/Write operation to decrypt/encrypt file up to 10 MB in size.

Prerequisite

Enable following features:

  • oic.suite.settings.certificate  (It will allow user to manage certificate life cycle in OIC)
  • oic.ics.stagefile.pgp.key.support (It will allow user to upload and delete PGP keys in stage file)

To enable feature flags – Refer to Blog on Enabling Feature Flags in Oracle Integration

The minimum Oracle Integration version required for the feature is 190904.0200.31130

Step By Step Guide

  • Public Key is used for Encryption and Private Key for decryption. In order to use encrypt/decrypt files we have to upload PGP keys in OIC. 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

How To Configure an Integration flow with Binary Content Using Rest Adapter as Trigger in Oracle Integration by Sri Ranga Prashant Padala

image

Binary Content Type Support in Oracle Integration Rest Adapter Trigger

Introduction:

Oracle Integration Rest Adapter now supports application/octet-stream in the trigger request and response, with this new capability, it will be possible to invoke an integration using Binary content over REST. Similarly, it will be possible for an integration flow to return binary content in response to a request over REST. Before we do a deep dive on the feature let us start with understating what is application/octet-stream

About "application/octet-stream" MIME attachments:

A MIME attachment with the content type "application/octet-stream" is a binary file. Typically, it will be an application or a document that must be opened in an application, such as a spreadsheet or word processor. If the attachment has a filename extension associated with it, you may be able to tell what kind of file it is. A .exe extension, for example, indicates it is a Windows or DOS program (executable), while a file ending in .doc is probably meant to be opened in Microsoft Word. 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

Integration Bootcamp Virtual Webtraing Europe, Middle East & Africa June 15th-17th 2020

Integrate SaaS Bootcamp Europe 06.2020Oracle Integration Bootcamp Europe, Middle East & Africa June 15th-17th 2020

SaaS solutions like HCM, CX and ERP Cloud need to be integrated and customized. Oracle Integration connects SaaS solutions with out of the box adapters.

Do you want to find out why Gartner named Oracle as a Leader in Magic Quadrant for three years in row? Are you able to innovate quickly in the new digital world? Are you looking for ways to integrate systems and data faster using a modern cloud integration platform? Attend the Oracle Integration Bootcamp, a three days hands-on training for Oracle partners!

Oracle Product Management is pleased to invite Oracle Partners to attend the 3-day hands-on workshop on how to integrate with ERP & HCM applications using Oracle Integration Cloud. This Invite-Only hands-on workshop will be delivered at No-Fee to Partners. It will consist of presentations, demos, and hands-on labs.

Schedule: June 15th-17th 2020

Workshop format:

  • Web based training with presentations, demos, and hands-on labs
  • Attendees will receive training environment login during the workshop

Audience:

  • Oracle SaaS partners who implement ERP, HCM and CX solutions
  • Consultants and Architect with technical background

For additional local training’s please visit the website 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

Integration Designer Pages – Progressive Web App UI Experience by Harish Vinayachandran

image

Pre-requisites

Enable oic.ics.featureflag.spa.designer feature flag to see the new Integration designer pages.

What’s New

New UI is built using Oracle JavaScript Extension Toolkit (Oracle JET) utilizing full benefits of JavaScript, CSS3 and HTML5 design and development principles. This new UI is compliant with latest UX standards and offers consistent user experience across Integration designer pages.

Following are the highlights of the new features and enhancements included in the new UI:

  • Single configuration UI to view and configure dependent resources of an integration.
  • Inline edit of connection resource configuration.
  • Lookup editor enhancements for ease of editing large table sets using paging controls.
  • Single click callout library configuration.
  • Pre-filtered results on resource list page based on logged in username.
  • Enhancements on the resource list page to filter by created and last updated username.
  • Progressive loading of UI contents.
  • Continuous and smooth scrolling of resource list contents.
  • Ease of accessing primary actions on resources list page.

Changes in the top-level menu structure

The top level menu in Suite UI has been restructured to make way for the new UI. When the logged in user has access to designer pages, a click on the ‘Integrations’ menu now opens a sub-menu with links to designer landing pages instead of page re-direction. Click the sub-menu links displays the respective landing 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.

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

How to Encrypt/Decrypt Files in OIC by Bipin Kumar

image

Encrypt/Decrypt capabilities in Stage Files

You may have a scenario where the requirement is to retrieve an encrypted file from sFTP server and send that to external REST endpoint in encrypted/unencrypted mode with additional capabilities such as processing in the middle.

Stage File action in Integration canvas supports various file operations (list/read/write/zip/unzip). Existing OIC feature (oic.ics.stagefile.pgp.key.support) enables decrypt option while reading entire file and encrypt option while writing file. This feature is useful to process the file upto 10 MB size and doesn’t support decryption option while doing read file in segments. For more details, see blog: Using Stage File Read/Write operation to encrypt/decrypt files.

This blog explains the new feature(oic.ics.stagefile.firstclass.encrypt-decrypt ) which allows OIC user to encrypt or decrypt file of size up to 1GB.

Prerequisite

Enable following features:

  • oic.suite.settings.certificate  (It will allow user to manage certificate life cycle in OIC)
  • oic.ics.stagefile.firstclass.encrypt-decrypt (It will allow user to Encrypt or Decrypt a large file in stage file). 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

Multiple resources with single REST: Oracle Integration by Ankur Jain

image

Struggling on how to expose a REST API with multiple resources in Oracle Integration Cloud. Here is the article which will help you to expose such REST APIs.

This feature is restricted with Feature Flag “oic.cloudadapter.adapter.rest.mvrp” which should be enabled on OIC pod before you start implementing the article.

See the article on feature flag.

Let’s gets started and see how to achieve this advance feature.

Use Case
  • Expose a single REST API to perform two operations
    • Insert employee details in DB
    • Get employee details from DB

Once the integration is completed it will look like below

PICK action in OIC

Step by step procedure to achieve the use case
  • Create a App Driven Orchestration integration with name “EmployeeResource
  • Drop the REST connection as a trigger point, provide information as below and click checkbox

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

Integration Bootcamp Virtual Webtraing India June 1st-3rd 2020

Integrate SaaS Bootcamp India 06.2020Oracle Integration Bootcamp June 1st – 3rd 2020

SaaS solutions like HCM, CX and ERP Cloud need to be integrated and customized. Oracle Integration connects SaaS solutions with out of the box adapters.

Do you want to find out why Gartner named Oracle as a Leader in Magic Quadrant for three years in row? Are you able to innovate quickly in the new digital world? Are you looking for ways to integrate systems and data faster using a modern cloud integration platform? Attend the Oracle Integration Bootcamp, a three days hands-on training for Oracle partners!

Oracle Product Management is pleased to invite Oracle Partners to attend the 3-day hands-on workshop on how to integrate with ERP & HCM applications using Oracle Integration Cloud. This Invite-Only hands-on workshop will be delivered at No-Fee to Partners. It will consist of presentations, demos, and hands-on labs.

Schedule: June 1st – 3rd 2020

Workshop format:

  • Web based training with presentations, demos, and hands-on labs
  • Attendees will receive training environment login during the workshop

Audience:

  • Oracle SaaS partners who implement ERP, HCM and CX solutions
  • Consultants and Architect with technical background

For additional local training’s please visit the website 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 Integration: defining and using constants by Jan Kettenis

image

Oracle Integration Cloud does not have native support for constants, but it is easy to set this up. This post discusses how. For integrations there are two ways to define constants in the Oracle Integration Cloud:

  • Lookups
  • Variables

Lookups are initially meant to support mapping of values from one domain to another. For example, one domain has country code using two letters ("NL") whereas another domain uses three letters ("NLD"). The lookup can then be used to "translate" the value from one to the other ("NL" <-> "NLD"). The same feature can also be used to support configurable constants by providing a list of name-value pairs. For example, in the following SMColor lookup two different name-value pairs have been stored, "YELLOW" with value "yellow", and "BLUE" with value "blue":
In an integration you can use this lookup to get the value by name using an XPath lookup function. As I will show hereafter, there are two different XPath expressions, each being used in a different context.
Variables are set in an Integration using the Assign activity. You can define a variable with a specific name and a value. You can also use a combination of the two. In the following example you see the variable "red" being defined with value "red" and the variable "blue" is initiated using an XPath expression that on its turn gets the value from the lookup name-value pair with name "BLUE": 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