- 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.
- 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.
- 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.
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.
SentryOne (sentryone.com, firstname.lastname@example.org) 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.