February 28, 2005, 12:58 AM
<jpav>DataMigrator: Pros and Cons
Hello everybody. We are currently looking at the demo version of DataMigrator for our ETL purposes(for Windows). Basically, we want to
- read in tab (or comma) delimited flat files,
- convert them to fixed width,
- send them to an internally created command line program that does some basic validation
- then we want to do some joins,
- create new columns,
- conduct complex validations and
- then save to Unicode fixed width files.
- Is this doable in DM?
- How does DM stack up against Data Integrator from Business Objects?
- Are there any pros and cons to using DM?
March 14, 2005, 12:09 PM
BoogarweedWe use DM extensively. I believe it will do all you are looking to do. I do not have experience with everything you are asking but I don't see any problems. It would be interesting to see your findings after you finish your evaluation.
April 04, 2005, 06:39 PM
BoogarweedDid you ever complete your evaluation? I would like to know your findings if you don't mind sharing.
April 19, 2005, 02:21 PM
S.J. KadishAre there any downloadable or online courses for learning the iWay DataMigrator? Our schedules preclude attending classes for the foreseeable future.