MOTOR Information Systems Cuts Time to Market in Half


LegiTest

MOTOR Information Systems needed an efficient way to compare subsequent loads of massive amounts of source data.

THE CHALLENGE

MOTOR Information Systems accumulates and maintains terabytes of automotive verhicle data collected from disparate sources. This data is standardized, organized, and made ready for consumption through an elaborate ELT/ETL process that lands transformed data in a data warehouse. It became increasingly difficult to verify the quality of data delivered since the data at source and destination is different in nature.

THE SOLUTION

MOTOR applied SentryOne's recently acquired Pragmatic Work's LegiTest and enabled automated, repeatable testing of data load row/elements counts versus prescribed upper and lower tolerances defined by historically accepted variances. These tests allowed MOTOR to automate the quality control process of the data load and eliminate the manual verification process.

THE RESULTS

LegiTest allowed MOTOR to reduce time to market from eight weeks to four weeks; 2X productivity. The automation of the quality control process eliminated manual testing, which was tedious, error-prone, and time-consuming. The LegiTest server is efficient and user-friendly, allowing all tests to be run from one location, and timely notifications of passed or failed results and a visual representation were provided.

 


“With the help of LegiTest data-driven tests, MOTOR automated and shortened the development and QA period and confirmed our confidence in the quality of the data we produce. ”

— Svetlana Latinsky, Senior Data Architect, MOTOR

motor-logo

MOTOR Information Systems is one of the world's premier suppliers of automotive data. Since 1903, MOTOR's mission has been to provide customers with accurate, thorough and timely information to help run their businesses more efficiently, effectively, and profitably. 



About SentryOne

SentryOne (sentryone.com, info@sentryone.com) empowers the Microsoft data professional to achieve breakthrough performance across physical, virtual, and cloud environments. The team shares its expertise at blogs.sentryone.com and sqlperformance.com.


 

Download the Case Study