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

SaaS Business Event Integration using Oracle ERP Adapter and Engagement Cloud Adapter in OIC–Webcast May 20th 2020

Rimageegister for this Webcast on May 20th 2020

This one-hour advisor webcast is recommended for technical users wanting to learn how to integrate Oracle ERP Cloud and Oracle Engagement Cloud) with other external applications using Business Event subscriptions using Oracle Integration Cloud.
Topics:
* Introduction: What is Business Event Integration
* Workflow for Configuring Business Event Integration
* Other Configuration Considerations
* Troubleshooting References
* Q&A

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.

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

PaaS (Process & Integration) Partner Community Newsletter May 2020

Dear PaaS Partner Community

Oracle Insight, part of Oracle Integration, will launched in our community webcast May 26th. Join us to empower business owners with KPI’s and dashboards build on their integration data.

Many System Integrators us Oracle Integration to connect SaaS services with out of the box adapters. Oracle Integration can be also used by Independent Software Vendors to integrate their solutions with Oracle SaaS and Oracle on-premises applications. A great example is our partner ARCivate who connects their Mi Invoices payment solution with E-Business suite base on Oracle Integration.

Watch Filip Huysmans, Cimageontribute moving customers to the Oracle Cloud Platform. We want to promote also your customer success, submit your story via the customer reference program.

How to become a SaaS Integration Expert? We offer training material, free online training including free certification, documentation, trial services and support via our slack channel. Be prepared to connect your next SaaS solution with Oracle Integration. Thanks to the community for sharing all the integration articles: Advisor Webcast: SaaS Business Event Integration using Oracle ERP Adapter and Engagement Cloud Adapter in OIC – May 20, 2020 & Kafka Adapter for OIC & Netsuite Custom Field Discovery & Creating net new apps on top of Netsuite with OIC Visual Builder & Object Storage with Oracle Integration Cloud – Part 2 & B2B – EDI Translation support & Token required to provision an Oracle Integration Cloud instance & OIC – Monitoring API – Getting Activity Stream data & SOA Suite: SOAP Faults in BPEL and Mediator & Swagger API document from Any WADL & Schema in Oracle SOA.

In the process & innovation section we Chris released the latest hands-on training material. Thanks to Niall for the excellent use case to integrate and extend Netsuite with custom workflows. New process features include an updated expression builder. Which can be also used for task actions in e-mail notifications.

For a short summery of our monthly key information watch the PaaS Partner Updates on YouTube. The May edition highlights all resources to become a SaaS Integration expert. This month’s community webcast will the launch of Oracle Insight by Simone Geib. Join our PaaS Partner Community Webcast May 26th 2020.

Want to publish your best practice article & news in the next community newsletter? Please feel free to send it via Twitter @soaCommunity #PaaSCommunity!

To read the newsletter please visit www.tinyurl.com/PaaSNewsMay2020

Please like and share the newsletter at Twitter and LinkedIn

PaaS Newsletter May 2020

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