We help IT Professionals succeed at work.

How to create an Interface with SQL Server 2005 Database with SAP ?

926 Views
Last Modified: 2013-12-08
I want to create an interface of my SQL Database with SAP. We are having attendance software in our company. When the user punches or swipes his/her card the data is stored in SQL Database. Now we want to create an interface between SQL Database and SAP so that all the entries also gets updated in SAP Tables automatically.
Please help me out, how to do this thing.
Comment
Watch Question

Commented:
I guess you are referring to SAP R/3. If I'm wrong then please tell us which SAP product(s) you are using.

A common way to integrate data and other systems with R/3 is via ABAP. Refer to the SAP documentation or consult an ABAP developer.

http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3976358411d1829f0000e829fbfe/content.htm
when you say you want to get the data into sap, do you mean actually insert rows into sap's table, or do you want to use some sap api ?

Author

Commented:
I m referring to SAP R/3.  I want to pick the Data from the SQL Tables and Insert them into my SAP Tables.

Author

Commented:
I want to do this through ABAP. How to Establish a connection from ABAP to SQL Database.

Commented:
I'm not an ABAP programmer but I expect you'll find some examples in the documentation.
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.