Oracle to Greenplum
Migrate Oracle Database schema and data into Greenplum.
Download DBConvert
Ongoing sync? Get DBSync · Details
Greenplum Migration Tools
PostgreSQL-compatible MPP migration and synchronization
Move data to and from Greenplum with DBConvert and DBSync tools for analytical workloads, PostgreSQL-compatible platforms, and enterprise data warehouse projects.
MPP
Massively parallel processing
PostgreSQL
Compatible SQL workflows
Analytics
Warehouse data movement
Migrating into Greenplum
Greenplum is an analytics data warehouse built on PostgreSQL with a massively parallel (MPP) architecture. DBConvert connects to it as a PostgreSQL target, so loading data into Greenplum works like a migration into PostgreSQL.
Point a supported source at your Greenplum coordinator and DBConvert maps the data types, creates the tables, and transfers the rows.
Plan for this up front: Greenplum distributes every table across segments. DBConvert creates standard tables - set the distribution and storage model in Greenplum afterwards so the data spreads and performs well.
Download the converter for your source
Each tool connects to Greenplum as a PostgreSQL target. Pick where your data is coming from.
SQL Server to Greenplum
Move Microsoft SQL Server tables and data into Greenplum.
Download DBConvert
Ongoing sync? Get DBSync · Details
MySQL / MariaDB to Greenplum
Migrate MySQL or MariaDB data into Greenplum.
Download DBConvert
Ongoing sync? Get DBSync · Details
Firebird / InterBase to Greenplum
Move Firebird or InterBase databases into Greenplum.
Download DBConvert
Ongoing sync? Get DBSync · Details
Access to Greenplum
Move Microsoft Access tables into Greenplum.
Download DBConvert
Ongoing sync? Get DBSync · Details
What to plan for
Greenplum is PostgreSQL on the surface, but it is an MPP warehouse underneath. Account for these before the run:
Distribution keys
Every Greenplum table is distributed across segments. DBConvert creates standard tables - set a DISTRIBUTED BY key in Greenplum so rows spread evenly instead of skewing to one segment.
Storage model
Append-optimized and column-oriented storage are Greenplum's design for analytics. DBConvert loads standard heap tables - convert large tables to AO or column storage afterwards.
Based on an older PostgreSQL core
Greenplum tracks an older PostgreSQL version, so some newer PostgreSQL types and syntax differ. Review the generated types on specialized columns.
Connection
Connect with a standard PostgreSQL connection string to the Greenplum coordinator - host, port, user, and SSL from your deployment.
Need log-based, real-time replication?
DBConvert Streams is a separate product for continuous, log-based change data capture. The DBConvert and DBSync tools on this page cover migration, scheduled sync, and trigger-based sync.
Ready to migrate into Greenplum?
Download the converter for your source above and run the first job on a free trial.