How to get data from SQL server.?

[Former Member]

Dear All

here is my problems.

please help me or give a suggestion.

.I used BPM try to get data from SQL server.

created:

1.DB request interface--for setting the "select * from table" SQL command

2.DB response interface--for receive the return dataSet.

the question is i can't receive the dataSet.

the DB response interface can't receive data.

but I sure that there are data in table.

and the BPM process was finished successfully.

i'm not sure what structure of DB response should be.

or there is any restriction ?

i was call a Z_RFC function from R3,and get return data successfully.found out that Z_RFC function.response has the same structure as the return XML value..i mean even the tag name are the same...is this problem?

Regards

Jack Lee

[Former Member]

thanks for help...my problem is solved.

my data type and message type were wrong.

[Former Member]

Hi,

For more clarification:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/30572c6a-d311-2a10-99ab-f646ec3b...

Thanks,

Boopathi

[Former Member]

hi,

check the below thread

https://www.sdn.sap.com/irj/sdn/mss

regards

kummari

Edited by: kummari on Jul 21, 2008 12:07 PM

[former_member192892]

These links should give you all you need

[JDBC Receiver Adapter -- Synchronous Select u2013 Step by Step|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3928] [original link is broken] [original link is broken] [original link is broken];

[XI: How-to on JDBC receiver response|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2377] [original link is broken] [original link is broken] [original link is broken];