Introduction
Atea is the leading Nordic IT infrastructure provider, supplying and supporting solutions from major vendors across seven countries. To move faster and reduce risk, Atea replaced a home-grown SQL Server warehouse and hand-coded procedures with WhereScape automation—standardizing delivery and ensuring reliable, end-to-end BI.
Pre-WhereScape Challenges
- Legacy sprawl: a home-made SQL Server warehouse with sprawling stored procedures slowed change and introduced fragility.
- People dependency: key processes relied on individuals “doing the magic” creating risk and bottlenecks during absences.
- Manual operations: frequent hand-runs and code edits consumed engineering time and delayed business requests.
- Confidence gaps: overnight jobs required early-morning checks; stability issues eroded trust in downstream analytics.
“Now I can actually go on vacation and I don’t have to read my emails. I don’t have to get up at six in the morning, because WhereScape does it for me.”
– Torgil Hellman, Chief Architect, Atea
The Solution
Standardized Automation Platform
WhereScape RED became the single engine to ingest from SQL Server, generate warehouse objects, and schedule dependable ELT; replacing fragile, hand-built scripts.
Model-Driven Design
Engineers work from metadata and patterns rather than one-off code, ensuring consistent naming, repeatable transformations, and auto-generated documentation and lineage.
End-to-End Orchestration
Dependency-aware jobs run in the right order with retries and monitoring, delivering predictable overnight processing without manual intervention.
Rapid Change Management
New fields and dimensions are introduced in hours, not days—regenerate objects and jobs safely without trawling through stored procedures.
Results
🚀 Faster Delivery
- Builds cut from one day to one hour: more than 10x faster.
- New fields/dimensions deployed the same day.
🚀 Operational Confidence
- Stable schedules remove early-morning checks.
- Automated retries reduce failed-load escalations.
🚀 Higher-Value Work
- Developers focus on modeling and stakeholder needs.
- Less time spent reading and editing SQL by hand.
🚀 Scalable Foundation
- Consistent patterns simplify onboarding and reviews.
- Documentation and lineage generated automatically.
“It was a revelation to see that actually I can just push a button and it worked.”
– Torgil Hellman, Chief Architect, Atea
From Stored Procedures to Patterns
Before WhereScape, changes meant combing through SQL stored procedures and coordinating manual job runs. With WhereScape RED, engineers define intent at the metadata level and let the platform generate target-specific code and job flows.
Reliability Users Notice
Automated orchestration eliminated “babysitting” the nightly cycle. Teams trust that loads are complete, so analysts start the day with fresh data instead of waiting for fixes or re-runs.
Developer Experience
By shifting from hand-coding to automation, Atea’s developers spend more time with the business, iterating on models and delivering new attributes and dimensions quickly: improving both velocity and satisfaction.
