Understanding Mapping Optional Elements in OIC Integration by Jan Kettenis

image

There are some easy to make mistakes to make when mapping messages with optional elements in OIC Integrations. This article describes how optional elements are being handled, and a way to make this work the way you want.
OIC Integration handles optional elements the same for both XML as well as JSON based elements, including mapping from XML to JSON and vise verse. The reason being that internally OIC will map JSON to XML. The examples hereafter therefore are based on XML. I will discuss the examples on the following XSD that is used in an integration that maps all elements 1:1 and echoes the result back. 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

Build Your First Integration free on-demand training

image

Learn how to build integrations that connect your cloud, on-premises, and SaaS applications in Oracle Integration. Discover the basics of defining connections and integrations. Use the mapper to move data between applications. Then, activate and monitor your integration.

Before You Begin: Get what you need: access to Oracle Integration, sign-in credentials, and some exploration skills.

In this learning path, you’ll build connections, define triggers and invokes, and map data between your applications to create your first integration in Oracle Integration.

Get Access to Oracle Integration: To complete this learning path, you need:

 

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

Integrate SaaS hands-on Bootcamps in Bangalore, Reading, Reston, Chicago and as a Virtual Class

image

Do you want to find out why Gartner named Oracle as a Leader in Magic Quadrant for three years in row? Are you able to innovate quickly in the new digital world? Are you looking for ways to integrate systems and data faster using a modern cloud integration platform? Attend the Oracle Integration Bootcamp, a three days hands-on training for Oracle partners!

Oracle Product Management is pleased to invite Oracle Partners to attend a 3-days 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.

Locations:

· Bangalore, India September 23rd-25th 2019

· Reading UK October 9th-11th 2019

· Virtual web training November 4th-6th 2019

· Reston, USA November 5th-7th 2019

· Chicago, USA December 17th-19th 2019

For additional location please visit our website 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

What is the Value of Robotic Process Automation in the Process Automation Space? by Eduardo Chiocconi

image

During the last two decades, much of the Process Automation efforts concentrated on using Business Process Management Systems (BPMS) as a means to document and digitize business processes. This technology wave helped the Process Automation space make a significant step forward. BPMS tools armed with Integration capabilities allowed organizations (and their business and IT stakeholders) visualize the processes they wanted to automate. From this initial business process documentation phase, it was possible to create a manageable digital asset to help “orchestrate” all business process steps regardless of its nature (people and systems). Without risking to exaggerate, most of Process Automation (or Business Process Management) practitioners would agree, that one of the hardest implementation areas is integrating with systems of information that the business process needs to transact with. BPMS vendors offered a wide array of application integration capabilities, usually in the form of application adapters, to integrate with these Enterprise and Productivity Applications. As more systems needed to be integrated from the business process, the hardest the implementation phase became. As much as we would like for Applications to enable all transactions via publicly available APIs, this is not the case and limits what integration service capabilities can do to integrate in an automated and headless manner.

Simplification in the integration space helps!

New Enterprise and Productivity Applications have started to really invest early in Application Programming Interfaces (API). REST based Web Services as an implementation mechanism and an API-First approach to offer Application functionality, certainly offered a simpler consumption of Application functionality and by transition it simplified the Process Automation implementation projects “hardest” last mile: integration. Integration vendors can leverage these APIs and offer a direct and easy way to transact against these Applications.

But is this not well enough?

Well… if your business processes create logic around new SaaS Applications you may be lucky. But for many organizations (and specially those that have gone the path of merger and acquisitions) it is not. Whether we like it or not, there are still many systems that are very hard to transact or interact with. This category of Applications include mainframe systems and homegrown to Enterprise Applications. But also, any kind of application that has gone some kind of customization where this functionality is only available through the application user interface (UI).

Robotic Process Automation (RPA): The new kid on the block!

What exactly is Robotic Process Automation? These questions may have many different answers. But to me, RPA offers a new mechanism to integrate and transact against Applications using the same UI that their users use. And via this non intrusive approach, it is possible to interact with the application as if it would be done by an person, but rather than a person doing the clicks and entering data, it is an automated application that we call a robot. Period!

Why do we talk about RPA in the context of Process Automation?

My first observation is that these two technologies are not the same. Secondly, that if you combine them to work together, it is possible to take Process Automation to the next level as RPA offers new ways to integrate with systems of record that could not be integrated before. The simplicity of the way in which it transacts with Applications also offers a first step of automation while a more robust and throughput optimal adapter or API approach is used. 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 SOA 12c Principles SOA Dehydration stores – Useful SQL Queries by Sanae BEKKAR

image

I share my main returns as part of a client request to extract the payloads of the instances in a given time interval, with payloads of instances in CLOB format. It’s an opportunity to explore the main SOA dehydration stores and queries the most used in 12c, and share them with you for such requests, I hope it will be useful,

