Dynamics 365 ERP - General
Category
Nov 13, 2022
Published date
Text
Article Type
AI Summary
- The article discusses the high cost of storing data in the Dataverse, particularly in the actual database.
- The author suggests that for customers with larger datasets, especially those in B2C businesses, it is essential to analyze and find ways to minimize data storage costs.
- The article provides 10 tips to manage data and keep it from being expensive, including creating a deletion list and setting up deletion jobs, flattening verbose fields, using virtual tables, utilizing datalake with analytics, using datalake for archiving, compressing complex structures, cleaning up non-production environments, revising the datamodel, revising integrations, and setting a lifecycle for instances.
- The first tip advises going through the biggest storage contributors and identifying data that can be deleted, such as canceled orders or unnecessary emails.
- The second tip suggests cleaning out or removing redundant data, such as the body of emails that contain the same information sent to multiple customers.
- The third tip recommends using virtual tables to store data that doesn't need to be in the Dataverse database, accessing it through virtual tables from sources like SQL or Cosmos DB.
- The fourth tip highlights that Dataverse is not ideal for analytics and suggests using a datalake with Azure Synapse Analytics for efficient data analysis.
- The fifth tip suggests using a datalake for archiving data that is not frequently used but may be required for compliance purposes.
- The sixth tip advises compressing complex data structures, such as order structures, into summarized formats to save storage space.
- The seventh tip emphasizes the importance of cleaning up non-production environments and removing unnecessary data from test or staging instances.
- The eighth tip recommends revising the datamodel to simplify it and reduce storage overhead.
- The ninth tip focuses on revising integrations, especially with marketing applications or ERP systems, to reduce the storage of granular behavioral data or unnecessary data.
- The tenth tip suggests setting a clear lifecycle for instances to avoid unnecessary data consumption by clearly defining ownership and purpose.
Registered users can view the full text for FREE!
Sign In Now!