Embedded File Server (SFTP) in Oracle Integration by Subhani Sahib Italapuram

image

We will be talking about how to leverage embedded File Server in Oracle Integration in this blog.

Prerequisites: Basic knowledge of Oracle Integration.

Targeted audience: Oracle Integration Developers OR Oracle Integration Users.

File Server Overview

File Server provides an embedded SFTP server within Oracle Integration, enabling organizations to focus on building integrations without needing to host and maintain a separate SFTP server.

Enable File Server in OIC

Before use, File Server must be enabled for the Oracle Integration instance. Enabling File Server is a one-time action completed in Oracle Cloud Infrastructure by an administrator with manage access to the instance. See Enable File Server

File Server Users

The primary users of File Server include:

· Oracle Integration administrators, who use File Server to manage server settings and configure users, groups, and folders, including permissions. To administer File Server as described in this guide, you must be assigned the ServiceAdministrator role in Oracle Integration. See Oracle Integration Service Roles in Provisioning and Administering Oracle Integration and Oracle Integration for SaaS, Generation 2.

· Oracle Integration developers, who use File Server along with the FTP adapter in integrations to read and write files.

· Oracle Integration users, who access File Server using an SFTP client. These users must be configured and enabled as users in File Server. Their access is controlled by their assigned folders and folder permissions. 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

OIC – SurveyMonkey 2 Netsuite Synchronisation by Niall Commiskey

imageSimple Use Case

As the sages say, its a gift to be simple and I’m fully d’accord with that. I have been asked to detail how to sync contact details from SurveyMonkey to Netsuite. Ok, said I to myself, let’s do it! It was only afterwards that I started considering what would be a valid use case from a business perspective. I came up with the following use case – A B2B scenario – I keep a list of customer contacts in SurveyMonkey.

AS you can see, I have 2 customers Commiskey Inc. and MacCumascaigh c.t.
Commiskey Inc has 2 contacts
Mac Cumascaigh c.t. has 1 contact. 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

Cloud Platform Partner Advisory Council 2020

image

You are invited to the 12th edition of the annual global Partner Advisory Council by the Oracle Integration Product Management team.

Why should you attend? Get the latest product updates and roadmap details from the Oracle Integration Product Management team. Provide feedback based on your customer project experience and discuss with the Oracle team product improvements & future directions.

Who should attend? Senior consultants architects, technical leaders & CTOs, who implemented successful Oracle Integration.

Schedule: December 8th-10th 2020

Agenda
December 8th 8:00-9:00 PST
Keynotes presented by Clay Magouyrk, Executive Vice President, Oracle Cloud Strategy and Andrew Mendelsohn, Executive Vice President, Oracle Data Management Strategy.
December 9th 2020 8:30-11:00 PST
Welcome & introduction & partner feedback
OIC Vision and Roadmap and Release Management
Extreme Scalability and Enhanced Resilience in Oracle Integration, Antony Reynolds
Summery & wrap up day 1
December 10th 2020 8:30-11:00 PST
Adapters & Accelerators & Recepis, Michael Meiner
Extend SaaS with Visual Builder and Process
API Management, Robert Wunderlich
SOA modernization, Ravi Pinto and Sandhya
Summery & wrap up

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

Invoking One Integration From Another Call Integration Action Step by Step by Harshit Yadav

image

In this blog, we are going to discuss, How to use Oracle Integration Cloud Service’s Call Integration Action feature to invoke an integration from another integration.

It is particularly useful when you need to have multiple small nested integrations rather than having one large integration. It is easier to diagnose errors when you have multiple small nested integrations. If you want to know more about How to Managing & Monitoring Integration Errors in Oracle Integration Cloud (OIC) check our blog.

If you are new to OIC and want to get familiarise then check our blog Oracle Integration Cloud (OIC) For Beginners Overview

Activate and Test Sample Hello World Integration

We will be using the sample  Hello World integration as the integration to be invoked (Child Integration) and Hello World Invoke integration will be used as the parent integration that will invoke the child integration. Both the integrations are provided as a sample but we will simplify the Invoke integration part for easy understanding. 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

OIC – Design Time variables – August Release New Feature by Niall Commiskey

image

Integration Properties are user defined properties available for usage by activities(e.g Notification ,Log) as read-only data within the flow. Integration properties provides a degree of integration configurability outside of the flow itself. For example, an email address used by a Notification activity within the flow can be externalized as integration property ‘sendTo’ allowing it to be configured without having to edit the integration itself or having to pass the value at runtime.

Ok, makes sense – so how to leverage this 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

Manage User & Roles Oracle Integration Cloud by Ankur Jain

image

It’s really important to manage users and roles for Oracle Integration Cloud. This article focuses on how to create users and assign different users to OIC application roles.

