Validation & Testing

thorough validation ensures each connector behaves predictably and avoids unintended bulk changes pre deployment checks confirm the schema matches the source data — all required columns exist and are typed correctly validate key fields for uniqueness in the source review delete strategy (flagged vs result set) to confirm it aligns with data behaviour ensure history logging is enabled for traceability dry runs set processimport/maxchanges and processimport/maxdelete to low values (e g , 50) import a small data subset verify that detected changes appear in the connector data table with expected action states review pending changes in the web interface before running the process step functional testing validate that creates, updates, and deletes trigger the correct event handlers check that scripts, job submissions, and notifications execute as expected confirm that multi value and foreign key columns are parsed correctly review that role or user links resolve properly via the relevant link handlers error testing simulate missing or malformed data to confirm retries and error handling work verify that email notifications fire on error conditions confirm that connectors stop gracefully when exceeding maxdelete or maxchanges thresholds post deployment monitoring review history tables after each run to confirm change tracking monitor connector logs for warnings or retries spot check sample rows across the import, data, and history tables schedule automated notifications on failure conditions