Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

ARCHIVING -DYNAMICS NAV 2009

Posted on by 7

Dear Forum - I have a requirement - to archived the historical data for 7 years due to statutory requirement

The requirement from the Business is to have a Data Readable (“READ-ONLY”)+ metadata ( “AS-IS) legacy in the Azure by archiving the solution.

 I have proposed options as follow – >>Provisioning 2 x new VM (eV4.3 App server & SQL on VM == OS(2019); SQL (2019)) + accessing either through the Azure Virtual desktop or Citrix ((A)“Source --- > AS-IS Legacy”  (B) “Target -- >> Azure CLOUD”) + all hardened with internal firewalls + monitoring tools AND no exposure to internet. & Private endpoint.

To mitigate the “high risk” this is the Security Solution i proposed - a “read-only archive platform, isolated & not accessible through internet & centrally secured control * hardened by Azure firewall, DDoS.”, high-level secured virtual desktop &  SQL security with hardened perimeter + private link”.,

 NOTE 1: this is accessible only on “READ-ONLY” to the Finance * Legal Users

 NOTE 2: The Archiving solution is for Statutory, audit and compliance purpose

 NOTE 3: The system is not transactional & not often used BUT to remain as read-only for audit purpose

 Key risk issue -- >> Microsoft Dynamics NAV 2009 R2 (out of support) & could pose a great risk to the environment

 The question is the Proposed Security Solution provided should be able to sustain & shield the system from “high to low risk”

The Technical Forum within the Organisation - the Infosec and Cyber Team Feedback:

 Two immediate areas of concern, 1) This may constitute a Cyber Essentials fail. We must only use licensed and supported products. Microsoft Dynamics NAV 2009 R2 ended on Jan14 2020 so as such cannot be utilised in this design.

 2) When unsupported software is utilised, future vulnerabilities can be exploited by an adversary. Although the solution will be behind an Azure firewall, another entry point could be exploited. This may result in an attacker being able to laterally move across the network and exploit this weakness.

 Please can you advice on this issue with the NAV 2009

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    RE: ARCHIVING -DYNAMICS NAV 2009

    Hi, I think if you upgrade to a newer version, the following two functions may solve your problem.

    Data cleanup tasks page (Data Administration page)
    https://yzhums.com/15246/

    Data archive extension (Data Archive List page)
    https://yzhums.com/19180/

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: ARCHIVING -DYNAMICS NAV 2009

    BC 14 is also out of support. So you should upgrade to something more recent.

    For archiving purpose you can just store a backup of your SQL database.

    That should be sufficient if you ever needs to document the data in your system.

  • oolakitan1 Profile Picture
    oolakitan1 7 on at
    RE: ARCHIVING -DYNAMICS NAV 2009

    Hi Zhu,

    Thanks for your response.

    We've upgraded the eV4.3 to D365 Business Central v14.

    However, the issue is that the business need to preserve the historical data - which is read-only as a IaaS for audit & legal purpose

    The risk as specified in my previous email - NAV client - 

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    RE: ARCHIVING -DYNAMICS NAV 2009

    Hi, NAV 2009 has been end of support for over 3 years and unfortunately I don't see any other way than to upgrade to a supported product.

    https://learn.microsoft.com/en-us/lifecycle/products/dynamics-nav-2009-r2

    pastedimage1682032750918v1.png

    Hopefully other experts can give you better advice.

    Thanks.

    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans