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!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!