Issue for JDBC to JDBC mapping ?

[Former Member]

Hi Experts,

I have the following mapping scenario at hand, please suggest the best way to acheive it.

I have to map from Oracle table of System A to Oracle table in System B.

Sender table A has a multiple sets of header and detail records, denoted by H or D.

For one header there may be many detail records.

Transfer number is unique to each header.

These are arranged in no particular order.

The requirement is to group them into ordered sets of same tranfer number, header followed by all the details. How can this be acheived?

SOURCE

Record Type TNo f1 f2 f3

H 100 AA * *

D 100 * BB cc

D 100 * dd ee

H 200 FF * *

D 200 * GG HH

D 100 II JJ

H 300 KK * *

D 300 * LL MM

D 300 * NN OO

D 200 * RR SS

D 300 * PP QQ

DESTINATION

Record Type TNo f1 f2 f3

H 100 AA * *

D 100 * BB cc

D 100 * dd ee

D 100 II JJ

H 200 FF * *

D 200 * GG HH

D 200 * RR SS

H 300 KK * *

D 300 * LL MM

D 300 * NN OO

D 300 * PP QQ

[GabrielSagaya]

IN Oracle System A add a column 'flag' to the table invoice (assume)

In Msg Mapping have normal message mapping such that

Source msg can have recordtype,tno,f1,f2,f3, flag

Target msg includes statementname,tablename,action='Insert' and access have recordtype,tno,f1,f2,f3,

in Sender JDBC CC

Select Query

select recordtype,tno,f1,f2,f3 from invoice where flag=0;

Update Query

update invoice set flag=1 where flag=0;

[Former Member]

Hi Gabriel and experts,

Thanks for the input.

Please suggest any logic to group the similar data according to the key transfer number.

Regards,

Shamly

[GabrielSagaya]

you can use SortByKey() function for TransferNumber for grouping

[Former Member]

Hi Shamly,

have u followed the standard structures that to be followed while designing JDBC receiver adapter in the receiver side, and at the same time the fields which u define the database and the fields which u define the XI must be same else the data wont be passed.

regards,

kishore

[Former Member]

Hi Suresh,

I have followed the receiver side structure and maintained the same filed names. but i am unable to hit upon a logic to group the data.

Regards,

Shamly

[Former Member]

Hi Shamly,

Whether have u got success in moni, actually where u got struck up with

regards,

sai

[Former Member]

Hi Sai,

I am unable to go about with the mapping. I am yet to test.

Regards,

Shamly

[Former Member]

Hi,

Check the links.

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

Regards,

Phani

[Former Member]

Hi,

Check this JDBCXI-JDBC Scenario

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC&

Regards

Seshagiri

[Former Member]

Hi Experts,

Please focus on the mapping issue, adapter configurations are in place, thank you for the input though.

shamly.