I. Description  of the principal’s tables  used

Below mentioned tables are the important ones that will be used to locate the instances.

CUBE_INSTANCE
COMPOSITE_INSTANCE
SCA_SENSOR_VALUE

COMPOSITE_INSTANCE

Below are the important columns in composite instance tables.

ECID: Unique values for one end-to-end transactions across several tables.
ID: Instance ID that is visible in Enterprise Manager Console
PARENT_ID: This will be null for initiator composite and child composite will have the value of parent composite
COMPOSITE_DN: Composite name along with partition name
STATE: State of the instance like completed, running etc which is explained in details
CREATED_TIME: Creation time of an instance

List of states and its description: 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

Integration Insider Guide to Oracle OpenWorld’19

clip_image002Oracle OpenWorld 2019 is just around the corner. We look forward to seeing you in San Francisco from September 16-19, 2019. Whether you are looking to learn about Oracle’s latest technologies, product roadmaps, customer implementations, get hands-on learning, dive into product demonstrations and/or networking with your peers, we are confident that this year’s conference will not disappoint!

Thanks for spending the week with Oracle. 

Good trip to San Francisco

Jürgen Kress

 

Cloud Platform and Middleware Strategy and Roadmap with Edward Screven Tuesday 12:30- 1:15 p.m YBCA Theater

Conversational AI for Enterprise Apps with a Chatbot Assistant  with Suhas Uliyar

Tuesday 1:45-02:30 p.m.´ Moscone South – Room 209

 

PaaS Focus on Docs: Guide your customers to sessions most relevant to THEIR cloud journey.

· Oracle Integration

· Oracle Cloud Platform for Oracle SaaS

· Oracle Digital Assistant

· Oracle Content and Experience

·  Visual Builder Cloud Service

 

PRO5871 – Oracle Integration Strategy & Roadmap – Launch Your Digital Transformation

Monday, September 16, 12:15 PM – 01:00 PM | Moscone South – Room 156C

Join this session to hear exciting innovations coming to Oracle Integration. See a live demonstration of next-generation machine learning (ML) integration enhancements and robotic process automation, all seamlessly connected into a hybrid SaaS and an on-premise integration. Learn how customer Vertiv successfully delivered its digital transformation with Oracle Integration Cloud by connecting Microsoft Dynamics CRM, Oracle E-Business Suite, Oracle PRM, Oracle ERP Cloud, and Oracle HCM Cloud for real time collaboration and faster business agility. Jumpstart your future today.

PRO5873 – Oracle Integration Roadmap

Wednesday, September 18, 12:30 PM – 01:15 PM | Moscone South – Room 156B

In this session explore the product roadmap for Oracle Integration including new and exciting initiatives such as AI/ML-based capabilities for recommending best next actions for integration and process, intelligent recommendations on mappings, a new UI with recipes for integration and process, anomaly detection, and enhanced connectivity to Oracle and third-party apps. This session also covers new process automation capabilities such as robotic process automation adapter (RPA-UiPath) and ML-driven case management process execution.

CAS2657 – Compliance and Risk Management Realized with Analytics and Integration Services

Monday, September 16, 10:00 AM – 10:45 AM | Moscone South – Room 155B

In modern global companies it is important to make sure that customers, suppliers, and (prospective) employees are not on a sanction list. Of course, this can be checked manually at onboarding, but what if a relation is added to a list after onboarding, while you are in business with them? Skanska and eProseed built a solution that fetches data from source systems and matches them with data from the Dow Jones Watchlist. This is done daily, minimizing the risk and increasing efficiency through automation. In this session see the solution and learn about the benefits of this cloud solution for Skanska, as well as the lessons learned.

PRO5805 – Oracle Integration: Monitoring and Business Analytics on Autopilot

Wednesday, September 18, 04:45 PM – 05:30 PM | Moscone South – Room 156B

Ever wondered how the crucial connections and processes in your environment are behaving? In this session learn to monitor and track your integrations and processes in real time. It is not enough to know things are running smoothly; business analytics are driving the evolution and growth of every industry as never before. Today’s competitive markets demand that stakeholders be able to understand, monitor, and react to changing market conditions in real time, and business owners require more control and expect more visibility over their processes. This session showcases how operational monitoring empowers IT while integration insight empowers executives with real-time insight into their business process, allowing IT and executives to take immediate action.

Hands on Labs

If you want to do more than listen to presentations and get your hands on Oracle Integration, sign up for one of our two Hands on Labs:

HOL6041 and HOL6043 – Connect Applications, Automate Processes, Gain Insight with Oracle Integration

Monday, September 16, 08:30 AM – 09:30 AM | Moscone West – Room 3022A and

