soap lookup

[Former Member]

Dear experts,

The scenario is file to file with a soap lookup. certain records are inserted using lookup in mapping.

The records which can not be inserted, along with the error code from the webservice response has to be sent to a database table. Please suggest the options .

Thanks ,

Aju

[Former Member]

hi,

generelly lookup is used to find the value which was not present in the sender structure ,and u need to find that, based on some field value in sender side from another system/server.

in youe case make sych soap message interface.

generate the soap request which used to fatch the value from other system .

if system not get any value for that it will return the error message.

map the responce message with the requird target field value.

please find the link for jdbc lookup

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

regards,

navneet

[prateek]

Check this for soap lookup

certain records are inserted using lookup in mapping.

Lookup as the name suggests should not be used for inserting data. It should only be used to lookup small amount of data. Better option would be use of sync send step in BPM.

Regards,

Prateek

[Former Member]

Hi ,

Is it possible to do a jdbc call in the response mapping . ie make it a sync file to soap . in the response use accessor and call the jdbc adapter . is that a feasible soliution ?

Thanks

Aju

[prateek]

Both ways, you are trying atleast once to insert the data using lookup functionalities. This is not at all a recommended approach. Go for BPM. It won't be that difficult as it seems.

Regards,

Prateek

[Former Member]

hi

check this