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