topic Re: Data transfer from SQL to SAP r/3 in Application Development and Automation Discussions

Data transfer from SQL to SAP r/3

Former Member — Thu, 09 Jun 2011 13:37:10 GMT

Hi,

We have a scenario wherein we require to get data from two tables in SQL and send the data to r/3 and do some some calculation. finally save the data in tables.

Can you please help me out the best way to do so. Is it Flat file transfer or RFC. Please do provide examples, if any.

Thanks.

Re: Data transfer from SQL to SAP r/3

former_member212713 — Thu, 09 Jun 2011 13:53:23 GMT

Hi Sai;

1. You can connect to SQL DB from SAP with native SQL. You can call to view or stored procedure or select statement.

2. You can write Vs .net NCO 3.0. You should write RFC at SAP. And call from .net.

Your sql tables and sap tables should be same structure.

I Think If you have .net license and should get periodic run process ; You can use .net with NCO 3.0

But If You use only several times this process ; You can use native sql method.

Best regards.

Re: Data transfer from SQL to SAP r/3

Former Member — Thu, 09 Jun 2011 14:01:20 GMT

Hi Melih,

Thanks for the response. sql tables and sap tables both the structures are different. Even we dont have .Net interface to use.

Can you suggest me with any other way?

Re: Data transfer from SQL to SAP r/3

Former Member — Thu, 09 Jun 2011 14:07:54 GMT

Setup a DBCO connection and use Native SQL. Check with your Basis for the connection setup.

http://help.sap.com/saphelp_nw04/helpdata/en/df/455ec9747111d6b25100508b6b8a93/content.htm

Re: Data transfer from SQL to SAP r/3

former_member212713 — Thu, 09 Jun 2011 14:24:12 GMT

Hi Sai;

I suggest you 2 way for your status.

Native sql very useful and healty method. You can try this method.

Please check below links.

Best regards.

http://help.sap.com/saphelp_smehp1/helpdata/en/a9/9cbe7ecd9b464b8f31449df34c8d8c/content.htm

http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

Re: Data transfer from SQL to SAP r/3

Former Member — Thu, 09 Jun 2011 14:38:48 GMT

Thank you Suman n Mehil.. Is it good optin to use Native sql? because the data will updated for every month in the sql tables.

Re: Data transfer from SQL to SAP r/3

Former Member — Thu, 09 Jun 2011 15:00:33 GMT

Sai, Native SQL is specific to database and In your case, you have a specific external database to access and as far as I understand you would read the data from two tables of the external database once in a month which should be fine.

Re: Data transfer from SQL to SAP r/3

SuhaSaha — Thu, 09 Jun 2011 15:23:43 GMT

Hello Sai,

In order to connect to external DBs SAP has provided [ADBC|http://help.sap.com/abapdocu_702/en/abenadbc.htm] API classes.

If you don't want to manually implement the Native SQL code you can use these API classes. Interested? Refer to the demo program ADBC_DEMO for further know-how!

Cheers,

Suhas