Push Data on SQL Server

[Former Member]

Hi All,

I need to Push data from SAP to SQL Server.

I have written some RFC's and they are fetching the data as required , as I don't have much experience in using the Connectors, Could anybody please help me in setting up the connectors.

with rgds

Ranjith Singh

[former_member743531]

Hello Ranjith,

You can use SAP PI for this.

You need to expose your data to a proxy ( created via PI) and then send data from PI to your SQL server using JDBC.

Regards,

Deepakd

[Former Member]

Hi Deepak,

Could you please help with any documentation if available.

with rgds

Ranjith Singh

[former_member743531]

First you need to create your data structure which you want to pass, then you need to create message types binding that structure, then you need to create a program which will use the proxy class created by the interface to push data to proxy.

All these steps except program will be created in Enterprise Service Repository.

Then you need to use Integration Directory to create the SOAP channel from SAP to PI and JDBC channel from PI to SQL Server. It is here we use our connectors.

Please refer:

and

http://wiki.scn.sap.com/wiki/display/XI/Step-by-Step+Guides

for step by step process. Hope this solves your problem.

Best Regards,

Deepak

[Former Member]

Excellent documentation Deepak !

J.