The Microsoft Navision Connector Built for Legacy ERP Archiving
Archive Microsoft Navision financial, inventory, and customer data, and retire the legacy ERP with confidence that every record your auditors will ever need is permanently accessible.
🌟 Featured in Gartner® Hype Cycle™ for Data Management
Connectors
Data Governance
Enterprise Clients
Talk to a Connector Expert
Microsoft Navision Data Archiving, Done Right
AArchon’s Microsoft Navision Connector extracts data from Navision’s C/SIDE native database format and SQL Server-backed deployments, spanning Navision 3.x through Dynamics NAV 2018 and archives financial, inventory, CRM, manufacturing, and project records into ADS in open Parquet/Delta Lake format.
Navision remains in active use at thousands of mid-market organizations that built on it in the late 1990s and 2000s. As migrations to Dynamics 365 Business Central accelerate, the question of what happens to historical Navision data: the GL entries, vendor ledger records, item ledger movements, and customer histories your auditors will ask for at statutory audit, requires a definitive answer before cutover.
- MS SQL Server JDBC and C/SIDE OLE DB (native Navision DB) extraction supported
- Navision 3.x, 4.x, 5.x, and Dynamics NAV 2009–2018 all supported
- Finance, Inventory, Manufacturing, CRM, Project Management, and HR modules
- Navision table and field metadata, C/AL object definitions preserved
- Cross-application search via Archon Analyzer, no Navision licence post-archive
Capabilities
Everything You Need for Microsoft Navision Data Operations
Navision Financial Ledger Extraction
Archon extracts the complete Navision general ledger, vendor ledger, customer ledger, and bank ledger with full entry-level detail and posting metadata. Fixed asset records, VAT entries, and currency exchange records are included in scope.
Inventory and Manufacturing Records
Item ledger entries, warehouse ledger, production orders, capacity ledger, and BOM component records are extracted with relational integrity, supporting ISO 9001 quality record retention and statutory inventory audit requirements.
Companies Act and GDPR Compliant Archive
Every archived Navision financial record is cryptographically hashed, timestamped, and immutable at ingestion. Companies Act UK 6-year retention, GAAP 7-year financial records, HMRC Making Tax Digital VAT record retention, and GDPR data lifecycle obligations are enforced through Archon's policy engine.
Cross-Application Search
Archived Navision data is immediately searchable via Archon Analyzer, GL entries, vendor invoices, sales orders, item movements separate from a live Navision instance, C/SIDE runtime, or Microsoft Dynamics license.
Use Cases
How Enterprises Use the Microsoft Navision Connector
01 Business Central Migration
Archiving Navision data before migrating to Dynamics 365 Business Central is the primary use case. Archon extracts the full Navision dataset, financials, inventory, customers, suppliers, and projects, archives it in ADS and eliminates the need to keep Navision live post-migration for compliance access.
02 Statutory Financial Audit
Companies Act UK and GAAP statutory auditors require access to Navision GL, vendor ledger, and customer ledger records going back 6–7 years. Archon surfaces these records from ADS on demand leaving out Navision reactivation, satisfying auditor information requests with no IT team interference.
03 HMRC VAT and Making Tax Digital Compliance
HMRC Making Tax Digital requires VAT records to be retained in digital format for 6 years. Navision VAT entry and transaction records archived in ADS satisfy MTD digital record-keeping requirements — providing a single searchable source of truth for VAT audit purposes.
04 ERP Platform Change
Organizations moving from Navision to SAP, Oracle, or a non-Microsoft ERP platform need the complete Navision history archived outside the Microsoft ecosystem. Archon provides the extraction path to open-format ADS, vendor-independent and permanently accessible beyond Microsoft licensing.
Technical Specifications
| Connection Method | MS SQL Server JDBC (SQL-backed Navision), C/SIDE OLE DB (native DB) |
|---|---|
| Supported Versions | Navision 3.x, 4.x, 5.x; Dynamics NAV 2009–2018 |
| Data Scope | Finance, Inventory, Manufacturing, CRM, Project Management, HR modules |
| Output Format | Parquet, Avro, XML, CSV, TXT, TSV, CSV, Excel |
| Metadata Handling | Navision table and field metadata, C/AL object definitions |
| Transformation Rules | Navision date format handling, option field translation |
| Retention Management | Policy-based retention with WORM controls and legal hold |
| Deployment | On-premises · Cloud (AWS) · Hybrid |
| Security & Compliance | TLS 1.3 in transit · AES-256 at rest · Companies Act UK · GAAP · HMRC MTD · GDPR |
How It Works
Up and Running in 4 Steps
01
Connect to Navision
Authenticate via MS SQL Server JDBC or C/SIDE OLE DB. Archon auto-discovers all Navision tables, field definitions, and C/AL object metadata for the deployed version. 02
Map & Configure
Define module scope, date format handling, Navision option field translation, and retention policies for Companies Act, GAAP, HMRC MTD, and GDPR compliance. 03
Validate & Preview
Run a dry-run against sample Navision data. The quality report validates C/SIDE data extraction accuracy, option field mapping, and currency field handling before full extraction. 04
Archive & Monitor
Execute the full extraction with real-time tracking. Cryptographic hashes applied per record. Navision infrastructure and licenses can be retired on completion.FAQ
Common Questions About the Microsoft Navision Connector
- 1. Does Archon support the oldest Navision 3.x versions with the native C/SIDE database?
Archon supports legacy Navision versions, including 3.x with the native C/SIDE database.
- 2. How does Archon handle Navision's option fields and enumeration types?
Archon preserves option fields and enumeration mappings to maintain business logic and data meaning.
- 3. Can Archon archive specific Navision modules instead of extracting the full ERP?
Archon enables selective, module-level archiving without full system extraction.
- 4. How does Archon ensure Navision VAT records meet HMRC Making Tax Digital requirements?
Archon ensures compliance by maintaining audit trails, data integrity, and structured record retention.
- 5. What happens to Navision data in ADS if we later migrate to a different platform?
Archon keeps the data portable and accessible, allowing reuse or migration, eliminating the dependency on Navision.
Ready to archive your Microsoft Navision data and retire the dependency?
Talk to an Archon integration specialist at archondatastore.com. Free consultation, no commitment, reply within 24 hours.
