topic Re: SAP data to SQL in Application Development and Automation Discussions

SAP data to SQL

Former Member — Wed, 20 Mar 2013 04:02:03 GMT

Hi All,

Can anyone share their expertise/knowledge/idea on how to
get the data from SAP server to SQL?

Thanks in advance.

Have Great day!!!

Re: SAP data to SQL

Former Member — Wed, 20 Mar 2013 04:33:42 GMT

This message was moderated.

Re: SAP data to SQL

Former Member — Wed, 20 Mar 2013 04:33:56 GMT

Hi James,

As i understand you want to get data from SAP server to non sap then you can use RFC and BAPI.

But this will help you to get some Specific data related to your requirment but not all the data.

So if you req some specific data for further use in different application u can use RFC and BAPI.

else

kindly give some more information on your requirment.

Regards

Rohit

Re: SAP data to SQL

satyabrata_sahoo3 — Wed, 20 Mar 2013 04:44:28 GMT

You can use BAPIs or FMs like RFC_READ_TABLE to get data of SAP tables from SQL. You have to use SQL queries using the BAPI or FM to get the data from SAP.

-SS-

Re: SAP data to SQL

Former Member — Wed, 20 Mar 2013 05:02:34 GMT

I need to move various data from SAP to SQL server and which is the best method to perform the transmission, SAP -to-> Excel -to-> SQL or Direct from SAP -to-> SQL?

Re: SAP data to SQL

Former Member — Wed, 20 Mar 2013 06:22:50 GMT

HI james,

It depends on you requirment... but normally if we send data to Non SAP System... it good we directly send the data to other system i.e. SAP - to - SQL , but u have to ensure that the data u are sending , same get by non sap system, a data consistency check must be done at other system.

Hope it will helps you

Regards

Rohit

Re: SAP data to SQL

Former Member — Wed, 20 Mar 2013 06:58:36 GMT

Thanks all it helps me a lot.

I appreciate.