[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[ale] OT: Data Mapping Tool
- Subject: [ale] OT: Data Mapping Tool
- From: jcphil at mindspring.com (Jim Philips)
- Date: 13 Mar 2002 15:57:35 -0500
There is a whole category of tools for doing this. The general name for
them is extract, transform and load or ETL tools. All of the ones I know
about come from commercial vendors like Informatica and are extremely
expensive. We used Informatica for some of our data migration projects
where I used to work. If anybody knows of some free or cheap versions, I
would sure like to hear about it.
On Wed, 2002-03-13 at 15:42, Kevin O'Neill Stoll wrote:
> Hello All,
> I am in need of a tool that can handle a combination of importing and
> mapping data to a database.
> Example of my problem would be this:
> I have a spreadsheet of data that I wish to import into a database BUT..
> this spreadsheet really contains data that needs to be divided up into
> three or four different tables in my database.
> What I would like to be able to do is choose a delimited file to import
> and then choose the 'mapping schema' that matches my database. In other
> words, import data from one file into multiple tables that don't have the
> same field name or number of fields but do have the proper data types.
> Thanks for your help in advance, I have always received awesome answers
> back from this list. Keep up the great work :)
> Kevin Stoll
> Do You Yahoo!?
> Try FREE Yahoo! Mail - the world's greatest free email!
> This message has been sent through the ALE general discussion list.
> See http://www.ale.org/mailing-lists.shtml for more info. Problems should be
> sent to listmaster at ale dot org.
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be
sent to listmaster at ale dot org.