Unifying E-Commerce Systems to Streamline Business Processes: Integration of JDE ERP and Magento

checklist
  • Duration: 1 year
  • Industries: E-Commerce; Marketing, Advertising, Sales; Manufacturing
  • Services: Backend Development; Custom Software Development; Software Integration Services
  • Software Categories and Types: Integration Solutions
  • IT Architecture Paradigms and Approaches: Enterprise Integration Patterns
  • Technical Expertise: Java Server Side Development; Databases; MuleSoft Implementation and Integration; Data Transformation
  • DevOps Expertise: Linux Advanced; Advanced build organization; CI/CD Basics; CI/CD Advanced; Monitoring Systems
  • Technologies: Git; Mule Runtime; Data Bases; Project Management, Collaboration and Bug Tracking; Jira; Java; Elasticsearch; Logstash; Backend; Spring; Development Infrastructure and Tools; Anypoint Studio; Kibana; Mule ESB; Microsoft SQL Server (MSSQL); Source Code Management (SCM); MUnit; Message Queues and Service Buses; Software Engineering and Management Tools; Various Platforms, Solutions and Engines
project-team
  • Team size (3):
  • 1 Project Manager
  • 2 Backend

Project summary

thumbnail-image

Our team had several major tasks. The first task was to develop the solution which allows performing the initial import and following data synchronization from the currently used JDE ERP system to the new eCommerce platform – Magento.

The business model of the customer company assumes that its clients receive different, distinct prices for goods and services. So, our second task was to display prices in a targeted way – own set of prices for each client. Therefore, our solution should also provide an API to get pricing information for each specific client.

The architecture solution includes the following software modules:

  • FTP to Staging DB import component
  • Data from JDE is uploaded to FTP in form of files with fixed length fields.
  • A separate file is created for each customer. Customer ID is specified in file name.
  • This module reads files and uploads data to Staging DB.
  • Pricing REST API
  • This component allows you to get information about prices for a specific customer (and if necessary – for specific SKUs).
  • Magento import component
  • Synchronizes Staging DB and Magento according to the schedule.
  • Synchronization is performed by the incremental method.

Technologies

Stack: Java SE 8, Mule 4.2 Community Edition.

Infrastructure: Git, Anypoint Studio, Jira, Elasticsearch, Logstash, Kibana.

Frameworks: Spring 5.

Test Automation libraries: MUnit.

DB: MS SQL 2016.

Screenshots

A description of showing relations in Magento-import-component
The diagram showing relations in Magento-import-component

The process of importing new records from the DB into Magento is launched daily at a certain time. Initially, the component sends a request with a list of new item numbers to find out which of them should be updated and which should be created. After receiving a reply the process is divided into 2 subprocesses: products update and creation.

Project features

  • Fixed project duration.
  • The decomposition at all levels of the project was done by the JazzTeam engineers based on the business requirements specified in the BRD (Business Requirements Document) which did not contain technical details.
  • Mule CE (Community Edition version) was used, additionally, we handled limitations associated with:
  • absence of software modules (connectors) from EE version (Encrypted Properties, Transform Message component).
  • CE version has a limited set of available Input Stream implementations that creates performance issues in some situations.
  • CE has open bugs that were closed in EE version of Mule.

Project result

  • The team has effectively completed assigned duties, performed its functions.
  • All iterations were successful in accordance with estimations and milestones.

The company’s achievements on the project

  • The team has successfully completed the task by implementing an intermediate integration layer, which made it possible to constantly synchronize data between JDE and Magento.
  • We actively participated in the stage of integration requirements clarification (file formats, data volumes), suggested ideas for implementation.
  • Taking into account our rich Mule expertise, we were able to foresee many potential bottlenecks, complex situations, were taking them into account and immediately “closing” them during the development.
  • The team managed to bypass all the limitations imposed by the Community Edition version of the runtime environment and to achieve all the set goals.
  • The team has completed the full development life cycle, beginning with the clarification of requirements and system design and ending with the preparation of a complete package of accompanying documentation, support and delivery of the project to the customer.
  • The solution has been documented according to SOP (Standard Operating Procedures).

What we did on the project, our responsibilities

  • Configuration of infrastructure and working environment.
  • Installation and setting of necessary software.
  • Design and creation of StagingDB tables.
  • Direct development of all three components.
  • Solution documenting.
  • Performance of various types of testing by the development team.
  • Identification and discussion of requirements directly with the customer.

Clients about cooperation with JazzTeam

Related projects

Recent Work

    Contact Us

    What happens next?
    • 1

      Leave your project request. We will contact you and schedule a call.

    • 2

      Signing of the NDA to ensure the project info confidentiality.

    • 3

      Negotiation of your request and the required services.

    • 4

      Team forming, coordination of workstages.

    • 5

      Contract signing and project start.