SAP PI 7.1 : Need to maintain Key-Value Entries

[arkesh_sharma]

Hi Experts,

I have to maintain 1200 entries as key-value pairs in PI.

The standard function "FixValues" in PI cannot hold so many values.

Please advice how can I fix/maintain it?

Thanks,

Arkesh

[Former Member · Accepted solution]

Hi,

>>The standard function "FixValues" in PI cannot hold so many values

Not sure about this limitation because i haven't tried it, but maintaining 1200 key-value pair using fix value is not a good option...u can think of using VMR or Value mapping.

Search SDN u will find lot of articles on the same.

Thanks

Amit Srivastava

[arkesh_sharma · Accepted solution]

Hi Amit,

Can you please let me know what is VMR ?

I have got only two columns in the table (Key-Value scenario) so how can I implement that in Value Mapping Table ?

I have to mention the source agency and schema and target agency and schema in Value Mapping but I do not have any of these details available.

If you can advice a little more on it then it would be helpful for me.

Thanks,
Arkesh

[Former Member · Accepted solution]

Hi,

Baskar has already pointed the article related to VMR, so u can refer it or search SDN, u will find lot more on the same.

>>I have got only two columns in the table (Key-Value scenario) so how can I implement that in Value Mapping Table

Check this discussion and the screen shot which i have mentioned:

http://scn.sap.com/message/13359211

Thanks

Amit Srivastava

[Former Member]

Hi,

        Since you need to maintain key value pairs, Value mapping will work for you. The agency\scheme pair names need to be provided by you. Search in SDN and you will get a lot of help on how to maintain\use a value mapping.

Since you need to maintain 1200 entries, you can use value mapping replication to populate your value mapping table, instead of entering all 1200 values manually.

Regards

[Former Member]

Hi,

Have a look at value mapping replication scenario:

http://scn.sap.com/people/udo.martens/blog/2009/04/03/value-mapping-replication-scenario

A visual demo here:

http://scn.sap.com/docs/DOC-3706

If VMR looks a big task then for single values you can try a simple RFC lookup where you maintain Key-Value entries in a table and retrive them using rfc lookup call

If your input has lot of key-value entries, then you can use the following blog:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2010/01/28/graphical-rfc-lookup-and-how-you-...

Thanks,

Sudhansu

[baskar_gopalakrishnan2]

Why don't you store it in database table and use jdbc lookup for this?  Since you have more entries, it would be very helpful to maintain if you move the data to the tables.  PI 7.1 supports graphical JDBC lookup.

[arkesh_sharma]

Thank You for your reply Baskar.

I am not sure if I can use the DB available in the current system for maintaining such tables. They use DB2 and I am not sure if that is a feasible option now that I have only 1 day left to fix it.

Thanks,

Arkesh

[baskar_gopalakrishnan2]

VMR means Value Mapping Replication. You can find details about this

http://help.sap.com/saphelp_nw04/helpdata/en/2a/9d2891cc976549a9ad9f81e9b8db25/content.htm

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e07dd2ae-f783-2c10-9aa6-ca69f67dd...

Why don't you choose a simple open source database like mysql server and use it? You really don't need to use DB2 for this.?

Also you can try if you want something in the file and do the lookup using simple UDF? This is another approach.

http://wiki.sdn.sap.com/wiki/display/XI/File+Lookup+in+UDF