Download directly to Unix/Linux from Internet/Oracle using WGET command

Hi Guys,

In this post, I will describe the process to directly download installers from Oracle.com to Unix Machines.
You may wonder, why a post on this topic. Its fairly easy, but sometimes we dont have Browsers in Linux machines. We only have the Terminal or Putty screens to work.
Here's the process, to download using putty.

1. Log in to Unix Machine using Putty.
2. Navigate to location, where you want download installers.
3. Now using any windows PC Chrome browser, Login to Oracle.com, Select your installer & Download it to PC. In Chrome Download tab, Right Click on Downloading file. Select 'Copy Link Address'.

The address will look something like below

http://download.oracle.com/otn/nt/middleware/12c/1221/fmw_12.2.1.0.0_soaqs_Disk1_1of2.zip?AuthParam=1454049262_286c6d7c2bf0ba6eb3c31dcfb3d309a0

This address is valid for few minutes only. Hence do all steps faster.

4. Prepare a command as below using this adrress, your username  password,


wget --http-user=dhexxxxxxha@xxxxx.com --http-password=xxxxx234a --no-check-certificate "http://download.oracle.com/otn/nt/middleware/12c/1221/fmw_12.2.1.0.0_soaqs_Disk1_1of2.zip?AuthParam=1454049262_286c6d7c2bf0ba6eb3c31dcfb3d309a0" -O NameOfDownloadedFile.zip

5. Copy the above Command and Paste it to Putty screen. Hit enter, your download will start.
6. Repeat the same steps if there are multiple installers.


Thats it folks!

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

Integration using Oracle ICS - Source ( Webservice ) to Target (Webservice) Part 2

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

Integration using Oracle ICS - Source ( Webservice ) to Target (Webservice)

http://osb-dheeraj.blogspot.in/2016/02/integration-using-oracle-ics-source.html

Lets continue with steps :

Create Integration using Source and Target Connection, Create Mapping:

Navigate to Integrations Screen and Click on 'Create New Integration'

A Screen similar to below will be seen

Step 1 :

Select 'Map My Data'. Screen shown Below will appear. Provide Name of the Integration and Click Create.

Step 2 :

Now Drag and Drop connections from Right Side Pane to Source .A screen as below will be shown. Provide Name of your Source, Then Click Next

Step 3 :

Select Operation from Available Operations. Then Click Next. As Shown below

Step 4 :

Verify the Summary, and Click Done

Step : 5

A Screen as shown below will appear.

Step 6:

Repeat Step 2 to Step 4 for Target connection. A Screen as below will appear

Step 7:

Now Click on 'Create Map' A + button will appear. Click on it, as shown below

Step 8:

You will be naviagated to Mapper Screen. Create a Source to target Mapping by Drag and Drop.

As Shown below

Step 9 :

Click on Save, and Exit Mapper. Shown below

Step 10:

Repeat Step 8 and Step 9 for Response Mapping.

A screen as below will be shown

Step 11:

Now Click on Tracking to add any field for Audit and tracking purpose. Then click on Done.

Shown below

Step 12 :

Now Click on save and Exit Integration Editor.

Step 13:

Now Click on Activate to deploy your integration.

Step 14:

Select tracing checkbox to Enable Deep data tracing.

This is all, We have successfully created and Deployed our integration using Oracle ICS.

More Learnings on ICS

1. Oracle Integration Cloud Service (ICS)

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

2. Oracle Integration Cloud Service (ICS) - Monitoring and Tracking Messages & Errors

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

3. Invoke Web service hosted at Oracle Integration Cloud Service (ICS) using SOAPUI

http://osb-dheeraj.blogspot.in/2016/02/invoke-web-service-hosted-at-oracle.html

Invoke Web service hosted at Oracle Integration Cloud Service (ICS) using SOAPUI - Part 2

This post is in continuation with my previous post, you can find the part 1 here

Invoke Web service hosted at Oracle Integration Cloud Service (ICS) using SOAPUI

http://osb-dheeraj.blogspot.in/2016/02/invoke-web-service-hosted-at-oracle.html

Let's continue with steps

Step 5:

This will open a new Pop up, Select Basic, then click on OK.

Step 6:

Provide your Username and Password.

Step 7:

Now Right Click on the Request tab. You will see a window similar to below. Select 'Add WSS Username Token'

Step 8:

Select 'Password Text' and Click OK. This will add a Security Header in your Request.

Step 9:

Now again Right Click on Request Tab. Then Select "Add WS-Timestamp"

