Create an XML file in Oracle Integration Cloud by Ankur Jain

Let’s see how to achieve this use case

• Create a FTP connection: Please go through the article to see how to create FTP connection
• Create a REST connection. Please go through the article to see how to create REST connection
• Go the the Integrations and click on the Create button from the upper right coner and select “App Driven Orchestration“
• Enter the Integration name as “WriteXMLFile” and click on the Create button.
• Select inline drag REST connection on the Integration canvas as a Trigger point
• Enter below information and click on the Next button
  • Name of the end point: WriteXML
• Enter below information and click on the Next button
  • What is the endpoint’s relative resource URI: /create
  • What action do you want to perform on the endpoint: POST
  • Select Configure a request payload for this endpoint checkbox- This option allows us to assign payload in the next step. 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 & Insight – Netsuite Data Sync Use Case by Niall Commiskey

OIC is a toolkit – 4 main tools:

· Integration – connect your apps

· Process – intelligent human workflows – can be used to extend apps or for your own custom processes.

· Insight – analyze what’s going on in Integration and Process, but this from a business user perspective. More details below.

· Visual Builder – create net new apps on top of your apis.

For those who haven’t seen Insight before – the OraDocs provide the following succinct description of what it offers – Integration Insight in Oracle Integration provides a business-friendly experience, allowing users to model, collect, and monitor business-level metrics using web-based dashboards. Integration Insight works with business processes that are implemented using the Integrations or Processes features in Oracle Integration. At a high level, Integration Insight provides:• A web-based interface to:
– Model business processes, including milestones
– Map models to a business processes implementation
– Monitor business progress through dashboards
• Efficient workflow requiring no development effort and minimal impact to runtime.
• Advanced analytics presented in both preconfigured and custom dashboards.
The following example leverages 3 of the OIC tools – Integration, Process and Insight in the context of a Netsuite data synchronisation use case. Please see my previous post here, for details of leveraging Visual Builder on top of 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

OIC Connectivity Agent by Daniel Teixeira

The OIC connectivity agent is the answer for a secure hybrid deployment, where you have a mix of cloud and on-premise applications and need to ensure a secure communication.

The agent is the handler/listener that manages both inbound/outbound communication. This ensures that there is no need to open a port in the on premise firewall.

Fortunately Mordac is not a Product Manager for OIC:)

1. Create an Agent Group
The agent group is a logical group to which we can associate the physical agents installed on premise. Very simple to create one – Just provide a name and a description.

2. Download and Run the Connectivity Agent Installer

On the same place where you created the agent group, download the connectivity agent. Let’s stop for a second and look to the system requirements. 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

SOA Suite Modernization Partner Community Webcast January 27th 2021

Oracle SOA Suite Modernization

Come to this session to learn about how you can modernize your SOA Suite estate while maintaining the value of your investment. You will learn about:

• Oracle’s commitment and roadmap for SOA
• Options you have for moving your SOA to the cloud
• Modernize your integration ecosystem with services like Oracle Integration, Digital Assistant and Autonomous DB

We will have Oracle Integration PMs on the call to provide you the strategic direction Oracle’s integration platform and recommendations for how to approach modernizing your SOA. You will learn why Oracle is best positioned to help you lower costs, increase your agility, and help you build out your Digital Platform for Digital Resilience which is more important now than ever.

Schedule:  January 27, 2021 16:30 – 17:30 CET (Berlin Time)

Featured speakers:

Sandhya Lakshmi Gopalan Senior Product Manager Oracle HQ LinkedIn	Ravi Pinto Director Product Management Oracle HQ LinkedIn

For details please visit the registration page here.

For more information watch our free on-demand webcasts:

• Integration Update & New Features
• ERP Integration with Application Adapters
• HCM Integration with Application Adapters
• Connect, Innovate, Extend SaaS Kickoff Webcast
• Cloud Platform Kickoff Webcast

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

Automating, Migrating and Upgrading Oracle eBusiness Suite R12 into the Cloud–Webcast February 11th 2021

Discover how to transform your Finance Team by migrating, upgrading, and enhancing Oracle eBusiness Suite with automation and utilising the cloud to realise the full potential and power of your application.

Join the experts from Arcivate and Data Intensity for a webinar on upgrading and migrating Oracle E-Business Suite to the cloud. You’ll also discover how to realise further efficiencies by automating your supplier invoice processes which will truly empower you to transform the way your Finance team operates.

Join us on the 11th February at 11:00am GMT 

In this webinar, we will explain how upgrading and migrating eBusiness Suite to the Cloud and enhancing with automation can optimise your end-to-end processes to deliver on key business objectives.

Data Intensity will cover the challenges you face in moving to the cloud by identifying the right cloud technologies to deliver faster time-to-value, reduced costs, and a predictable path to achieve your business outcomes.

Arcivate will demonstrate automation of the Accounts Payable data entry process with its Mi Invoices SaaS solution and the business benefits of automated invoice processing, including lowering costs and minimising manual inputs.

For details please visit the registration page here. 

Additional webinars are available here and on-demand webinars 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

A Simple Guide to Oracle HCM Data Loader (HDL) Job Support in Oracle HCM Cloud Adapter by Prakash Masand, and Asawari Pawar

