{"id":12374,"date":"2021-04-02T16:15:00","date_gmt":"2021-04-02T14:15:00","guid":{"rendered":"https:\/\/xient.com.tr\/?p=12374"},"modified":"2024-01-29T13:38:15","modified_gmt":"2024-01-29T10:38:15","slug":"migration-und-prozessoptimierung-durch-sap-hana-data-lake","status":"publish","type":"post","link":"https:\/\/xient.com.tr\/en\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/","title":{"rendered":"Bayer-Monsanto: Migration and Process Optimization"},"content":{"rendered":"<p>When two industrial giants join forces, streamlining business processes is a truly monumental task. The best example was the merger of Bayer AG with the US company Monsanto. <a href=\"https:\/\/xient.de\/tr\/analytics\/\">Reporting and analysis specialists<\/a> Xient GmbH supported the huge wedding on various levels and ensured that everything ran smoothly.<\/p>\r\n<p>The systems and processes of two industry giants, some of them developed over decades, had to be harmonized and modernized during the merger. We were faced with the challenge of migrating the systems of seed specialist Monsanto to those of Bayer. After the migration, the data state did not only have to be uniform. A modern and high-performance target architecture was also part of the task. <a href=\"https:\/\/xient.de\/tr\/architektur\/\">Xient architects<\/a> employed.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-sap-hana-data-lake-ersetzt-veraltete-sap-queries\">SAP HANA data lake replaces legacy SAP queries<\/h3>\r\n\r\n\r\n\r\n<p>Monsanto relied on outdated SAP queries for around 200 relevant Knowledge Sets. After a detailed analysis of the data situation and consultation with decision makers at Bayer and Monsanto, we decided on an SAP HANA Data Lake database as the target architecture. This is hosted on Amazon Web Services Cloud. Our extensive expertise in lake architectures, as well as our extensive experience in working with large companies, especially in the pharmaceutical and logistics sectors, were the driving forces behind the successful implementation of the data merger between global companies.<\/p>\r\n<p>Our developers performed a systematic analysis of Monsanto's historically growing and therefore complex SAP queries. This also included deconstructing the sometimes opaque query logics through reverse engineering and categorizing the results by importance and complexity. Xient developers then transformed the legacy Monsanto Infosets into SAP HANA-based Compute Views.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\">Smooth process despite complex challenges<\/h3>\r\n\r\n\r\n\r\n<p>The integration of Monsanto data into the Bayer environment was of course a very interesting task, and not only because of the challenging data starting point. Our range of services also included the complete support of the merger. This included extensive testing and subsequent live activation of the SAP solutions developed, as well as training and support for employees. With global companies like Bayer and Monsanto, there are also challenging logistics involved. With employees in Europe, the US and India involved, all sub-processes had to be coordinated across three time zones.<\/p>\r\n<p>Despite all the perceived challenges, our Xient team managed to complete the data migration between Monsanto and Bayer quickly and with maximum efficiency. All data reconciliations between the old and new systems worked successfully and without errors according to our tests.<\/p>\r\n<p>The performance gains of the new architecture should not be underestimated: While queries based on legacy Monsanto Infosets sometimes have response times of up to 15 minutes, the modern SAP HANA in-memory database delivers results practically as real-time computational views. The chosen in-memory hosting in the AWS cloud provides a tremendous boost in performance and therefore productivity - a gain on every level that can be expected from an enterprise group of this size.<\/p>","protected":false},"excerpt":{"rendered":"<p>When two industrial giants join forces, streamlining business processes is a truly monumental task. The best example was the merger of Bayer AG with the US company Monsanto. Reporting and analysis specialists Xient GmbH supported the huge wedding on various levels and ensured that everything went smoothly. During the merger, the systems and processes of the two industry giants, some of which had been developed over decades [...]<\/p>","protected":false},"author":3,"featured_media":12964,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,8],"tags":[50,48,49,51],"class_list":["post-12374","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics-consulting","category-case-studies","tag-sap-hana","tag-sap-hana-data-lake","tag-sap-sorgulari","tag-veri-birlestirme"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SAP HANA veri g\u00f6l\u00fc arac\u0131l\u0131\u011f\u0131yla ge\u00e7i\u015f ve s\u00fcre\u00e7 optimizasyonu<\/title>\n<meta name=\"description\" content=\"Monsanto verilerini entegre etmek ilgin\u00e7 bir i\u015fti. SAP HANA veri g\u00f6l\u00fc veritaban\u0131 art\u0131k eski SAP sorgular\u0131n\u0131n yerini al\u0131yor.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/xient.com.tr\/en\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAP HANA veri g\u00f6l\u00fc arac\u0131l\u0131\u011f\u0131yla ge\u00e7i\u015f ve s\u00fcre\u00e7 optimizasyonu\" \/>\n<meta property=\"og:description\" content=\"Monsanto verilerini entegre etmek ilgin\u00e7 bir i\u015fti. SAP HANA veri g\u00f6l\u00fc veritaban\u0131 art\u0131k eski SAP sorgular\u0131n\u0131n yerini al\u0131yor.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/xient.com.tr\/en\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/\" \/>\n<meta property=\"og:site_name\" content=\"Yaz\u0131l\u0131m Tabanl\u0131 S\u00fcre\u00e7ler i\u00e7in Butik Dan\u0131\u015fmanl\u0131\u011f\u0131n\u0131z\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-02T14:15:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-29T10:38:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/xient.com.tr\/wp-content\/uploads\/2021\/10\/AdobeStock_336778740_Editorial_Use_Only-scaled.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Xient Redaktion\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Xient Redaktion\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAP HANA veri g\u00f6l\u00fc arac\u0131l\u0131\u011f\u0131yla ge\u00e7i\u015f ve s\u00fcre\u00e7 optimizasyonu","description":"Monsanto verilerini entegre etmek ilgin\u00e7 bir i\u015fti. SAP HANA veri g\u00f6l\u00fc veritaban\u0131 art\u0131k eski SAP sorgular\u0131n\u0131n yerini al\u0131yor.","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:\/\/xient.com.tr\/en\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/","og_locale":"en_US","og_type":"article","og_title":"SAP HANA veri g\u00f6l\u00fc arac\u0131l\u0131\u011f\u0131yla ge\u00e7i\u015f ve s\u00fcre\u00e7 optimizasyonu","og_description":"Monsanto verilerini entegre etmek ilgin\u00e7 bir i\u015fti. SAP HANA veri g\u00f6l\u00fc veritaban\u0131 art\u0131k eski SAP sorgular\u0131n\u0131n yerini al\u0131yor.","og_url":"https:\/\/xient.com.tr\/en\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/","og_site_name":"Yaz\u0131l\u0131m Tabanl\u0131 S\u00fcre\u00e7ler i\u00e7in Butik Dan\u0131\u015fmanl\u0131\u011f\u0131n\u0131z","article_published_time":"2021-04-02T14:15:00+00:00","article_modified_time":"2024-01-29T10:38:15+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/xient.com.tr\/wp-content\/uploads\/2021\/10\/AdobeStock_336778740_Editorial_Use_Only-scaled.jpeg","type":"image\/jpeg"}],"author":"Xient Redaktion","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Xient Redaktion","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/xient.com.tr\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/#article","isPartOf":{"@id":"https:\/\/xient.com.tr\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/"},"author":{"name":"Xient Redaktion","@id":"https:\/\/xient.com.tr\/#\/schema\/person\/bd087f21cf1c272e8b76f5f6237dc68b"},"headline":"Bayer-Monsanto: Migrasyon ve S\u00fcre\u00e7 Optimizasyonu","datePublished":"2021-04-02T14:15:00+00:00","dateModified":"2024-01-29T10:38:15+00:00","mainEntityOfPage":{"@id":"https:\/\/xient.com.tr\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/"},"wordCount":589,"publisher":{"@id":"https:\/\/xient.com.tr\/#organization"},"image":{"@id":"https:\/\/xient.com.tr\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/#primaryimage"},"thumbnailUrl":"https:\/\/xient.com.tr\/wp-content\/uploads\/2021\/10\/AdobeStock_336778740_Editorial_Use_Only-scaled.jpeg","keywords":["SAP HANA","SAP HANA-Data-Lake","SAP-Sorgular\u0131","Veri Birle\u015ftirme"],"articleSection":["Analytics Consulting","Case Studies"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/xient.com.tr\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/","url":"https:\/\/xient.com.tr\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/","name":"SAP HANA veri g\u00f6l\u00fc arac\u0131l\u0131\u011f\u0131yla ge\u00e7i\u015f ve s\u00fcre\u00e7 optimizasyonu","isPartOf":{"@id":"https:\/\/xient.com.tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/xient.com.tr\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/#primaryimage"},"image":{"@id":"https:\/\/xient.com.tr\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/#primaryimage"},"thumbnailUrl":"https:\/\/xient.com.tr\/wp-content\/uploads\/2021\/10\/AdobeStock_336778740_Editorial_Use_Only-scaled.jpeg","datePublished":"2021-04-02T14:15:00+00:00","dateModified":"2024-01-29T10:38:15+00:00","description":"Monsanto verilerini entegre etmek ilgin\u00e7 bir i\u015fti. SAP HANA veri g\u00f6l\u00fc veritaban\u0131 art\u0131k eski SAP sorgular\u0131n\u0131n yerini al\u0131yor.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/xient.com.tr\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/xient.com.tr\/2021\/04\/02\/migration-und-prozessoptimierung-durch-sap-hana-data-lake\/#primaryimage","url":"https:\/\/xient.com.tr\/wp-content\/uploads\/2021\/10\/AdobeStock_336778740_Editorial_Use_Only-scaled.jpeg","contentUrl":"https:\/\/xient.com.tr\/wp-content\/uploads\/2021\/10\/AdobeStock_336778740_Editorial_Use_Only-scaled.jpeg","width":2560,"height":1707,"caption":"Bayer AG, German multinational pharmaceutical and life sciences company, one of largest pharmaceutical companies in world brand, logo on its office building located in Lyon, France - February 23, 2020"},{"@type":"WebSite","@id":"https:\/\/xient.com.tr\/#website","url":"https:\/\/xient.com.tr\/","name":"Yaz\u0131l\u0131m Tabanl\u0131 S\u00fcre\u00e7ler i\u00e7in Butik Dan\u0131\u015fmanl\u0131\u011f\u0131n\u0131z","description":"Xient","publisher":{"@id":"https:\/\/xient.com.tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/xient.com.tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/xient.com.tr\/#organization","name":"Yaz\u0131l\u0131m Tabanl\u0131 S\u00fcre\u00e7ler i\u00e7in Butik Dan\u0131\u015fmanl\u0131\u011f\u0131n\u0131z","url":"https:\/\/xient.com.tr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/xient.com.tr\/#\/schema\/logo\/image\/","url":"https:\/\/xient.com.tr\/wp-content\/uploads\/2021\/08\/Xient_logo-scaled-e1624008296130.jpg","contentUrl":"https:\/\/xient.com.tr\/wp-content\/uploads\/2021\/08\/Xient_logo-scaled-e1624008296130.jpg","width":1555,"height":467,"caption":"Yaz\u0131l\u0131m Tabanl\u0131 S\u00fcre\u00e7ler i\u00e7in Butik Dan\u0131\u015fmanl\u0131\u011f\u0131n\u0131z"},"image":{"@id":"https:\/\/xient.com.tr\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/xient.com.tr\/#\/schema\/person\/bd087f21cf1c272e8b76f5f6237dc68b","name":"Xient Redaktion","url":"https:\/\/xient.com.tr\/en\/author\/redaktion\/"}]}},"_links":{"self":[{"href":"https:\/\/xient.com.tr\/en\/wp-json\/wp\/v2\/posts\/12374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xient.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xient.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xient.com.tr\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/xient.com.tr\/en\/wp-json\/wp\/v2\/comments?post=12374"}],"version-history":[{"count":8,"href":"https:\/\/xient.com.tr\/en\/wp-json\/wp\/v2\/posts\/12374\/revisions"}],"predecessor-version":[{"id":15850,"href":"https:\/\/xient.com.tr\/en\/wp-json\/wp\/v2\/posts\/12374\/revisions\/15850"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xient.com.tr\/en\/wp-json\/wp\/v2\/media\/12964"}],"wp:attachment":[{"href":"https:\/\/xient.com.tr\/en\/wp-json\/wp\/v2\/media?parent=12374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xient.com.tr\/en\/wp-json\/wp\/v2\/categories?post=12374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xient.com.tr\/en\/wp-json\/wp\/v2\/tags?post=12374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}