Oracle SOA Suite: Want performance? Don’t log so much and clean up your database! by Maarten Smeets

image

 

The Oracle SOA Suite infrastructure, especially composites, use the database intensively. Not only are the process definitions stored in the database, also a lot of audit information gets written there. The SOA infrastructure database, if not well managed, will grow and will eventually have detrimental effects on performance. In this blog post I will give some quick suggestions that will help you increase performance of your SOA Suite infrastructure on the database side by executing some simple scripts. These are some suggestions I have seen work at different customers. Not only do they help managing the SOA Suite data in the database, they will also lead to better SOA Suite performance.

Do not log too much!

Less data is faster. If you can limit database growth, management becomes easier.

  • Make sure the auditlevel of your processes is set to production level in production environments.
  • Think about the BPEL setting inMemoryOptimization. This can only be set for processes that do not contain any dehydration points such as receive, wait, onMessage and onAlarm activities. If set to true, the completionpersistpolicy can be used to tweak what to do after completion of the process. For example only save information about faulted instances in the dehydration store. In 12c this setting is part of the ‘Oracle Integration Continuous Availability’ feature and uses Coherence.

Start with a clean slate regularly

Especially for development environments it is healthy to regularly truncate all the major SOAINFRA tables. The script to do this is supplied by Oracle: MW_HOME/SOA_ORACLE_HOME/rcu/integration/soainfra/sql/truncate/truncate_soa_oracle.sql

The effect of executing this script is that all instance data is gone. This includes all tasks, long running BPM processes, long running BPEL processes, recoverable errors. For short everything except the definitions. The performance gain from executing the script can be significant. You should consider for example to run the script at the end of every sprint to start with a clean slate. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter 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

Happy Easter from the PaaS Community

As part of the #PaaSForum community presentation we created on stage an application to handle a dynamic process to adopt a Bunny for a day. The case has two stages to adopt a bunny and take care of the bunny. The milestone “happy bunny” is achieved when to you feed and play with the bunny. Want to try it yourself? Get a feed Oracle Process Cloud Services trial here (for OPN members please see here).

Happy Easter from the PaaS Community – Jürgen Kress

image

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter 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 Business Events in E-Business Suite to send messages to other applications via ICS by Naveen Nahata

image

Introduction

In this article, I will discuss and demonstrate the use of Business Events in E-Business Suite (EBS) to integrate it with other applications using Integration Cloud Service (ICS). The Oracle Workflow Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems. This functionality is leverage by ICS to register a subscription with EBS for an event which is invoked when the event is triggered. In this article I’ll explain this in detail. ICS provides Oracle SaaS customers with pre-defined to connections to most SaaS subscriptions and zero-code integration features to quickly connect SaaS applications.

Prerequisites

E-Business Suite can be installed in a customer’s data center or on OMCS or on IaaS (Infrastructure-as-a-service). It may be installed allowing access from Public Internet, or behind the firewall where access is restricted to only within the corporate network. In case where EBS is publically accessible, ICS can integrate with EBS directly.

However, when EBS is only available within the corporate network, ICS has no connectivity to EBS. In such cases, connectivity can still be established by the use of on-premises connectivity agent. Whenever ICS needs to connect to EBS, it write the message to a queue. The connectivity agent is installed on-premises and it polls ICS periodically and passes the messages to EBS. This is a prerequisite to use ICS with EBS for any kind of integration use case. For instructions on how to install connectivity agent, please read this article

In case of Business Events, connectivity agent helps automate the process of registration of ICS integration which needs to be invoked when the even fires. When an integration in ICS which uses EBS Business Event as a trigger is activated, ICS registers the integration as a subscriber to that particular Business Event. Since ICS cannot directly communicate with EBS, if it is behind the firewall, it writes the message to a queue which is read by the connectivity agent which in turns registers the integration as a subscriber. Once the subscription is created, EBS can directly invoke the integration with the event payload since the firewall blocks incoming connections to EBS and not outgoing HTTP(s) connections from the EBS to ICS.

There are other tasks that you need to perform on EBS before it can be used with ICS for integration using Business Events. These steps include setting up Integrated SOA Gateway REST Services, deploying the required REST services, setting up ICS credentials etc. To perform the required setup, please follow the instructions in page Setting Up and Creating an Oracle E-Business Suite Adapter Connection of Oracle E-Business Suite Adapter documentation.

Main Article

For this article, I’ll take an example where there is a requirement to keep Trading Community Architecture (TCA) data in sync between EBS and Oracle Sales Cloud (OSC). EBS is on-premises and behind the firewall so it cannot be accessed from internet. I will demonstrate how to use ICS to achieve this real-time integration.

