OIC – First Steps with the ATP adapter by Niall Commiskey

image

ATP = Autonomous Transaction Processing from Oracle.
Oracle Autonomous Transaction Processing delivers a self-driving, self-securing, self-repairing database service that can instantly scale to meet demands of mission critical applications.
More details about ATP here
First step was to get access to an ATP service.
I then connected to this via SQLDeveloper – here I created a new table – 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

Securing files using PGP encryption (Part-2-Decryption): Oracle Integration by Ankur Jain

image

This is the second part of transferring the secured file over SFTP in Oracle Integration Cloud. In the previous blog, we showcased how to create encrypted files using Pretty Good Privacy (PGP) mechanism.

In the article, we’ll process the encrypted file, decrypt it and print the records into the logs.

I’ll recommend you to check the previous article before going ahead.
To decrypt the file, we would be needing the PGP private key along with the password.
The PGP key private key needs to be uploaded into the FTP connection. Open the FTP connection and click on the Configure Security button. Notice the "PGP Private Key" field, click on the Checkbox and click on the Upload button.
Once we click on the Upload button, it will allow us browsing the file. Browser the PGP private key and click on the Upload button
Enter the PGP private key password 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

Securing files using PGP encryption (Part-1-Encryption): Oracle Integration by Ankur Jain

image

Are you scared the data can be hijacked during transmission of the files if we are doing transactions using the Integration Cloud? Do not scare, read the article and feel comfortable to transmit the files in a secured manner.
Oracle Integration Cloud provides Pretty Good Privacy (PGP) mechanism to encrypt or decrypt the files which allow us to read/write files in a secure manner.
So, we only required PGP public and private keys to transfer files in a secure manner.

  1. Do you want to encrypt the file?: So use PGP public key to encrypt
  2. Do you want to decrypt the file? Use PGP private key to decrypt

We are dividing encryption and decryption into two parts:

Part 1): Will demonstrate how to  encrypt the files

Part 2): Will demonstrate how to decrypt the files

In this article, we’ll cover Part-1

Use Case: We’ll read the plain CSV from FTP location and create the encrypted CSV file on FTP location

Let’s see how to achieve this.

