All geek questions in one place

Automated ETL / Database Migration Solution

I am looking for an ETL solution that we can create manually and then deploy to run offline. This is a basic transformation; it does not have to be heavy. Key points are free, open source software that can be tailored to meet specific needs.

In fact, this can be reduced to a simple database migration tool that will run on a Linux server. In essence, this is the same as above, but we probably will not need to check / convert the data at all, except for renaming the columns.

I forgot to mention that it will be a very cross platform. I would like to be able to deploy it on a server, and also test it on OSX and Windows.

+4
source share
1 answer

Try Pentaho or Talend. Pentaho has a good work-planning paradigm, as well as an ETL workbench (kettle). I did not use Talend, but I heard good things, and I believe that it has similar functionality.

+5
source

Source: https://habr.com/ru/post/1310750/

More articles:


All Articles