Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

How to Import and Export data from and to a SQL Server Database

Former Member

‎2014 Jan 21 7:19 AM

0 Likes
1,688

Hi,

Greetings, I am novice to SAP and hence need your urgent help in addressing a problem i am facing.

We have a system in SQL SERVER. We want to post data to SAP and Fetch Data from SAP.

Kindly suggest how can we proceed. I was just told that using BAPI it is possible. Can anyone help me on this please? I don't know what's correct way to proceed using BAPI. whether I need to write BAPI and whether writing BAPI will suffice to push data to SQL Server DB and retrieve and update in SAP?

Any tool/ setup i need to use to connect to SAP or write BAPIs? Any prerequisites.

Thanks in advance. appreciate quick response.

Mayuresh

Hi,

Greetings, I am novice to SAP and hence need your urgent help in addressing a problem i am facing.

We have a system in SQL SERVER. We want to post data to SAP and Fetch Data from SAP.

Kindly suggest how can we proceed. I was just told that using BAPI it is possible. Can anyone help me on this please? I don't know what's correct way to proceed using BAPI. whether I need to write BAPI and whether writing BAPI will suffice to push data to SQL Server DB and retrieve and update in SAP?

Any tool/ setup i need to use to connect to SAP or write BAPIs? Any prerequisites.

Thanks in advance. appreciate quick response.

Mayuresh

Reply
2 REPLIES 2
Read only

Former Member

‎2014 Jan 22 3:15 PM

0 Likes
659

Hi Mayur,

Yes this can be done by BAPI's, you have to first decide which BAPI to use.

There are many standard BAPI's available in SAP which can be used for fetching and inserting data from and in DB.

Decide what data you will be inserting in DB, Like data related to sales order or customer and than search for relevant BAPI.

I think this may help to start with.

Regards,

Ganesh

Read only

ec1
Active Participant

‎2014 Jan 30 10:14 PM

0 Likes
659

Hi Mayuresh,

I just want to add comments from Ganesh.

If you have SSIS installed on your SQL server, you can SSIS to extract or import data from SAP. Please have a look at the following link for detailed information

http://msdn.microsoft.com/en-us/library/dd788623(v=bts.80).aspx

For more information about BAPI, I found the following tutorial useful to get my head around finding correct BAPI and how to use it.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/200dd1cc-589e-2910-98a9-bb2c48b78...