JDBC adapter at receiver side

[Former Member]

hi all,

iam integrating SAP sytem with Oracle database system.

so iam using JDBC at reciver side.

SAP side data is coming from 3 tables say tab1,tab2,tab3.

tab1 having 3 fields f1,f2,f3, tab2 having 2 fields f4,f5, tab3 having 2 fields f6 f7.

sender side structre is as below:

<node>

<f1>

<f2>

.........

<f7>

</node>

but receiver side they want another extra field table name say <tabname>

in receiver table data has to update like this:

<tabname> <f1> <f2> <f3> <f4> <f5> <f6> <f7>

tab1 value value value null null null null

tab2 null null null value value null null

tab3 null null null null null value value

that means data related to tab1 has to filled in tab1 related fields remainig all r null.

Can anybody help me out?

Thanks,

Sreedhar Goud

[Former Member]

hi sreedar,

create 4 data types

data 1 <itab><f1>...<f7>

data 2 <itab1><f1>...<f7>

data 3 <itab2><f1>...<f7>

data 4 <itab3><f1>...<f7>

add this data type four times in messgae mapping i.e

create mapping program say "multi mapping"

with maps source to 4 data types at a shot

<xml>

target as

<f1>...<f7> data1

<f1>...<f7> data 2

<f1>...<f7>data 3

<f1>...<f7>data 4

map accordingly .

after this create 4 interfaces for 4 data types

in interface mapping select one source interface and 4 target interfaces

once u refresh mapping all data types are populated and u can see message mapping program.

in configuration create receiver interface determination go to extended and use interface mapping u did

4 reciever determinations for 4 interfaces and use one communication channel.

create receiver determinatio as one sender and receiver.

thats done hope so.

Thanks & Regards,

Rama krishna

Edited by: rama krishna talluri on Mar 6, 2008 10:20 AM

Edited by: rama krishna talluri on Mar 6, 2008 10:22 AM

Edited by: rama krishna talluri on Mar 6, 2008 10:22 AM

[Former Member]

Hi Rama krishna,

Thanks for ur quick replay.

but in mapping...at reciver structure we have to map tablename to the field tabname.

How can we track that table name and how can we map that?

thanks,

sreedhar

[Former Member]

Hi,

Reffer this BLOG for your JDBC Structure and give the Table name According to that

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Regards

Seshagiri

[Former Member]

Dear Seshagiri,

Thanks for ur replay.

In receiver structure I can give the database table name that in not a problem,but the thing is i have a field 'tablename' in my receiver structure.I have to map SAP table name(from where the data is coming) to that field.

How can i track that one.

Thanks,

Sreedhar

[aashish_sinha]

Hi,

Refer this link related with JDBC receiver..

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

regards

Aashish Sinha

PS : reward points if helpful

[Former Member]

Hi,

You should have the receiver JDBC structure as mentioned in the BLOG.You shldn't have the structure according to your's

Receiver JDBC is having some sort of structure follow that

If you are passing the SAP r/3 table mane to the JDBC structure means where you are capturing this value at Receiver Database side??

Regards

Seshagiri

[Former Member]

hi Seshagiri,

Receiver JDBC having some sort of structure....Thats true.

structure is like this:

<Statement>

<table> -

---

you r saying abt this table name if iam not wrong(JDBC table name)

<action>

<access>

<tabname>----

---

iam asking abt this table name(it is SAP table)

<f1>

<f2>

.....

<f7>

I am following this structure only at reciver side.I know the jdbc tale name.no problem with this.

I want to track SAP table name.

Here we r extracting the data from 3 sap tables.

thanks,

sreedhar

Edited by: Sreedhar Goud on Mar 10, 2008 10:52 AM