Guide to Data Conversion Software

Don't select a data converter at the last second

Data conversion is often an afterthought when launching a new system; everyone instead focuses on the new software and how to make it as strong as possible. While this is great, it will all be for naught if you can't access your historical data without opening your old system. Be sure to include your data conversion utility software planning in as early a step in your system design as possible.

I recommend: Adeptia Data Transformation Server includes 3 distinct components, including a Design Studio that can be used early in your system design process.

Research if your data conversion software can handle the type of historical data you're moving

The ability of modern data conversion tools to handle your historical data can often depend on when your former software program was written. The older your software, the more difficult it is for one of today's data conversion applications to handle it smoothly. Therefore, it's critical to know the type of data you have on hand as well as how it's stored in your system.

I recommend: Altova MapForce allows conversion of data types including XML, database, flat file and EDI. AdventNet SwisSQL maps data across a variety of standard database schemas.

Tailor your choice of software for data conversion to your IT team's expertise level

While it would be ideal if your entire IT team was thoroughly knowledgeable on how to enact a successful data conversion effort, the truth is that this is not likely. Instead, you should focus on finding a data conversion program that allows your team to focus on the part they know best--the data itself--and takes care of the difficult part of the conversion of data on its own.

I recommend: Astera's Centerprise Integration Studio utilizes data transfer wizards to make the conversion as smooth as possible.