Using Stage File Write operation(with opaque schema) to copy files by Namratha Narayan

image

The stage file action can process each file downloaded by the FTP Adapter. The stage file action can read, write, zip, unzip, and list files in a staged location known to Oracle Integration Cloud.

For example, you may include a stage file action in an integration as follows:

  • Configure an FTP Adapter with the following settings:
    • Download File operation
    • Unzip the File option
    • Input directory and download directory path
  • Because the ZIP file may contain multiple files, configure a for-each action below the FTP Adapter to iterate over repeated elements.
  • To read each file from the input directory, configure a stage file action below the for-each action to read each file from the input directory as follows:
    • In the Expression Builder, specify the file name and directory from which to read the file.
    • Specify the schema file by loading a file that contains the data structure. 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 Capture EBS Business Event in Oracle Integration Cloud by Ankur Jain

imageIn this article, we are going to describe how to capture Events in Oracle Integration Cloud of Enterprise Business Suite (EBS) using the Oracle EBS adapter.

For example, if an Account Payable (AP) transaction closes for the period the AP raises the event “oracle.apps.ap.CloseProcess.period”. The status of the closed transaction can be sent to the downstream application once it is captured in the Oracle Integration Cloud.

During design time, we need to create an integration called "Close AP Transaction" with Oracle E-Business Suite “Financials” as a trigger (source) connected through the Oracle E-Business Suite Adapter

During run time, if an Account Payable transaction closes, the business event “oracle.apps.ap.CloseProcess.period” is raised in Oracle EBS Account Payable which triggers the Integration.

Pre-requisite to achieve the use case:

