Oracle
May 2019 Edition Oracle PaaS Partner
Community Newsletter
Dear PaaS Partner Community,
PaaS the knowledge from the emerging PaaS Partner Community Forum. As a community member you get access to the conference presentations, demos and hands-on training material. Make us of it, become trained & certified, publish service offerings, host customer cloud test drive events, build proof of concepts based on the Oracle Cloud Platform. In case you could not attend our annual conference attend an upcoming hands-on integration training in Italy & France.

Special thanks to the PaaS Partner community to deliver successful customer projects. Based on the joint customer success, Oracle was recognized in the third year in a row as a leader in the Gartner magic quadrant for enterprise integration platforms as a service.

In the process & innovation section we published a free online training for using a process within a VBCs application. With the adapters from UiPath and Automation Anywhere, robots can be integrated and used in a process. Blockchains drives digital transformation for investment banks and verifies honey and diamonds. With the Blockchain Platform SDK developers can build solutions local and deploy them in the Oracle cloud. 
Jürgen Kress
For a short summery of our key monthly information watch the Fusion Middleware & PaaS Partner Updates on YouTube. The May edition highlights presentations and training material from the emerging PaaS Partner Community Forum and Oracle is again recognized by Gartner as an integration platform leader. This month’s community webcast will be an update on ERP integration please join our monthly PaaS Partner Community Webcast – May 28th 2019.
Want to publish your best practice article & news in the next community newsletter? Please feel free to send it via Twitter @soaCommunity #PaaSCommunity!
Table Of Contents
Community Annoucements
PaaS the knowledge emerging PaaS Forum conference material & reports
Community Forum 2019
Make use of the emerging PaaS Forum conference material and share the knowledge with your team and your customers. Special thanks to Phil, Sven, Monica, Sanae and David for their blog posts:
In case you published a PaaS Forum article please let us know via twitter #PaaSForum!

At our community workspace (membership required) we published the presentations & training material. Make use and update your team and customers!
Integrate ERP Cloud with Oracle Integration Cloud – PaaS Partner Community Webcast May 28th 2019
PaaS Partner Community Webcasts
bullet Integrate ERP Cloud May 28th 2019 15:30-16:30 CET
Integrate ERP Cloud Oracle Integration eliminates barriers between business applications through a combination of machine learning, embedded best-practice guidance, prebuilt integration, and process automation. Oracle Integration is unique in the market by leveraging Oracle application expertise to build an extensive library of adapters to Oracle and 3rd party SaaS and on-premises applications to enable you to deliver new business services faster. For more information please visit www.tinyurl.com/integrateSaaS.
Presenter: Niall Commiskey.
Niall Commiskey

Detailed Registration Page cta-arrow
PaaS Partner YouTube Update May 2019
The May edition of the PaaS & Middleware Partner Update contains three topics:
  • Share the emerging PaaS Forum knowledge
  • Leader Gartner Integration Platform
  • ERP integration community webcast
PaaS Partner
For regular updates please subscribe to our YouTube channel here. Thanks for your likes and sharing the video on YouTube and LinkedIn. For the latest PaaS Community information please visit our Community update wiki here (Community membership required).
Watch the video here cta-arrow
Join the Oracle Developer Meetup groups
We launched three new local Meetup locations in Cairo, Frankfurt and Porto! Want to learn more about developing Enterprise-grade Cloud Native applications on the Oracle Cloud Platform, covering topics like Microservices Architecture, developing in Node, Python and PHP, using Low Code development tools to build Mobile apps, and much more? Oracle Developer Meetups

