on 09-24-2008 12:16 PM
Hi,
Please tell me the scenario to integrate sql server database to sap system using xi. please provide me life cycle solution with real world example.
Hi,
Please check some links.
JDBC ADAPTER
http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm
JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm
multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
JDBC RECEIVER ADAPTER
Tips and Tutorial for Sender JDBC Adapter
https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC&
Regards,
Phani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Laxmi,
It will be a normal JDBC - XI - SAP scenario.
In the jdbc adapter configuration u specify the either the select query / execution of the stored procedure that will pull the data from sql server and then pass it xi from there for target system.
http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm
you can go through this blog:
If u want to create the data type and message type for selecting the database . For data type format refer :
Regards,
Vinod.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Lakshmi,
Real world example:
Assume the Purchase order information is stored in Database and needs to send the data to R/3 for creating sales order.
Sender: JDBC adapter (ORacle or any DB)
Receiver: IDOC adapter (SAP system)
The vice versa also can be done.
For any JDBC adapter, you require to put a select query and an update query for polling the data from DB. You cal also execute Stored procedures also.
For any receiver JDBC adapter, you can either insert, update or delete .
Regards,
Krish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.