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

Real World SOA Modernization with Keste & Oracle Webcast January 21st 2021

Upgrade your Oracle SOA Suite to modern Oracle Integration in the Cloud

In this 30-minute webcast Oracle and Keste will talk about the real-world advantages of SOA modernization and highlight 3 different use cases. Learn from these real world customer success stories how to shift your existing Oracle SOA Suite into a cloud based, highly scalable, cost-effective solution that provides better performance at lower cost.

Schedule: January 21st 2021 10am PST.1pm EST

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.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Choosing Your Update Window by Antony Reynolds

Starting in the November Quarterly release we will allow customers to choose between two update windows for their OIC Generation 2 instances.

What is an Update Window?

We currently provide OIC functional updates every quarter. For OIC Generation 2 instances we do this in two windows, usually two weeks apart. Starting with the November release we will allow customers to select the windows in which they wish to be updated. We recommend that non-production instances are updated in the first window and production instances in the second window. This allows customers to sanity check the update before it is applied to production instances.

How Do I Select a Window?

We use the OCI tagging mechanism to identify the window in which an OIC instance should be updated. We currently look at one tag : OIC_UPDATE_WINDOW1. If that tag is set then we update the instance in window 1, otherwise we update it in window 2. 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