All geek questions in one place

Is there an SSG-like function in PostgreSQL?

We use SSIS (SQL Server Integration Services) in SQL 2008 R2 to copy database tables from 30+ databases (running on SQL Server 2000) to one database for data analysis on a daily basis. Is there an SSG-like function in PostgreSQL? Because we plan to move our database to an open source database in the future. Thanks!

+6
source share
3 answers

PostgreSQL itself does not have an ETL module like ssis, however there are several open source BI stacks. The most popular open source ETL toolkit is probably the Pentaho tool Kettle . He recommended the Postgres wiki.

+3
source

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

+3
source

There is pg_dump that generates an SQL script that can be played in another database. Some scripts will be required to collect data from your 30 databases.

To avoid confusion, note that in Postgres a "database" can contain several "schemas" - in SQL Server an "instance" can contain several "databases". The basic concepts are roughly equivalent.

0
source

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

More articles:


All Articles