Wednesday, September 18, 09:00 AM – 10:00 AM | Moscone West – Room 3022A

These 2 hands on labs provide a unique opportunity to experience Oracle Integration. Learn how to enhance process and connectivity capabilities of CX, ERP, and HCM applications with Oracle Integration Cloud. Create a forms-driven process to extend existing applications, discover how to synchronize data by integrating with other applications, and learn how to collect business metrics from processes and integrations and collate it into a dashboard that can be presented to business owners and executives. This session explores the power of having a single integrated solution for process, integration, and real-time dashboards delivered by Oracle Integration. Discover how the solution provides business insight by collecting and collating business metrics from your processes and integrations and presents them to your business owners and executives.

Demos

In between sessions, you should consider a stroll to The Exchange in Moscone South at the Exhibition Level (Hall ABC) and stop by our demo pods to see to see real world examples of how Oracle Integration future proofs your digital journey with pre-built application adapters, simple and complex integration recipes, and process templates. Stop by to discuss how integration is more than connecting applications, it is also about extending applications in a minimally invasive fashion. Visit us to see how to gain visual business insight from your integration flows.

Oracle Integration Product Management and Engineering will be there to answer your questions and brainstorm about your integration use cases.

We have 2 demo pods at The Exchange:

INT-008 – Connect Applications, Automate Processes and RPA Digital Workforce, Gain Insight

INT-002 – Leverage Oracle Integration to Bring Operations and Business Insight Together

And an additional demo pod at Moscone West – Level 2 (Applications)

ADM-003 – Connect Cloud and on-prem Applications with Adapters, B2B, MFT, SOA and hybrid solutions

Oracle Integration and Digital Assistant Customer Summit

Last, but not least, there is still time to register for the Oracle Integration and Digital Assistant Customer Summit on 19-September-19 at the W Hotel San Francisco, followed by our Customer Appreciation Dinner.
For more information, visit You’re Invited: Oracle Integration and Digital Assistant Customer Summit at Oracle OpenWorld 2019

 

Quick Links: Everything you need to navigate OOW’19!

·       OOW’19 Homepage

·       OOW’19 Session Catalog

 

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

Trigger OIC Integration Using OAuth by Greg Mally

image

As businesses move to the cloud there is a high demand for securing/protecting their HTTP resources from unauthorized access. There are several approaches to protecting these resources which include SAML for SOAP service, OAuth for REST services, HTTP basic for both, and sometimes home grown proprietary mechanisms. It may not be widely known yet, but all Oracle Integration Cloud (OIC) REST endpoints are OAuth protected and can be triggered from a client using OAuth 2.0 (August 2018 – https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/WhatsNew.html). Although there is online Oracle documentation that detail OAuth configuration on Oracle’s Identity Cloud Service (IDCS) as well as the aforementioned OIC What’s New link, the docs can be confusing especially if you have never used OAuth before. Therefore, this blog will demonstrate what is necessary for a client (in this example, Postman) can successfully trigger an OIC REST-based integration. 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

Upgrade on premise ICS agent by Ankur Jain

image

In one of my article, I have showcased how to install the on-premise agent on the Linux machine. This article will show you how to upgrade the existing on-premise agent. In this blog, we are upgrading the agent from 18.1.3.0.0 to 18.4.3.0.1 Below are the steps to upgrade the on-premise agent

  • Login into the ICS console and move to the Designer -> Agents page
  • Click on the Download -> Connectivity Agent
  • A file will be downloaded with name ics_conn_agent_installer_181022.0000.1074.zip
  • Move the file on the server where the agent in up and running. In our case, we have moved the file to /home/AgentPatch/
  • Unzip the installer and notice below files:

 

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

Working with Create Error Activity by Carli Gray

image

Want the ability to add an Create Error activity at any point in the execution of an integration flow?  Now you can.  You will need to enable "oic.ics.console.integration.throw-action" feature flag to enjoy this feature.

· Create or Edit an Integration

· Drag the ‘Create Error’ action

· Notice the gray plus icons that appear over the connector lines

· The error can be Dropped on any of those plus icons

· Once dropped enter a Name and Description (optional) for the error

· 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

Poll File from Agent server leveraging File Adapter: Integration Cloud by Ankur Jain

image

Oracle Integration Cloud provides a File adapter to deal with the files which reside on the local server. File adapter allows following operations on an on-premise location, using Integration Cloud connectivity agent:

  • File polling
  • Write

The in and out directories should be locally accessible from the server where ICS connectivity agent is installed. Refer the blog to understand the difference between File and FTP adapter. Use Case: For the particular article, we’ll leverage the File adapter to poll the file from the server where connectivity agent is installed and transfer the file on FTP server. Let’s get started and see how to achieve the use case

 

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