Solved

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

Posted on 2009-05-09
6
806 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.
0
Comment
Question by:ashokpumca
  • 3
  • 2
6 Comments
 
LVL 22

Expert Comment

by:dportas
ID: 24357706
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
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 24359134
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 ?
0
 
LVL 5

Author Comment

by:ashokpumca
ID: 24361047
I m referring to SAP R/3.  I want to pick the Data from the SQL Tables and Insert them into my SAP Tables.
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 5

Author Comment

by:ashokpumca
ID: 24361105
I want to do this through ABAP. How to Establish a connection from ABAP to SQL Database.
0
 
LVL 22

Expert Comment

by:dportas
ID: 24361498
I'm not an ABAP programmer but I expect you'll find some examples in the documentation.
0
 
LVL 5

Accepted Solution

by:
ashokpumca earned 0 total points
ID: 24464239
FORM get_connection USING p_con_name TYPE dbcon_name
p_con_ref TYPE REF TO cl_sql_connection.
DATA:
sqlerr_ref TYPE REF TO cx_sql_exception.
* create a connection object
IF p_con_name IS INITIAL.
* default connection
CREATE OBJECT p_con_ref.
ELSE.
* open a secondary connection
TRY.
p_con_ref = cl_sql_connection=>get_connection( p_con_name ).
CATCH cx_sql_exception INTO sqlerr_ref.
PERFORM handle_sql_exception(adbc_demo) USING sqlerr_ref.
RETURN.
ENDTRY.
ENDIF.
ENDFORM.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now