Astera Solution and Results
After evaluating various available tools, the food services company chose Centerprise because it was able to do exactly what was needed. Ilmer was able to use the visual drag-and-drop mapping with little fuss. He leveraged Centerprise’s static lookups to easily build the code translations for each supplier’s status codes and the database lookup to find the correct customer based on the supplier’s own customer identifier. In short, Centerprise delivered a simple but effective solution to an otherwise tedious problem.
After some initial setup to develop the mappings for each supplier, Ilmer is able to transform and import data into his own system in no time. In fact, he runs the transformations from a command line and simply double-clicks a batch file when he gets new supplier data. With manual spreadsheet manipulation out of the way, Ilmer is able to concentrate on processing rebates faster and without the context switch that was frequently involved.