cancel
Showing results for 
Search instead for 
Did you mean: 

Transport of data from SAP Database to Another Oracle Database

biswajit_das6
Participant
0 Kudos

Hi Experts,

Our requirement is after creation of Purchase Order No. in SAP we have to transport that no. to another database which is same as our SAP DB( that is Oracle 10G).

Please help me to do that....

Eagerly waiting for reply.

Thanks & Regards,

Biswajit

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Biswajit

Please make your question little more clear, as your SAP sytems must be residing on some DATABASE like oracle9i or 10g or db2, and what this other database oracle 10g, what is the application on it ?

thanks

Bhudev

biswajit_das6
Participant
0 Kudos

SAP Db also is Oracle 10G.

Annd the Application is JAVA

biswajit_das6
Participant
0 Kudos

Other DB is also Oracle 10G.

And the Application is JAVA..

Former Member
0 Kudos

Hello Biswajit

Are you working on Portal ?

Like we transfer the changes in SAP ABAP, from one system to another via Transports, then you can do that in portal too ..

or you are asking for workflow ? that too can be done for both

thanks

Bhudev

biswajit_das6
Participant
0 Kudos

Actually the thing is there is an Java related application from which we are transporting data to SAP via JACO.

but we need to transport data also from SAP to that application in run time . That we can not do via JACO coz it only works while JAVA to SAP connection is made but we need to transfer data from SAP to java even when JAVA to SAP via JACO is not connected .

I want to know how can we do that?

Here is simple flow....

Application1

JAVA--


>JACO--


>SAP

return

DB<--JAVA<


JACO<--


|

Here JACO is always needed to connect SAP.....

But our requirement is

Application1

DB<----


SAP

(not via JACO)

Waiting for reply...

Thanks ........

Former Member
0 Kudos

Hi,

1. you would define a remote database connection to your non-SAP Oracle DB via DBCON transaction.

2. Use this connection i.e. in an ABAP FM that connects to the Oracle DB

3. Update the table(s) via the connection

i.e. in your SAP database via DBCON you defined a connection ORADB pointing to your remote Oracle DB:

Later you use this conenction in an ABAP Function module:

...

EXEC SQL.
CONNECT TO 'ORADB' AS 'ODB'
ENDEXEC.


EXEC SQL .
Insert into oradb_table values (:your_SAPdata_field1, :your_SAPdata_field2 )
ENDEXEC.

EXEC SQL.
CLOSE 'ODB'
ENDEXEC.

...

you need some program skills in native SQL with Oracle

Check for DBCON , native SQL, remote database connection

bye

yk

Answers (0)