OSB 12c - Domain Value map (DVM)

Hey guys !

Here I am going through the Domain Value map (DVM) functionality in OSB 12c.

In the 12c versions of OSB, Support for the DVM is included, Hence lets discuss the use case and Steps to implement DVM.

Use Case 

Simple Integration  Scenarios, Where Source system, Which sends data to Target System needs domain conversion of values.

A very typical example is Country name to Country Code conversion using DVM, i.e. Source system sends Country name and Target system expects Country code.

Design

Step 1 :

Open Jdevloper 12c (Service Bus console can also be used), Create a Service Bus Project.

I have given name to project as 'SBProject_DVM'

Step 2:

Create Source and target Schemas or WSDL (This is not a essential Step). For better demonstration, I Have used WSDL.

Step 3:

Create a Domain value map (CountryName_Code.dvm) and Add the Domain Name and Values. Atleast 2 rows needs be added.

Step 4:

Create a XSLT mapper (CountryNameToCode.xsl), Choose Source and Target to this mapper from your WSDL.

Step 5 :

User mapper to drag and Drop mapping element, Shown below

Step 6:

Go to XSLT source view and Edit the code as below 

Add this snippet 

<CountryCode>          

            <xsl:value-of select="DVMFunctions:lookupValue (&quot;SBProject_DVM/CountryName_Code&quot;, &quot;Name&quot;, string(/ns0:process/ns0:CountryName), &quot;Code&quot;, &quot;Unknown&quot; )"/>

 </CountryCode>

Now if you go to Design view, the below design will be visible

Step 7:

Create a new Pipeline Based on your WSDL and go to design view.

Add Pipeline pair to it, 

Inside Request Pipeline add a Stage. Inside stage add a 'Replace' action.

Inside Response Pipeline add a Reply action with Success.

Step 8:

Lets go to Replace action and use the Earlier created XSLT mapper to do the DVM  task.

In the input Field add the Variable which contains input element, as below

Step 9:

Save your changes and Export is to deploy to Test Server or Deploy directly from Jdeveloper.

Testing 

Step 1:

Open the Pipeline, click on test button, this will open in new window

Step 2:

Edit the request payload and click on Execute button to test it.

Voila !

You have successfully created DVM using OSB 12c

You can download the sbconfig jar of this project from
https://drive.google.com/file/d/0BxHj0h0tnxxOWWVYVXVvTGtWUGs/view?usp=sharing

Here are some other posts, which may interests you

1. Fusion Middleware 12c – SAP Adapter Configuration

http://osb-dheeraj.blogspot.in/2016/02/fusion-middleware-12c-sap-adapter.html

2. Oracle Integration Cloud Service (ICS)

http://osb-dheeraj.blogspot.in/2016/02/oracle-integration-cloud-service-ics.html

3. SOA Interview Questions : Service Oriented Architecture Interview Questions Part 1

http://osb-dheeraj.blogspot.in/2016/02/soa-interview-questions-service.html

Oracle SOA Suite 12c - OSB Domain Configuration part 2

This post is in continuation with previous post, you can find part 1 at :

Oracle SOA Suite 12c - OSB Domain Configuration

http://osb-dheeraj.blogspot.in/2016/02/oracle-soa-suite-12c-osb-domain.html

Lets continue with domain creation steps

Step 10:

The Wizard will test each connection, if you have given correct information, then all connection will show success as below, Then Click Next

Step 11:

Click Next on the Screen,

Step 12:

On this screen select the elements, which you want to configure for your domain. For example select Admin server and Manage Server then click on Next, as shown

Step 13:

Provide Server port Number, Host Address, and SSL port, You can keep the default setting as well. Then Click Next

Step 14:

For Managed Server, Provide Name, Port, SSL Port, or keep the default settings.

Step 15:

Since we have only one Managed server, hence we do not need cluster, Click Next

Step 16:

Click next for Coherence and Coherence Cluster Screen. Click on + button to add Machine, Provide details of your machine

Step 17:

Then look the Summary of your configuration and Click Create

Step 18:

It will take some time to create the domain. The last will be the confirmation screen.

Voila ! you have successfully created your OSB 12c Domain.

In case you want to go through the steps for SOA domain, refer my previouspost here:

Oracle SOA Suite 12c - SOA Domain Configuration

http://osb-dheeraj.blogspot.in/2016/02/oracle-soa-suite-12c-soa-domain.html

Oracle SOA Suite 12c - SOA Domain Configuration part 2

This post is in continuation with my previous post, about SOA domain creation. You can find part 1 at 

Oracle SOA Suite 12c - SOA Domain Configuration

http://osb-dheeraj.blogspot.in/2016/02/oracle-soa-suite-12c-soa-domain.html

Lets Continue with the steps of domain creation:

Step 9:

Fill the DB Schema details for each of the Datasource by selecting each one by one

Once all filled, Click on Next button

Step 10:

The Wizard will test each connection, if you have given correct information, then all connection will show success as below, Then Click Next

Step 11:

Click Next on the Screen,

Step 12:

On this screen select the elements, which you want to configure for your domain. For example select Admin server and Manage Server then click on Next, as shown

Step 13:

Provide Server port Number, Host Address, and SSL port, You can keep the default setting as well. Then Click Next

Step 14:

For Managed Server, Provide Name, Port, SSL Port, or keep the default settings.

Step 15:

Since we have only one Managed server, hence we do not need cluster, Click Next

Step 16:

