DB Lookup

[former_member182455]

Hi Friends,

How to write the UDF's below one

Performs query into Integration Database using three input values

Regards

srinivas

[rajasekhar_reddy14 · Accepted solution]

Then it very easy to pefrom.

first deploy your data base drivers in PISever using Visual Admin,

we can perform DB Lookups in 3 ways

1)Wrting UDF,and making data base conection direclt from UDF,but its not advisable.

2)Create JDBC Receiver communication channel and fill the details like Driver details ,required paramentrs in Receiver communication channel and cal the Receiver channel in UDF.

3)Using connection pooling mechanism.

my advice to you create receiver JDBC Channle and cal the chanel using UDF and write your logic.

manmy blogs available on the same,let me know if you hav any concerns.

Regards,

Raj

[rajasekhar_reddy14]

Hi,

What do you mean by Integration Data Base?? its external DB or SAP??clarify this one first.

If you want to look up any values from data base,there is a standard approach like making conection to data base in UDF..search sdn u wil find docs and code too.

Regards,

Raj

[former_member182455]

Hi shaker,

That is external DB?

Regards

srinivas

[Former Member]

Srinivas,

External DB means Database outside XI/PI...can be oracle/Sql server

Regards ,