The CockroachDB Connector
Archive CockroachDB distributed SQL datasets for long-term compliance retention. Preserve globally distributed transactional data in open Lakehouse formats while reducing the need to keep CockroachDB clusters running solely for historical access.
🌟 Featured in Gartner® Hype Cycle™ for Data Management
Connectors
Data Governance
Enterprise Clients
Talk to a Connector Expert
Purpose-Built Archiving for CockroachDB
Archon’s CockroachDB Connector extracts tables, schemas, and historical data from CockroachDB Dedicated, CockroachDB Serverless, and self-managed clusters, then archives them in open Parquet and Delta Lake formats. It is well suited for fintech, SaaS, and e-commerce organizations managing long-term retention of globally distributed transactional data.
CockroachDB’s survivability and geo-distribution make it ideal for globally consistent transactional workloads. But it is not designed for multi-year compliance archiving. Archon offloads aged CockroachDB data to cost-efficient Lakehouse storage, helping organizations meet retention requirements while reducing reliance on active database nodes for historical access.
- JDBC (PostgreSQL-compatible connector) extraction from CockroachDB v21.x, v22.x, v23.x, v24.x; Serverless and Dedicated
- Tables, schemas, views, indexes, changefeeds, audit logs captured with full schema metadata
- Schema structure, indexes, and stored procedure metadata preserved
- Cross-table search and query through Archon Analyzer after archiving
- Supports retention policies for PCI DSS, GDPR, SOX, and other financial regulations
Capabilities
Everything You Need for CockroachDB Data Operations
Full Schema and Historical Data Extraction
Archon extracts CockroachDB tables, views, and schema structures while preserving relational integrity and column-level metadata. Uses standard JDBC connectivity, eliminating the need for custom extraction scripts.
Application Retirement and License Cost Elimination
CockroachDB 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
During database modernization projects, Archon archives historical CockroachDB data before cutover, reducing migration scope while keeping long-term records independently accessible.
Compliance Audit Trail Support
Audit tables, transaction logs, and schema metadata remain searchable through Archon Analyzer, supporting compliance reviews and investigations without restoring the source database.
Use Cases
How Enterprises Use the CockroachDB Connector
01 Application Retirement
Legacy applications built on CockroachDB are retired when organizations modernize. Archon archives the underlying database, including schema, data, and audit records, before shutdown, ensuring continued access for compliance and business users.
02 Database Migration Historical Archiving
Migrations from CockroachDB to modern databases use Archon to archive complete historical data before cutover, preserving the complete operational record in open Parquet format.
03 License and Infrastructure Cost Elimination
CockroachDB 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 CockroachDB records from prior years are fulfilled through Archon Analyzer without restoring a live CockroachDB environment.
Technical Specifications
| Specification | Details |
|---|---|
| Connection Method | JDBC (PostgreSQL-compatible connector) |
| Supported Versions | CockroachDB v21.x, v22.x, v23.x, v24.x; Serverless and Dedicated |
| Data Scope | Tables, schemas, views, indexes, changefeeds, audit logs |
| Output Format | Parquet, Delta Lake, Avro, XML, CSV, TXT, TSV, Excel |
| Metadata Handling | Schema structure, indexes, constraints, column definitions |
| Transformation Rules | CockroachDB data type normalization supported |
| Retention Management | PCI DSS, GDPR, SOX, multi-jurisdiction financial regulations 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 at rest · WORM · Cryptographic hashing |
How It Works
Up and Running in 4 Steps
01
Connect to CockroachDB
Authenticate via JDBC (PostgreSQL-compatible connector) to CockroachDB v21.x, v22.x, v23.x, v24.x; Serverless and Dedicated. 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 CockroachDB databases. Quality report flags null primary keys, data type normalization issues, and schema anomalies before full extraction. 04
Archive & Monitor
Execute full extraction. Integrity validation and audit metadata are applied during archiving, making records immediately searchable through Archon Analyzer.FAQ
Common Questions About the CockroachDB Connector
- 1. Does Archon support CockroachDB using standard read-only access?
Yes. Archon connects using standard read-only JDBC access and does not rely on custom extraction scripts.
- 2. Can Archon archive CockroachDB without impacting live application performance?
Yes. Archon uses read-only connections with configurable parallelism and throttle settings, resulting in zero production impact during extraction.
- 3. How does Archon handle CockroachDB-specific data types during archiving?
Archon applies built-in transformation rules to normalize CockroachDB-specific data types into open Parquet-compatible formats while preserving metadata.
- 4. Is archived CockroachDB data queryable without the CockroachDB runtime?
Yes. Archon archives data in open Parquet and Delta Lake formats that are searchable through Archon Analyzer or can be queried using common Lakehouse analytics tools such as Apache Spark and Amazon Athena.
- 5. Does archived CockroachDB data satisfy GDPR and compliance retention requirements?
Yes. Archon supports compliant long-term retention with WORM storage, audit metadata, and governance features aligned with GDPR Article 5 and applicable sector-specific regulations.
Retiring CockroachDB but need to preserve historical data?
Discuss your archiving goals with an Archon specialist and explore the best approach for your CockroachDB environment.
