Value Mapping Replication for Mass Data - tables are on external Oracle db

[former_member187587]

Hi Guys,

Looking into the Value mapping with mass data replication , looks like a powerful tool to resolve some integration challenges.

One of my Data sources is an external Oracle data base.

As in SAP documentation only SAP database solutions are mentioned (based on JAVA\ABAP PROXY)

I was wondering whether this scenario can be performed using the JDBC Adapter to replicate the data to XI.

Is it a good practice?

Does the Mass data replication process can be used for A2A scenarios or B2B (Agency) scenarios as well.

Points will be awarded of course.

Cheers.

[MichalKrawczyk · Accepted solution]

Hi,

>>>Looking into the Value mapping with mass data replication , looks like a powerful tool to resolve some integration challenges.

only for small numer of records (as per SAP best practice)

>>>I was wondering whether this scenario can be performed using the JDBC Adapter to replicate the data to XI.

yes - JDBC to get the data and proxy to populate

>>>Does the Mass data replication process can be used for A2A scenarios or B2B (Agency) scenarios as well.

both

question:

why not use JDBC graphical lookup ? easy, simple, scalable (as DB) and ready for large number of records

BTW

for value mapping limitations have a look at many sdn blogs,

Regards,

Michal Krawczyk

[former_member187587 · Accepted solution]

Hi Michal,

From previous implementations I recall the graphical mapping as an unstable solution (especially with many records) . I need this lookup at Item level and not header data level (might be 300-800 records).

Therefor I was looking into other SAP PI artifacts to handle the lookup .

you replyed that " JDBC to get the data and proxy to populate"  - Does this replication of data is usign another PI Process (JDBC to PROXY ) or part of the value mappnig replication? - not cleared.

Cheers.

[MichalKrawczyk · Accepted solution]

Hi,

>>>I need this lookup at Item level and not header data level (might be 300-800 records).

item level is the same as header level in terms of calling (only one lookup call)

>>>recall the graphical mapping as an unstable solution (especially with many records)

design is crucial - wrong design = multiple calls = unstable solution

proper design = one call for all lines = stable solution

>>>>- Does this replication of data is usign another PI Process (JDBC to PROXY ) or part of the value mappnig replication?

you use a proxy to populate value mapping rep tables but you can use any adapter on the other end to get the data... don't know what's not clear here

Regards,

Michal Krawczyk

[former_member187587 · Accepted solution]

when you say : "one call for all lines" you mean using a context change in the mapping lookup to get all the results for the source message fields context?

Is this possible even before the rest on the targt structuer elements has been created?