10
J

Date Compress Batch jobs

Jose Azevedo on 5/4/2020 4:04:31 PM
Following "Extend Data storage" for BC published in https://cloudblogs.microsoft.com/dynamics365/it/2020/04/28/extend-data-storage-for-dynamics-365-business-central/, i would suggest to bring again to Dynamics 365 BC the Data Compress batch jobs.
In previous Dynamics NAV versions (old ones I must admit), there was some Batch jobs to compress tables like General Ledger Entries for closed periods (Report 98 Date Compress General Ledger and Codeunit 356 DateComprMgt).

I would suggest to recreate similar batch jobs and besides the compress, it should allow to copy all the detailed transactions to Azure Data Lake storage.

This way, Dynamics 365 BC will have less transactions and need less storage but for a BI perspective, all the data will be available to be analysed.

Thanks,
Category: General
STATUS DETAILS
Needs Votes
Ideas Administrator

Business Central Team (administrator)

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.

Best regards,
Business Central Team

Comments

J

J

RE: Date Compress Batch jobs

Jose Azevedo on 5/14/2020 9:47:19 AM

Thanks Business Central team to consider this idea for voting.

As i first delivery, i would suggest to bring back the Data Compression routines from NAV versions. But not all of them. I would suggest:
Data Compression G/L Entries
Data Compression Bank Ledger Entries
Data Compression Customer Ledger Entries
Data Compression Vendor Ledger Entries
Data Compression Warehouse Entries.

As next deliveries, we can include more tables.

Category: General