Transfer Data from one Database to another using Kettle (PDI)

Introduction#

You can use Pentaho Data Integration (Kettle) to Transfer Data from One Database to another. Its very easy as the transformation is automatically created just by creating the connection.and it can transfer Lacs of records very quickly.

Steps to Move One table of MySQL to another table in postgres:

Click on New Files —> Transformation once a new transformation is open, Click on views tab ,under views create two connections (source ) and (destination).

source: table where data is available destination: table where you want to push your data.

Once done.

on the top bar you have tools —> Wizard —> Copy table

It will ask you to provide source and destination Connection details.

and Click on Finish.

Once done you will find a transformation Created with Source to destination mapping.

Just check once before you run the Kettles that table inside the database which you want to move is properly selected.

as you can see in the above screenshot 720 Records are Moved Successfully from one table to another,where one table was MySQL and another table was in Postgres!!