Descripción

“Cada vez que trajimos un nuevo distribuidor, hubo que realizar muchos esfuerzos de desarrollo, mientras que con Astera, it’s a lot faster process, and it doesn’t require a developer to be involved every step of the way.” – Mike Ethetton, Senior Programmer

General

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.

Caso de uso

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.

Participar Astera Generador de canalización de datos

Después de evaluar varias soluciones de software de integración de datos, VinSolutions eligió 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 Data Pipeline Builder’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.

Según el programador senior de VinSolutions, Mike Ethetton, un desarrollador puede tardar hasta dos meses en realizar la codificación personalizada para garantizar la captura precisa de los datos del DMS de un nuevo cliente en la red de VinSolutions. Con 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.