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

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close