You are not logged in.

A List of Data Transformation Tools

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

patch_32

Professional

  • "patch_32" is male
  • "patch_32" started this thread

Posts: 12

Date of registration: Mar 10th 2006

  • Send private message

1

Wednesday, March 22nd 2006, 2:13am

A List of Data Transformation Tools

Hi, I saw this website full of data conversion tools.

http://dataconv.org/apps_db.html

I am trying to use KETTLE (www.kettle.be) and their demo tutorials look promising.

This post has been edited 2 times, last edit by "patch_32" (Mar 22nd 2006, 2:14am)

Dave

Master

Posts: 37

Date of registration: Dec 8th 2005

  • Send private message

2

Wednesday, March 22nd 2006, 9:58am

RE: A List of Data Transformation Tools

I've had a play with KETTLE and must admit it's probably the best open source ETL tool that I have come accross so far.
The SAP connector is useful and other than that it can connect with most sources.

patch_32

Professional

  • "patch_32" is male
  • "patch_32" started this thread

Posts: 12

Date of registration: Mar 10th 2006

  • Send private message

3

Thursday, March 23rd 2006, 1:34am

I was really amazed with what kettle can do. With this tool you can pull data from different data sources (database, text files, excel sheets etc) with one shot!

The graphical tool is very easy to use.

With kettle and palo, I think what can be done is to:

design your data extraction and transformation with kettle
dump your results into a mysql database
and then, load the data into the cubes of palo.

Bwahaha! I'm very happy...
Rate this thread