Skip to Content
avatar image
Former Member

jdbclookup

Hi,

Is there any standard udf for jdbc lookup?

please tell me links for jdbc lookups.

Thanks

Best Regards,

Harleen Kaur Chadha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Jul 17, 2008 at 10:01 AM

    Hi Harleen,

    In SAP NetWeaver Process Integration (PI) 7.1, there is now graphical support for JDBC and RFC mapping lookups in message mappings, instead of having to create a user-defined function with the relevant lookup code as in previous releases (e.g. XI 3.0/PI 7.0). This new feature significantly facilitates the creation of such mapping lookups and allows the PI developer to allocate his/her time to other mapping requirements.

    do chk this link

    SAP PI 7.1 Mapping Enhancements Series: Graphical Support for JDBC and RFC Lookups

    Configuring JDBC Connector Service To Perform Database Lookups

    i found worth pls do the required

    Thnax

    Sampath

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2008 at 10:02 AM

    ...

    Cannot delete message!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2008 at 10:02 AM

    Hi,

    check these

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

    Configuring JDBC Connector Service To Perform Database Lookups

    Data Lookup Optimized

    Regards

    Seshagiri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2008 at 10:06 AM

    Hi,

    You are using which XI version..till 7.0, JDBC lookup is possible by creating new java UDF.

    But from 7.1 (will be relesed soon), have standard UDF for that.

    thanks

    farooq.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2008 at 10:32 AM

    Hi,

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

    How to check JDBC SQL Query Syntax and verify the query results inside a User Defined Function of the Lookup API -

    http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

    How to check JDBC SQL Query Syntax and verify the query results inside a User Defined Function of the Lookup API

    Lookups - Wrapping your Mapping Lookup API code in easy-to-use Java classes

    Lookups - https://blogs.sap.com/?p=41515

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

    http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/content.htm

    Optimizing Lookup's in XI

    How we have to create the lookups?

    Check this weblogs with some screenshots on how to achieve this:

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

    Use this crazy piece for any RFC Mapping Lookups!

    https://blogs.sap.com/?p=41515

    Optimizing Lookup's in XI

    Wrapping your Mapping Lookup API code in easy-to-use Java classes

    Regards,

    Phani

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2008 at 10:36 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2008 at 10:47 AM
    Add comment
    10|10000 characters needed characters exceeded