Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Pierre_Richer on Feb 1 at 10:35 AM Hi, I agree with Horacio. Both methods are ok but i prefer the ABAP Side using Native SQL with the help of table DBCON. It always depends how your client wants it's Oracle DB refreshed and how often. If it's on demand from .NET front-end, use RFC. This way you don't even have to duplicate the tables (in SAP and Oracle), just the SAP one would do. If it can be done async...use a schedule job (every hours, 30 minutes, 10 minutes no matter) in SAP with an ABAP program using Native SQL. Or, use a .NET program that loads the data from SAP into Oracle using the Windows scheduler. Pierre
| | | ---------------Original Message--------------- From: john.louk Sent: Friday, February 01, 2013 9:55 AM Subject: How to Insert Data from SAP Ztables to Oracle Tables? I would lean to what Horacio has given you on the RFC (Remote-enabled) approach. You could also publish a web method. Both allow the external application to access your custom tables. This keeps you from having to look at whether your tables are in sync at the time the external system reads this other Oracle table. Cheers John | | Reply to this email to post your response. __.____._ | _.____.__ |