The high level series of steps will be:

1. Create an Agent group in ICS

2. Download the connectivity agent installer from ICS and install it on a separate server. This agent will help receive messages from ICS and pass them to EBS. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter 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

Integrating the Chatbot by Léon Smiers

image

In this blog we look at the specific aspects of Chatbots and elaborate on its four integration parts. Read our previous blogs in this series: Why Chatbots, Maturity levels and Intelligence.

Chatbots are like any other application; they have a need for integration. In basic form the Chatbot integrates with the Channels, the Intelligence Providing systems, Backend systems  and it offloads Usage information for later improvements and intelligence determination.

All four integration parts have their usage patterns and (non functional) requirements for usage in the Chatbot solution.

Here we go through the details of each integration parts and considerations that need to be made during the design of a Chatbot solution.

Channel integration
Integration with channels firstly is about the job of acting as a funnel for many devices all communicating with the bot engine. As human interaction is a fraction of the speed of the ability for the engine to process the dialogue we need a more contemporary integration model that doesn’t tie up resources such as threads for each stream of interaction such as the models that Kafka and Node.js support. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter 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

Interfacing with HCM (or other file source) via FTP – ICS Definitive Tip #8 By Phil Wilkins

image

The techniques for integrating Oracle Human Capital Management (HCM) and several other Oracle SaaS solutions can require the use of Oracle Transactional Business Analysis (OTBI). The need for OTBI comes down to the fact that to  access to the relevant data an API is not available. OTBI can be configured to generate a report and then transfer the report using FTP. When the report needs to be consumed by ICS then an obvious FTP location is needed. One such option to hold a file for ICS to retrieve is the FTP server provided with the SaaS services (details here).

However,  it has come to light that the original intent for this FTP service was for holding bulk data intended to be used for ‘priming’ your HCM instance. As a place for staging data for ICS is in the mid to long term it isn’t recommended. The roadmap for the SaaS product team may result in removing the FTP server.

FTP Data Staging

So the question begs, where should we put the data coming out of OTBI to be consumed elsewhere? Well the next option would be to use Oracle’s Managed File Transfer (MFT). Although historically listed with SOA Cloud Service (SOA CS), it is independently priced and has  become a 1st class citizen of the PaaS family more recently. For MFT to be an option it needs to include an FTP server which it does. But MFT also has the abilities for doing a number of orchestration processes, such as calling web services when files are ready. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter 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: Best practices for 3rd Generation API Management – Webcast April 17th 2018 16:00 CET

API webcastJoin this webcast to meet the 3rd Generation Oracle API Platform Cloud Service. In this short session, you will learn how a sleek, intuitive full lifecycle API Platform built on Oracle’s proven gateways will improve productivity and effectiveness in your business.
Learn how you can leverage this true hybrid offering to:

  • Focus on the full API lifecycle, starting with Design & Governance, all the way through Security, Discovery & Consumption, Monetization, and Analysis, to develop APIs and create modern applications and user experiences.
  • Develop an API-First strategy to accelerate digital transformation, safely extend the reach of intellectual property, and create new revenue streams.
  • Leverage an open, heterogeneous environment with an easy-to-use platform that is compatible with open standards
  • Best practices API management

Speakers:

clip_image002
Luis Weir

CTO Oracle DU

Capgemini UK

clip_image004

Robert Wunderlich

Oracle HQ

Director Product Management

clip_image006

Jürgen Kress

Oracle EMEA

PaaS Partner Adoption

Schedule: April 17th 16:00 CET 2018

Please register here: www.tinyurl.com/API3rdGeneration

 

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter 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

Top tweets SOA Partner Community – March 2018

image

March 2018  top tweets by soaCommunity

Send your tweets @soacommunity #PaaSCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

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

ICS Pricing – ICS Definitive Tip #9 by Phil Wilkins

image

ICS pricing is based on two aspects – the number of connections and the number of messages processed.  But what constitutes a connection?  What happens if I exceed the number of messages or connections?

Number of Connections

The overall model for ICS pricing is on page 34 of Oracle Platform as a Service and Infrastructure as a Service – Public Cloud Service Descriptions-Metered & Non-Metered. The key definition for a Hosted Connection is on Page 9 of this document.  The critical wording for the connections is:

A Connection is counted per unique application, data source, third party software, Oracle software, Web Service or REST end point to which the Oracle Integration Cloud Service is connected. SOAP or REST Web Services that have the same base URI (combination of host and port) are counted as one Connection.

