{"id":92,"date":"2016-05-18T08:55:22","date_gmt":"2016-05-18T08:55:22","guid":{"rendered":"https:\/\/etlsolutions.com\/?p=92"},"modified":"2023-01-26T15:17:29","modified_gmt":"2023-01-26T15:17:29","slug":"efficient-multi-country-data-integration","status":"publish","type":"post","link":"https:\/\/etlsolutions.com\/efficient-multi-country-data-integration\/","title":{"rendered":"Efficient multi-country data integration for Snap-on"},"content":{"rendered":"<h2>The Challenge<\/h2>\n<p>Snap-on Business Solutions\u2019 Prism product provides sophisticated analysis and reporting services to automotive dealers and manufacturers. 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.<\/p>\n<h2>The Solution<\/h2>\n<p><a href=\"http:\/\/www.etlsolutions.com\/data-hub-3\/\">Our DataHub service<\/a> was implemented to obtain extracts from range of dealer management systems (DMS) in different markets. For instance, we integrate data in France from dealers\u2019 I\u2019Car and DCSNet systems, from Carfac DMS in Belgium, and in the Netherlands using EVA systems. The information collected includes data on parts stock, services and repairs and parts counter sales. Daily extracts are collected overnight, with minimal processing required at the dealership.<\/p>\n<p>Data is transferred to our DataHub, where data processing ensures that the information is accurate and complete. All data is passed to Prism, where further enhanced processing occurs and data can be viewed by the manufacturer and dealers. The result is a system of accurate integration with minimal risk and increased transparency. Snap-on have complete control of the dealerships\u2019 data.<\/p>\n<blockquote><p>\u201cETL Solutions are an essential component in our overall offer and bring an industry-leading technology platform that allows SBS to focus on our business improvement goals without worrying about the mechanics of getting the data.\u201d Sid Murrey, Snap-on Business Solutions<\/p><\/blockquote>\n<div id=\"downloads\">\n<ul>\n<li><a href=\"https:\/\/etlsolutions.com\/wp-content\/uploads\/2021\/10\/Datahub-Automotive-Brochure.pdf\">DataHub brochure<\/a><\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"The Challenge Snap-on Business Solutions\u2019 Prism product provides sophisticated analysis and reporting services to automotive dealers and manufacturers. 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. The Solution Our DataHub service was implemented to obtain extracts from range&#8230; <a class=\"view-article\" href=\"https:\/\/etlsolutions.com\/efficient-multi-country-data-integration\/\">View Article<\/a>","protected":false},"author":1,"featured_media":4591,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mo_disable_npp":"","footnotes":""},"categories":[8],"tags":[],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/posts\/92"}],"collection":[{"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/comments?post=92"}],"version-history":[{"count":6,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/posts\/92\/revisions"}],"predecessor-version":[{"id":7578,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/posts\/92\/revisions\/7578"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/media\/4591"}],"wp:attachment":[{"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/media?parent=92"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/categories?post=92"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/etlsolutions.com\/wp-json\/wp\/v2\/tags?post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}