{"id":497471,"date":"2022-02-17T13:30:00","date_gmt":"2022-02-17T12:30:00","guid":{"rendered":"https:\/\/www.devoteam.com\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/"},"modified":"2025-04-10T11:08:32","modified_gmt":"2025-04-10T09:08:32","slug":"tradera-path-to-modernisation-with-devoteam-g-cloud-2","status":"publish","type":"success-story","link":"https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/","title":{"rendered":"Tradera: Path to Modernisation with Devoteam G Cloud"},"content":{"rendered":"\n\t
\n\n\t\n\t

In Short<\/h3>
1<\/span><\/div>

Operation at this scale demands agility to align with business growth and goals.<\/p><\/div><\/div>

2<\/span><\/div>

Tradera\u2019s data warehouse was on-premise, and a decision was made to re-platform it to run on BigQuery instead.<\/p><\/div><\/div>

3<\/span><\/div>

The solution? Data warehouse modernisation. Their goal was to migrate to the cloud, so Tradera got in touch with Devoteam G Cloud in August of 2019 to assist in their legacy migration.<\/p><\/div><\/div><\/div>\n\t\n\t<\/div>\n\n\n\n\n\t

\n\n\t\n\t
\n\n<\/svg>

We enjoyed working with the team from Devoteam G Cloud, who were knowledgeable, responsive and professional during our data warehouse project together.<\/p><\/blockquote>

\n
\"\"<\/figure>\n
\n\t

Patrik Akselsson<\/p>\n\t\n\t

CTO at Tradera<\/p>\n\t<\/div>\n<\/div>\n<\/figcaption><\/figure>\n\t\n\t<\/div>\n\n\n\n\n

About Tradera<\/h2>\n\n\n\n

Tradera, a leading online commercial marketplace, hosts more than 2.5 million members offering millions of listings for products in categories like collectables, electronics, clothing and art. These listings can be purchased via auctions or fixed prices.<\/p>\n\n\n\n

Tradera sees more than 4 million visits weekly to their site. Though most of their members are Swedish, Tradera is accessible to members around the world. The headquarters of Tradera is in Sweden.<\/p>\n\n\n\n

The Problem<\/h2>\n\n\n\n

Whole Tradera\u2019s data warehouse was on-premise. They made a decision to re-platform it to run on BigQuery instead. Previously having conducted a project on BigQuery, they discovered the advantages of using a scalable and serverless data warehouse.<\/p>\n\n\n\n

The Goal<\/h2>\n\n\n\n

The goal was to migrate to a scalable and serverless data warehouse. <\/p>\n\n\n\n

The Solution<\/h2>\n\n\n\n

The first step was to run an investigation on their needs and present their findings to Tradera through a proof-of-concept. According to their Data Warehouse Modernisation methodology developed in tandem with Google, they first prepared a Technical Analytics Design Document, detailing how they would deliver the solution covering all the differences in programming syntax between Microsoft SQL and BigQuery.<\/p>\n\n\n\n

In their check-up they covered topics such as Backup and Restore, Migration, Transformation, Monitoring, Data Access Management and forged an agenda to develop this solution.<\/p>\n\n\n\n

The plan was to implement different ETL pipelines on Google Cloud and transform the data in Big Query without sacrificing data accuracy.<\/p>\n\n\n\n\t

\n\n\t\n\t
\n\n<\/svg>

Using the new setup on BigQuery and Cloud Composer, ETL performance was quadrupled. ETL pipelines were also easily monitored via Grafana and source controlled for increased transparency.<\/p><\/blockquote>

\n
\"\"<\/figure>\n
\n\t

Jason Quek<\/p>\n\t\n\t

CTO at Devoteam G Cloud Sweden<\/p>\n\t<\/div>\n<\/div>\n<\/figcaption><\/figure>\n\t\n\t<\/div>\n\n\n\n\n

Methodology<\/h2>\n\n\n\n

Experts from Devoteam G Cloud performed the migration of the infrastructure, stored the data and maintained the visualisation layer after the transformation. Some of the steps included re-designing the ETL pipeline and translating MS SQL to represent the same logic in BigQuery.<\/p>\n\n\n\n

The Result<\/h2>\n\n\n\n

The project was successfully completed in mid-April, and now Tradera runs most of their workloads in Google Cloud, using BigQuery to analyse their business. <\/p>\n\n\n\n

\u201cUsing the new setup on BigQuery and Cloud Composer, ETL performance was quadrupled. ETL pipelines were also easily monitored via Grafana and source controlled for increased transparency.\u201d
-Jason Quek, CTO, Devoteam G Cloud<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Tradera\u2019s data warehouse was on-premise. The goal was to migrate to a scalable and serverless data warehouse. The solution? Data warehouse modernisation. Tradera decided to migrate to the cloud, so Tradera got in touch with Devoteam G Cloud in August of 2019 to assist in their legacy migration. Now Tradera runs most of their workloads in Google Cloud, using BigQuery to analyse their business.<\/p>\n","protected":false},"featured_media":497473,"template":"","categories":[2604],"tags":[2605,3593],"industry":[],"class_list":["post-497471","success-story","type-success-story","status-publish","has-post-thumbnail","hentry","category-google-cloud-sk","tag-google-cloud-sk","tag-modernisation-sk"],"acf":[],"cards":"\n\t

\n\n\t\t
\"Tradera:<\/a><\/figure>\n\n\t\t\n\t\t
\n\t

Success story<\/p>\n\n\t\t\n\t\t

Tradera: Path to Modernisation with Devoteam G Cloud<\/a><\/h3><\/div>\n\t\t\n\t<\/div>\n\n","yoast_head":"\nTradera: Path to Modernisation with Devoteam G Cloud | Devoteam<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tradera: Path to Modernisation with Devoteam G Cloud\" \/>\n<meta property=\"og:description\" content=\"Tradera\u2019s data warehouse was on-premise. The goal was to migrate to a scalable and serverless data warehouse. The solution? Data warehouse modernisation. Tradera decided to migrate to the cloud, so Tradera got in touch with Devoteam G Cloud in August of 2019 to assist in their legacy migration. Now Tradera runs most of their workloads in Google Cloud, using BigQuery to analyse their business.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Devoteam\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-10T09:08:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/john-schnobrich-FlPc9_VocJ4-unsplash.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\\\/\",\"url\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\\\/\",\"name\":\"Tradera: Path to Modernisation with Devoteam G Cloud | Devoteam\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/john-schnobrich-FlPc9_VocJ4-unsplash.jpg\",\"datePublished\":\"2022-02-17T12:30:00+00:00\",\"dateModified\":\"2025-04-10T09:08:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\\\/#breadcrumb\"},\"inLanguage\":\"en-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-SK\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\\\/#primaryimage\",\"url\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/john-schnobrich-FlPc9_VocJ4-unsplash.jpg\",\"contentUrl\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/john-schnobrich-FlPc9_VocJ4-unsplash.jpg\",\"width\":1920,\"height\":1280},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Success stories\",\"item\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/success-story\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Tradera: Path to Modernisation with Devoteam G Cloud\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/#website\",\"url\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/\",\"name\":\"Devoteam\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/devoteam.info\\\/sk\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-SK\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Tradera: Path to Modernisation with Devoteam G Cloud | Devoteam","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/","og_locale":"en_US","og_type":"article","og_title":"Tradera: Path to Modernisation with Devoteam G Cloud","og_description":"Tradera\u2019s data warehouse was on-premise. The goal was to migrate to a scalable and serverless data warehouse. The solution? Data warehouse modernisation. Tradera decided to migrate to the cloud, so Tradera got in touch with Devoteam G Cloud in August of 2019 to assist in their legacy migration. Now Tradera runs most of their workloads in Google Cloud, using BigQuery to analyse their business.","og_url":"https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/","og_site_name":"Devoteam","article_modified_time":"2025-04-10T09:08:32+00:00","og_image":[{"width":1920,"height":1280,"url":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/john-schnobrich-FlPc9_VocJ4-unsplash.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/","url":"https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/","name":"Tradera: Path to Modernisation with Devoteam G Cloud | Devoteam","isPartOf":{"@id":"https:\/\/devoteam.info\/sk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/#primaryimage"},"image":{"@id":"https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/#primaryimage"},"thumbnailUrl":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/john-schnobrich-FlPc9_VocJ4-unsplash.jpg","datePublished":"2022-02-17T12:30:00+00:00","dateModified":"2025-04-10T09:08:32+00:00","breadcrumb":{"@id":"https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/#breadcrumb"},"inLanguage":"en-SK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-SK","@id":"https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/#primaryimage","url":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/john-schnobrich-FlPc9_VocJ4-unsplash.jpg","contentUrl":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/john-schnobrich-FlPc9_VocJ4-unsplash.jpg","width":1920,"height":1280},{"@type":"BreadcrumbList","@id":"https:\/\/devoteam.info\/sk\/success-story\/tradera-path-to-modernisation-with-devoteam-g-cloud-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devoteam.info\/sk\/"},{"@type":"ListItem","position":2,"name":"Success stories","item":"https:\/\/devoteam.info\/sk\/success-story\/"},{"@type":"ListItem","position":3,"name":"Tradera: Path to Modernisation with Devoteam G Cloud"}]},{"@type":"WebSite","@id":"https:\/\/devoteam.info\/sk\/#website","url":"https:\/\/devoteam.info\/sk\/","name":"Devoteam","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devoteam.info\/sk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-SK"}]}},"uagb_featured_image_src":{"full":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/john-schnobrich-FlPc9_VocJ4-unsplash.jpg",1920,1280,false],"thumbnail":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/john-schnobrich-FlPc9_VocJ4-unsplash-150x150.jpg",150,150,true],"medium":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/john-schnobrich-FlPc9_VocJ4-unsplash-300x200.jpg",300,200,true],"medium_large":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/john-schnobrich-FlPc9_VocJ4-unsplash-768x512.jpg",768,512,true],"large":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/john-schnobrich-FlPc9_VocJ4-unsplash-1024x683.jpg",1024,683,true],"1536x1536":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/john-schnobrich-FlPc9_VocJ4-unsplash-1536x1024.jpg",1536,1024,true],"2048x2048":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/john-schnobrich-FlPc9_VocJ4-unsplash.jpg",1920,1280,false]},"uagb_author_info":{"display_name":"Julien Pawlowski","author_link":"https:\/\/devoteam.info\/sk\/author\/"},"uagb_comment_info":0,"uagb_excerpt":"Tradera\u2019s data warehouse was on-premise. The goal was to migrate to a scalable and serverless data warehouse. The solution? Data warehouse modernisation. Tradera decided to migrate to the cloud, so Tradera got in touch with Devoteam G Cloud in August of 2019 to assist in their legacy migration. Now Tradera runs most of their workloads…","_links":{"self":[{"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/success-story\/497471","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/success-story"}],"about":[{"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/types\/success-story"}],"version-history":[{"count":0,"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/success-story\/497471\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/media\/497473"}],"wp:attachment":[{"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/media?parent=497471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/categories?post=497471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/tags?post=497471"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/devoteam.info\/sk\/wp-json\/wp\/v2\/industry?post=497471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}