SAP XI to Database integration

[Former Member]

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.

[Former Member · Accepted solution]

Hi,

Please check some links.

JDBC ADAPTER

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

- File to JDBC

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 Response

JDBC RECEIVER ADAPTER

Tips and Tutorial for Sender JDBC Adapter

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC&

Regards,

Phani

[former_member537867]

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.

[Former Member]

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