cancel
Showing results for 
Search instead for 
Did you mean: 

jdbc-rfc synchronous scenario

Former Member
0 Kudos

Hi...All,

we r plaing to do JDBC-RFC Synchronous Scenario with out BPM,please tell me any settings are required for this scenario.any body is having any links regarding this type of scenario pls share with me...that is helpfull for me...

thanks in advance,

Pasi.

Accepted Solutions (1)

Accepted Solutions (1)

former_member556603
Active Contributor
0 Kudos

Hello Pasi,

JDBC-RFC Synchronous Scenario with out BPM,

Go through this links...

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

/people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible

http://help.sap.com/saphelp_nw04s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Thanks,

Satya Kumar

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

I think JDBC-RFC sync scenario is not supported with jdbc interface as sender. Take into account

that the response of the rfc cannot be handled by the jdbc interface.

Regards,

Emiliano

Former Member
0 Kudos

HI check the link

1. You will have to create a Sender JDBC adapter. Check the link below for configuring a JDBC sender adapter.

An important point to note are 2 fields, QUERY this will contain the select query. Next will be the UPDATE.this will contain the UPDATE statement after the rows are selected from your database.

The reason an update statement has to be given is, as the JDBC adapter will continually poll over your database, the rows read in one polling interval should not be read again.

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

2. Next, you will have to configure a receiver RFC adapter. This can be done following this link,

http://help.sap.com/saphelp_nw04/helpdata/en/c8/e80440a832e369e10000000a155106/content.ht

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

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

regards

chandrakant

Former Member
0 Kudos

Hi,

For JDBC We have to Install the JDBC Drivers on XI Server

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

JDBC to JDBC

https://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC

Regards

Former Member
0 Kudos

sorry pls ignore this

Important Tables in SAP BI ( NW2004)

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/bi/important%2btables%2bin%2bsap%2bbi%2b(%2bNW200...

Useful ABAP Programs & Function Modules in SAP BI

https://www.sdn.sap.com/irj/sdn/wiki?path=/pages/viewpage.action?pageId=35458

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b485d390-0201-0010-8189-91444c74...

and check the thread

regards

chandrakanth

Edited by: chandra kanth. k on Jun 9, 2008 10:02 AM