Join the Oracle Developer Meetup groups if you want to follow Oracle’s solutions in this area, or participate in the events and hands-on labs we organize:
Utrecht,
Netherlands
Join Now cta-arrow
Brussels,
Belgium
Join Now cta-arrow
Cairo, Egypt
Join Now cta-arrow
Cologne,
Germany
Join Now cta-arrow
Frankfurt,
Germany
Join Now cta-arrow
Lisbon,
Portugal
Join Now cta-arrow
Lille,
France
Join Now cta-arrow
London,
UK
Join Now cta-arrow
Madrid,
Spain
Join Now cta-arrow
Istanbul,
Turkey
Join Now cta-arrow
Porto,
Portugal
Join Now cta-arrow
Oslo,
Norway
Join Now cta-arrow
PaaS free trial accounts ICS, SOA CS, API CS, PCS, IoT and PaaS for SaaSDemo.Oracle.com
PaaS free trial accounts
As part of our communities we do offer free PaaS accounts.
To request a free 30 days cloud trial, which can be extended or an additional month, please add yourself to our community wiki:
PaaS Demo Accounts (Community membership required)
Free Cloud Trials cta-arrow
Integration Section
Oracle Again a Leader in Gartner Magic Quadrant for Enterprise Integration Platform as a Service
oracle-again-leader
Report solidifies Oracle’s leadership in execution and vision for enterprise customers. For the third straight year, Oracle was named a Leader in Gartner’s 2019 “Magic Quadrant for Enterprise Integration Platform as a Service (iPaaS)” report. Special thanks to the PaaS Partner community to deliver successful customer projects.
iPaaS offerings are crucial for the modern enterprise to adopt hybrid digital transformation strategies, making this recognition a testament to Oracle’s continued success in delivering value to its large enterprise customers.

Get the report here cta-arrow
Connect the Cloud
connect-the-cloud
Extend what is possible with Oracle Cloud Platform for Integration
The Integration Solution
Software-as-a-Service (SaaS) applications have become pervasive across the corporate computing landscape. Almost every industry is in the throes of digital transformation, and it is changing how business is done.
Despite the improvements created by digital transformation, integration challenges persist, impacting even otherwise successful projects.
In an economy fueled by digital transformation, the success of an enterprise will be directly linked to its ability to meet and surpass demanding performance benchmarks both enabled and fueled by the ability to introduce artificial intelligence and machine learning in the form of autonomous integration.

Innovations now and into the near future for autonomous integration accelerates the path to digital transformation by eliminating barriers between business applications through a combination of machine learning, embedded best-practice guidance, and prebuilt application integration and process automation. Autonomous integration enables faster time to market, better business agility, and complete visibility across business process lifecycles.

Get the free eBook here cta-arrow
ERP & HCM Application integration using Oracle Integration –Workshop June 24 - June 26, 2019 Paris France
erp-hcm-application
Are you working on Oracle SaaS implementations and want to integrate and extend them using PaaS? Oracle Product Management is pleased to invite Oracle Partners to attend the 3-day hands-on workshop on how to integrate with ERP & HCM applications using Oracle Integration Cloud. This Invite-Only hands-on workshop will be delivered at No-Fee to Partners.
It will consist of presentations, demos, and hands-on labs. Oracle Integration Cloud (OIC) offers Integration, Process Automation and Visual design capabilities that help business analysts and IT specialists to automate end to end business processes across departments. Oracle Integration Cloud offers a simple recipe to be successful in this application integration and process automation journey: Build, Integrate and Engage.