Oracle Integration continues to simplify integrations with Oracle HCM Cloud by adding native support to more and more Oracle HCM integration touch points. Oracle Integration now supports Oracle HCM Data Loader (HDL) jobs, a powerful tool for bulk loading data through integrations. Using Oracle HDL, you can load business objects for most Oracle HCM Cloud products into Oracle Integration. For example, you can load new hires from Oracle Talent Acquisition Cloud (Taleo EE) as workers into Oracle HCM Cloud using an Oracle HDL job. To learn more about Oracle HDL jobs, refer to this blog.

The Oracle HCM Cloud Adapter in Oracle Integration simplifies the way an integration specialist invokes an Oracle HDL job process and monitors the status of the job. The Oracle HDL job can load data into business object from delimited data (.dat) files. Integration architect can generate the delimited data files in Oracle Integration using business object template files provided by Oracle HCM Cloud. 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

Security Improvements for Database & FTP Adapters by Michael Meiner

Overview

Oracle Integration (OIC)  has a rich set of security capabilities to enable our customers to connect applications and technologies in a secure manner. We continue to enhance Oracle Integration to provide additional security settings and functionality. In the November 2020 release, Oracle Integration offers new security-related functionality for the Database and FTP adapters.

The features discussed here include:

• Integration with ATP Serverless configured with Private Endpoint
• Support for Wallet based authentication with privately hosted databases
• Automatic Database Wallet and Password refresh
• Message payload security capabilities with privately hosted SFTP servers

Two of these features involve use of the Oracle Integration Connectivity Agent. Using the connectivity agent, you can create hybrid integrations and exchange messages between applications in private or on-premises networks and Oracle Integration.

1. Integration with ATP Serverless configured with Private Endpoint

Autonomous Database (ATP) is becoming more widely adopted, along with its use within integration flows using OIC. When configuring your Autonomous Database, you can specify that it use a private endpoint within your VCN in your tenancy. This allows you to keep all traffic to and from your Autonomous Database off of the public internet. When using the ATP adapter in Oracle Integration to connect to an ATP instance using a private endpoint, you need to set up the connectivity agent. Inside the connection details for the ATP adapter, there are 2 options for security: JDBC Basic Authentication and JDBC over SSL. When selecting JDBC over SSL, you are prompted to enter the wallet and wallet password. Prior releases of Oracle Integration do not allow you to use the JDBC over SSL (wallet) option with the connectivity agent. In addition, Username-token policy is not supported by ATP Serverless, This means that there were no options for integrating OIC with ATP-S with the connectivity agent. 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

Read ZIP files in Oracle Integration Cloud by Ankur Jain

We all know the capabilities of Oracle Integration Cloud FTP adapter of reading and writing files. There are situations where the files are in the zip format and required to read the zip files, parse each and every file under the zip file and send the data into the downstream applications.

In the article, we will explain how to read ZIP file from FTP location and push the content of each file under the zip file into the Oracle database. Download the zip file from here. This zip file contains three CSV file in the below format

Below are some pre-requisites which are required to execute this use case:

• Oracle Integration Cloud instance subscription. If  you don’t have please subscribe for the free trial from here
• FTP which should be accessible publicly
• Oracle Database
• OIC agent should be up and running
• Download the SQL script from here. Run these script which will create a table USER_MASTER table and a package UserPKG along with one procedure AddUser

Let’s start and achieve the use case: 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 the OCI Object Storage from the Oracle Integration Cloud by Daniel Martins Teixeira

The Oracle Cloud Infrastructure (OCI) offers a great set of services that can be very useful in combination with the Oracle Integration Cloud (OIC) for a wide variety of use cases. Things like the Object Storage, Oracle Streaming Service, Functions etc, can easily be accessed from OIC. The OCI ecosystem has a rich set of API’s that can be used for that purpose – https://docs.cloud.oracle.com/en-us/iaas/api/#/

In this post I am going to show how to create a file in the Oracle Object Storage.

What is the Object Storage

“The Oracle Cloud Infrastructure Object Storage service is an internet-scale, high-performance storage platform that offers reliable and cost-efficient data durability. The Object Storage service can store an unlimited amount of unstructured data of any content type, including analytic data and rich content, like images and videos.”

Traditional integration use cases rely heavily on File Servers and SFTP access as an harbour for files. Object Storage and similar services are picking up fast in replacing them. We see more and more customers leveraging the benefits of these services for the handling of all different types of content that need to be stored and moved.

How to Start

Before jumping to the Integration Cloud, we need to create an object storage bucket and we need API signing keys. 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 – Adapter Enhancements to Non Oracle Applications by Arvind Venugopal

Overview

Oracle Integration (OIC) has a rich set of security capabilities to enable our customers to connect applications and technologies in a secure manner. We continue to enhance Oracle Integration to provide additional enhancements and features on existing Application Adapters.

In the November 2020 release, Oracle Integration added the following capabilities to third party application adapters:

• Salesforce Adapter:  Enablement for Salesforce Government Cloud Customers
• ServiceNow Adapter: Graceful downgrade of User Experience
• PayPal Adapter Inbound Support and New Modules
• Shopify Adapter New Modules

Salesforce Adapter:  Enablement for Salesforce Government Cloud Customers

In the recent past, the Salesforce Adapter was enhanced with the elimination of the need to upload the enterprise WSDL on the Connections page. With this enhancement the customers, who were using the Salesforce Government Cloud, were unable to create new connections due to login considerations as mentioned in this help document. With the November release, the Salesforce Adapter provides support to create a connection of the Salesforce.com application that can integrate with Salesforce Government Cloud.

You simply need to select the target Salesforce instance type as Government and provide your custom domain name and API version on the Connections page. So let’s start with a quick tour of the new field on the Connection 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