Key Takeaways from 2024
Learn how AI is transforming document processing and delivering near-instant ROI to enterprises across various sectors.
Case Study
VinSolutions Keeps Track of over a Million Cars Using Astera’s Automated ETL.
Vendor On-boarding Time Reduced To 2 Developer Hours From 368 Developer Hours
99% Reduction in Time Spent on Vendor On-boarding
Background
Founded in 2006 and headquartered in Mission, Kansas, VinSolutions is the data service middleman between car dealerships and internet car marketing companies like AutoTrader.com and Cars.com. The company not only manages their own data integration and is responsible for integrating their software into the dealership management system (DMS), the core software application that automates car dealerships. In addition, VinSolutions works with another 60 to 80 smaller DMSs as well as custom-built DMSs.
Use Case
VinSolutions bears the brunt of the data integration challenges for AutoTrader and the other websites that dealers use to advertise their vehicles. Each car may have over 100 pieces of data that need to be updated daily. That includes critical data, such as the list price, along with various other pieces of metadata that determine how the vehicle should be listed. With listings on more than a million cars requiring updates every day, each with their own massive heap of data, the scale of the challenge for VinSolutions approaches big-data territory.
Profile
VinSolutions is an automotive software solution that works with car dealership companies like the AutoTrader Group to deliver a single view of the customers across a dealership.
Industry
Technology and Software
Use Case
Using Astera, VinSolutions scaled their data integration processes as their business grew, ensuring a seamless flow of data between dealerships and marketing platforms.
Results
Vendor on-boarding time reduced from 368 developer hours to 2 developer hours, which eliminated a lot of custom coding and data mapping work, saving developer resources significantly.
Enter Astera
After evaluating several data integration software solutions, VinSolutions chose Astera because it provided all the functionality they needed, including automated ETL, and the easy-to-use interface that enabled even non-IT employees to operate the software smoothly.
Astera’s data extraction capabilities allowed VinSolutions to seamlessly extract data from various DMSs, regardless of their customized configurations. This ensured that VinSolutions could efficiently access and integrate data from different sources without manual intervention.
Data transformation and mapping features also played a crucial role in standardizing the extracted data. VinSolutions could easily transform and map the data to a unified format, ensuring consistency and compatibility across systems. Data scheduling capabilities enabled VinSolutions to set up regular and automated data transfers, ensuring that the integrated data remained up-to-date and synchronized.
According to VinSolutions senior programmer Mike Ethetton, it could take up to two months for a developer to do the custom-coding to ensure the accurate capture of data from a new client’s DMS into the VinSolutions network. With Astera, that task has been cut to about an hour’s worth of work. With 70 to 100 car dealers going online with VinSolutions every month, the company has eliminated a lot of custom data mapping work on the part of its development team.
Authors:
Astera Analytics Team
Company
Partners
Customers
Support
Copyright © 2025 Astera Software. All rights reserved.