-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- SAP Business Suite
- Artificial Intelligence
- Business applications
- Data and analytics
- Technology Platform
- Financial Management
- Spend Management
- Supply Chain Management
- Human Capital Management
- Customer Experience
- SAP Business Network
- View products A-Z
- View industries
- Try SAP
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Re: fetch data into SAP from SQL Server
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
fetch data into SAP from SQL Server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2010 Aug 18 11:14 AM
- SAP Managed Tags
- ABAP Development
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2010 Aug 18 1:04 PM
- SAP Managed Tags
- ABAP Development
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2010 Aug 18 1:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2010 Aug 18 1:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2010 Aug 19 4:53 AM
- SAP Managed Tags
- ABAP Development
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
Bluesky