topic Re: Data transfer from SAP to SQL Server in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237946#M1719382 <HTML><HEAD></HEAD><BODY><P>Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?</P><P></P><P>Thanks and Regards,</P><P>Kartheek</P></BODY></HTML> Fri, 01 Feb 2013 05:04:18 GMT Former Member 2013-02-01T05:04:18Z Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237939#M1719375 <HTML><HEAD></HEAD><BODY><P style="font-size: 12px; background-color: #ffffff; color: #333333;">SAP Gurus,</P><P></P><P style="font-size: 12px; background-color: #ffffff; color: #333333;"><SPAN style="color: #333333; font-size: 12px;">I have a requirement to transfer data from SAP and pass it on to SQL server. Basically no middle ware should be involved and data should be dumped instantly into SQL database. In other words, I will write a program to pull data and call a function(probably RFC and what ever mechanism) to instantly dump data in SQL database.</SPAN></P><P></P><P style="font-size: 12px; background-color: #ffffff; color: #333333;">As I havent come across this requirement before, need your help in identifying various means of transfering data. Appreciate your replies as soon as possible.</P><P></P><P></P><P>Can we pick up data from application server of SAP to SQL Server ? If yes, can you please explain ?</P><P></P><P>Does FTP file transfer works ?</P><P></P><P><A href="http://saptechnical.com/Tutorials/ABAP/FTP/Index.htm" title="http://saptechnical.com/Tutorials/ABAP/FTP/Index.htm">http://saptechnical.com/Tutorials/ABAP/FTP/Index.htm</A></P><P></P><P style="font-size: 12px; background-color: #ffffff; color: #333333;">Thanks</P><P style="font-size: 12px; background-color: #ffffff; color: #333333;">kartheek</P></BODY></HTML> Thu, 31 Jan 2013 13:02:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237939#M1719375 Former Member 2013-01-31T13:02:14Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237940#M1719376 <HTML><HEAD></HEAD><BODY><P>Hi Kartheek,</P><P>have you thought about this: <A href="http://help.sap.com/abapdocu_70/en/ABENOPENSQL_MULTICONNECT.htm">http://help.sap.com/abapdocu_70/en/ABENOPENSQL_MULTICONNECT.htm</A></P><P>Best regards</P><P>Thorsten</P></BODY></HTML> Thu, 31 Jan 2013 20:54:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237940#M1719376 schneidertho 2013-01-31T20:54:00Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237941#M1719377 <HTML><HEAD></HEAD><BODY><P>Remote database connection and Native SQL (see ABAP help) seems like an obvious solution, unless there is more to it... <SPAN __jive_emoticon_name="confused" __jive_macro_name="emoticon" class="jive_macro jive_macro_emoticon jive_emote" src="https://community.sap.com/1151/images/emoticons/confused.gif"></SPAN></P></BODY></HTML> Thu, 31 Jan 2013 21:28:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237941#M1719377 Jelena_Perfiljeva 2013-01-31T21:28:01Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237942#M1719378 <HTML><HEAD></HEAD><BODY><P>Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?</P><P></P><P>Thanks and Regards,</P><P>Kartheek</P></BODY></HTML> Fri, 01 Feb 2013 05:04:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237942#M1719378 Former Member 2013-02-01T05:04:13Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237943#M1719379 <HTML><HEAD></HEAD><BODY><P>Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?</P><P></P><P>Thanks and Regards,</P><P>Kartheek</P></BODY></HTML> Fri, 01 Feb 2013 05:04:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237943#M1719379 Former Member 2013-02-01T05:04:17Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237944#M1719380 <HTML><HEAD></HEAD><BODY><P>Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?</P><P></P><P>Thanks and Regards,</P><P>Kartheek</P></BODY></HTML> Fri, 01 Feb 2013 05:04:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237944#M1719380 Former Member 2013-02-01T05:04:18Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237945#M1719381 <HTML><HEAD></HEAD><BODY><P>Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?</P><P></P><P>Thanks and Regards,</P><P>Kartheek</P></BODY></HTML> Fri, 01 Feb 2013 05:04:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237945#M1719381 Former Member 2013-02-01T05:04:18Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237946#M1719382 <HTML><HEAD></HEAD><BODY><P>Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?</P><P></P><P>Thanks and Regards,</P><P>Kartheek</P></BODY></HTML> Fri, 01 Feb 2013 05:04:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237946#M1719382 Former Member 2013-02-01T05:04:18Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237947#M1719383 <HTML><HEAD></HEAD><BODY><P>Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?</P><P></P><P>Thanks and Regards,</P><P>Kartheek</P></BODY></HTML> Fri, 01 Feb 2013 05:04:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237947#M1719383 Former Member 2013-02-01T05:04:18Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237948#M1719384 <HTML><HEAD></HEAD><BODY><P>This message was moderated.</P></BODY></HTML> Fri, 01 Feb 2013 05:04:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237948#M1719384 Former Member 2013-02-01T05:04:21Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237949#M1719385 <HTML><HEAD></HEAD><BODY><P>Hi Kartheek,</P><P></P><P>Can you check with <A href="http://www.oracle.com/technetwork/middleware/data-integrator/overview/odigs-sapabap-168070.pdf">SAP Jco Connector</A> . ?</P><P></P><P>Regard's</P><P>Smruti</P></BODY></HTML> Fri, 01 Feb 2013 05:15:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237949#M1719385 Former Member 2013-02-01T05:15:39Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237950#M1719386 <HTML><HEAD></HEAD><BODY><P>Sorry Smruti, dont have an idea about SAP JCO COnnector, Can we do it with the help of BAPI ??</P><P></P><P></P><P>Regards,</P><P>Kartheek</P></BODY></HTML> Fri, 01 Feb 2013 05:28:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237950#M1719386 Former Member 2013-02-01T05:28:54Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237951#M1719387 <HTML><HEAD></HEAD><BODY><P>Yes ,we can connect SAP R/3 to Non SAP Using SAP Jco Connector . you can do it with BAPI/RFC ,No issue . but you need to Configure SAP Jco in your Non SAP System end with Some SAP Connection Credentials Required like SAP User Id. Pwd , Application Server Name or IP Address,Instance Number, System ID and in SAP side you need RFC Destination Must be Create using SM59 T-code with Proper authorization Required that SAP User ID which is Connect you Non SAP System. it require ABAP+Functional Consultant(as per requirement)+BASIS+Networking+Non SAP Developer's .&nbsp; </P><P></P><P>Regard's</P><P>Smruti</P></BODY></HTML> Fri, 01 Feb 2013 05:50:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237951#M1719387 Former Member 2013-02-01T05:50:59Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237952#M1719388 <HTML><HEAD></HEAD><BODY><P>Thanks a lot for your quick answers.</P><P></P><P>I have never used a Custom BAPI to send data from Legacy system to SAP system, can you please explain or can any guru can explain.</P><P></P><P></P><P>Regards,</P><P>Kartheek</P></BODY></HTML> Fri, 01 Feb 2013 11:00:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237952#M1719388 Former Member 2013-02-01T11:00:16Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237953#M1719389 <HTML><HEAD></HEAD><BODY><P>kartheek, I have to ask - what is your background? Are you an ABAPer or a developer in some other area? Or not a developer at all? </P><P></P><P>Native SQL I've mentioned allows connecting to external data bases from an ABAP program. This will "push" the data from SAP to external database. BAPI has nothing to do with that. If you want to "pull" data from SAP then it's the whole different story and in this case you'd need to do some development outside of SAP.</P></BODY></HTML> Fri, 01 Feb 2013 15:19:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237953#M1719389 Jelena_Perfiljeva 2013-02-01T15:19:07Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237954#M1719390 <HTML><HEAD></HEAD><BODY><P>Thanks Jelena, i totally understood the concept of Native SQL.</P><P></P><P>But i wanna&nbsp; know how do we use BAPI in an Legacy system, because i have never worked on that part in my career, if you can explain it would be great on your part. </P><P></P><P>Regards,,</P><P>Kartheek</P></BODY></HTML> Fri, 01 Feb 2013 17:54:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237954#M1719390 Former Member 2013-02-01T17:54:13Z Re: Data transfer from SAP to SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237955#M1719391 <HTML><HEAD></HEAD><BODY><P>"Legacy system" is a generic term that usually means "system used before SAP". Since SAP usually replaces a legacy system, then I'm not sure why would company invest in any new interfaces for it. </P><P></P><P>The answer depends on what exactly the "legacy system" is in your case. If you want to call BAPI from outside of SAP (it doesn't actually matter where from) then development should be done on the other side, not in SAP. You've mentioned SQL Server - on MSDN there is a lot of information on how to connect to SAP. There are also tools such as BizTalk and I'm sure many others.</P><P></P><P>I might be wrong but it seems that what you need is really an interface. Basic interface design steps are pretty much the same regardless of specific systems involved. Do some research (Google) on what is available on one side and on the other side. Then decide which side is going to "push" or "pull" and then pick whatever is the best option. </P><P></P><P>That's why I asked whether you're a developer - the question seemed rather strange for someone with development experience...</P></BODY></HTML> Fri, 01 Feb 2013 18:51:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-transfer-from-sap-to-sql-server/m-p/9237955#M1719391 Jelena_Perfiljeva 2013-02-01T18:51:00Z