How to copy the Data From Oracle Table To SAP Table

[Former Member]

Hi Friends,

We need to copy the data from Oracle Database Table to SAP Table. The data should be updated simultaneously in both tables . Should I write a program that contains the native sql statement like EXEC SQL PERFORMING WRITE,....

I appreciate any suggestions regarding this.

Regards

CSM Reddy

[Former Member]

Reddy,

I also want to establish a connection between SAP and Oracle Database. Cud you tell me how you achieved that ?

Is that thru DBCON (SM30) ?

Thanks,

Jothi.

[Frank-Martin]

Hi Jothi,

through the DBCON mechanism ( DBSL Multiconnect ) you can establish a second connection from your SAP system ( running on DB2 ) to an ORACLE database. For example if you want to copy data from the ORACLE database into a DB2 table you can select the data in the ORACLE connection to an ABAP internal table and then insert the data into the DB2 table through the primary DB2 connection.

Another way to make ORACLE table visible in an SAP system running on DB2 is to use the DB2 federated feature. This requires some more DB2 skill to create a NICKNAMES to the ORACLE tables. The advantage is that can access the ORACLE data without explicitly opening a secondary connection in the SAP system. DB2 federated will open a connection to ORACLE implicitly when a NICKNAME is accessed.

Regards

Frank

[Frank-Martin]

Hi,

since you posted this question in the DB2 forum I assume that you are using a DB2 database for your SAP system.

To access a table from a legacy ORACLE database you may use the DBSL multiconnect feature. I.e. you open a secondary connecction in the SAP system to your ORALE database. You can then ready the data from the ORACLE database into an ABAP internal table and insert it afterwards into the DB2 table on the main connection.

Another way to access an ORACLE table from a DB2 database is to use the DB2 federated database feature. This requires a little bit more DB2 skill. With this feature you can make the ORACLE table visible within the DB2 database. To copy data you can then simply use a "INSERT ... SELECT" statement.

Regards

Frank