So you can define for example two ICS connections (one in and one out for example, or one per operation) to the same service aslong as the basic part of the URL e.g. icsallpurpose-xxxxxx.integration.us2.oraclecloud.com  is the same. The ports will typically only become a countable to the same URL if you use different protocols e.g. HTTP, HTTPS, FTP. This simply comes down to the fact different protocols typically use different ports.  But, if I daisy chained integrations within the same ICS instance; then assuming they are all HTTPS calls they would only consume 1 connection. This is regardless of how many different connections created to provide the full path.  This is also important as when transitioning versions of end points you may need the current and previous endpoints available, which within this model would count as the same connection as typically the version identifier is in the subsequent path. Read the complete article here.

PaaS (Process & Integration) Partner Community Newsletter March 2018

Dear PaaS Partner Community,

Thanks to all attendees, presenters and trainers to make the Oracle PaaS Partner Community Forum 2018 a superb success. With 232 attendees from 40 countries and a long waiting list the conference was booked out a month in advance. Watch Amit Zavery’s community welcome briefing here. In case you could not attend in Budapest presentations and training material will become available at our community workspace (membership required)

The next series of Integrate and Extend SaaS free hands-on bootcamps are schedules for Istanbul, Utrecht and Warsaw. Registration for the April edition of the free on-demand SOA Suite 12c and BPM Suite 12c bootcamps is open here. Or attend one of the upcoming Oracle developer meetups across Europe.

API Management played a key role in Budapest as adoption is souring. Thanks for sharing the best practices on API policy versioning, tracing execution and gateway installation.

Thanks to the community for sharing all the Integration articles: Oracle PaaS – the Whole Platform Story by Ian Reed & Ed Zou & Teaching how Oracle Integration Cloud (OIC) simplifies Application Integration, Process Automation and API Management & Teaching How to Design and Secure an API with Oracle API Platform & Connect the Cloud free eBook& Teaching How to Recover Errored Instances with Oracle Integration Cloud & Integration Cloud Service (ICS) – Lets POC and get our feet wet & Provision Oracle Integration Cloud Using Stack Templates & Rubicon Red Uses Oracle Cloud to Grow Green Business & Pre-built Virtual Machine for SOA Suite 12.2.1.3.0.

BPM was a prominent theme across the PaaS Partner Community Forum. Form best practices to extend SaaS with processes, dynamic processes, joint present by UiPath and Oracle about robotics process automation, all the way to hands-on labs. Including an excellent discussion on the role of BPM in a microservices architecture. Thanks to Richard, Marcel and Marc for the next series of articles: Jarvis Pizzeria: Setting up the Dynamic Process & Jarvis Pizzeria: The logic underneath the Dynamic Process & Jarvis Pizzeria: Activating activities and attaining milestones & Jarvis Pizzeria: The various Decisions of a Decision Model & Jarvis Pizzeria: Fourth step in Implementing the Order Processing, Decision Model.

In our last innovation and architecture section blockchain continues to be a prominent topic. During the PaaS Partner Community Forum partners had the opportunity to try the cloud service hands-on. Get started listen the blockchain podcast.

For a short summery of our key monthly information watch the Fusion Middleware & PaaS Partner Updates on YouTube. The March edition highlights free on-demand training, Oracle Developer meetups and Oracle OpenWorld call for papers. . This month’s community webcast will be an update on Oracle JET, please join our monthly PaaS Partner Community Webcast – March 27th 2018.

Want to publish your best practice article & news in the next community newsletter? Please feel free to send it via Twitter @soaCommunity #PaaSCommunity!

To read the newsletter please visit www.tinyurl.com/PaaSNewsMarch2018 (OPN Account required)

Please like and share the newsletter at Twitter and LinkedIn

 

Jürgen Kress

Fusion Middleware Partner Adoption
Oracle EMEA
Tel. +49 89 1430 1479
E-Mail: juergen.kress@oracle.com
clip_image003Blog clip_image004LinkedIn clip_image005 Twitter

To become a member of the SOA Partner Community please register at http://www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Newsletter Logo 2017

Blog Twitter LinkedIn image[7][2][2][2] Facebook

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

Building an Oracle Integration Cloud Service Integration in 2 Minutes by Robert van Molken and ACE Associate Phil Wilkins

image

Oracle ACE Robert van Molken and ACE Associate Phil Wilkins, authors of "Implementing Oracle Integration Cloud Service," (2017, Packt Publishing) demonstrate how to create an OICS integration in just 2 minutes. Watch the video here.