Before we encrypt the file, we have to upload the PGP public key into the Integration FTP connection. So, I am considering we already have one FTP connection in place. Open the FTP connection and click on the Configure Security button. Notice the PGP Public Key field, click on the Checkbox and click on the Upload button. 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

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

    Additional new content PaaS Partner Community

    image

    · Quality Control: How to Track a Diamond’s Journey Consumers want to ensure that their diamonds weren’t sold to finance insurgencies or wars, and insurers want to stop theft and fraud. Startup Everledger creates “a unique thumbprint from 40 metadata points of a diamond and records that into the blockchain,” says founder and CEO Leanne Kempuses, aspiring to trace the “lifetime journey” of a diamond from the mine to the end consumer. Tracking other high-value goods with emerging technology.

    · Interview: The IoT Is in the Applications By now businesses are convinced that IoT can improve their operations, “but they really don’t want to assemble IoT solutions themselves,” says Oracle’s Bhagat Nainani. Instead, they want to see IoT data from industrial operations, manufacturing, transportation, and field service integrated into the business application they already use. Five examples.

    · Free Ebook: SaaS for Dummies

    · Using AI to Match Patients with Clinical Trials With tens of thousands of clinical trials worldwide, “it’s very hard to know what you’re eligible for,” says Dan Kuenzig, a director in Oracle’s Strategic Programs. Enter The Opportunity Project, a US-government-led initiative that attacks this and other problems by giving private software engineers swaths of “open” federal data so they can apply emerging technologies such as artificial intelligence and cloud computing resources to the analysis. How does it work?

    · Data, AI, and Analytics: What Matters Most It’s a challenge for business leaders to know what technology trends to invest in first. Business intelligence and analytics expert Bruno Aziza suggests three trends that will define the years 2020 to 2030: cloud-based data control, more integration of analytics, and the embrace of artificial intelligence. The research behind his advice

    · This Week’s Headlines: Blockchain Choice, Impending Disaster, Game Publishing Unbound and More Experts at Blockchain Cleveland sort out when to use a distributed ledger. Oracle’s Matthew O’Keefe asks why we miss signals of impending disaster. The Dragon Ball games publisher says that it will not be bound by established ideas. And how Puerto Rico wants to “become the center of the world for resiliency and rebuilding.” Plus new videos, events, and more

    · ERP and Blockchain Work Together for Complex, Multiparty Transactions | Beth Stackpole 

    · Synchronized Patient Health Data with Blockchain Technology | Neil Cattermull

    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

    Everything As Code – Article for PTK by Phil Wilkins

    image

    PTK (Pass The Knowledge) is the new name for the Independent UK Oracle User Group‘s journal, previously known as Oracle Scene.  Yesterday saw the 1st release under its new name, and I’m proud to say that I have an article included called Everything as Code.

    Not only that,  it is great to see the journal includes the appearance of one of my Oracle Team colleagues at CapgeminiAmy Simpson-Grange (here).

    The magazine features the approach trialled in the last issue of Oracle Scene where the Journal was split in two – one half focusing on Oracle Applications and Applications Technology and the other on Oracle core technologies i.e PaaS, IaaS, Database, Infrastructure etc.  it also just happens that Amy appears in one half, and I in the other.

    One thing that hasn’t changed is the high quality of articles that reflect the diversity of Oracle’s portfolio and community – covering things like Women In IT, Conversational AI, Sanjeevan Bala from Channel 4 discussing the use of Data Science, Database Security and Table Scans. 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

    Blockchain Supply Chain App for Intelligent Track & Trace by Mary Hall

    image

    Blockchain technology offers  greater transparency and a single source of truth for for participants using supply chain networks. Intelligent track and trace of orders, goods and delays via blockchain could expedite the sending and receipt of goods.

    Today’s supply chains produce multiple data points often times resulting in thousands of daily transactions that need to be validated and confirmed.

    While all this "big data" data presents opportunities, it can also be incredibly difficult to manage, especially if that data isn’t properly validated by all parties. The lack of validation can expose organizations to risk, especially if they are trying to track supply chain goods that are regulated by law.   For supply chain tracking, blockchain technology offers some unique benefits.

    • Traceability: Full audit tail of data throughout the supply chain
    • Compliance: Single, timestamped, tamper-proof source of data
    • Flexibility: Real-time rule-based verification of multi-party confirmations
    • Reliable transactions: Trusted digital signature based peer to peer interactions

    Intelligent Track and Trace on Blockchain for Supply Chain
    Oracle’s Blockchain Supply Chain Application is designed to help organizations meet some of the business problems posed by supply chain networks.

    In late 2018, Oracle announced a new suite of Blockchain Applications at Oracle OpenWorld. Since the announcement, Oracle has been closely collaborating with  early adopters to gather their feedback to help design the Blockchain Apps.  At MBX, March 19-21 in Las Vegas, Oracle experts  will share aggregated learnings from their design partner engagements and take a deep dive into our first Blockchain Application Offering: Oracle Intelligent Track and Trace. 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 Approach to RPA by Phil Wilkins

    image

    With the recent announcement of working with Automation Anywhere (press release here) adding to the partnership already in place with UiPath, Oracle’s approach to Robotic Process Automation (RPA) is differing to other players such as SAP and Pega Systems for example who have acquired vendors.

    It is an interesting question as to whether partnering is the right solution given that RPA vendors can and do challenge the need for an integration platform. After all with the exception of IoT most solutions have an some form of UI or API the robot can connect to. This assertion whilst isn’t wrong it fundamentally overlooks the ability to push transaction volumes through, UIs are vulnerable to change, the ability to apply very robust security. But when discussing integration needs with business rather than technology leaders such factors can be so easily overlooked.

    Whilst acquisition is a possibility, unless Oracle acquires one of the big three (Automation Anywhere, UiPath, Blue Prism) they are likely to end up with a less established and/or less feature rich offering, that could very easily be perceived as an expensive OIC adaptor. Where as by having now partnered with two of the three major players, it is easier to sell the story that the technologies can be complimentary. 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