OSB 12c – Database Polling using DB adapter by Vivek Garg

 

clip_image001Oracle introduced couple of new features in 12c version which is recently launched. For OSB, the major shift that we saw in 12c is that now we can use Jdeveloper to do the development which we use to do through OEPE (Eclipse). With that change, we can leverage the existing technology adapter in OSB as well which we use to have in SOA. In OSB 11g version, in case of Database interaction, we use to create DB adapter in Jdeveloper and later import all required files to OEPE and generate required services from that, but in this new version-12c as we development in Jdeveloper itself so we need not to follow same steps again, we can add the DB adapter directly in OSB project and do required operations.

In this post, we show you how to use DB adapter in OSB project. For that we have created a table in database, we poll the data from that table and write that information to one file.

First of all we need to create a new OSB project, so first create a new project and then in composite.xml file, right click on proxy service lane, choose “Insert Adapters” and select Database to add DB adapter.

Provide name to adapter and click on next. In next window, choose DB connection (In our case it is local as we read the data from local table) and click on browse button to select the outbound connection pool created earlier for DB adapter. 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

OSB 12c – Pipeline Template by Vivek Garg

 

clip_image002As we know Oracle SOA 12c comes with lot of new features, one of that is service bus is merged with SOA Suite i.e. we need not to use separate IDE to build service bus projects. In 12c we use Jdeveloper to build service bus projects.

In previous post we discuss about SOA templates which helps to improve developer productivity, similarly in service bus we have pipeline template. We will discuss about pipeline template in this post, we see how to create pipeline template and how to use pipeline template.

A pipeline template depicts the general message flow and we can generate concrete message flow using this pipeline template.

One point which we need to keep in mind that we cannot create a pipeline template in Oracle Service Bus Console.

How to create pipeline template

Now we see how to create pipeline template from Jdeveloper. To create pipeline template, create a new project and choose “Service Bus project” option. Also provide the project name and click on finish. 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

SOA 12c – Managed File Transfer Hands On by Vivek Garg

 

clip_image002MFT (Managed File Transfer) is out of box functionality introduced in Oracle SOA 12c. By using MFT we can securely exchange the files between two internal or external points. In this post, we will see how to transfer one sample file from one local folder to another local folder. You can also transfer the file to any other point like FTP, SFTP etc but for simplicity we took local folders.

