I am looking to integrate webmethods (wM7) with Oracle R12. I know we can use wMJDBC adapter to integrate with oracle 10g, oracle apps adapter to integrate with oracle 11i.
I know a solution where webMethods to oracle 11i integration is done using JDBC adapter where oracle 11i will be populating the staging tables from where webMethods will extract data using JDBC adapter.
Now would be the best solution to integrate with oracle R12 ? Does the staging table strategy works? will Oracle apps adapter be useful in integrating with Oracle R12? Plz suggest.