EDI Mapping App Case Study

Team:  Me as sole designer w/ PM point of contact

Focus:  Full design process from research to execution

Summary

I recently undertook a freelance project for an anonymous client to design an EDI mapping application supporting their B2B integration operations. With no prior experience designing software in this domain, I chose to follow Alan Cooper’s Goal-Directed Design process rigorously to ensure my work was grounded in solid research rather than assumption.

What is EDI Mapping?

EDI (Electronic Data Interchange) mapping is the behind-the-scenes process that connects one business’s eCommerce or ERP platform to another’s eProcurement system, allowing them to exchange structured business documents automatically and accurately. This gives buyers an experience not unlike purchasing on Amazon, but using pre-negotiated contracts and prices.

EDI mapping always involves three components:

  1. A source schema – the structure of data coming from one platform (e.g. a purchase order from Coupa)
  2. A target schema – the structure expected by the receiving platform (e.g. an 850 transaction set for a vendor’s ERP)
  3. A transformation map – the logic that translates source fields to target fields

These three components are grouped into Packages. Source and target schemas can be reused across multiple packages, but each transformation map is unique to its package since every trading partner relationship has its own data requirements.