Saturday, September 5, 2009

Marketing Database Interface and System for Junction Solutions/MS DAX (Microsoft Dynamics AX)

One of our major clients with more than 11 million customers is successfully migrating from MACS by Smith-Gardener/Ecometry/Escalate to Junction Solutions MS DAX system.

We have been handling their circulation modeling and list pulls for several years. There are many significant challenges migrating from one legacy system to another. An area often neglected is the connection between the old data and the new. Not only does a new file structure require a new interface into the marketing database, but also, new product categories, customer types, division codes, group codes, suppression codes all have to be unified on the database. Most importantly, if customer segmentation is required, old product classifications must be converted to new systems so that customer preferences will include both new and old (so we can figure out what kinds of products they prefer).

Jim Berry, our database guru, said, "Most people don't realize that conversion of an existing marketing database to a new operations system is more difficult than building one from scratch."

Bottom line, if you have either, MACS or DAX, we have an interface and database ready for you.