Click next for Coherence and Coherence Cluster Screen. Click on + button to add Machine, Provide details of your machine

Step 17:

Then look the Summary of your configuration and Click Create

Step 18:

It will take some time to create the domain. The last will be the confirmation screen.

Voila, you have successfully created your SOA Domain.

In case you want to configure OSB Doamin, refer my previous post:

Oracle SOA Suite 12c - OSB Domain Configuration

http://osb-dheeraj.blogspot.in/2016/02/oracle-soa-suite-12c-osb-domain.html

Oracle SOA Suite 12c - SOA Domain Configuration part 2

This post is in continuation with my previous post, about SOA domain creation. You can find part 1 at 

Oracle SOA Suite 12c - SOA Domain Configuration

http://osb-dheeraj.blogspot.in/2016/02/oracle-soa-suite-12c-soa-domain.html

Lets Continue with the steps of domain creation:

Step 9:

Fill the DB Schema details for each of the Datasource by selecting each one by one

Once all filled, Click on Next button

Step 10:

The Wizard will test each connection, if you have given correct information, then all connection will show success as below, Then Click Next

Step 11:

Click Next on the Screen,

Step 12:

On this screen select the elements, which you want to configure for your domain. For example select Admin server and Manage Server then click on Next, as shown

Step 13:

Provide Server port Number, Host Address, and SSL port, You can keep the default setting as well. Then Click Next

Step 14:

For Managed Server, Provide Name, Port, SSL Port, or keep the default settings.

Step 15:

Since we have only one Managed server, hence we do not need cluster, Click Next

Step 16:

Click next for Coherence and Coherence Cluster Screen. Click on + button to add Machine, Provide details of your machine

Step 17:

Then look the Summary of your configuration and Click Create

Step 18:

It will take some time to create the domain. The last will be the confirmation screen.

Voila, you have successfully created your SOA Domain.

In case you want to configure OSB Doamin, refer my previous post:

Oracle SOA Suite 12c - OSB Domain Configuration

http://osb-dheeraj.blogspot.in/2016/02/oracle-soa-suite-12c-osb-domain.html

Oracle SOA Suite 12c - OSB Domain Configuration part 2

This post is in continuation with previous post, you can find part 1 at :

Oracle SOA Suite 12c - OSB Domain Configuration

http://osb-dheeraj.blogspot.com/2016/02/oracle-soa-suite-12c-osb-domain.html

Lets continue with domain creation steps

Step 10:

The Wizard will test each connection, if you have given correct information, then all connection will show success as below, Then Click Next

Step 11:

Click Next on the Screen,

Step 12:

On this screen select the elements, which you want to configure for your domain. For example select Admin server and Manage Server then click on Next, as shown

Step 13:

Provide Server port Number, Host Address, and SSL port, You can keep the default setting as well. Then Click Next

Step 14:

For Managed Server, Provide Name, Port, SSL Port, or keep the default settings.

Step 15:

Since we have only one Managed server, hence we do not need cluster, Click Next

Step 16:

Click next for Coherence and Coherence Cluster Screen. Click on + button to add Machine, Provide details of your machine

Step 17:

Then look the Summary of your configuration and Click Create

Step 18:

It will take some time to create the domain. The last will be the confirmation screen.

Voila ! you have successfully created your OSB 12c Domain.

In case you want to go through the steps for SOA domain, refer my previouspost here:

Oracle SOA Suite 12c - SOA Domain Configuration

http://osb-dheeraj.blogspot.com/2016/02/oracle-soa-suite-12c-soa-domain.html

Oracle SOA Suite 12c - OSB Domain Configuration

Here we are going through the Steps for the creation of OSB Domain.
Since we have already Installed Oracle OSB suite 12c for Windows.

If you want to go through the Installation Steps:
Refer my Previous Blog Post at :

Oracle SOA Suite 12c 12.2.1 - Installation for Windows

http://osb-dheeraj.blogspot.com/2016/02/oracle-soa-suite-12c-1221-installation.html

Lets Start with OSB Domain Creation

Step 1:

Open Folder location 

<Middleware Home>\oracle_common\common\bin

Location as per Previous post, which discusses about installation steps

D:\SOA12c\MiddlewareHome\oracle_common\common\bin

Here you will see below files

Step 2:

Double click on config.cmd  This will open Configuration wizard

Step 3:

Provide Name and Location of Domain then click Next
E.g
D:\Oracle_Home\SOA12c_Home\user_projects\domains\OSB_domain

Step 4:
Select Oracle Service Bus, it will automatically choose all the required apps.
Then click on Next button

Step 5:
Provide location for the Applications, or keep the default location. Then click Next

Step 6 :
Provide Admin Password (Make a note of it ). Then Click on Next button

Step 7:

Keep the default value, click on Next

If you want similar control as Production, then select Production here

Step 8 :
Select manual Configuration , to Provide details about the DB schemas .

Before this We need to create DB schemas using Repository Creation Utility. Follow my Previous post to Create Schemas at:

Repository Creation Utility (RCU) - Creation of DB Schemas for SOA 12.2.1

http://osb-dheeraj.blogspot.com/2016/02/repository-creation-utility-rcu.html

Step 9:

Fill the DB Schema details for each of the Datasource by selecting each one by one

Once all filled, Click on Next button

Continue Learning Steps of Domain creation in my Next Post at

Oracle SOA Suite 12c - OSB Domain Configuration part 2

http://osb-dheeraj.blogspot.com/2016/02/oracle-soa-suite-12c-osb-domain_17.html