et’s start with the exercise, first open the MFT console by going to (http://host:port/mftconsole) link. You will see below screen, at the top you can see three links. Design link is used by developer to do define required parameters to transfer the file. Monitoring link is used to monitor the file transfer and administration link is used for administration purpose.

Click on Design link and now we define the source parameters where we place the sample file and MFT pick it from here. As mentioned earlier we are using local folder for source so we give source a name and choose “File” from drop down list. You also need to specify folder path. 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

SOA 12c Service Bus Resequencer by Vivek Garg

clip_image002We often come under such situation when we receive message from source system which are not in proper sequence but target system need to receive that in proper sequence. To resolve this we need to re-sequence the messages and process them in proper sequence.   Re-sequencing is term used when we need to process incoming messages in sequence which are not coming in proper sequence. Design and developer need to think on this re-sequencing when they encounter such requirement as e described above. E.g. suppose we are receiving sales orders from source system, sales order contain one field with the name sales order number, suppose source system sends sales order in this sequence ( 1, 4,3,2,5,6,7 ) but target system need sales order in this sequence (1,2,3,4,5,6,7) , in this case we need to do re-sequencing of message.

In 11g version of Oracle SOA Suite, re-sequencing was there in Mediator component but this feature was not available for BPEL and Service Bus. In 12c release, this feature is provided for service bus. We can set this feature either at pipeline level or at operation level. In this post, we will discuss on that. We will only discuss about pipeline level re-sequencer.

We have three types of re-sequencing in Service Bus.

Standard:  This sequencer is used when incoming message contain numeric identifier.  This numeric identifier is termed as Sequence Id. We may specify message Group also, that means incoming order can be Sales Order or purchase order, in this case we will have separate group for both Sales Order and purchase order. When source system send out of order messages then it store out-of-order message until complete order is received this is based on sequence Id.

FIFO: This sequencer works based on message arrival time. Whichever message received first, will be processed first. Here you need to specify only Group. So all the messages which are there in one group processed based on message receive time.

Best Effort: It is used when we receive large number of messages in a short period of time and cannot provide information to the re-sequencer about the identifier to use for sequencing. Typically, the identifier used for sequencing in such scenarios is of a dateTime type or numeric type.

To configure re-sequencer in service bus, double click on the pipeline and choose configuration tab. Click on resequencer, to enable the resequencer check the “Enable Resequencer” checkbox. Once you enable the resequencer, you need to choose the resequencer level. Resequencer level can be set either pipeline or operation. Also choose the type of resequencer which you need to use.

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

SOA 12c Encryption and Decryption of Sensitive Data By Vivek Garg

clip_image002Oracle SOA Suite is used for reliable transfer of information, it stores whole the message in SOA_INFRA schema. We can see incoming and outgoing messages in audit trail from EM console. That means user which has access to EM console can see all the messages coming and going through middleware, sometimes some of the information which is flowing through Oracle SOA Suite is very critical and SOA Suite user should not have access to see that critical piece of information. In this post we will discuss how to fulfill this requirement using Oracle SOA Suite.

In previous version of Oracle SOA Suite (11g) there were no out of box provision to encrypt and decrypt sensitive data so that user can’t see the data which is flowing through fusion but in current version of Oracle SOA Suite which is 12c, Oracle provided out of box functionality to encrypt specific fields in the message which is flowing through middleware. Below is sample encrypted message field.

In Oracle SOA 12c, encryption policy is used to encrypt and decrypt the message, message encryption happens at component binding that means message get encrypted before it come to component (BPEL or Mediator) and we see only encrypted message in audit trail. Message decryption happens at reference binding level that means message fields get decrypted before it is sent to target service/system. 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

SOA12c -Service Bus Resequencer by Vivek Garg

clip_image002We often come under such situation when we receive message from source system which are not in proper sequence but target system need to receive that in proper sequence. To resolve this we need to re-sequence the messages and process them in proper sequence.   Re-sequencing is term used when we need to process incoming messages in sequence which are not coming in proper sequence. Design and developer need to think on this re-sequencing when they encounter such requirement as e described above. E.g. suppose we are receiving sales orders from source system, sales order contain one field with the name sales order number, suppose source system sends sales order in this sequence ( 1, 4,3,2,5,6,7 ) but target system need sales order in this sequence (1,2,3,4,5,6,7) , in this case we need to do re-sequencing of message.

In 11g version of Oracle SOA Suite, re-sequencing was there in Mediator component but this feature was not available for BPEL and Service Bus. In 12c release, this feature is provided for service bus. We can set this feature either at pipeline level or at operation level. In this post, we will discuss on that. We will only discuss about pipeline level re-sequencer. 

We have three types of re-sequencing in Service Bus.

Standard:  This sequencer is used when incoming message contain numeric identifier.  This numeric identifier is termed as Sequence Id. We may specify message Group also, that means incoming order can be Sales Order or purchase order, in this case we will have separate group for both Sales Order and purchase order. When source system send out of order messages then it store out-of-order message until complete order is received this is based on sequence Id.

FIFO: This sequencer works based on message arrival time. Whichever message received first, will be processed first. Here you need to specify only Group. So all the messages which are there in one group processed based on message receive time.

Best Effort: It is used when we receive large number of messages in a short period of time and cannot provide information to the re-sequencer about the identifier to use for sequencing. Typically, the identifier used for sequencing in such scenarios is of a dateTime type or numeric type.

– See more at: http://www.soawork.com/2014/09/soa12c-service-bus-resequencer.html#sthash.CJJjVYly.dpuf

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

SOA 12c blog series by Vivek Garg

Special thanks to Vivek Garg for all his SOA Suite 12c blog posts! Make sure you share yours with us via twitter @soacommunity or #soacommunity or Facebook! Please visit his Oracle Fusion Middleware Blog and read his great articles:

clip_image002SOA12c -Service Bus Resequencer

SOA 12c – Translate Activity

SOA 12c – Create Service Bus Project from Service …

SOA 12c – Custom Activity Template

SOA 12c – Component Template

SOA12c – Project Template

SOA12c – Templates

SOA 12c – MDS Support For OSB

SOA 12c – How to publish service bus artifacts to …

SOA 12c – Custom Coherence Cache Name

SOA 12c – Coherence Default Cache Name

SOA 12c- Coherence Adapter

SOA 12c – Create Java derby database data source

SOA 12c- Unable to start jdeveloper – org.netbeans…

SOA 12c – Configure Coherence Adapter

Oracle BAM interview questions and answers series

Oracle Service Bus (OSB) Interview Questions and A…

Oracle SOA Interview Questions and Answers Series

Oracle BAM Interview Questions and Answers Part-2

Oracle BAM Interview Questions and Answers Part-1

Oracle SOA Interview Questions and Answers (Adapte…

SOA 12c – Schedule Secured SOA Composite from ESS

SOA 12c- Schedule SOA Composite Using ESS

Oracle Managed File Transfer (MFT) Step By Step In…

SOA 12c- Create required schemas for Oracle MFT

SOA 12c- Oracle Managed File Transfer (MFT) Instal…

Oracle SOA 12c Step By Step Installation Series

SOA 12c – Create soa 12c server domain

SOA 12c – Create Weblogic server compact domain

SOA 12c – Create Integrated Weblogic Server Standa…

SOA 12c – Create Integrated weblogic server defaul…

SOA12c – RCU Step by Step Installation

SOA12c – Oracle XE 11g Database step by step Insta…

SOA12c- Enterprise Service Scheduler Introduction

SOA12c – Share Artifacts using SOA Design-Time MDS…

SOA 12c – Get Started With MDS

SOA 12c – Create Java Derby Database Connection

Oracle SOA 12c Features

SOA 12c – Oracle Service Bus Hands On

SOA 12c – SOA Debugger in Oracle SOA 12c

SOA 12c – oracle.fabric.permission.CompositePermis…

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

SOA Suite 12c article series by Vivek Garg

Thanks to Vivek for all his blog posts about SOA Suite 12c:

Thanks to Vivek for all his blog posts about SOA Suite 12c:

With the release of Oracle SOA 12c, Oracle introduces SOA Debugger in Jdeveloper which helps developer to test and debug the composite. This makes developer life really easy. Earlier in 11g we follow below development cycle.

  • Build code in Jdeveloper
  • Deploy it to Server
  • Test it in EM console and debug it using flow traces

If we see any issue with the code then again we have to repeat above steps. But with the introduction of SOA Debugger development cycle got reduced as trouble shooting environment is provided with in Jdeveloper only. We can add breakpoints in the code and troubleshoot it in debug mode. During debugging you can also change value of the variable or xml element. In this post, I will show how this SOA Debugger works. We will use HelloWorld sample which we built in previous post. Follow below steps to debug your composite using SOA Debugger. First we need to start the debugger if already not started. You can start the debugger in two ways. Either by right-clicking composite file and click on Debug or click on red button in menu bar as highlighted in below screen shot. 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

Get started with MDS by Vivek Garg

Oracle has introduced couple of new features in Oracle SOA Suite 12c. I have listed couple of new features that Oracle introduced for developer in my post. These new features really make developers life easy as these reduce development cycle.
Here we discuss about MDS and what all featured introduced in that. As we know MDS is used to store artifacts like WSDL, XSD, XSLT etc. we have two types of MDS, File based MDS and DB based MDS. In Oracle SOA 12c, when we use default server which is integrated with Jdeveloper then we can use only Design Time MDS (File Based MDS), Run Time MDS (DB Based MDS) is not supported. Check this post to create design time MDS connection. In Oracle SOA 12c release, Oracle provided couple of new options that we can use when we use Design Time MDS, these options were not there in 11g. Below are options available with Design Time MDS. vivek

  • Create and Delete folders
  • Export and Import MDS artifacts
  • Transfer Artifacts between MDS repositories

In this post, we discussed these options one by one. Get started with Oracle SOA 12c.
Create and Delete Folders
We can simple add and remove folders from design time MDS repository. To add a new folder to it, simply right click on the apps folder and choose “Create Folder”. 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