on 06-09-2008 8:56 AM
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.
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
Thanks,
Satya Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For JDBC We have to Install the JDBC Drivers on XI Server
To install JDBC driver follow the 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.
JDBC to JDBC
https://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sorry pls ignore this
Important Tables in SAP BI ( NW2004)
Useful ABAP Programs & Function Modules in SAP BI
https://www.sdn.sap.com/irj/sdn/wiki?path=/pages/viewpage.action?pageId=35458
and check the thread
regards
chandrakanth
Edited by: chandra kanth. k on Jun 9, 2008 10:02 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.