Data transfer from SAP to SQL Server

[Former Member]

SAP Gurus,

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.

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.

Can we pick up data from application server of SAP to SQL Server ? If yes, can you please explain ?

Does FTP file transfer works ?

http://saptechnical.com/Tutorials/ABAP/FTP/Index.htm

Thanks

kartheek

[schneidertho]

Hi Kartheek,

have you thought about this: http://help.sap.com/abapdocu_70/en/ABENOPENSQL_MULTICONNECT.htm

Best regards

Thorsten

[Jelena_Perfiljeva]

Remote database connection and Native SQL (see ABAP help) seems like an obvious solution, unless there is more to it...

[Former Member]

Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?

Thanks and Regards,

Kartheek

[Former Member]

Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?

Thanks and Regards,

Kartheek

[Former Member]

Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?

Thanks and Regards,

Kartheek

[Former Member]

Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?

Thanks and Regards,

Kartheek

[Former Member]

Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?

Thanks and Regards,

Kartheek

[Former Member]

Thanks a lot both for your information, i have a small doubt, can we send data through a BAPI to SQL system ?

Thanks and Regards,

Kartheek

[Former Member]

This message was moderated.

[Former Member]

Hi Kartheek,

Can you check with SAP Jco Connector . ?

Regard's

Smruti

[Former Member]

Sorry Smruti, dont have an idea about SAP JCO COnnector, Can we do it with the help of BAPI ??

Regards,

Kartheek

[Former Member]

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 . 

Regard's

Smruti

[Former Member]

Thanks a lot for your quick answers.

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.

Regards,

Kartheek

[Jelena_Perfiljeva]

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?

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.

[Former Member]

Thanks Jelena, i totally understood the concept of Native SQL.

But i wanna  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.

Regards,,

Kartheek

[Jelena_Perfiljeva]

"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.

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.

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.

That's why I asked whether you're a developer - the question seemed rather strange for someone with development experience...