A user needs to be created under Oracle Identity Cloud Service (IDCS).

Once a user is created, he/she can be assigned to any Oracle Cloud service and OIC is one of them. 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

Automating End to End Bulk Export from Oracle ERP Cloud using Oracle Integration (Part 1- ERP Cloud Callback) by Kishore Katta

image
Background

What are the main methods available for Outbound Integrations within Oracle ERP Cloud?

Oracle ERP Cloud has provided a very useful functionality which empowers business enterprises to extract financials data from Oracle Cloud ERP and integrate it with on-premise systems, legacy systems and other Cloud Applications.

One very common business scenario in an enterprise is to generate extracts of financials data like Journals, Payables Invoices, Payments, Receivable Invoices etc for legacy or third-party partner systems. Let’s see the Outbound mechanisms and the purpose of each of them based on the volume of data that needs to be sent to downstream applications

BIP Extract

Designed to extract incremental data for scenarios ex:

–Get the list of invoices that has been approved since last execution

–Extract payment data since last execution to update downstream or upstream applications to reflect payments 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

OIC – Syncing Netsuite customers and contacts with Eloqua by Niall Commiskey

image

Introduction

What follows is a simple example of syncing Netsuite Customers/Primary Contacts with Eloqua Accounts/Contacts

I create a new customer in Netsuite – Commiskey Botanicals with Joe Strummer as a contact. I run the integration – and validate in Eloqua – So how did I do this?
An raibh sé draíochta? – you may well ask, but no, no magic, just OIC. So back to the integration. I began by creating a Saved Search in Netsuite – think of this like SQL for dummies – you pick the business object you’re interested in, join with other related objects and then you’re finished; you have the data you require. 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 b/w Oracle Engagement Cloud, Oracle CPQ & Oracle EBS by Atul Kumar

image

We have been getting a lot of queries from our Oracle Integration Cloud OIC trainees on Use case how to create an integration so that opportunity can be converted into a quote and then into order.

In this blog, I am going to show step by step process on how to use Oracle Integration cloud OIC to integrate Oracle Sales Cloud, Oracle CPQ (Configure, Price, Quote), and Oracle E-Business Suite so that data is synchronized in real-time.

If you are starting to learn Oracle Integration Cloud OIC we have a perfect training for you where you will learn to Provisioning OIC | Connectors/Adapters | REST & SOAP APIs | Customer Case Study | Security | Monitoring Integration.

Use Case

1. Opportunity Comes through Oracle Engagement Cloud and sent to Oracle CPQ Cloud.
2. Opportunity is received and converted into a quote through Oracle CPQ Cloud and sent to Oracle E-Business Suite.
3. Then the quote is converted into Order in Oracle E-Business Suite.
4. When the integration is completed the data should be synchronized in real-time between Oracle Engagement cloud (Sales Cloud), Oracle CPQ (Configure, Price, Quote), and Oracle E-Business Suite.

It is necessary that the systems to utilize one set of data and automatically transfer data between systems, this requires the systems to be integrated so that data could flow between them in a bidirectional manner.

For this scenario, we are choosing Oracle Integration cloud OIC as it offers bidirectional data synchronization. Oracle Integration will be used for bidirectional data synchronization between Oracle Engagement cloud (Sales Cloud), Oracle CPQ Cloud, and Oracle E-Business Suite.

What Is Oracle Integration Cloud (OIC)?

Oracle Integration Cloud (OIC) is a cloud-based integration application designed to perform integrations between SaaS to SaaS SaaS to On-Premise and vice versa. 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 Properties by Samir Sahu

image

How to externalize properties using Integration Properties in OIC?

Have you tried to use the integration to read the files from FTP and wondered if there was a way to externalize the FTP location outside the integration? Or create an integration that sends out notification and wanted to externalize the recipient of the email as a property to be passed as a parameter to the integration? We have heard from our customers on the need for an easy way to externalize properties from the integration and be able to modify the values without editing the integration.

Changing hard-coded parameter values in the integration canvas can be a time-consuming task as

        i) Integrations needs to be edited

        ii) Familiarity with the integration and the design tool in order to update the appropriate action and property.

Also, there are use cases where an integration is developed by a one user and run by different users. The user running it might not have privileges to edit the integration making it difficult to change the parameter values.

We have introduced a new feature that allows the integration developer to define properties which are exposed and can be modified outside of the integration designer. Integration developers can define properties of their choosing, providing them with meaningful names and default values, and then use them throughout the integration in the rich set of available actions. Although property values are not modifiable using integration actions, what makes them extremely useful is that the default value can be overridden outside of the design tool prior to running the integration. This feature is available for both – App Driven and Scheduled Orchestration styles. 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