Integrated Cloud-Based Oracle OTM with Custom ERP – Decade Cost-Effectively
We enabled a bi-directional, file-based Oracle OTM Cloud integration with the client’s legacy ERP to streamline shipping operations without middleware.
the client
A US-based manufacturer of stainless steel sinks, faucets, and kitchen cabinetry headquartered in Downers Grove, Illinois.
Downers Grove – Illinois
Industry
Manufacturing
Engagement Details
- Project name: Oracle OTM–Decade Integration
- Complexity: Medium
Technology Stack
- Oracle OTM Cloud
- Custom ERP (Decade)
- XML
- Reverse Proxy Scripts
Business Need
File-based integration with Oracle OTM on the cloud with in-house custom ERP system – Decade.
Challenges
- Integrate cloud-based Oracle OTM with custom ERP – Decade.
- Integration needs to be bi-directional exchanging of information on a periodic basis (batch mode).
- Design needs to incorporate one-time guaranteed delivery of the message.
- No middleware is in use at Elkay.
Solutions
- Designed a solution leveraging an intermediate shared directory for the exchange of information between Oracle OTM and the On-Premise Decade system.
- From Oracle OTM, information is downloaded to a shared directory which is then processed by inbound programs in Decade.
- Outbound programs are written, For uploading information to OTM, which creates an XML file and stores the file in the shared directory.
Result
- Credentials for both systems are in respective programs, and only shipping information is exchanged.
- Reverse proxy is used to avoid any security concerns.
- Cost-effective XML-based integration was adopted to meet Elkay’s needs.
- Ability to reprocess a particular order on a need basis is also available.