graphical message mapping examples for JDBC and RFC lookup

[Former Member]

hi, can any body provide me graphical message mapping examples for the "JDBC Lookup" function and "RFC Lookup" function?

I'm now studying the graphical message mapping and want to try those 2 functions. thank you.

I expect the examples to be simple enoung, not need to set up much.

[former_member188019]

can u check this link:

PI 7.0 & 7.1 Mapping - Blogs,Articles,Wiki,Code Samples and Videos Collections https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=79955426

it contains a link : SAP PI 7.1 Mapping Enhancements Series: Graphical Support for JDBC and RFC Lookups /people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-graphical-support-for-jdbc-and-rfc-lookups

[Former Member]

>

> can u check this link:
> 
> PI 7.0 & 7.1 Mapping - Blogs,Articles,Wiki,Code Samples and Videos Collections https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=79955426   
> 
> it contains a link : SAP PI 7.1 Mapping Enhancements Series: Graphical Support for JDBC and RFC Lookups /people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-graphical-support-for-jdbc-and-rfc-lookups

May be I'm too foolish to follow those links, I got issues of each links.

What I really want is an example from step0

Swarup:

Refer the Lookup document - Easy Lookup in Process Integration 7.1

https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/20befc9a-aa72-2b10-ae9b-b0988791d457

The first step is "Create an RFC Enabled Function Module for look up", but where can I create the function module? Should I use ESB, IB? or use transaction 'SE11' ?

Kulkarni:

Very good links for RFC lookup with 7.0/3.0

https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/70d90a91-3cf4-2a10-d189-bfd37d9c3231&overrid...

At page6 "PI Development/Configuration", it saies "You are on the design maintenance screen in the Integration Builder.Expand the subnodes for the software component version for which you want to import interfaces".

What is "design maintenance screen" ? My IB version is: Service Pack:08 Release:NW07_08_REL.

When I open IB, it display a screen titled with "Configuration: Intergation Builder", I did not find "software component version" node on the left tree.

Madhu_1980 :

it contains a link : SAP PI 7.1 Mapping Enhancements Series: Graphical Support for JDBC and RFC Lookups /people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-graphical-support-for-jdbc-and-rfc-lookups

The Prerequisites state:

The JDBC channel to be used for the lookup must be configured and activated in the Integration Directory.

The definition of the table used for the lookup must already be imported into the ES Repository as an external definition

But I don't know how to create a JDBC channel and define the table.

[Former Member]

hi

To create a channel JDBC .. if you don't have Party create a new one..>> create a business services >> create a new channel >> chose adapter type JDBC >> Transport Protocol JDBC>> Message Protocol (XML SQL Format)>> Adapter Engine Integration Server.in the connection put the parameters.

[Former Member]

Very good links for RFC lookup with 7.0/3.0

https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/a03e7b02-eea4-2910-089f-8214c6d1b439&overrid...

https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/70d90a91-3cf4-2a10-d189-bfd37d9c3231&overrid...

You dont have to do much, build UDF using code given in the link

with little modifications as per your requirement and will work

[Former Member]

Hi,

Refer the Lookup document - Easy Lookup in Process Integration 7.1

https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/20befc9a-aa72-2b10-ae9b-b0988791d457

Thanks

Swarup

[Former Member]

thanks alot! it is RFC example, I'm also seeking JDBC lookup example as well.

[Former Member]

Hi,

its almost same way to use JDBC lookup, provided you know the Table structure.

Refer -SAP help best way to learn

http://help.sap.com/saphelp_nwpi71/helpdata/EN/44/749dd812dd3676e10000000a114a6b/frameset.htm

Below doc will provide you the sample example

https://www.sdn.sap.com/irj/scn/elearn?rid=/library/uuid/f06d11f2-e7c2-2a10-04a9-f2f6f374cd29&overri...

Thanks

Swarup