Get XML Document from SOA Infra table by Martien van den Akker

image

Today I’m investigating a problem in an interaction between Siebel and SOASuite. I needed to find a set of correlated messages, where BPEL expects only one message but gets 2 from Siebel.

To get all the messages that are related to two flows that run parallel based on the same message exchange.
The thing is that of course you want to see the contents of the message in the xml_document. This attribute is a BLOB that contains the parsed document from oracle xml classes. You need the oracle classes to serialize it to a String representation of the document. I found this nice solution from Michael Heyn.
In 12c this did not work right a way. First I had to rename the class to SOAXMLDocument, because I got a Java compilation error complaining that XMLDocument already was in use. I think it conflicts with the imported oracle.xml.parser.v2.XMLDocument class. Renaming it was the simple solution.
Another thing is that in SOA Suite 12c, the documents are apparent. 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

Deploying SOA Composites from Oracle JDeveloper to Oracle SOA in WebLogic Kubernetes Operator Environment by Ravi Pinto

image

Inputs provided by Ashageeta Rao and Vivek Raj

This post provides steps to deploy Oracle SOA composites/applications from Oracle JDeveloper (that runs outside the Kubernetes network) to the SOA instance in WebLogic Kubernetes Operator Environment.

Pre-requisities

Note: Replace entries inside <xxxx> specific to your environment

  1. Get the Kubernetes Cluster Master Address and verify the T3 port which will be used for creating application server connections. You can use below kubectl command to get the T3 port:

kubectl get service <domainUID>-<AdministrationServerName>-external -n  <namespace>-o jsonpath='{.spec.ports[0].nodePort}’

  1. JDeveloper need to access Managed Server during deployment. In WebLogic operator Environment each Managed Servers are pods and cannot be accessed directly by JDeveloper. Hence we need to configure the Managed Server’s reachability:
    1. Decide on external IP address to be used to configure access of Managed Server ( soa cluster). Master or worker node IP address can be used to configure Managed Server accessibility. In case you decide to use some other external IP address, that need to be accessible from Kubernetes Cluster. Here we will be using Kubernetes Cluster Master IP.
    2. Get the pod names of Administration and Managed Servers (i.e. "<domainUID>-<server name>") which will be used to map in /etc/hosts. 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

OIC June 2020 release UI updates by Niall Commiskey

imageThis release sees the introduction of the Oracle JET based OIC UI. It looks better and has more functionality – what more can I say? Maybe give you some idea of what is now available – For those who want more info, please see my colleague Antony’s blog post here There is also a compelling video from Ankur available here
New Menu Structure

This allows for easier navigation in OIC
Example –

Note: only the menu has been refreshed.

Net, net, the idea here is for you to be able to do your work in OIC,
with the least amount of navigation/clicking around.

Monitoring

New look and feel – 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

Integration Versioning: Oracle Integration Cloud by Ankur Jain

image

In this article, we are going to showcase the concept of Integration Versioning in Oracle Integration Cloud.

Some blogs that might help you extend your knowledge

Multiple resources with single REST: Oracle Integration

Oracle Integration Cloud Service Lookups

What is Versioning

You might be wondering what a number on software’s, integrations and applications. These numbers are called version of the applications.

For example: If we say download a 12C database. Here what 12 mean is, it is nothing, it’s just version of database. 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

OIC Feature Flag – Data Stitch by Niall Commiskey

image

Data Stitch action in Orchestration

Available to you as feature flag
(oic.ics.console.integration.stitch-action)
Available from version -All text in italics is from ORCL docs.

This is a new capability within the orchestration designer that enables customers to initialize and progressively update complex variables within integration flows. IT specialists can now use the "Global Variables" section of the designer to define new variables in the integration flow that can hold complex content and use the data stitch action to progressively populate and/or manipulate whole or parts of the document. You can simply drag and drop the "Data Stitch" action from the component palette into the canvas and graphically model the data assignments as an ordered sequence of statements to populate scalar or complex variables wholly or partially.  Designers can add multiple data stitch actions at various points in the integration flow to update existing or append new sections to previously declared and populated variables using data from various sources.

