How setup data and work with data

Written by Claus Petersen
Updated 1 year ago

To secure data integrity when two systems are integrated, you can incorporate measures 
into the data integration pipeline to retain the integrity of data1. Some of these measures include:

Data cleaning: Data cleaning accounts for 30-80% of data preparation efforts

Ideally, a data cleaning initiative should satisfy two objectives:

It should eliminate errors, inconsistencies, null values, 
and extra spaces, letters, or numerals from the source data.
The process should be standardized for all incoming data to reduce the manual 
effort in applying the same rules repetitively for streaming data.

Remove irrelevant data
Correct errors in data
Limit access to data and change permissions to constrain modifications to data by unapproved parties.

Focus on data validation to ensure the accuracy of data when collected or integrated.

Maintain a regular backup of data

Use logs to monitor when data is entered, altered, or erase

Conduct systematic internal audits to ensure that information is up-to-date.

!!!!!

Autotask is a from a Business Central perspectiv a non validations system, you can type add any data almost any where

Business Central, check almost all data and setup they ok, and can be used in the right way.

So this means to you.

Input cant be controlled in Autotask but can in Business Central

Beaware of the impact

Did this answer your question?