topic Re: Push Data on SQL Server in Application Development and Automation Discussions

Push Data on SQL Server

Former Member — Sat, 23 May 2015 05:02:59 GMT

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

Re: Push Data on SQL Server

former_member743531 — Sat, 23 May 2015 05:16:17 GMT

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

Re: Push Data on SQL Server

Former Member — Sat, 23 May 2015 05:25:37 GMT

Hi Deepak,

Could you please help with any documentation if available.

with rgds

Ranjith Singh

Re: Push Data on SQL Server

former_member743531 — Sat, 23 May 2015 06:57:24 GMT

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

Re: Push Data on SQL Server

Former Member — Sat, 23 May 2015 13:18:19 GMT

Excellent documentation Deepak !