Simple file transformation tools, where are they? 2
Submitted
by
cs668
cs668 writes "There is a part of our business that does one time loads of data. It comes from the customers in varying formats and can be anywhere from 5,000 to 500,000 records. Our import processes use XML. Currently we are using Excel to transform the data from the customers format to our XML. It's the wrong tool for the job.
We are looking for a good data transformation tool that makes it easy to graphically define the transformation, allowing the input format to be easily defined and constraining the output to the XSD for our XML. Here is the problem, every tool we can find is geared at writing code, or the part of some massive ETL architecture intended to be the MOM of your entire enterprise. It seems like 10 years ago you could find nice tools for this, but all of the good ones have turned into massive piles of Enterprise level over complexity.
Can anyone recommend a simple tool that is suited for this type of one time data transformation?"
We are looking for a good data transformation tool that makes it easy to graphically define the transformation, allowing the input format to be easily defined and constraining the output to the XSD for our XML. Here is the problem, every tool we can find is geared at writing code, or the part of some massive ETL architecture intended to be the MOM of your entire enterprise. It seems like 10 years ago you could find nice tools for this, but all of the good ones have turned into massive piles of Enterprise level over complexity.
Can anyone recommend a simple tool that is suited for this type of one time data transformation?"