The Teradata Connector Built for Enterprise Data Warehouse Modernization
Archive Teradata data warehouse history at petabyte scale. Reduce your Teradata footprint. Migrate analytics to Snowflake or Databricks with full compliance continuity.
🌟 Featured in Gartner® Hype Cycle™ for Data Management
Connectors
Data Governance
Enterprise Clients
Talk to a Connector Expert
Teradata Data Archiving, Done Right
Archon’s Teradata Connector extracts data from Teradata via JDBC and Teradata FastExport, handling Teradata’s parallel processing architecture to extract at scale without impacting production workloads. Data lands in Parquet/Delta Lake format in ADS, immediately accessible for compliance review, analytical reuse, and regulatory examination not having a live Teradata dependency.
Teradata houses decades of aggregated analytical data, operational records, financial history, and customer data at organizations across financial services, retail, telecommunications, manufacturing, and government. As cloud migration and Teradata footprint reduction become strategic priorities, the historical data question is always the hardest to resolve. Archon provides the answer: open-format archiving that eliminates the Teradata license dependency while preserving every compliance obligation.
- Teradata JDBC, FastExport, and Teradata Parallel Transporter (TPT) all supported
- Teradata 14.x–17.x and Teradata Vantage supported
- Petabyte-scale with parallel extraction and production workload isolation
- Teradata Data Dictionary (DBC), table statistics, and column metadata preserved
- BYTEINT, PERIOD, INTERVAL, JSON, CLOB/BLOB type handling
Capabilities
Everything You Need for Teradata Data Operations
Teradata Parallel Transporter (TPT) Extraction
Archon uses Teradata's native parallel transporter protocol for maximum extraction throughput, distributing extraction across all AMPs in the Teradata environment while isolating the archive workload from production OLAP queries. Zero impact on production SLAs during extraction.
Open-Format Migration to Cloud Analytics
Teradata data extracted by Archon lands in Parquet/Delta Lake format, immediately queryable in Snowflake, Databricks, BigQuery, or Azure Synapse. Teradata-specific types including PERIOD, BYTEINT, and INTERVAL are normalized to standard equivalents compatible with all modern analytics engines.
Financial Regulatory Data Retention
Each archived Teradata dataset is immutable from the moment it is ingested. MiFID II 5-year trade data retention, BCBS 239 data accuracy and governance requirements, and DORA ICT risk data obligations are enforced through Archon's retention policy engine with cryptographic hashing.
Teradata License Cost Reduction
Archiving historical, low-access Teradata data to ADS directly reduces the active Teradata database footprint, lowering per-node licensing costs proportionally to the data volume archived. Organizations typically achieve 40–60% footprint reduction by archiving data beyond the 2–3 year active reporting window.
Use Cases
How Enterprises Use the Teradata Connector
01 Teradata Footprint Reduction
Archiving historical, low-access Teradata data to ADS reduces the active database volume, lowering per-node licensing costs, reducing infrastructure spend, and improving production query performance. The archived data remains accessible via Archon Analyzer for compliance and occasional analytical retrieval.
02 Teradata to Snowflake or Databricks Migration
Organizations migrating analytical workloads from Teradata to Snowflake or Databricks need historical Teradata data archived before appliance decommission. Archon extracts the complete Teradata environment in Parquet/Delta Lake format, instantly queryable in the target cloud platform.
03 Financial Services Regulatory History Retention
Financial services organizations hold years of risk model outputs, trading analytics, capital adequacy data, and regulatory reporting history in Teradata. Archon archives these with MiFID II, BCBS 239, and DORA-aligned retention schedules for regulatory examiner access.
04 AI/ML Model Governance and Training Data
Historical Teradata datasets used to develop and train financial and risk models must be retained for SR 11-7 and SS1/23 model risk governance. Archon archives these in open Parquet format with WORM immutability, accessible to ML toolchains and auditable for model governance review.
Technical Specifications
| Connection Method | Teradata JDBC |
|---|---|
| Supported Versions | Teradata 14.x–17.x, Teradata Vantage |
| Scale | Petabyte-scale with parallel AMP-distributed extraction and workload isolation |
| Output Format | Parquet, Avro, XML, CSV, TXT, TSV, CSV, Excel |
| Metadata Handling | Teradata Data Dictionary (DBC), table statistics, column metadata |
| Teradata Types | BYTEINT, PERIOD, INTERVAL, JSON, CLOB/BLOB handling |
| Transformation Rules | Teradata-specific type normalization |
| Retention Management | MiFID II, BCBS 239, DORA-aligned policies with WORM controls |
| Deployment | On-premises · Cloud (AWS) · Hybrid |
| Security & Compliance | TLS 1.3 in transit · AES-256 at rest · MiFID II · BCBS 239 · DORA · SR 11-7 |
How It Works
Up and Running in 4 Steps
01
Connect to Teradata
Authenticate via Teradata JDBC or TPT. Archon auto-discovers all databases, tables, Data Dictionary definitions, and table statistics across the Teradata environment.
02
Map & Configure
Define extraction scope, TPT parallelism settings, Teradata-specific type handling, and retention policies for MiFID II, BCBS 239, or DORA compliance requirements.
03
Validate & Preview
Run a dry-run against a sample Teradata partition. The quality report validates type normalization, partition completeness, and DBC metadata preservation.
04
Archive & Monitor
Execute petabyte-scale extraction with real-time AMP-level throughput monitoring. Data lands in Parquet/Delta Lake and is directly queryable in Snowflake or Databricks.FAQ
Common Questions About the Teradata Connector
-
1. Does Archon support Teradata Vantage as well as legacy Teradata platforms?
Archon supports both Teradata Vantage and legacy Teradata environments.
-
2. What extraction throughput does Archon achieve on a large Teradata environment?
Archon delivers high-throughput, parallel extraction, typically scaling to terabytes per day.
-
3. How does Archon ensure Teradata data is queryable in Snowflake after migration?
Archon transforms and loads data into optimized, query-ready formats for Snowflake.
-
4. How does Archon's Teradata archive support BCBS 239 data accuracy requirements?
Archon ensures compliance by maintaining data lineage, integrity, and audit trails.
-
5. Can Archon extract Teradata data incrementally to support ongoing footprint reduction?
Archon supports incremental extraction to enable continuous data reduction and archiving.
Ready to archive your Teradata data and retire the dependency?
Talk to an Archon integration specialist at archondatastore.com Free consultation, no commitment, reply within 24 hours.
