Question

  Asked: Apr 28 2005   2:55 PM GMT
  Asked by: hof11a


Direct insert into a remote Oracle RDBMS (not running SAP) from SAP. Can it be done from SAP?


Interaction Center Technology, Oracle, SAP, Basis, MySAP, mySAP Enterprise, R/3, 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!

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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
  • AddThis Social Bookmark Button

Browse more Questions and Answers on CRM, Oracle and SAP.

Looking for relevant CRM Whitepapers? Visit the SearchCRM.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

JOWENAB  |   May 24 2005  4:59AM GMT

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

 

Arthur101  |   Jun 1 2005  2:51AM GMT

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