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

0 pts.
Tags:
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!
ASKED: April 28, 2005  2:55 PM
UPDATED: June 1, 2005  2:51 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JOWENAB
    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
    0 pointsBadges:
    report
  • Arthur101
    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
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following