Data migration using Kettle (Pentaho)
I have been using Kettle (a Pentaho tool) for quite sometime in order to do migration of data from different kinds of data sources to PostgreSQL and I can now say that it has been just able to do all kinds of different jobs for me.
All you need to have is the JDBC driver for your target and source database and that is it. Most of the database drivers are already there with standard Kettle installation but in case you need to use a datasource that is not there you can easily configure it with Kettle by placing the JDBC driver in the classes folder for Kettle. I did the same too when I had to convert DBF files to PostgreSQL where I downloaded the DBF JDBC driver; configured it and moved the data across just in few minutes.
I myself have tested it with migrating data from Oracle, SQL Server, CSV, XML and DBF to PostgreSQL without much problem so I will highly recommend people looking for an open source data migrator tool that works with PostgreSQL.