{"id":35717,"date":"2022-04-17T17:42:46","date_gmt":"2022-04-17T15:42:46","guid":{"rendered":"http:\/\/54.194.80.134.nip.io\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/"},"modified":"2022-04-17T17:42:49","modified_gmt":"2022-04-17T15:42:49","slug":"the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi","status":"publish","type":"post","link":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/","title":{"rendered":"The Internet of Things, Big Data and a Fischertechnik Factory &#8211; Part 4: Access from an SAP HANA via Smart Data Integration (SDI)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"35717\" class=\"elementor elementor-35717 elementor-826\" data-elementor-settings=\"{&quot;element_pack_global_tooltip_width&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;element_pack_global_tooltip_width_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;element_pack_global_tooltip_width_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;element_pack_global_tooltip_padding&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_padding_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_padding_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_border_radius&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_border_radius_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_border_radius_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true}}\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-da107f1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"da107f1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-34a3a21\" data-id=\"34a3a21\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-211c023 elementor-widget elementor-widget-text-editor\" data-id=\"211c023\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\tIn the two previous parts of this blog, I described how the Fischertechnik factory simulation generates data in the form of a CSV file and how this data gets into the Hadoop cluster and is even available there as a table. This part is now about the various ways in which the contents of this table can now be reported on.\r\n\r\nThere are two relatively simple ways in which the data in this Hadoop table can be made available to SAP tools:\r\n\r\n1. in a HANA database via SDA (Smart Data Access) or SDI (Smart Data Integration). The data can then be consumed, for example, in an SAP Analytics for Cloud (no SAP BW system is then required for this) or in an SAP BW system.\r\n2. with the help of the middleware GLUE from our partner company Datavard, it is very easy to use ABAP transactions to create tables in Hadoop, read them out or move content back and forth between tables located in Hadoop and ABAP tables. This does not necessarily require a HANA database, but it does require an ABAP application server. I would like to present both possibilities here.\r\n\r\nSDA\/SDI\r\nSDA\/SDI SDA or SDI are connector libraries delivered by SAP. They allow the connection of a remote database and generate virtual links to the tables of this remote database. These virtual links can then be accessed as if they were local tables in the HANA database. The SDI adapters are technologically more advanced and have additional capabilities compared to the SDA adapters. In some cases, for example, they are capable of extracting only the delta changes by evaluating the changelogs rather than the tables. Whether and which capabilities the adapters have has to be checked in each individual case, e.g. in the Hadoop case, the adapters do not have this delta capability. Furthermore, in contrast to SDA, the SDI adapters are additionally chargeable.\r\n\r\nWe even connected our HANA database (HA4) with two different SDI adapters for test purposes, once via the SDI Hive adapter:\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-48b2f28 elementor-widget elementor-widget-image\" data-id=\"48b2f28\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/cdn.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_1.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"IoT4_1\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6ODMxLCJ1cmwiOiJodHRwczpcL1wvd3d3LmN1YmVzZXJ2LmNvbVwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAxOVwvMDlcL0lvVDRfMS5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1198\" height=\"370\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_1.png\" class=\"attachment-full size-full wp-image-831\" alt=\"\" srcset=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_1.png 1198w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_1-300x93.png 300w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_1-768x237.png 768w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_1-1024x316.png 1024w\" sizes=\"(max-width: 1198px) 100vw, 1198px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-25525b2 elementor-widget elementor-widget-text-editor\" data-id=\"25525b2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\tand once via the SDI-ImpalaAdapter:\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f3a8fa1 elementor-widget elementor-widget-image\" data-id=\"f3a8fa1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/cdn.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_2.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"IoT4_2\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6ODM0LCJ1cmwiOiJodHRwczpcL1wvd3d3LmN1YmVzZXJ2LmNvbVwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAxOVwvMDlcL0lvVDRfMi5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1198\" height=\"490\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_2.png\" class=\"attachment-full size-full wp-image-834\" alt=\"\" srcset=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_2.png 1198w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_2-300x123.png 300w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_2-768x314.png 768w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_2-1024x419.png 1024w\" sizes=\"(max-width: 1198px) 100vw, 1198px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fb4fdad elementor-widget elementor-widget-text-editor\" data-id=\"fb4fdad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\tThis makes it easy to create virtual table links (here in the DATA_EXTERN schema), which can be used to access the original table.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-836088c elementor-widget elementor-widget-image\" data-id=\"836088c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/cdn.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_3.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"IoT4_3\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6ODM3LCJ1cmwiOiJodHRwczpcL1wvd3d3LmN1YmVzZXJ2LmNvbVwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAxOVwvMDlcL0lvVDRfMy5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"214\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_3-1024x214.png\" class=\"attachment-large size-large wp-image-837\" alt=\"\" srcset=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_3-1024x214.png 1024w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_3-300x63.png 300w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_3-768x160.png 768w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_3.png 1199w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-44c56a8 elementor-widget elementor-widget-text-editor\" data-id=\"44c56a8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\tThis works also quite wonderfully, as e.g. the following query shows:\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-08b8035 elementor-widget elementor-widget-image\" data-id=\"08b8035\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"833\" height=\"628\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_4.png\" class=\"attachment-full size-full wp-image-840\" alt=\"\" srcset=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_4.png 833w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_4-300x226.png 300w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_4-768x579.png 768w\" sizes=\"(max-width: 833px) 100vw, 833px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>In the two previous parts of this blog, I described how the Fischertechnik factory simulation generates data in the form of a CSV file and how this data gets into the Hadoop cluster and is even available there as a table. This part is now about the various ways in which the contents of this &#8230; <a title=\"The Internet of Things, Big Data and a Fischertechnik Factory &#8211; Part 4: Access from an SAP HANA via Smart Data Integration (SDI)\" class=\"read-more\" href=\"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/\" aria-label=\"Read more about The Internet of Things, Big Data and a Fischertechnik Factory &#8211; Part 4: Access from an SAP HANA via Smart Data Integration (SDI)\">Read more<\/a><\/p>\n","protected":false},"author":16,"featured_media":831,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[41],"tags":[45,44,43],"class_list":["post-35717","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-iot","tag-business-analytics-platform","tag-hadoop","tag-hana"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>The Internet of Things, Big Data and a Fischertechnik Factory - Part 4: Access from an SAP HANA via Smart Data Integration (SDI) - CubeServ<\/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:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Internet of Things, Big Data and a Fischertechnik Factory - Part 4: Access from an SAP HANA via Smart Data Integration (SDI)\" \/>\n<meta property=\"og:description\" content=\"In the two previous parts of this blog, I described how the Fischertechnik factory simulation generates data in the form of a CSV file and how this data gets into the Hadoop cluster and is even available there as a table. This part is now about the various ways in which the contents of this ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/\" \/>\n<meta property=\"og:site_name\" content=\"CubeServ\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/CubeServ\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-17T15:42:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-17T15:42:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1198\" \/>\n\t<meta property=\"og:image:height\" content=\"370\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Thorsten Stossmeister\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@CubeServ\" \/>\n<meta name=\"twitter:site\" content=\"@CubeServ\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Thorsten Stossmeister\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\\\/\"},\"author\":{\"name\":\"Thorsten Stossmeister\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/#\\\/schema\\\/person\\\/2a15f26fb37d4ff3c8fb491ac4ce66d9\"},\"headline\":\"The Internet of Things, Big Data and a Fischertechnik Factory &#8211; Part 4: Access from an SAP HANA via Smart Data Integration (SDI)\",\"datePublished\":\"2022-04-17T15:42:46+00:00\",\"dateModified\":\"2022-04-17T15:42:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\\\/\"},\"wordCount\":402,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/IoT4_1.png\",\"keywords\":[\"Business Analytics Platform\",\"Hadoop\",\"HANA\"],\"articleSection\":[\"IoT\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\\\/\",\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\\\/\",\"name\":\"The Internet of Things, Big Data and a Fischertechnik Factory - Part 4: Access from an SAP HANA via Smart Data Integration (SDI) - CubeServ\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/IoT4_1.png\",\"datePublished\":\"2022-04-17T15:42:46+00:00\",\"dateModified\":\"2022-04-17T15:42:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/IoT4_1.png\",\"contentUrl\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/IoT4_1.png\",\"width\":1198,\"height\":370},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Internet of Things, Big Data and a Fischertechnik Factory &#8211; Part 4: Access from an SAP HANA via Smart Data Integration (SDI)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/\",\"name\":\"CubeServ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/#organization\",\"name\":\"CubeServ Group\",\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/CubeServ_Web_Logo-768x372-1.png\",\"contentUrl\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/CubeServ_Web_Logo-768x372-1.png\",\"width\":768,\"height\":372,\"caption\":\"CubeServ Group\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/CubeServ\",\"https:\\\/\\\/x.com\\\/CubeServ\",\"https:\\\/\\\/www.instagram.com\\\/cubeservgroup\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/112961\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/CubeServGroup\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/#\\\/schema\\\/person\\\/2a15f26fb37d4ff3c8fb491ac4ce66d9\",\"name\":\"Thorsten Stossmeister\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/elementor\\\/thumbs\\\/stossmeister_thorsten-backup-pz0j1qe4za2mtid8n7u1m19ontcib6ti4uoux2984c.jpg\",\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/elementor\\\/thumbs\\\/stossmeister_thorsten-backup-pz0j1qe4za2mtid8n7u1m19ontcib6ti4uoux2984c.jpg\",\"contentUrl\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/elementor\\\/thumbs\\\/stossmeister_thorsten-backup-pz0j1qe4za2mtid8n7u1m19ontcib6ti4uoux2984c.jpg\",\"caption\":\"Thorsten Stossmeister\"},\"description\":\"Competency Lead EDW\\\/HANA with sometimes old-fashioned preferences for backend and ABAP\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/stossmeister-thorsten-4b2427117\\\/\"],\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/en\\\/author\\\/stossmeistert\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The Internet of Things, Big Data and a Fischertechnik Factory - Part 4: Access from an SAP HANA via Smart Data Integration (SDI) - CubeServ","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:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/","og_locale":"en_US","og_type":"article","og_title":"The Internet of Things, Big Data and a Fischertechnik Factory - Part 4: Access from an SAP HANA via Smart Data Integration (SDI)","og_description":"In the two previous parts of this blog, I described how the Fischertechnik factory simulation generates data in the form of a CSV file and how this data gets into the Hadoop cluster and is even available there as a table. This part is now about the various ways in which the contents of this ... Read more","og_url":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/","og_site_name":"CubeServ","article_publisher":"https:\/\/www.facebook.com\/CubeServ","article_published_time":"2022-04-17T15:42:46+00:00","article_modified_time":"2022-04-17T15:42:49+00:00","og_image":[{"width":1198,"height":370,"url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_1.png","type":"image\/png"}],"author":"Thorsten Stossmeister","twitter_card":"summary_large_image","twitter_creator":"@CubeServ","twitter_site":"@CubeServ","twitter_misc":{"Written by":"Thorsten Stossmeister","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/#article","isPartOf":{"@id":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/"},"author":{"name":"Thorsten Stossmeister","@id":"https:\/\/www.cubeserv.com\/en\/#\/schema\/person\/2a15f26fb37d4ff3c8fb491ac4ce66d9"},"headline":"The Internet of Things, Big Data and a Fischertechnik Factory &#8211; Part 4: Access from an SAP HANA via Smart Data Integration (SDI)","datePublished":"2022-04-17T15:42:46+00:00","dateModified":"2022-04-17T15:42:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/"},"wordCount":402,"commentCount":0,"publisher":{"@id":"https:\/\/www.cubeserv.com\/en\/#organization"},"image":{"@id":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_1.png","keywords":["Business Analytics Platform","Hadoop","HANA"],"articleSection":["IoT"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/","url":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/","name":"The Internet of Things, Big Data and a Fischertechnik Factory - Part 4: Access from an SAP HANA via Smart Data Integration (SDI) - CubeServ","isPartOf":{"@id":"https:\/\/www.cubeserv.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/#primaryimage"},"image":{"@id":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_1.png","datePublished":"2022-04-17T15:42:46+00:00","dateModified":"2022-04-17T15:42:49+00:00","breadcrumb":{"@id":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/#primaryimage","url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_1.png","contentUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/09\/IoT4_1.png","width":1198,"height":370},{"@type":"BreadcrumbList","@id":"https:\/\/www.cubeserv.com\/en\/the-internet-of-things-big-data-and-a-fischertechnik-factory-part-4-access-from-an-sap-hana-via-smart-data-integration-sdi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.cubeserv.com\/en\/"},{"@type":"ListItem","position":2,"name":"The Internet of Things, Big Data and a Fischertechnik Factory &#8211; Part 4: Access from an SAP HANA via Smart Data Integration (SDI)"}]},{"@type":"WebSite","@id":"https:\/\/www.cubeserv.com\/en\/#website","url":"https:\/\/www.cubeserv.com\/en\/","name":"CubeServ","description":"","publisher":{"@id":"https:\/\/www.cubeserv.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cubeserv.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.cubeserv.com\/en\/#organization","name":"CubeServ Group","url":"https:\/\/www.cubeserv.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cubeserv.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/07\/CubeServ_Web_Logo-768x372-1.png","contentUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/07\/CubeServ_Web_Logo-768x372-1.png","width":768,"height":372,"caption":"CubeServ Group"},"image":{"@id":"https:\/\/www.cubeserv.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/CubeServ","https:\/\/x.com\/CubeServ","https:\/\/www.instagram.com\/cubeservgroup\/","https:\/\/www.linkedin.com\/company\/112961\/","https:\/\/www.youtube.com\/user\/CubeServGroup"]},{"@type":"Person","@id":"https:\/\/www.cubeserv.com\/en\/#\/schema\/person\/2a15f26fb37d4ff3c8fb491ac4ce66d9","name":"Thorsten Stossmeister","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/12\/elementor\/thumbs\/stossmeister_thorsten-backup-pz0j1qe4za2mtid8n7u1m19ontcib6ti4uoux2984c.jpg","url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/12\/elementor\/thumbs\/stossmeister_thorsten-backup-pz0j1qe4za2mtid8n7u1m19ontcib6ti4uoux2984c.jpg","contentUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/12\/elementor\/thumbs\/stossmeister_thorsten-backup-pz0j1qe4za2mtid8n7u1m19ontcib6ti4uoux2984c.jpg","caption":"Thorsten Stossmeister"},"description":"Competency Lead EDW\/HANA with sometimes old-fashioned preferences for backend and ABAP","sameAs":["https:\/\/www.linkedin.com\/in\/stossmeister-thorsten-4b2427117\/"],"url":"https:\/\/www.cubeserv.com\/en\/author\/stossmeistert\/"}]}},"_links":{"self":[{"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/posts\/35717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/comments?post=35717"}],"version-history":[{"count":0,"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/posts\/35717\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/media\/831"}],"wp:attachment":[{"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/media?parent=35717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/categories?post=35717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/tags?post=35717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}