The Ingres Connector Built for Legacy Database Archiving
Archive Actian Ingres database data, government records, financial applications, and healthcare systems into open-format Lakehouse storage before skills scarcity makes extraction impossible.
🌟 Featured in Gartner® Hype Cycle™ for Data Management
Connectors
Data Governance
Enterprise Clients
Talk to a Connector Expert
Ingres / Actian Data Archiving, Done Right
Archon’s Ingres Connector directly accesses IBM Ingres and Actian databases via JDBC/ODBC, extracting structured data into ADS in open Parquet or Delta Lake format. The connector handles Ingres’s proprietary data types including INGRESDATE, MONEY, C (fixed-length character), TEXT, BYTE, LONG VARCHAR, and LONG BYTE, normalizing them for long-term storage with no dependency on Ingres expertise on the migration team.
Ingres has deep roots in academic computing and government information systems, with significant deployments in public sector, financial services, healthcare, and manufacturing organizations that built mission-critical applications on Ingres in the 1980s and 1990s. Migration to PostgreSQL or cloud-native databases is the most common destination, but the historical data in Ingres carries retention obligations that must be addressed before decommissioning.
- Ingres JDBC driver (iijdbc.jar) and ODBC extraction. Ingres 9.x, 10.x, Actian X supported
- Full Ingres data type support: INGRESDATE, MONEY, C, TEXT, BYTE, LONG VARCHAR
- Ingres system catalog metadata, table definitions, and constraints preserved
- Full and incremental extraction modes
- Cross-application search via Archon Analyzer; no Ingres licence post-archive
Capabilities
Everything You Need for Ingres / Actian Data Operations
Government and Public Sector Records
Ingres underpins government information systems holding citizen records, tax data, benefit payment histories, and administrative records. Archon archives these with NARA and Public Records Act-aligned retention schedules, making records retrievable for FOIA requests and inspector general audits.
Ingres-Specific Type Normalization
INGRESDATE, Ingres's non-standard temporal type, is converted to ISO-standard timestamps with timezone handling. MONEY types are normalized to standard decimal with precision preservation. C (fixed-length character) and BYTE large object fields are extracted and stored in standard equivalents.
Multi-Sector Compliance Archive
Every archived Ingres record is cryptographically hashed, timestamped, and WORM-compliant at ingestion. Supports NARA retention for government, HIPAA minimum retention for healthcare, SOX 7-year financial records, and GDPR data lifecycle management.
Cross-Application Search
Archived Ingres data is immediately searchable via Archon Analyzer, including citizen records, financial transaction histories, patient administrative data, and production records, with no dependency on a live Ingres instance, Ingres runtime, or Actian license.
Use Cases
How Enterprises Use the Ingres / Actian Connector
01 Ingres Decommissioning and PostgreSQL Migration
The most common Ingres migration destination is PostgreSQL, given the shared open-source heritage. Archon archives historical Ingres data into ADS before the PostgreSQL migration cutover, preserving data that is beyond the active migration scope but within retention windows.
02 Government Record Preservation
Federal and state government agencies running legacy Ingres applications accumulate citizen records, tax data, and administrative records with long statutory retention windows. Archon archives these with NARA-aligned retention schedules and FOIA-ready search access from ADS.
03Financial Services Application Archive
Financial applications built on Ingres, including trading systems, account administration, and loan management, hold records requiring SOX-compliant 7-year retention. Archon archives these with full WORM immutability and financial audit retrieval capability with no dependency on Ingres skills on the operations team.
04 Healthcare Information System Archive
Healthcare organizations with Ingres-hosted patient administration and clinical support systems need HIPAA-compliant long-term record retention. Archon archives the full Ingres clinical dataset with HIPAA-aligned retention schedules and WORM immutability.
Technical Specifications
| Connection Method | Ingres JDBC driver (iijdbc.jar), ODBC |
|---|---|
| Supported Versions | Ingres 9.x, 10.x; Actian X, Actian Avalanche |
| Data Types | INGRESDATE, MONEY, C, TEXT, BYTE, LONG VARCHAR, LONG BYTE |
| Output Format | Parquet, Avro, XML, CSV, TXT, TSV, CSV, Excel |
| Metadata Handling | Ingres system catalog metadata, table definitions, constraints |
| Transformation Rules | Ingres-specific date/type normalisation |
| Extraction Mode | Full and incremental |
| Retention Management | Policy-based retention with legal hold and WORM controls |
| Deployment | On-premises · Cloud (AWS) · Hybrid |
| Security & Compliance | TLS 1.3 in transit · AES-256 at rest · NARA · HIPAA · SOX · GDPR |
How It Works
Up and Running in 4 Steps
01
Connect to Ingres
Authenticate via Ingres JDBC driver (iijdbc.jar) or ODBC. Archon auto-discovers all databases, tables, Ingres system catalog metadata, and data type definitions. 02
Map & Configure
Define extraction scope, INGRESDATE type handling, MONEY precision settings, and retention policies for NARA, HIPAA, SOX, or GDPR compliance. 03
Validate & Preview
Run a dry-run against sample Ingres data. The quality report validates INGRESDATE conversion, MONEY precision, and BYTE field extraction before full extraction. 04
Archive & Monitor
Execute the full extraction with real-time tracking. Cryptographic hashes applied per record. Immediately searchable via Archon Analyzer.FAQ
Common Questions About the Ingres / Actian Connector
- 1. Does Archon support the oldest Ingres 9.x versions?
Archon supports legacy Ingres environments, including 9.x versions.
- 2. How does Archon handle Ingres's non-standard INGRESDATE type?
Archon accurately converts INGRESDATE types while preserving date precision and context.
- 3. Can Archon extract Ingres LONG BYTE and LONG VARCHAR large object fields?
Archon fully supports extraction and archiving of LONG BYTE and LONG VARCHAR fields.
- 4. How does Archon ensure archived Ingres government records meet NARA retention requirements?
Archon ensures compliance by enforcing retention policies, immutability, and audit trails.
- 5. What is the typical extraction performance for large Ingres databases?
Archon delivers high-performance, parallel extraction, typically scaling large data volumes depending on system configuration.
Ready to archive your Ingres / Actian data and retire the dependency?
Talk to an Archon integration specialist at archondatastore.com — free consultation, no commitment, reply within 24 hours.
