When it comes to managing their EDI infrastructures – especially their maps – retailers have it rather easy. They define their formats and then tell their suppliers to deliver their EDI documents in that format. Suppliers, on the other hand, have a significant challenge on their hands. They have to meet the formats, standards and data requirements of each retailer. Shoot, many still have to keep translation tables to cross-reference retailer versions of product numbers with their own manufacturer or GTIN numbers. What a nightmare!
Just getting started is a challenge, but thinking about the long-term is another problem altogether. And if the long-term isn’t considered at the very beginning of a project, a substantial amount of corporate risk can be associated with the way a company chooses to create and manage their EDI maps. In short, there are three primary ways of managing maps. The first is a one-to-one model where every transaction with every trading partner is handled with an individual map. The second is a one-to-many model where similar transactions for multiple trading partners are handled within one map. The final model utilizes a “canonical” method where all data is mapped to an “internal standard” format and then mapped again into whatever output format is needed – and might also include aspects of the one-to-one or one-to-many model – or both.
The One-to-One Model
While many will argue the merits of all of the formats, the one-to-one model provides the lowest risk option for companies. In the long run it might also prove to be the least costly and most manageable option as well. Individual maps are created for each transaction for each trading partner. Where possible, maps are “cloned” or duplicated, renamed, and then used for new trading partners. Minor or major changes are made to make sure the map meets the customer requirements, and then the map is tested with the trading partner. All the separate maps require a strong document governance process to make sure everyone knows where each map for each trading partner can be found. Companies also must make sure each map is referenced in the translation tools that utilize the map. Though many maps are created, this is the simplest and safest method to create and manage EDI maps.
The One-to-Many Model
The one-to-many model looks exciting on the surface. Fewer maps need to be developed because maps are shared across multiple trading partners. However, each map is more complex – sometimes exceedingly so. If multiple companies are utilizing one map, conditional statements (“If partner A, do this. If partner B, do something else”) within the map will most likely need to be made. While this reduces the number of maps to manage, it means that if a change is ever made for a trading partner, it is imperative to re-test with ALL trading partners using that map or risk transaction failures. However, it isn’t easy or customer friendly to keep going back to your customers and asking them to re-test a transaction they have tested already. From a business standpoint, you are left with the option of increasing operational risk (and potentially customer satisfaction) by not testing with every company using the map or absolutely decreasing customer satisfaction by re-testing with each customer. Neither is a good option, with the former providing potentially catastrophic risk if a mapping problem impacts a major transaction or multiple customers at one time. Also, when managing documents, it will require a significant effort to document the code in each map to make sure each individual customer’s requirements are called out in the code comments, and then equal efforts to track which trading partner uses which map within the appropriate tools. A potential mitigating step, exits, however. That would be to move each trading partner to its own map once they requested a change to their shared map. Eventually this B2B program would look exactly like the One-to-One Model.
The Canonical Model
The canonical model has been pushed since internal integration and enterprise application integration tool vendors tried to move into the EDI market. In fact, some internal integration companies made the use of canonical models the basis of the entire operations of the backbones of their applications. The theory is that a company can map their back office systems into a neutral format and then map from the neutral format to any other format needed by a trading partner or other internal system. Supposedly this helps mitigate risk associated with ERP migrations and cross-application internal integration, but it introduces all sorts of other risks that don’t make a lot of sense for B2B transactions. For instance, if the field level requirements for a canonical format ever need to be changed, then there is a potential to impact all transactions that use that canonical format. Also, instead of doing one map for a transaction, a company needs to do multiple maps – one into the canonical format for each back office system and one out to the trading partner. This, then, is the 1+ map method. In fact, the canonical model can be seen as a combination of the other two models where a one-to-one approach is used from back office systems into the canonical documents and then either a one-to-one or one-to-many approach is used to go from the canonical model to each trading partner.
While the canonical format might help in massive internal integration projects, it doesn’t necessarily help B2B projects – and can in fact negatively impact them if the tool utilizing the canonical format doesn’t support the same validations and limitations necessary for assuring EDI success. Finally, the idea that you spend extra time 1+ mapping up front for B2B to minimize ERP migration risks down the road seems strangely off-base, since the cost of re-mapping is usually an insignificant part of any ERP migration. What should be of more concern is the potential costs of redoing all the maps if the application changes at some point and requires a change to the canonical format, the way maps are built/used, or something else that impacts translation and/or transactions – and there isn’t a big budget ERP project to absorb the costs.
If You Outsource
No matter which model you chose, if you do it yourself, you face the risk of having to redo/revise every map each time your translation software vendor significantly upgrades their application. Sometimes a transition tool/process is provided, but sometimes the applications change so drastically that wholesale remapping needs to be done. Choosing to outsource means that your outsource provider will cover those migration costs themselves, reducing your variable costs and potential risks. And because your outsourcing vendor will eat those costs for all their customers, it is in their interest to make sure the transition to new tools is seamless and cost effective. And because of SLAs, the risks should be low, too.
Managing Your Corporate Risk
The challenge of managing corporate risk has always been of concern for certain executives, but today risk has become a more common topic. Combine government regulations (e.g. Sarbanes-Oxley) with industry mandates and activist stakeholders, and C-Suite residents are more risk adverse than ever. Now might be a good time to take long hard look at your EDI and other B2B operations. If you are utilizing a one-to-many or canonical method, you might want to consider a one-to-one model when you need to change your EDI infrastructure – or if you are experiencing too many negative business impacts tied to EDI. If you are considering a change anyhow, ask your vendor how they recommend your maps be done. The one-to-one model provides the safest method for building and managing maps over time. If you are looking to outsource, make sure your outsource vendor provides one-to-one maps to minimize risk and maximize value in the long run.