Q

Automated migration between servers

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)?

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.


This was last published in July 2001

Dig Deeper on SAP ABAP

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchHRSoftware

Close