Step 10:

Select 60 in new pop up window Then click Ok. 

This will Add Timestamp to your request

Step 11:

Now click on Test button, to execute the request. This button is highlighted in yellow 

Step 12:

Thats all, you will receive the response from your ICS service

Congrats !, You have successfully invoked Web service hosted at Oracle ICS

For More Integrations and Design patterns, Please refer to My Other posts on ICS webservice integrations

1. Integration using Oracle ICS - Source ( Webservice ) to Target (Webservice)

http://osb-dheeraj.blogspot.in/2016/02/integration-using-oracle-ics-source.html

2. Oracle Integration Cloud Service (ICS) - Monitoring and Tracking Messages & Errors

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

3. Oracle Integration Cloud Service (ICS)

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

Invoke Web service hosted at Oracle Integration Cloud Service (ICS) using SOAPUI - Part 2

This post is in continuation with my previous post, you can find the part 1 here

Invoke Web service hosted at Oracle Integration Cloud Service (ICS) using SOAPUI

http://osb-dheeraj.blogspot.in/2016/02/invoke-web-service-hosted-at-oracle.html

Let's continue with steps

Step 5:

This will open a new Pop up, Select Basic, then click on OK.

Step 6:

Provide your Username and Password.

Step 7:

Now Right Click on the Request tab. You will see a window similar to below. Select 'Add WSS Username Token'

Step 8:

Select 'Password Text' and Click OK. This will add a Security Header in your Request.

Step 9:

Now again Right Click on Request Tab. Then Select "Add WS-Timestamp"

Step 10:

Select 60 in new pop up window Then click Ok. 

This will Add Timestamp to your request

Step 11:

Now click on Test button, to execute the request. This button is highlighted in yellow 

Step 12:

Thats all, you will receive the response from your ICS service

Congrats !, You have successfully invoked Web service hosted at Oracle ICS

For More Integrations and Design patterns, Please refer to My Other posts on ICS webservice integrations

1. Integration using Oracle ICS - Source ( Webservice ) to Target (Webservice)

http://osb-dheeraj.blogspot.in/2016/02/integration-using-oracle-ics-source.html

2. Oracle Integration Cloud Service (ICS) - Monitoring and Tracking Messages & Errors

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

3. Oracle Integration Cloud Service (ICS)

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

Integration using Oracle ICS - Source ( Webservice ) to Target (Webservice) Part 2

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

Integration using Oracle ICS - Source ( Webservice ) to Target (Webservice)

http://osb-dheeraj.blogspot.in/2016/02/integration-using-oracle-ics-source.html

Lets continue with steps :

Create Integration using Source and Target Connection, Create Mapping:

Navigate to Integrations Screen and Click on 'Create New Integration'

A Screen similar to below will be seen

Step 1 :

Select 'Map My Data'. Screen shown Below will appear. Provide Name of the Integration and Click Create.

Step 2 :

Now Drag and Drop connections from Right Side Pane to Source .A screen as below will be shown. Provide Name of your Source, Then Click Next

Step 3 :

Select Operation from Available Operations. Then Click Next. As Shown below

Step 4 :

Verify the Summary, and Click Done

Step : 5

A Screen as shown below will appear.

Step 6:

Repeat Step 2 to Step 4 for Target connection. A Screen as below will appear

Step 7:

Now Click on 'Create Map' A + button will appear. Click on it, as shown below

Step 8:

You will be naviagated to Mapper Screen. Create a Source to target Mapping by Drag and Drop.

As Shown below

Step 9 :

Click on Save, and Exit Mapper. Shown below

Step 10:

Repeat Step 8 and Step 9 for Response Mapping.

A screen as below will be shown

Step 11:

Now Click on Tracking to add any field for Audit and tracking purpose. Then click on Done.

Shown below

Step 12 :

Now Click on save and Exit Integration Editor.

Step 13:

Now Click on Activate to deploy your integration.

Step 14:

Select tracing checkbox to Enable Deep data tracing.

This is all, We have successfully created and Deployed our integration using Oracle ICS.

More Learnings on ICS

1. Oracle Integration Cloud Service (ICS)

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

2. Oracle Integration Cloud Service (ICS) - Monitoring and Tracking Messages & Errors

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

3. Invoke Web service hosted at Oracle Integration Cloud Service (ICS) using SOAPUI

http://osb-dheeraj.blogspot.in/2016/02/invoke-web-service-hosted-at-oracle.html