Is there a SSIS-like feature in PostgreSQL?

Question

We are using the SSIS (SQL Server Integration Services) in SQL 2008 R2 to copy database tables from 30+ databases (running on SQL Server 2000) to a single database for data analysis purposes on a daily basis. Is there a SSIS-like feature in PostgreSQL? As we are thinking to migrate our database to open source database in the future. Thanks!

Answer 1

You can use SQL Server Integration Services for that. Just connect to your PostgreSQL using a ODBC connection! I do it myself.

Answer 2

PostgreSQL itself doesn't have ETL module similar to ssis, however there are some open-source BI stacks. The most popular open-source ETL toolkit is probably Pentaho's tool Kettle. It's recommended on Postgres wiki