Data Transfer

[adnanmaqbool]

Respected Guys

Is there any way to transfer few fields from different tables located on a Database Server used by SAP to an other database used by an another application. The other database also have same fields and and Tables structure.

Both databases are located on different servers and are oracle9i.

Is there any way to transfer real time data from one database to another. If not then any way by which we can preiodically can transfer the data.

Thnx

[Former Member]

it actually depends on the capability of the third part system to accept the data. For example let me assume that your other data base system is able to accept data in a tab seperated text file. In that case you can write a program to download the contents from SAP into a text file and place it in a folder where the other system will be able to pick it up and process the same. If you want this to happen on a periodic basis then you have to schedule the job.

Alternatively, you can do a export from your current DB and import the data into your other DB. This will be purily a DB to DB copying.

Regards,

Guru

[adnanmaqbool]

But isnt there some thing involve like BAPI BADI or IDoc which can help in this regard. or what about replication of current data to another. Which is again purely DB to DB task.

Please note I need some tip which can work on real time system. Basically we want to transfer SAP data to anoter database which a GPRS system is using to get and send data on spot in field.

[Former Member]

Not sure about a BAPI, but you can always do it through a IDOC. you can define a IDOC structure similar to yoru table structure and write a program to post these IDOCs to yrou other DB system. This will also work.

This shoudl be sufficient to solve your problem.

- Guru

[adnanmaqbool]

Dear Guru

Thnx for your reply. Can u provide me any documentation on Idocs which can help me in this regard.

As I told you there are two databases server, one of them is used by SAP. Its ok I can deal with Idocs at the server linked with SAP but what about other database server. As no ABAP would be available there how Idocs can be controlled there.

Thnx

[Former Member]

I dont have any document with me. But as I mentioned earlier acceptance of data in the non-sap data base depends on its capability. A solution to automate the non-sap system is write a script and schedule the script to run on a periodic basis to import the data sent by SAP.

- Guru

PS : Dont forget to rewards points if the answer is helpful to you.