Data Archive in Business Central – Cleanup your data
In Business Central Wave 2 2021 Microsoft will come with a new extension which calls “Data Archive”. With this extension you can archive your data which is stored in the original tables into a json format in the extension. The json format is stored in table “Data Archive Media Field” in a media field:
If you search for “Data Archive” in Business Central you find it:
In the ribbon just click on “Create new archive”, enter a name of your archive and then click on “Start logging”:
But you can also do it with code.
Also you can do it with the function SaveRecord() function. An example is shown in the report “Date Compress General Ledger”:
The only think is that you sometimes want to view historical data for analyses. I think then you can create an export function to an Azure Cosmos database and analyze it from there.
In this way the data is out of your hot database and stored in a low cost database.
So keep on archiving 😊
Leave a Reply