Detailed Registration Page cta-arrow
api-platform-cloud-service
Oracle API Platform Cloud Service – Enabling the Digital Transformation by Eduardo Barra Cordeiro
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?
provisioning oracle API
Provisioning Oracle API Platform Gateway Nodes using Terraform and Ansible on AWS by Kevin King
When using Oracle Autonomous API Platform, an API gets deployed to a logical gateway. The logical gateway consists of one or more nodes which are instances of the runtime, installed on physical machines, virtual machines, or cloud infrastructure. The gateway nodes handle the processing of the API requests, but a load balancer is still required to distribute traffic between the nodes. When performance becomes an issue, more nodes can be added to increase throughput. Providing an automated way to manage nodes ensures consistency of configurations and the ability to easily add and remove nodes.
evolution of interface protocols
A brief look at the evolution of interface protocols leading to modern APIs by Luis Weir
Application interfaces are as old as the origins of distributed computing and can be traced back to the late 1960's when the first request-response style protocols were conceived. For example, according to this research, it wasn't until the late 1980's when the first popular release of RPC (described below) was introduced by SUN Microsystems (later acquired by Oracle), that internet-based interface protocols gained wide popularity and adoption.
Best Practices for Cloud ERP
Dive Deep into Wells Fargo’s Best Practices for Cloud ERP Integration by Vika Mlonchina
Recently, Daryl Eicher, Oracle Director of Product Marketing for Oracle Integration, sat down for a webcast with Aneri Shah, Wells Fargo Senior Vice President, ERP Strategist to explore the business and technical considerations that make ERP integration and automation work for agile finance and supply chain management leaders. Read on for a deep dive into their conversation to learn about Wells Fargo's best practices for cloud ERP integration along with several other customer integration journeys.
Full Podcast Series
Full Podcast Series Now Available - Integration: Heart of the Digital Economy by Vika Mlonchina
Rapid cloud adoption, mobile devices, and AI technologies are rapidly changing the way customers interact with businesses. And organizations are quickly assembling ad-hoc solutions to meet these challenges. The result is a tangled mess of hardwired enterprise systems that can no longer support business needs. Modern applications and data infrastructures are needed to enable mission-critical business systems to work with big data systems. Cloud-agnostic integration platforms are required to support agile processes that can take advantage of new tools like AI and blockchain. In this podcast series, learn how organizations can leverage integration technologies to compete successfully in the digital age.
Integration, Process and Visual Builder by Jin Park
OIC makes integration easy with ODI. We know OIC (Oracle Integration Cloud) is capable of file based integration for ERP over API.
And we do know that ODI (Oracle Database Integrator from Data Integration Platform Cloud) is capable of ingesting large file and processing it for ERP through the database layer aka ETL / ELT.
Okay, what if those cloud services work together and give you a simple pattern which can be applied to typical use case such as large number of big files integration with ERP through the database layer.
OIC Integration with Netsuite
OIC Integration with Netsuite - initial setup and basic troubleshooting by Niall Commiskey
It's always good to try new things, so here I am checking out OIC integration with Netsuite.
This post covers the following –
1. Creating a new user in Netsuite, giving them login permissions and assigning roles.
2. Activating that user in Netsuite for web services access.
3. Creating a connection to Netsuite in OIC, leveraging the user created.
4. Creating a simple integration to Netsuite - Contact Creation.
5. Troubleshooting - what permissions does my user need to create a contact in Netsuite. 
Fetch Email attachments
Fetch Email attachments using Microsoft Email adapter in Oracle Integration Cloud by Ankur Jain 
In the article, we'll show how to fetch the attachments from email and dump the attachments on the SFTP server.
To complete this article, we should have in place:
1. MS email connection: If not created, use the post to create a connection with Microsoft outlook
2. FTP connection: If not created, use the post to create a connection with FTP
Below is the end to end use case which is demonstrated in the article:
• Fetch the emails from MS outlook
• Extract the attachments from each and every email
• Dump all attachments on the SFTP server
Let's go ahead and see how to achieve this
Pick action in OIC
How to use Pick action in OIC Orchestration by Sumeet Singh
REST Adapter in its current version only publishes a single resource with a single verb in the inbound. Also, there can only be a single source within an integration flow. This is somewhat restrictive as the users have to create multiple integrations (each with a separate resource URI) for related resources and verbs.
Let's say someone has a requirement to create, update and delete a resource. Naturally, the expectation is that there would be a single resource which can be manipulated with different HTTP verbs. This is not possible with REST adapter and in the current version, users are forced to create multiple integrations for performing these different operations.
Change date time format in Oracle Integration Cloud by Ankur Jain 
We got a request from multiple folks saying they are struggling to change the date time format in Oracle Integration Cloud.
We are writing this article to see how to change the default date format(2019-04-13T05:09:05.049+00:00) to a different format.
Oracle Integration Cloud Service provides an Out of the box function(xp20:format-dateTime) which allows us to change the date time format. We are on ICS version (18.4.3.0.3) and the function is available(xp20:format-dateTime). Let us see how to apply this function and change the date format as per the requirement. The function(xp20:format-dateTime) takes below two arguments:
using integration flows
Using Integration flows with File Transfers by Michael Meiner
Oracle Integration (OIC) eliminates barriers between business applications through a combination of machine learning, embedded best-practice guidance, pre-built integration and process automation. Integration Cloud provides the means for integrating applications, automating processes and building applications visually. Integration Cloud can also consume, produce, and perform transformations, on files.
microservices architecture
Microservices Architecture pt.2: Why do we want Microservices architecture? By Lykle Thijssen 
After exploring what a microservices architecture actually is (see Microservices Architecture pt.1: Definition), we can ask ourselves why we want such an architecture. After all, it seems rather complex, discourages reusability, can lead to data inconsistency and any hype will be overtaken by something else in the future. However, there are benefits too and most of the downsides can be mitigated. It's also not always necessary to go for the most hardcore version of an idea, some middle ground can be reached to come up with a reasonable solution.
Ready to run SOA
Getting ready to run SOA on Oracle Cloud Infrastructure with Terraform by Robert Wunderlich
Oracle has a robust portfolio of cloud offerings ranging from SaaS to IaaS. Some of the services like Autonomous Transaction Processing (ATP), or Oracle Integration Cloud (OIC) are fully managed by Oracle, lifting the burdens from DBAs and System Administrators. These services run on Oracle Cloud Infrastructure (OCI) sometimes referred to as the "gen 2 cloud".
Test Remote Asynchronous
Test Remote Asynchronous Request Response services by Martien van den Akker
A few years ago, I described how you can test Asynchronous Request Response services.
The thing with Asynchronous Request Response services is, as I used to describe it, that they're in essence two complementary Request-Only (Fire and Forget) services. That is, the client submits a request to the Asynchronous Request Response service, and at a certain point waits for the response by listening to an endpoint.
Moving SOA to Oracle
Moving SOA to Oracle Cloud Infrastructure by Robert Wunderlich
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.
SOA Suite 12c
SOA Suite 12c upgrade - Composite DVMs by Martien van den Akker
Today I found something curious in a composite upgraded from 11g to 12c, regarding DVMs. I sometimes use DVMs in BPEL to prevent the use of complex xpath expressions with many conditions. For instance, if I need to know if a JMSType is in a certain range and if it is I need to continue, I can create a DVM that has those JVMTypes correlated to an indicator.
Process & Innovation Section
Oracle Visual Builder
Use a process in an Oracle Visual Builder application.
In the Processes feature of Oracle Integration, create a process application and a process. In Oracle Visual Builder, create a web application that displays processes and tasks and executes them.
Create and Configure a Process Starting from Visual Builder, develop a process application and a simple process, creating and configuring the process elements so that they can easily be used by Visual Builder.
Use a Process in a Visual Builder Application Create and configure a Visual Builder web application that starts processes, displays processes and tasks, and lets you execute the tasks
Want to Learn More? Dive deeper into the capabilities of Processes and Visual Builder.
Oracle Integration
Oracle Integration has the best of breed RSO (Robotic Service Orchestration) support by Nicolas Damonte
But before justifying it, let’s start by explaining what RSO is and the differences with RPA.
The What …
RSO (Robotic Service Orchestration) is basically managing bots in the context of a business process, just like they would manage people.
RPA (Robotic Process Automation) enables the automation of manual tasks using UI Scrapping technologies. The value proposition is using bots to perform repetitive manual tasks (like data entry) mainly on legacy systems (with no APIs).
The Difference …
RPA was designed to performs tasks, not to manage end to end services.
RSO is about end to end services, managing their full orchestration and fostering a continuous improvement lifecycle.
The Justification …
Arab Jordan Investment
Arab Jordan Investment Bank in Production with Oracle Blockchain by Mary Hall
Arab Jordan Investment Bank (AJIB) is now in production with the Oracle Blockchain Platform. The project is the largest blockchain deployment in the Middle East. AJIB deployed Oracle Blockchain Platform to replace the banking application previously used for money transfers between AJIB entities, resulting in cost-savings and real-time cross-border transactions.
Oracle BlockChain Service
Oracle BlockChain Service: creating a smart contract aka how to write a chaincode by Lonneke Dikmans
In the first blog about blockchain, I used Oracle Compute Cloud Classic and installed MultiChain on it. Since then, Oracle has released a Blockchain Cloud Service with a lot of out of the box functionality, based on Hyperledger.
Oracle BlockChain Platform
Oracle Blockchain Platform for Verifying Diamonds
Everledger, a leader in developing real-world applications of blockchain, has assessed Oracle’s blockchain offering and product capabilities to provide enhanced customer solutions. The outcome has seen synergies in enhanced product feature sets and functionalities requirements including Oracle Blockchain's rich history database that transparently enables analytics integration for interactive dashboards and reports.
Oracle BlockChain Verifies
Oracle Blockchain Verifies Real Honey by Mary Hall
At the recent Oracle OpenWorld Dubai show, Oracle showed a demonstration of how natural Honey can be verified by blockchain. You may wonder, well, why would anyone need Honey verified by blockchain? You may be surprised to learn that Honey is one of the most frequently impure or mislabeled foods. In recent years, Honey mixed with impure ingredients such as sugar, salt, corn syrup and even toxins has been found at grocery suppliers and retailers.
Oracle BlockChain Platform SDK
Blockchain Platform SDK
The Oracle Blockchain Platform SDK contains a development environment for developers to develop and test applications for Oracle Blockchain Platform Cloud. The Oracle Blockchain Platform SDK also contains a few examples in order for the developer to get started.
Additional New Material for PaaS Community
How a CTO Finds Flow - Groundbreaker Ambassador cta-arrow
Why Enterprise Developers Need to Understand Block cta-arrow
Announcing the Oracle Cloud Developer Image for cta-arrow
The Best Way to Install Cloud-Based Applications  cta-arrow
Mark Hurd: Cloud Is a New Business Model  cta-arrow
Smart Cities Improve Resident Experience cta-arrow
The Driverless Car: Closer Than You Think cta-arrow
When Seconds Count: A UK Police Department cta-arrow
Twitter
Top tweets PaaS Partner Community – May 2019
Send us your tweets  #PaaSCommunity and follow us on twitter http://twitter.com/soaCommunity
PaaS Community
Tweets
cta-arrow
Partner Community
Training Calendar PaaS Partner Community
For the latest training's please visit our PaaS Community Training Wiki here (membership required) feel free to add your events!
PaaS Community Training Wiki cta-arrow
PaaS the knowledge at a local Oracle Developer Meetup
PaaS the knowledge - Oracle Developer Meetup
Every year the #PaaSCommunity meets at the PaaS Partner Community Forum, Oracle OpenWorld and the PaaS Summer Camp.
To PaaS the knowledge within partners and customers we created the local Developer Meetups. Join them to share, network and collaborate across Europe:
  • Brussels, Belgium
  • Cairo, Egypt
  • Cologne, Germany
  • Frankfurt, Germany
  • Istanbul, Turkey
  • Lisbon, Portugal
  • Lille, France
  • London, UK
  • Madrid, Spain
  • Oslo, Norway
  • Porto, Portugal
  • Utrecht, Netherlands
Special thanks to all local hosts! Please let us know in case you want to run an event at one of this location or you want to start your local Meetup.

Join an Oracle Developer Meetup Group cta-arrow
Invite your colleagues to join the PaaS Partner Community
Free Registration cta-arrow
Community Resources
Slack cta-arrow
Workspace cta-arrow
Stay Connected
Facebook Linkedin Twitter Youtube Oracle
#PaaSCommunity