← All customer stories
Case study · Cognos

A cloud migration, and a merger, without losing a report.

How Orthofix moved its entire Cognos estate to the cloud, absorbed a merger mid-flight, and cleaned house along the way.

The eighth-largest medical device company in the world
William Tarry
William Tarry
Senior BI Developer, Orthofix
10K → 6K
reports, cleaned up during the move
~5 min
to restore an accidentally deleted report
500+
users across a global estate
The challenge

Orthofix, the eighth-largest medical device company in the world, needed to move from on-prem Cognos to Cognos SaaS while keeping roughly 10,000 reports straight across a global user base. Reports were touched by many developers, with no easy way to know what was actually used. Then, near the end of the migration, a merger with C-Spine landed a second Cognos estate on a different stack (SQL Server vs. Oracle), doubling the complexity overnight.

The solution

Orthofix used Motio to inventory the whole estate: what existed, what was scheduled, and what was bouncing back to people who had left. Content was promoted cloud-side one business group at a time, with reports validated between environments before the old platform was switched off. When something was deleted by mistake, version control brought it back in minutes, and the same tooling compared C-Spine's reports across environments through the merger.

If you don't know what you have, you don't know what you need to take with you. MotioCI gave us that. Without it, the inventory alone would have taken two or three times as long.

William Tarry · Senior BI Developer, Orthofix
The results
Cleaned the estate from ~10,000 reports to ~5,000–6,000, archiving the rest safely
Restored accidentally deleted reports in about five minutes
Validated reports across environments through the C-Spine merger (SQL Server → Oracle)
Established a recurring cleanup cadence so the estate stays lean

Someone deletes something in the wrong folder, and within five minutes we've gone in and brought it back. The first couple of times I did that, it made them true believers.

William Tarry · Senior BI Developer, Orthofix

See what Motio can do for your Cognos team.

Book a Demo →More stories