Couldn’t have said it better myself, net, net – Data Stitch allows us to create and manipulate complex variables within an integration orchestration. This was something missing in OIC, for those coming from SOA Suite/SOA CS. 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 embed CDATA into XML: Oracle Integration Cloud by Ankur Jain

imageThere is a scenario where you are required to consume SOAP API and the API require to send CDATA as part of the request. In the article, we are going to showcase how to embed the CDATA into the XML request in Oracle Integration Cloud.

Let’s first understand what CDATA is?

A Character Data(CDATA) section contains text that will NOT be parsed by a parser. Tags inside a CDATA section will NOT be treated as markup and entities will not be expanded. The primary purpose is for including material such as XML fragments, without needing to escape all the delimiters.

Example of SOAP API having the CDATA

In the below SOAP API request, please see the “<general:BPXML>” and under this CDATA element is there. When you will consume the same into OIC, you will not see the end elements( <wrapper>, <emp>, <name>, etc. ) under CDATA in mapper. If not found in the mapper how you will send the data to SOAP request which is required. 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

A Simple Guide to Connect to a Private FTP Server using FTP adapter by Dinesh Pant

image

You can now integrate with an FTP server even when it is in private network and not accessible publicly. This is made possible with the latest feature where a Connectivity Agent can be configured to be used with the FTP adapter.

The FTP adapter supports connectivity to:

  • FTP/SFTP hosted on-premise – through a connectivity agent
  • FTP/SFTP hosted on cloud – without a connectivity agent, as before
Connection Properties:

Provide connection property values:

Enter the FTP/SFTP host address and port

If using a secure FTP server, then select Yes for ‘SFTP Connection’ else select No.

Security:

Please select one of the security policy

FTP Server Access Policy : for username/password authentication.

FTP Public Key Authentication : as the name suggests, for Public Key authentication.

FTP Multi Level Authentication : i.e, to authenticate using both username/password and public key. 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

ERP Integration using File Based Data Import: Oracle Integration by Ankur Jain

image

The Oracle ERP integration is one of the most common integration requirement in today’s world as most of the big organization is having Enterprise Resource Planning(ERP) to manage enterprise functions including accounting, financial management, project management, and procurement etc. The article is focused on the aspects which is required in order to connect Oracle ERP system with Oracle Integration Cloud (OIC) using File Based Data Import (FBDI).

For this article, we’ll consider the import of Account Receivables (AR) invoices as an example.

Some important link which might help you to extend your knowledge

Web Application in Oracle Visual Builder

Parent Child relationship in Oracle Visual Builder

Dependent/Cascading List Of Values (LOV) in VBCS

Here is the use case which we are trying to sort out here:

  • The third party application generates CSV file and keeps the data at SFTP location. The file may be large than 10 MB
  • Convert the source file into the pre-defined FBDI format and upload into the ERP
  • Once ERP completes the import job, it will send a callback to OIC to notify the status of import job. 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,

Top tweets PaaS Partner Community June 2020

imageJune top tweets by PaaSCommunity

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

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

Introducing the Box Adapter in Oracle Integration by Yogesh Sontakke, and Tuck Chang

image

As many of you might know already, at Oracle Open World (OOW) 2019 a few months ago, we announced our partnership with Box to empower our customers to connect their cloud and on-premises Oracle and third-party applications with Box via Oracle Integration (OIC). Read the announcement from OOW here.

Box offers enterprises content management as a cloud service, enabling organizations to share files, collaborate between team members, and manage the lifecycle of content securely. As a cloud service, Box can scale as its customers needs grow in size and depth of complexity including attaching custom metadata to content and watermarking content for review.

Today, we are pleased to present the availability of the Box Adapter (in preview mode), which offers bound inbound and outbound integration with Box on the Oracle Integration platform. Integration designers can now use this adapter in conjunction with the vast array of other adapters that provide connectivity to various different technologies, cloud services, and on-premise applications. 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