Make Orchestration Better with RPA by Eduardo Chiocconi

image

 

Nobody can deny, that when used correctly, RPA has the potential of providing a great ROI. Specially in situations where we are trying to automate manual no value added tasks as well as used as a mechanism to integrate with systems of information that do not have headless way (for example no APIs or Adapters if you are using an integration broker tool) to interact with them.

I would like to start this article with a simple example. Imagine for a second, an approval business process where a Statement of Work (SOW) needs to be approved by several individuals within an organization (consulting manager to properly staff project, finance manager to make sure project is viable). Once the approvals are done, the SOW should be uploaded and associated to an opportunity in this company’s CRM application (where all customer information is centrally located). At the core of this business process, there is orchestration that coordinates people approvals and should also integrate with the CRM application to upload the SOW to the customer opportunity. The diagram below illustrates the happy path of this orchestration using BPMN as the modeling notation to map this business process (screenshot from Oracle Integration Cloud – Process).

Process Automation tools can easily manage the human factor of these orchestrations. Different tools manage integration to applications differently. Depending on the integrated system, the task of transacting against this system may be simple, complex and at times not possible at all. If we take a closer look at the step in which we need to upload the SOW document to the opportunity, then we have the following options:

Option a) If the CRM application has an API that allows uploading documents and link it directly to an opportunity, then this transaction can be invoked from the orchestrating business process and automated in a headless manner. When available, this is the preferred way as it is more scalable and it does not come with the overhead of transacting via the application User Interface. Read the complete article here.

 

PaaS Partner Community

For regular information on Oracle PaaS 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.

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 18c Certification for Fusion Middleware 12c Release 2 by Dirk Nachbar

image

Since a few days the Certification Matrix for Oracle Fusion Middleware 12c Release 2 (12.2.1.x) was updated within Oracle Technology Network, now Oracle 18c (18.1 on Exadata and 18.3 on On-Premise) is certified and supported as Target Database for RCU (Repository Creation Utility and as Application Datasource. Certification Matrix for Fusion Middleware 12.2.1.2.0

Read the complete article here.

 

PaaS Partner Community

For regular information on Oracle PaaS 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.

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 query your JMS over AQ Queues by Martien van den Akker

image

At my current customer we use queues a lot. They’re JMS queues, but in stead of Weblogic JMS, they’re served by the Oracle database.

This is not new, in fact the Oracle database supports this since 8i through Advanced Queueing. Advanced Queueing is Oracle’s Queueing implementation based on tables and views. That means you can query the queue table to get to the content of the queue. But you might know this already.

What I find few people know is that you shouldn’t query the queue table directly but the accompanying AQ$ view instead. So, if your queue table is called MY_QUEUE_TAB, then you should query AQ$MY_QUEUE_TAB. So simply prefix the table name with  AQ$. Why? The AQ$ view is created automatically for you and joins the queue table with accompanying IOT tables to give you a proper and convenient representation of the state, subscriptions and other info of the messages. It is actually the supported wat of query the queue tables.

A JMS queue in AQ is implemented by creating them in queue tables based on the Oracle type
sys.aq$_jms_text_message type.

That is in fact a quite complex type definition that implements common JMS Text Message based queues. There are a few other types to support other JMS message types. But let’s leave that.

Although the payload of the queue table is a complex type, you can get to its attributes in the query using the dot notation. But for that it is mandatory to have a table shortname and prefix the view columns with the table shortname. Read the complete article here.

 

PaaS Partner Community

For regular information on Oracle PaaS 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.

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

Invite your customers to attend the the Oracle Integration and Digital Assistant Customer Summit @ #OOW19 – in San Francisco, Thursday, September 19th, 2019

imageCalling all Oracle Integration and Digital Assistant Customers:

We are very excited to invite you to this all-inclusive event highlighting Oracle Integration, Process Automation and Robotics, Digital Assistant, Visual Builder, Integration Analytics, SOA Suite and SOA Cloud Service, Managed File Transfer, B2B, and related products and components.

Why Join Us? Preview of coming attractions:

  • Where We’re Going: Product updates and roadmaps. Compass not required.
  • Customers First 101: Your experience. Your business. Your world.
  • What’s On Your Mind: Give us your feedback. We’re listening.
  • Don’t Go It Alone: Network with other customers. Share and collaborate.
  • One-on-One: Interact with Oracle Engineering and Product Management.

Mix & Mingle. Extend the day into the night with our Customer Appreciation Event. Food and fun, beverages and bonuses! An exclusive event open only to customers of Oracle Integration and Digital Assistant.

In case you are an Oracle Partner please attend the Application Integration Partner Advisory Council.

 

Thursday, September  19th, 2019

San Francisco USA

For details please visit the registration page here.

PaaS Partner Community

For regular information on Oracle PaaS 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.

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

SOA Cloud Service – PaaS Partner Community Webcast August 27th 2019

image

Attend our August edition of the PaaS Partner Community Webcast live on August 27th 2019

SOA Cloud Service Comprehensive Integration and Analytics in the Cloud

SOA Cloud Service provides an integration platform as a service (iPaaS) so that you can quickly provision your new platform, start developing and deploying your APIs and integration projects and provide real-time analytics as you transition to Digital Business. For details please visit the website here.

Presenter: Robert Wunderlich, Director Product Management

ID 8000524 password 277084image

UK: +44 (0) 208 118 1001 & United States: +1 40 877 440 73

Schedule: Tuesday August 27th 2019 16:30-17:30 CET.

Attend the Webcast

Take the opportunity to watch our community webcasts on-demand:

· PaaS Overview Webcast

· Process Cloud Service Update

· Integrate ERP Cloud

· Integrate HCM Cloud

· Functions and Cloud Native

· Cloud trials & community update

· Oracle Integration Cloud Update

· Oracle OpenWorld 2018 Preview

· Innovate, Extend and Integrate SaaS Overview and Pricing

· Robotic Process Automation

· Autonomous Mobile Cloud

· PaaS Overview Webcast

· Blockchain

· API Platform Cloud Service part 2

· 3rd Generation API Gateways part1

· Oracle JET

· Oracle Visual Builder Cloud Service

· Container Native Application Development Platform

For the latest information please visit Community Updates Wiki page (Community membership required).

 

PaaS Partner Community

For regular information on Oracle PaaS 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.

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 ANT to investigate JCA adapters by Martien van den Akker

image

My current customer has a SOA Suite implementation dating from the 10g era. They use many queues (JMS serves by AQ) to decouple services, which is in essence a good idea.

However, there are quite a load of them. Many composites have several adapter specifications that use the same queue, but with different message selectors. But also over composites queues are shared.

There are a few composites with ship loads of .jca files. You would like to replace those with a generic adapter specification, but you might risk eating messages from other composites. This screendump is an anonymised of one of those, that actually still does not show every adapter. They’re all jms adapter specs actually. Read the complete article here.

 

PaaS Partner Community

For regular information on Oracle PaaS 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.

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

PaaS Partner YouTube Update August 2019

The August edition of the PaaS Partner Update contains three topics:

• Certifications and trainings for Partners

• Oracle OpenWorld tips

• SOA Cloud Service Webcast

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).

