RE: Oracle to PostgreSQL - DWH

Migration is fine, but is PostgreSQL good for DWH use cases ?

Can PostgreSQL support data warehousing loads?

From: John Wiencek <jwiencek3(at)comcast(dot)net>
Sent: woensdag 12 februari 2020 16:31
To: Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org
Subject: Re: Oracle to PostgreSQL - DWH

EnterpriseDB has a product called Migration Toolkit (MTK) that can do this.

John

On Feb 12, 2020, at 8:25 AM, <soumik(dot)bhattacharjee(at)kpn(dot)com<mailto:soumik(dot)bhattacharjee(at)kpn(dot)com>> <soumik(dot)bhattacharjee(at)kpn(dot)com<mailto:soumik(dot)bhattacharjee(at)kpn(dot)com>> wrote:

Hi Experts,

Greetings!!

Did anyone have some use cases for migrating Oracle to PostgreSQL in context to DWH(Data warehousing ) considering 5TB to 8TB database size (Source-Oracle)

Thanks..