{"id":3947,"date":"2020-05-26T13:13:03","date_gmt":"2020-05-26T13:13:03","guid":{"rendered":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/?p=3947"},"modified":"2025-11-18T08:40:59","modified_gmt":"2025-11-18T08:40:59","slug":"global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80","status":"publish","type":"post","link":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/","title":{"rendered":"Global QSR Accelerates Migration from Legacy ETL Platform to Talend by 80%"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><p>[vc_row][vc_column][vc_column_text css=&#8221;&#8221;]<\/p>\n<h2 class=\"wp-block-heading\">Challenge<\/h2>\n<p>This global QSR is responsible for global restaurant operations improvement captures and analyzes data about everything from food safety to speed of service and customer satisfaction. This data from over 37,000 restaurants across 108 markets worldwide, was stored in an on-premises IT ecosystem. To reduce its data center costs and improve the flexibility and scalability of its data management environment, this group decided to migrate its entire on-prem IT ecosystem to Amazon Web Services (AWS).<\/p>\n<p>The move to the cloud prompted the company to migrate its data integration tool as well. Concerned about diminishing support for DataStage, they enlisted Wavicle\u2019s ETL migration services to migrate to Talend.<\/p>\n<h2 class=\"wp-block-heading\">Solution<\/h2>\n<p>Wavicle\u2019s ETL migration experts approached the work in three phases:<\/p>\n<ul>\n<li><span style=\"font-size: 20px;\">Analysis: Analyzing, categorizing, and scoping the work<\/span><\/li>\n<li><span style=\"font-size: 20px;\">Development: Converting ETL jobs from DataStage to Talend<\/span><\/li>\n<li><span style=\"font-size: 20px;\">Testing: Testing of output across both platforms to compare results<\/span><\/li>\n<\/ul>\n<p>Our team leveraged ETL conversion accelerators and proprietary testing tools to automate and accelerate these time-consuming tasks and dramatically reduce the development time. To get started, they simply fed legacy ETL components to the ETL Conversion accelerator for analysis.<\/p>\n<p>In this case, the analysis of ETL jobs identified a large inventory of DataStage components. Working closely with the group\u2019s business analysts, we identified backup or obsolete jobs that could be eliminated from the conversion project. This left nearly 300 jobs to be analyzed and ranked for their level of complexity based on parameters such as the number of nodes, objects, occurrences, SQL statements, system types used, and transformation expressions.<\/p>\n<p>Using our ETL Conversion tool, we migrated these jobs to Talend and then used our Data Capturer tool to compare output across the legacy ETL and Talend platforms. These tools automated 80% of the development effort, requiring manual intervention only for the most complex jobs. Throughout the effort, we collaborated closely with the QSR\u2019s cloud migration team to ensure the environment was set up on AWS for accurate testing.<\/p>\n<h2 class=\"wp-block-heading\">Results<\/h2>\n<p>Using Wavicle\u2019s accelerators and frameworks to automate the analysis, conversion, and testing tasks, we successfully converted all ETL jobs to Talend, saving 95% of the analysis work and 81% of the development effort.<\/p>\n<h2 class=\"has-text-align-left wp-block-heading\">ETL Conversion tool reduces analysis and development time<\/h2>\n<table class=\"dttable\">\n<tbody>\n<tr>\n<td colspan=\"2\"><strong>Without ETL Converter<\/strong><\/td>\n<td colspan=\"2\"><strong>With ETL Converter<\/strong><\/td>\n<td><strong>Time Savings<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Total number of jobs<\/td>\n<td>283<\/td>\n<td>Total number of jobs<\/td>\n<td>283<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Estimated analysis hours<\/td>\n<td>1,056<\/td>\n<td>Actual analysis hours<\/td>\n<td>80<sup>1<\/sup><\/td>\n<td>95%<\/td>\n<\/tr>\n<tr>\n<td>Estimated conversion hours<\/td>\n<td>10,864<\/td>\n<td>Actual conversion hours<\/td>\n<td>2,077<sup>2<\/sup><\/td>\n<td>81%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 class=\"wp-block-heading\">Additional value of the project includes:<\/h3>\n<ul>\n<li class=\"wp-block-heading\"><strong style=\"font-size: 20px;\">Licensing cost savings:<\/strong><span style=\"font-size: 20px;\"> Move to Talend reduces ETL software licensing costs by 75%[3]<\/span><\/li>\n<li class=\"wp-block-heading\"><strong style=\"font-size: 20px;\">Ongoing software support:<\/strong><span style=\"font-size: 20px;\"> Access strong Talend support team and community vs. reduction in DataStage support<\/span><\/li>\n<li class=\"wp-block-heading\"><strong style=\"font-size: 20px;\">Integration:<\/strong><span style=\"font-size: 20px;\"> Talend provides seamless integration to other global data analytics solutions like RedShift, Tableau, Adhoc extracts etc.<\/span><\/li>\n<li class=\"wp-block-heading\"><strong style=\"font-size: 20px;\">Easier maintenance:<\/strong><span style=\"font-size: 20px;\"> Reduces costs of developer rates by cutting the time nearly in half to build, pull, and extract data elements with fewer errors than manual ETL<\/span><\/li>\n<li class=\"wp-block-heading\"><strong style=\"font-size: 20px;\">Reduced cycle time for enhancements:<\/strong><span style=\"font-size: 20px;\"> Developers can tap into the core products of Talend and use community-supported and created plugins to match any specific ETL need<\/span><\/li>\n<li class=\"wp-block-heading\"><strong style=\"font-size: 20px;\">Reduced infrastructure costs:<\/strong><span style=\"font-size: 20px;\">\u00a0Eliminating need for on-premises infrastructure saves data center operations and maintenance cost<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 14px;\"><strong>[1]<\/strong>\u00a0This effort denotes the time taken by the converter to generate detailed analysis reports. Additional effort was spent to validate and document the results.<br \/>\n<\/span><span style=\"font-size: 14px;\"><strong>[2]<\/strong>\u00a0This effort is for the overall conversion activity. A small amount of additional effort will be required to tweak the complex category jobs.<br \/>\n<\/span><span style=\"font-size: 14px;\"><strong>[3]<\/strong>\u00a0Based on the published pricing<\/span>[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_btn title=&#8221;Download Case Study&#8221; style=&#8221;classic&#8221; color=&#8221;blue&#8221; size=&#8221;lg&#8221; css=&#8221;&#8221; link=&#8221;url:https%3A%2F%2Fwavicledata.com%2Fwp-content%2Fuploads%2F2020%2F05%2FMcDonalds_Talend.pdf|target:_blank&#8221;][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Migrated 550+ Tableau dashboards to QuickSight using EZConvertBI, achieving 80% automation, 60% time savings, and seamless collaboration under tight timelines and data constraints.<\/p>\n","protected":false},"author":2,"featured_media":5252,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[77,141,76,54,72,120,98,95],"tags":[],"class_list":["post-3947","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-architecture-engineering","category-aws","category-build-migrations","category-case-studies","category-data-management","category-ibm-datastage","category-talend","category-technology","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Global QSR Boosts ETL Migration Speed by 80% with Talend<\/title>\n<meta name=\"description\" content=\"Learn how a global QSR accelerated its migration to Talend, improving ETL process efficiency and data management capabilities.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Global QSR Boosts ETL Migration Speed by 80% with Talend\" \/>\n<meta property=\"og:description\" content=\"Learn how a global QSR accelerated its migration to Talend, improving ETL process efficiency and data management capabilities.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/\" \/>\n<meta property=\"og:site_name\" content=\"Wavicle Data Solutions\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-26T13:13:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-18T08:40:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2020\/05\/1717.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1065\" \/>\n\t<meta property=\"og:image:height\" content=\"930\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Data Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Data Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/\",\"url\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/\",\"name\":\"Global QSR Boosts ETL Migration Speed by 80% with Talend\",\"isPartOf\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2020\/05\/1717.jpg\",\"datePublished\":\"2020-05-26T13:13:03+00:00\",\"dateModified\":\"2025-11-18T08:40:59+00:00\",\"author\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/dd7976fcb051bcb40f39bb51c8fbdd9e\"},\"description\":\"Learn how a global QSR accelerated its migration to Talend, improving ETL process efficiency and data management capabilities.\",\"breadcrumb\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/#primaryimage\",\"url\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2020\/05\/1717.jpg\",\"contentUrl\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2020\/05\/1717.jpg\",\"width\":1065,\"height\":930},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Global QSR Accelerates Migration from Legacy ETL Platform to Talend by 80%\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#website\",\"url\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/\",\"name\":\"Wavicle Data Solutions\",\"description\":\"and analytics consulting solutions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/dd7976fcb051bcb40f39bb51c8fbdd9e\",\"name\":\"Data Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e23491a3af11f4a98f6410b9023b80c0675cb87552af0094392cf966c0311a96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e23491a3af11f4a98f6410b9023b80c0675cb87552af0094392cf966c0311a96?s=96&d=mm&r=g\",\"caption\":\"Data Team\"},\"url\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/author\/data-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Global QSR Boosts ETL Migration Speed by 80% with Talend","description":"Learn how a global QSR accelerated its migration to Talend, improving ETL process efficiency and data management capabilities.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Global QSR Boosts ETL Migration Speed by 80% with Talend","og_description":"Learn how a global QSR accelerated its migration to Talend, improving ETL process efficiency and data management capabilities.","og_url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/","og_site_name":"Wavicle Data Solutions","article_published_time":"2020-05-26T13:13:03+00:00","article_modified_time":"2025-11-18T08:40:59+00:00","og_image":[{"width":1065,"height":930,"url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2020\/05\/1717.jpg","type":"image\/jpeg"}],"author":"Data Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Data Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/","url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/","name":"Global QSR Boosts ETL Migration Speed by 80% with Talend","isPartOf":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/#primaryimage"},"image":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/#primaryimage"},"thumbnailUrl":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2020\/05\/1717.jpg","datePublished":"2020-05-26T13:13:03+00:00","dateModified":"2025-11-18T08:40:59+00:00","author":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/dd7976fcb051bcb40f39bb51c8fbdd9e"},"description":"Learn how a global QSR accelerated its migration to Talend, improving ETL process efficiency and data management capabilities.","breadcrumb":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/#primaryimage","url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2020\/05\/1717.jpg","contentUrl":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2020\/05\/1717.jpg","width":1065,"height":930},{"@type":"BreadcrumbList","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/global-qsr-accelerates-migration-from-legacy-etl-platform-to-talend-by-80\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/"},{"@type":"ListItem","position":2,"name":"Global QSR Accelerates Migration from Legacy ETL Platform to Talend by 80%"}]},{"@type":"WebSite","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#website","url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/","name":"Wavicle Data Solutions","description":"and analytics consulting solutions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/dd7976fcb051bcb40f39bb51c8fbdd9e","name":"Data Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e23491a3af11f4a98f6410b9023b80c0675cb87552af0094392cf966c0311a96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e23491a3af11f4a98f6410b9023b80c0675cb87552af0094392cf966c0311a96?s=96&d=mm&r=g","caption":"Data Team"},"url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/author\/data-team\/"}]}},"_links":{"self":[{"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/posts\/3947","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/comments?post=3947"}],"version-history":[{"count":5,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/posts\/3947\/revisions"}],"predecessor-version":[{"id":4168,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/posts\/3947\/revisions\/4168"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/media\/5252"}],"wp:attachment":[{"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/media?parent=3947"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/categories?post=3947"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/tags?post=3947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}