Direct insert into a remote Oracle RDBMS (not running SAP) from SAP. Can it be done from SAP?
Basis, Interaction Center Technology, MySAP, mySAP Enterprise, Oracle, R/3, SAP, SAP development, Workflow
We need to insert SAP data directly into a staging table in a non-SAP app on a remote Oracle 9.2 DB. We've been given write access to only this one table in the remote Oracle DB.
Currently, we create a flat file in SAP (on a DB400 DB), FTP the file to an intermediate Oracle DB owned by our group, SQL*Loader it into our Oracle DB, then use Oracle's database link technology to insert into the table in the target remote Oracle DB.
Can we write to this table directly from SAP? How do we do it (Function module, BAPI, native SQL, or what)? Thanks!
Software/Hardware used:
Software/Hardware used:
ASKED:
April 28, 2005 2:55 PM
UPDATED:
June 1, 2005 2:51 AM
Answer Wiki:
Hi,
If DBlink was already set, You may use the native sql commands for updating.
*--to connect
* where gd_connect contains the logical name for the
* database connection set up by your BASIS team
* SAMPLE connection only "ITSCON"
GD_CONNECT = "ITSCON".
EXEC SQL.
CONNECT TO :GD_CONNECT
ENDEXEC.
*---Populate your internal table having thesame structure
*---as with the remote DB
it_oradb-<field1> = <value1>
it_oradb-<field2> = <value2>
append it_oradb.
*--to insert
EXEC SQL.
*--then you can insert here the normal SAP SQL commands
INSERT <oradb> from table :it_oradb
ENDEXEC.
Thanks,
Jowen
To see all answers submitted to the Answer Wiki: View Answer History.
Hi,
If DBlink was already set, You may use the native sql commands for updating.
*–to connect
* where gd_connect contains the logical name for the
* database connection set up by your BASIS team
* SAMPLE connection only “ITSCON”
GD_CONNECT = “ITSCON”.
EXEC SQL.
CONNECT TO :GD_CONNECT
ENDEXEC.
*—Populate your internal table having thesame structure
*—as with the remote DB
it_oradb- =
it_oradb- =
append it_oradb.
*–to insert
EXEC SQL.
*–then you can insert here the normal SAP SQL commands
INSERT from table :it_oradb
ENDEXEC.
Thanks,
Jowen
I don’t market this product but have you considered using TAVIZ
The product provides links from multiple foreign databases to Oracle including interfaces into Oracle Apps.
The advantage of Taviz is that you can clean up data and gather statistics on rows extracted, loaded etc.
The downside may be cost. It is some years since I used it on a project but its merit was that it worked. In complex loads Taviz was sometimes thought to be slow, but this was usually down to the Apps architecture rather than the basic load activity. Arthur Davies