PaaS Partner Community

For regular information on Oracle PaaS 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.

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: YouTube,SOA Community,Oracle SOA,Oracle BPM,Jürgen Kress,Middleware Update,Partner Update

The Power of High Availability Connectivity Agent by Antony Reynolds

image

High Availability with Oracle Integration Connectivity Agent

You want your systems to be resilient to failure and within Integration Cloud Oracle take care to ensure that there is always redundancy in the cloud based components to enable your integrations to continue to run despite potential failures of hardware or software.  However the connectivity agent was a singleton until recently.  That is no longer the case and you can now run more than one agent in an agent group.

Of Connections, Agent Groups & Agents

An agent is a software component installed on your local system that "phones home" to Integration Cloud to allow message transfer between cloud and local systems without opening any firewalls.  Agents are assigned to agent groups which are logical groupings of agents.  A connection may make use of an agent group to gain access to local resources.

The feature flag oic.adapter.connectivity-agent.ha allows two agents per agent group.  This provides an HA solution for the agent, if one agent fails the other continues to process messages.

Agent Networking

Agents require access to Integration Cloud using HTTPS, note that the agent may need to use a proxy to access Integration Cloud.  This allows them to check for messages to be delivered from the cloud to local systems or vice versa.  When using multiple agents in an agent group it is important that all agents in the group can access the same resources across the network.  Failure to do this can cause unexpected failure of messages. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS 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.

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

Difference between File and FTP adapter in Oracle Integration Cloud by Ankur Jain

image

There are two inbuilt adapters offered by Oracle Integration Cloud. One is File and another one is FTP. Users often confused when to use File and when to use FTP adapter and what is the actual difference between these two adapters. The common idea behind these two adapters is to handle File-based processing in the integrations. We are writing this post to describe what is the actual difference between these two adapters? Read the complete article here.

 

PaaS Partner Community

For regular information on Oracle PaaS 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.

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

First steps with Oracle Self Service Integration Cloud by Lucas Jellema

image

An important part of enabling optimal use of SaaS applications is integrating various functions in said applications. Events in one application need to have an effect in others. From simple practical matters such as “send  an email when a specific type of file was uploaded into a certain Dropbox or OneDrive folder” or “Update a Google Document when a IRA issue is created” to more profound actions as “When a new lead is added to Oracle Sales Cloud, a new message is posted in a Slack channel” or “When an Eloqua Account is added, create same account Oracle Sales Cloud.”

Oracle Self Service Integration Cloud provides a framework for periodically polling a wide range of business applications out of the box as well as any application you add yourself (as long as the application can be polled through calls to a REST API). Any records retrieved in a polling action can be used to trigger actions in other applications. SSI can perform some logic (filter, loop, conditional execution as well as some calculation and conversion) and create a request message to send to a target application. Many recipes are available out of the box, and more can easily be created for all know business applications as well as for those we add ourselves.

Note that SSI will be the foundation for a new Custom Adapter development kit for Oracle Integration Cloud; apparently this it will support a low code, graphical experience with drag and drop for easy creation of adapters.

In this article a few first impressions with SSI.

Step 1: provision an SSI instance

From the Cloud Dashboard, I have opened the Service Console for SSI. Here I have selected the option to create a new instance. Read the complete article here.

 

PaaS Partner Community

For regular information on Oracle PaaS 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.

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