I have two different servers. On one server local application is running with SQL database on an NT system while...
other server is my SAP server. Everyday I have to migrate certain data from my local server to SAP server. How can I automate this process? Can I use native SQL in ABAP/4 to access remote server (i.e. non SAP system)?
You have three choices that I can think of:
1. Write a program to extract data from your SQL database to a flat file. Write an ABAP program that picks that data up from you application server - perhaps using FTP as an external command.
2. Using the Java RFC kit, or COM4ABAP or suchlike, write an application in Java or VB, which extracts the information from your SQL database, and then uses RFC to send the information to your SAP server. The function module called on the SAP server then handles the sent data as you wish.
3. Use ABAP EXEC SQL, to make the connection to your SQL database, and grab the information that way. To set this up will require working with your SAP Basis team to give SAP appropriate rights to your database. There are notes on what to do in OSS. Search for keyword DBCON in OSS.
Dig Deeper on SAP ABAP
Related Q&A from Matthew Billingham
An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header.continue reading
An SAP user needs information on how to change the password on several SAP user accounts from a central location.continue reading
An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.