The Greenplum Database Connector
Archive Greenplum MPP analytic datasets before hardware refresh, cloud migration, or end-of-support. Preserve petabyte-scale warehouse history in open Lakehouse format without retaining Greenplum infrastructure.
🌟 Featured in Gartner® Hype Cycle™ for Data Management
Connectors
Data Governance
Enterprise Clients
Talk to a Connector Expert
Retire VMware Greenplum Without Losing History
Archon’s Greenplum Connector extracts tables, schemas, partitioned data, and analytic datasets from VMware Greenplum and Tanzu Greenplum environments, then archives them into open Parquet and Delta Lake formats. Built for data engineering teams modernizing from on-premises Greenplum MPP appliances to cloud-native warehouses including Snowflake, BigQuery, Redshift, or Databricks Lakehouse.
Greenplum deployments frequently contain years of financial reporting, risk analytics, and regulatory data that cannot simply be discarded during migration. Archon extracts data at scale, including partition structures and distribution keys, and preserves it in open Parquet format.
- JDBC (Greenplum / PostgreSQL-compatible JDBC driver) extraction from Greenplum 5.x, 6.x, 7.x; Tanzu Greenplum
- Tables, schemas, partitioned tables, views, external tables, audit logs captured with full schema metadata
- Schema structure, indexes, and stored procedure metadata preserved
- Cross-table search and query through Archon Analyzer with no VMware Greenplum runtime required after archiving.
- Basel III, BCBS 239, SEC, FINRA, HIPAA, SOX retention policy support
Capabilities
Everything You Need for VMware Greenplum Data Operations
Full Schema and Historical Data Extraction
Archon extracts VMware Greenplum tables, views, and schema structures while preserving relational integrity and column-level metadata. No custom extraction scripts or database administrator involvement required.
Application Retirement and License Cost Elimination
VMware Greenplum instances retained solely for compliance data access are decommissioned after Archon archives the historical data. Licensing and infrastructure costs are eliminated while full regulatory compliance is maintained.
Database Migration Historical Data Preservation
Application migrations from VMware Greenplum to modern databases use Archon to archive historical data before cutover, reducing migration scope while satisfying compliance retention requirements.
Compliance Audit Trail Support
Audit tables, transaction logs, and schema-level metadata preserved in the Archon archive satisfy Basel III, BCBS 239, SEC, FINRA, HIPAA, and SOX compliance requirements, with records accessible through Archon Analyzer.
Use Cases
How Enterprises Use the VMware Greenplum Connector
01 Application Retirement
Legacy applications built on VMware Greenplum are retired when organizations modernize. Archon archives the underlying database, including schema, data, and audit records, before shutdown, ensuring compliance access without the legacy infrastructure.
02 Database Migration Historical Archiving
Migrations from VMware Greenplum to modern databases use Archon to archive complete historical data before cutover, preserving the full operational record in open Parquet format, independently of the migration.
03 License and Infrastructure Cost Elimination
VMware Greenplum instances running solely for compliance access are decommissioned after Archon archives the data. Licensing, support, and infrastructure costs are eliminated while regulatory compliance is maintained.
04 Compliance Audit and eDiscovery Support
Compliance audits and legal proceedings requiring VMware Greenplum records from prior years are fulfilled through Archon Analyzer without requiring a live VMware Greenplum instance or database administrator involvement.
Technical Specifications
| Specification | Details |
|---|---|
| Connection Method | JDBC (Greenplum / PostgreSQL-compatible JDBC driver) |
| Supported Versions | Greenplum 5.x, 6.x, 7.x; Tanzu Greenplum |
| Data Scope | Tables, schemas, partitioned tables, views, external tables, audit logs |
| Output Format | Parquet, Delta Lake, Avro, XML, CSV, TXT, TSV, Excel |
| Metadata Handling | Schema structure, indexes, constraints, column definitions |
| Transformation Rules | VMware Greenplum data type normalization supported |
| Retention Management | Basel III, BCBS 239, SEC, FINRA, HIPAA, SOX retention schedules |
| Legal Hold | Database and table-level hold orchestration with audit trail |
| Deployment | On-premises · Cloud (AWS) · Hybrid |
| Security & Compliance | TLS 1.3 in transit · AES-256 encryption at rest · WORM storage · Cryptographic integrity verification |
How It Works
Up and Running in 4 Steps
01
Connect to VMware Greenplum
Authenticate via JDBC (Greenplum / PostgreSQL-compatible JDBC driver) to Greenplum 5.x, 6.x, 7.x; Tanzu Greenplum. Archon auto-discovers all databases, schemas, tables, views, and stored procedure definitions. 02
Map & Configure
Define schema and table scope, data type normalization rules, and jurisdiction-specific retention schedules. Configure PII masking for GDPR compliance where applicable. 03
Validate & Preview
Run a dry-run against sample VMware Greenplum databases. Quality report flags null primary keys, data type normalization issues, and schema anomalies before full extraction. 04
Archive & Monitor
Execute full extraction. Cryptographic hashes and trusted timestamps applied per table. Data searchable via Archon Analyzer immediately on ingestion.FAQ
Common Questions About the VMware Greenplum Connector
- 1. Does Archon support VMware Greenplum without requiring DBA involvement?
Yes. Archon uses read-only JDBC (Greenplum / PostgreSQL-compatible JDBC driver) connections, eliminating the need for DBA scripts, administrative privileges, or custom extraction code.
- 2. Can Archon archive VMware Greenplum without impacting live application performance?
Yes. Archon uses read-only connections with configurable parallelism and throttling settings to minimize production impact during extraction.
- 3. How does Archon handle VMware Greenplum-specific data types during archiving?
Archon applies built-in transformation rules to normalize VMware Greenplum-specific data types into open Parquet-compatible formats while preserving metadata.
- 4. Is archived VMware Greenplum data queryable without the VMware Greenplum runtime?
Yes. Archon archives data in open Parquet and Delta Lake formats, making it queryable through Archon Analyzer, Apache Spark, Amazon Athena, and other Lakehouse query engines.
- 5. Does archived VMware Greenplum data satisfy GDPR and compliance retention requirements?
Yes. Archon supports WORM storage, integrity verification, and retention policy enforcement to help organizations meet GDPR Article 5 and applicable industry retention requirements.
Archive your Greenplum data before your next migration.
Speak with an Archon expert to plan a smooth transition without compromising historical records.
