Teachers

Migrating data from Oracle database to Postgresql database using Pentaho Kettle

This post will talk about migrating data from Oracle database to Postgresql database.

The same can be doable from one database to another database.(i.e., for example MS-SQL server to postgreSQL).

Pentaho has its in built wizard tools to Migrate data from one database to another another database.

Find the below steps how we can use this in-buit tool in migrating.

1) Create source database connection and target database connection.

i.e., for example oralce connection as source and postgresql connection as target.

Go to Tools -> Wizard -> Create database connection.

Repeat the same for postgresql connection.

2) Go to Tools -> Wizard ->Copy Tables . Find the below images.

3) Itll create a job and “N” number of transformations based upon the number of tables in oracle database.

4) Run your job.. Thats all we have done.

Check the description & content of the tables in postgres.

References : 

https://wiki.postgresql.org/wiki/Migrating_from_one_database_to_another_with_Pentaho_ETL


http://wiki.pentaho.com/display/COM/Using+the+Copy+Table+Wizard

Posted by Unknown at 1:45 PM

Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Labels: data, database, from, kettle, migrating, oracle, pentaho, postgresql, to, using