The global nature of the automotive industry means that data often has to be integrated across different markets and diverse Dealership Management Systems (DMS).\u00a0 This case study illustrates how we extract data from different systems, creating seamless integration of all the different formats.<\/p>\n
Snap-on Business Solutions\u2019 Prism product provides sophisticated analysis and reporting services to automotive dealers and manufacturers.\u00a0 The challenge was to develop an efficient process for extracting accurate service, repairs, counter sales and parts data daily from dealerships for use in Prism.\u00a0 (Click here<\/a> for ideas on how dealerships can use their data to boost profitability.)<\/p>\n Our DataHub integration service is used to obtain extracts from range of Dealer Management Systems (DMS) in different markets.\u00a0 For instance, we integrate data in France from dealers\u2019 I\u2019Car and DCSNet systems, and in the Netherlands using EVA systems.<\/p>\n Daily data extracts are securely collected overnight via the internet, with minimal processing required at the dealership.\u00a0 The information collected includes parts stock, services, repairs and parts counter sales.\u00a0 The data is transferred to our DataHub, a core that forms the central part of the dealership data network, with points that are data sources.\u00a0 The software enables the core to share data bi-directionally with any number of sources.<\/p>\n The data is aggregated, replicated, converted and loaded into a target data store, before being transmitted to Prism.\u00a0 Once established, the DataHub operates automatically through a central configuration management facility.\u00a0 The software manages any changes in functionality, maintenance routines or software updates, and then deploys them automatically to each location or point.\u00a0 This reduces the burden of maintenance on the dealer and maintains a full audit trail.<\/p>\n After the data is passed to Prism, further enhanced processing occurs and data can be viewed by the manufacturer and dealers.\u00a0 The result is a system of accurate integration with minimal risk and increased transparency.\u00a0 The process is now being expanded to 200 dealers in France, over 100 in Belgium and a similar number in the Netherlands, providing Snap-on with complete control of the dealerships\u2019 data.<\/p>\nThe solution<\/h4>\n