Categories
Architecture

Canonical Data Models Are a People Problem

Fragmented data estates usually share a trait – there’s no consistent representation of core business entities. It’s a common thread I’ve seen – system-centric entities and attributes, then another solution which recreates these in its own unique way. Different systems talking different languages make integrations messy and bespoke. It’s a technical mess, and it doesn’t […]

Categories
SSIS

Simple, Consistent, and Effective Failure Tracking in SSIS

SSIS packages provide great flexibility for integration between systems, but when they go wrong you can end up digging through logs or reports because every package logs differently. A standarised framework for tracking failures can drastically cut down troubleshooting time. I reminisced recently about old code, I said “it’s not enough to make it work correctly. It […]