Database Lookup ?

[Former Member]

Hi Guys,

I have RFC-SOAP scenario working properly. I get a status code back from the 3rd party system in one of the response field and i need to map this to one of the field in RFC.

The status codes maintained in the sql server database on the 3rd party system are in 100's, so i think i need to perform a DB Lookup and UDF in the response mapping.

Do i need to create the table structure in XI ? or i can directly pull the message for the corresponding field.

I have a single argument and single result message like

100 -- success & 200- Failure. I think i need not use the advanced function?

I am following the web blog as below for the DB lookup.

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

any suggestions would be appreciated

Thanks,

Srini

[Former Member]

You need not create a table structure in XI.

If it is single status code lookup then you need not use Adavanced UDF.

[Former Member]

Hi Anand,

I have the mappings defined between the RFC structure and the WSDL of the 3rd party system. can you explain briefly where i need to use the table structure in XI ?

any help would be appreciated

Thanks,

Srini

[Former Member]

Hi,

You don't need to create the structure in XI for this scenario.

Accessing data from an external database is the objective of DB lookup. You will be doing this via UDF. Under the UDF code you will be using the communciation channel derived for triggering the query with SQL database.

Under the UDF only you will get the field values from database. You can refer the code used in the blog you are currently referring.

Here you can see UserID and Passwords are validated.

Simialr way you can get the data of status code

Thanks

Swarup