Refer section “Deploy the required REST services in Oracle E-Business Suite” to deploy the above required service of a document

  • We must perform the one-time setup tasks in Oracle E-Business Suite to enable the business event. Refer section “Setup Tasks for Using the Oracle E-Business Suite Adapter as a Trigger (Source) Connection” of the document
  • Enable event oracle.apps.ap.CloseProcess.period in Oracle EBS suite. This article will help you to enable events. 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 The Co-op Cut Time to Hire in Two Quarters by Daryl Eicher

    image

    We had to re-imagine our recruitment service…

    When you’re one of the largest co-operatives in the world with £9.5 billion in revenue and your hiring managers are spending 4 minutes and 60 clicks to open a job requisition, what will it do for in-store performance to cut that to 30 seconds and 5 clicks? Yvonne Foster, Head of Resourcing Services at The Co-op, wanted to know.

    Connected HCM was part of the answer and her team set out to reduce their time to hire as quickly and cost-effectively as possible. Yvonne spoke with me about their journey to digitize their Recruit to Hire process as part of our customer success series

    The Co-op Reimagines Connected Recruiting

    The Co-op automated their recruitment process to reduce hiring time by connecting and extending their HCM Cloud. Head of Resourcing Services Yvonne Foster shares how Oracle Integration helped accelerate her innovation.

    Finding and engaging enough of the right talent in their retail grocery line of business meant extending and connecting SaaS and on-premises applications including Oracle HCM Cloud, Taleo, and multiple third-party systems.

    After receiving estimates of two years to implement their digital strategy from SaaS and cloud platform vendors, they knew they needed a faster and less risky approach. Using Oracle Integration as their digital transformation platform, they were live in two quarters with game-changing results:

    Congratulations to our partner Capgemini for this successful implementation.

    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

    Quick steps for setting up a Gateway Node in Oracle API Cloud Service By Sven Bernhardt

    image

    Oracle API Platform Cloud Service (APIP CS) is an API Management Platform for covering the complete API lifecycle. A general overview about the solution is provided in one of my previous blog posts.

    In this blog post, I’ll summarize the steps that are needed to setup a first API Gateway Gateway Node.

    Logical Gateway and Gateway Nodes

    Before getting started with the Gateway setup, a basic concept needs to be clarified.

    Oracle APIP CS support the concept of a so called Logical Gateway, which depicts a logical configuration and management unit for the several Gateway Nodes. A Gateway Node is a physical representation of a API Gateway. It is the runtime component, where APIs are exposed to the outside world and where the defined API policies are enforced, when an API is called by a client.

    From a subscription perspective the number of Logical Gateways is the relevant criterium with respect to the occurring costs. No matter, on how many Gateway Nodes are registered to a Logical Gateway.

    Installation

    Prerequisites

    Before getting started with the installation, a respective Compute Node (OCI, AWS, Azure, On-Premise) instance is needed on which the Gateway Node should be deployed. In my case, I used a OCI Compute instance, which I setup using the OCI console. 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

    FlexDeploy Loves Oracle API Platform: Series Overview by Joel Wenzel

    image

    APIs are everywhere.  The API boom is upon us and Oracle doesn’t intend to sit this one out.  Oracle API Platform, released in 2017, is Oracle’s answer to API lifecyle management and provides everything you would expect from a typical API abstraction layer such as:

    • Direct integration with an API designer (Apiary)
    • About 2 dozen out of the box policies such as OAuth security and API Rate limiting
    • In depth analytics of API requests

    We are excited to announce that FlexDeploy now offers robust support for Oracle’s API Platform.  In the coming posts we are going to walk through the core features of the plugin and discuss some API management strategies. We’ll be covering:

    After reading through this series you will have an understanding on how to provision Oracle API infrastructure as well as several different approaches to managing your APIs via FlexDeploy.

    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

    API Platform – Plans & Subscriptions by Phil Wilkins

    image

    When it comes to Plans and Subscriptions on the Oracle API Platform we have a very flexible set of relationships. When it comes to checking the relationships to ensure a configuration is correct and that the impact of changing a plan or subscription is clear.  I end up having to draw a little diagram, which always leaves me second guessing myself about which way the linkages are. So I created a quick aide memoir, particularly given the unfortunate fact that Oracle’s online documentation isn’t great for diagrams. 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

    Oracle API Platform Cloud Service – Enabling the Digital Transformation by Eduardo Barra Cordeiro

    image

    We live in a digital world. With the digital transformation, customers demand connectivity and innovative services. And in this rapidly changing marketplace, they have more options than ever. Companies need to respond quickly. It can be tough to keep up. On the bright side, this is a really exciting time because we can, in fact, deliver faster. And more. So how can you meet consumers expectations?

    One of the most popular ways of communicating digital information is via APIs, or Application Programming Interfaces. A lot of widely known apps use APIs: the most common social platforms, your favorite traffic apps, like Waze, your bank app or even apps like weather. They all use APIs.

    In this post, we will present the Oracle API Platform Cloud Service, and walk you through some of its concepts, including why you should consider using it.

    Why an API platform?

    To better understand why you should use this platform in your company, we should talk about hybrid clouds. Gartner defines a hybrid cloud service “as a cloud computing service that is composed of some combination of private, public and community cloud services, from different service providers. A hybrid cloud service crosses isolation and provider boundaries so that it can’t be simply put in one category of private, public, or community cloud service. It allows one to extend either the capacity or the capability of a cloud service, by aggregation, integration or customization with another cloud service.” 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

    Moving SOA to Oracle Cloud Infrastructure by Robert Wunderlich

    image

    Many customers are running their workloads on Oracle Cloud Infrastructure Classic (OCI-C), but the new Oracle Cloud Infrastructure (OCI) offers compelling benefits that customers should consider moving their workloads to the "gen 2 cloud".  Additionally if the customer is not yet running SOA 12.2.1.3 or above, now is an ideal time to make the move.

    A SOA implementation is typically large and serves mission critical requirements.  This means that a "side-by-side" migration is the best approach.  At a high-level the process is as follows:

    • Discover/map the existing OCI-C deployment.  Oracle provides a set of tools to help in migrating workloads to OCI.  You can learn more about this at Upgrade to Oracle Cloud Infrastructure.
    • Branch your SOA projects: SOA projects can be deployed into a new environment and they will be upgraded on the deployment.  However, a better approach is to branch your version control and upgrade the projects in JDeveloper.  You can then validate the project to catch any potential issues. 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

    Microsoft SQL adapter in Oracle Integration Cloud by Ankur Jain

    image

    In this article, we are going to explain MS adapter, its capabilities and how to create a connection with MS SQL server that resides in the on-premises network.

    Micrsoft SQL server Adapter capabilities

    The Microsoft SQL Server Adapter enables to integrate the Microsoft SQL Server database residing behind the firewall of your on-premises environment with Oracle Integration Cloud Service through use of the on-premises connectivity agent.

    The Microsoft SQL Server Adapter provides the following capabilities:

    • Execution of stored procedures in the Microsoft SQL Server database
    • Execution of DML statement such as Select, Insert, Update, and Delete using the Run a SQL Statement option
    • Support for generating XSD from PureSQL. This feature generates an XSD from a PureSQL statement provided by dynamically querying on the table.
    • Support for polling new and updated records for processing in the Microsoft SQL Server database

    Let’ see how to create MS SQL connection:

    • Login into the Oracle Integration Cloud console and click on the Connections
    • Click on the Create button from Top right corner
    • Search for the Microsoft SQL server and select the adapter. 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

    Oracle Integration Cloud Taleo EE (OTAC) – Create Requisition by Niall Commiskey

    image

    As you can see, I am looking to hire a philosopher. The above "Requisition" was created via the Taleo UI. But how could I leverage OIC to do the same?My first port of call was TCC. As per the previous post – I need a wrapsoap file describing the Requisition. Now I am just kicking the tyres – I have no sample input csv file, I don’t know what a Requisition looks like; so where do I start? 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