[Lazarus] ETL tool - make or use?

[Marc Santhoff]

Der list members,

does anyone of you know a tool for ETL[1] tasks?

At best it would be written in object pascal and be open source.

I'm currently charged with doing some simple data transfer actions like
loading CSV (aka SDF) data and pushing those records to a relational
database and the like. I have the strong feeling that someone has
already done something like that. ;)

Options to solve this request are

1. whipping together minimal code that does it

2. make a more generic tool that can be used for all tasks, having to be
extended when needed

3. use some tool already existing

Some tools I tried or looked at are mostly written in Java and do suck
ressources, or they are not able to handle some requirements (like
databases in use) or are closed source. Last tests were done using
OpenAdaptor[2] which is really cool but has problems with posgresql and
demands being familiar with spring. There is still Pentaho Data
Integration[3] n the list of tools to do some testing with.

What do you use for ETL tasks?

TIA,
Marc


[1] http://en.wikipedia.org/wiki/Extract,_transform,_load
[2] https://www.openadaptor.org/
[3] http://www.pentaho.com/explore/pentaho-data-integration/

-- 
Marc Santhoff <M.Santhoff at web.de>