Let’s talk!

Kindly provide your details, we will reach you shortly.


Contact Us

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.