Tuesday, January 22, 2013

How to change the time format in SOA


Drag and drop a format-dateTime function in Transformation In picture you will specify what is the format you want your output to be "[Y0001]-[M01]-[D01]-[H01].[m01].[s01].[f000001]" it will produce an output in 2000-12-11-12.12.23.120000 Similarly you can change the picture to produce output in your required format.

Tuesday, January 08, 2013

How to pass Batch ID in ODI Call from SOAP UI

Create a project variable.

DAta type -alphanumeric

No history

default value -1

In refreshing page get the sequence value

select XX_WSH_SHIPMENT_GDW_STG_S2.NEXTVAL from dual

Now the logic is we can call the process from SOAP UI or otherwise it should be put in scheduler

So for this to achieve we first create the variable BATCH_ID as defined earlier

Then in the package we first declare then evaluate it .

We compare if it is greater than zero .

If yes then directly complete the interface

however if it is less than zero then go to another step where again drag and drop the BATCH_ID as refresh variable.

This way you can both call the service from SOAP ui and as well as you can put it on scheduler.

In case of scheduler default value will be always -1 hence it will refresh the value

however in case of ODI call the passed value will be always greater than 0 hence refresh step will be skipped and the value passed from SOAP ui will be used as a BATCH _ID


Calling ODI SCenario from SOAP UI



   
   
     
         
         
           
           
            user
           
            password
            DEVWORKREP
         
         
            SCENARIONAMEPRC
            001
            001
           
            false
           
           
           
           
           
 
               
               SCENARIONAME.BATCH_ID
               78
           

           
            5
       
     
 


When calling ODI Scenario from SOAP UI make sure that you are passing the correct user id password which is there for ODI console.


If you are passing any input variable it should be passed in Variable.

Name should be poject name.variable name

and value should contain the value.

One important thing is there is gap in the project name make sure you are replacing it with underscore _ while passing the variable in odi call.