Our company is currently involved in a project in which we will replace our legacy systems with an Oracle Applications ERP system. webMethods has been chosen as the integration tool to be used during and after the migration. For that reason, I am working on identifying the best possible way of integrating webMethods with the Oracle App.
Initially, I had in mind simply connecting to the Oracle tables via the JDBC adapter. I then heard Oracle came with an e-Commerce Gateway that would probably facilitate most of the integrations. Recently, however, I learned that webMethods had an Oracle Apps adapter (WmOAAdapter).
I was wondering if any of you have used this adapter and if you could tell me if it’s worthwhile. In other words, is there really an advantage to using the Oracle adapter versus simply using the JDBC adapter? Have you experienced any problems with the adapter?
If possible, please elaborate on what type of transactions you use the adapter for. I am interested in being able to create orders; retrieve shipment and invoice records; create, update, and retrieve product and customer records, etc.
Also, if you have integrated with an Oracle Applications system without using the adapter, I’d be interested in learning about your experience.