The JBA System 21 Connector Built for Legacy ERP Decommissioning
Archive JBA System 21 financials, manufacturing, and supply chain data, from IBM i to Lakehouse, before diminishing Infor support makes extraction impossible.
🌟 Featured in Gartner® Hype Cycle™ for Data Management
Connectors
Data Governance
Enterprise Clients
Talk to a Connector Expert
JBA System 21 Data Archiving, Done Right
Archon’s JBA System 21 Connector extracts data from System 21’s underlying database layer, typically DB2 for i on IBM i (AS/400), and archives financial, manufacturing, and distribution records into ADS. Data lands in open Parquet/Delta Lake format, accessible for audit, compliance, and operational reference without any System 21 dependency.
JBA System 21 carries decades of financial, production, and supply chain records in regulated manufacturing, distribution, and process industry organizations. Infor’s product consolidation and diminishing System 21 support creates urgency around data archiving before the system becomes unserviceable. Archon’s connector provides the extraction path, from IBM i’s DB2 database to open-format Lakehouse, that System 21’s own tooling cannot deliver.
- DB2 for i JDBC (JT400) extraction, the native path from IBM i without middleware
- EBCDIC-to-UTF-8 conversion with full codepage mapping for IBM i data
- Financials, Manufacturing, Distribution, Supply Chain, and Payroll module coverage
- System 21 data dictionary and field definitions preserved in ADS
- Cross-application search via Archon Analyzer, no System 21 or IBM i license post-archive
Capabilities
Everything You Need for JBA Data Operations
IBM i Native Extraction
System 21 data on IBM i is extracted directly from DB2 for i using JT400 JDBC, handling IBM i's physical and logical file structures, DDS record layouts, packed decimal fields, and EBCDIC character data, eliminating the need for COBOL extraction scripts or middleware.
Supply Chain and Manufacturing Record Preservation
Production orders, BOM histories, stock movements, supplier records, and customer order histories are extracted with relational integrity. Supports ISO 9001 quality record retention and food manufacturing FSA/FDA batch record requirements.
Statutory Financial Record Archive
Every archived System 21 GL, AP, and AR record is cryptographically hashed, timestamped, and WORM-compliant at ingestion. Companies Act UK 6-year retention, GAAP 7-year financial records, and VAT record-keeping requirements (Making Tax Digital) are enforced through Archon's retention policy engine.
Cross-Application Search
Archived System 21 data is immediately searchable via Archon Analyzer, including financial postings, production records, supplier invoices, customer orders, removing the need for a live System 21 instance or IBM i environment.
Use Cases
How Enterprises Use the JBA Connector
01 System 21 Decommissioning
Organizations decommissioning JBA System 21, whether migrating to Infor M3, SAP, or Microsoft Dynamics, need the complete financial, manufacturing, and supply chain record archived before the system is shut down. Archon extracts the full dataset from IBM i DB2, makes it searchable in ADS, and eliminates the System 21 dependency.
02 IBM i Hardware Retirement
System 21 decommissioning frequently coincides with IBM i hardware retirement. Archon handles both: extracting System 21 application data from DB2 for i and any other IBM i files or applications simultaneously, providing a single extraction project for the full IBM i environment.
03 Manufacturing Compliance and Quality Audit
ISO 9001, BRC, and FSSC 22000 audits require access to production records, quality inspection data, and non-conformance histories held in System 21. Archon surfaces these records on demand from ADS without reactivating System 21 or IBM i.
04 Financial Statutory Audit
Statutory auditors and HMRC enquiries require access to System 21 GL, purchase ledger, and sales ledger records going back 6–7 years. Archon archives the complete financial history with Companies Act-compliant retention and makes records retrievable for audit on demand.
Technical Specifications
| Connection Method | DB2 for i JDBC (JT400), direct database access |
|---|---|
| Platforms | IBM i (AS/400), IBM AIX (later System 21 versions) |
| Data Scope | Financials, Manufacturing, Distribution, Supply Chain, Payroll modules |
| Output Format | Parquet, Avro, XML, CSV, TXT, TSV, CSV, Excel |
| Metadata Handling | System 21 data dictionary and field definitions preserved |
| Transformation Rules | EBCDIC conversion, packed decimal, JBA date formats |
| 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 · Companies Act UK · GAAP · ISO 9001 · GDPR |
How It Works
Up and Running in 4 Steps
01
Connect to System 21
Authenticate to IBM i DB2 via JT400 JDBC. Archon auto-discovers all System 21 module tables, physical and logical files, and field definitions from the System 21 data dictionary. 02
Map & Configure
Define module scope, EBCDIC codepage settings, packed decimal handling, and retention policies. System 21 templates cover financials, manufacturing, and supply chain patterns. 03
Validate & Preview
Run a dry-run against sample data. The quality report validates EBCDIC conversion, packed decimal normalization, and date format handling before full extraction. 04
Archive & Monitor
Execute the full extraction from IBM i. Cryptographic hashes and trusted timestamps applied per record. System 21 and IBM i infrastructure can be retired on completion.FAQ
Common Questions About the JBA Connector
- 1. Does Archon support all versions of JBA System 21 on IBM i?
Yes, Archon supports a wide range of System 21 versions, including legacy environments.
- 2. How does Archon ensure compliance for mainframe archival?
Archon uses native connectors and automated schema interpretation, eliminating the need for custom COBOL.
- 3. Can I archive System 21 and other IBM i applications in the same Archon project?
Yes, Archon supports multi-application archiving within a single project.
- 4. How does Archon ensure System 21 financial records meet Companies Act retention requirements?
Archon ensures compliance by enforcing policy-based retention, audit trails, and secure, tamper-proof storage.
- 5. What happens to System 21 data in ADS after IBM i hardware is retired?
The data remains fully accessible, searchable, and independent of the original system.
Ready to archive your JBA System 21 data and retire the dependency?
Talk to an Archon integration specialist at archondatastore.com. Free consultation, no commitment, reply within 24 hours.
