topic fetch data into SAP from SQL Server in Application Development and Automation Discussions

fetch data into SAP from SQL Server

Former Member — Wed, 18 Aug 2010 10:14:51 GMT

Dear Guru,

I have a table in SQL server, i want to fetch data table into SAP and use in my program.

So it is possible to access sql server table into SAP and How i will use that table inside SAP.

thanks,

man

Re: fetch data into SAP from SQL Server

Former Member — Wed, 18 Aug 2010 12:04:58 GMT

Answer copied from - points removed.

When I understand you right you want to write a report in ABAP that can store data in an MS-SQL database that is located on an other server than your SAP database. Is that right?

If yes I would suggest looking into ADBC (wimre that stands for ABAP DataBase Connector). There are some classes like CL_SQL_STATEMENT that allow this. One requirement is that you have installed the right DBSL (if your SAP system is running on a MS-SQL DB that is ok anyway) and. Then you have to maintain an database connection to the remote system. Transaction DBACOCKPIT is one way to do that.

As I'm posting that from home and not being in the office I don't have access to all documentation at the moment so I cannot go into detail here. And I fear there is not much documentation available in the public at all. But if you search for it you will find something.

But please remember one drawback of using ADBC (or EXEC-SQL or anything like that): You are writing native SQL that is executed on the database. ABAP syntax checks cannot help you at all. And you can do a lot of damage when accessing a database directly without good knowledge of what you are doing.

installed Microsoft Data

Access Components (MDAC) and DBMSSLIB.DLL 32 bit instead of 64 bit.

Edited by: Matt on Jun 9, 2011 11:25 PM

Re: fetch data into SAP from SQL Server

Former Member — Wed, 18 Aug 2010 12:08:09 GMT

Deleted...

Edited by: BreakPoint on Aug 18, 2010 2:09 PM

Re: fetch data into SAP from SQL Server

former_member233090 — Wed, 18 Aug 2010 12:12:23 GMT

Hi Manish,

go through this link [Forum|]

/message/5328259#5328259 [original link is broken]

Cheers,

Bhavana

Re: fetch data into SAP from SQL Server

Former Member — Thu, 19 Aug 2010 03:53:41 GMT

guru's,

I have one more query, if i were save excel file in my local system, and then through some .net application i want to upload that file into SAP RFC internal table, then it will upload the file in int. table or not.

And where we will save that excel file in SAP application server or .net server or local system.

thanks,

man