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.

Thnx

[Former Member]

Dear Adnan

Lars is right..

Yes with a complicated PL/SQL script you can transfer few fields of a table.But it is not recmd.

Yes there are some ways like Replication,Dataguard Etc which will transfer real time data from one database to another.This is at table,schema or database level.

One well known and easy method is Export and Import.

Regards

Vinod

[lbreddemann]

Dear Adnan,

this requirement should not be met by using direct sql data access.

Build a (B)API for it in the WAS.

Besides the fact that you never should access SAP data directly on the database (think of the loss of security, access auditing, client seperation, oracle licensing terms etc.) imagine what happens if the SAP data structure is changed.

With the db -> db approach you've to change the transfer function and probably the target db as well.

When using a API for this all you've to change is the implementation of that API. The target system(s), the interface, the transfered data: it just stays the way it is.

That said you shouldn't really want to access the data directly.

If you still decide to do so, then think about oracle's dblink-Feature.

With it you can do use objects (like tables, views etc.) in remote oracle databases.

A typical statement would then look like that:

SELECT * FROM DUAL@<dblinkname>;

Since I really don't recommend this solution, please help yourself in looking up the details on it in the oracle documentation.

Best regards,

Lars