Cloud Integration Case Study

Ability to reprocess a particular order on a need basis is also available.

Client

US manufacturing company. Manufacturer of stainless steel sinks, faucets and kitchen cabinets.

Industry

Manufacturing

Engagement Details

Oracle OTM Cloud Progress based Decade

Location

Downer’s Grove – Illinois

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.

CES Managed Security Services is a trusted partner for your organization's all security needs.

Contact us online
Chevron Up