topic Re: How to Import and Export data from and to a SQL Server Database in Application Development and Automation Discussions

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

Former Member — Tue, 21 Jan 2014 07:19:02 GMT

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

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

Former Member — Wed, 22 Jan 2014 15:15:44 GMT

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

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

ec1 — Thu, 30 Jan 2014 22:14:39 GMT

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-bb2c48b78dfa?QuickLink=index&…