{"id":4050,"date":"2017-03-21T00:00:00","date_gmt":"2017-03-21T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration"},"modified":"2025-06-16T08:22:28","modified_gmt":"2025-06-16T15:22:28","slug":"azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/","title":{"rendered":"Azure Data Factory offers SAP HANA and Business Warehouse data integration"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/data-factory\/\">Azure Data Factory<\/a> is a cloud-based data integration service that orchestrates and automates the movement and transformation of data, which support copying data from <a href=\"https:\/\/azure.microsoft.com\/en-us\/documentation\/articles\/data-factory-data-movement-activities\/#supported-data-stores-and-formats\">25+ data stores<\/a> on-premises and in the cloud easily and performantly. Today, we are excited to announce that Azure Data Factory newly enables <b>loading data from SAP HANA and SAP Business Warehouse (BW) <\/b><b>into various Azure data stores<\/b><b> for advanced analytics and reporting, <\/b>including Azure Blob, Azure Data Lake, Azure SQL DW, etc.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-s-new\">What\u2019s new<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SAP is one of the most widely-used enterprise software in the world. We hear you that it\u2019s crucial for Microsoft to empower customers to integrate their existing SAP system with Azure to unblock business insights. Azure Data Factory start the SAP data integration support with SAP HANA and SAP BW, which are the most popular ones in the SAP stack used by enterprise customers.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With this release, you can easily ingest data from the existing SAP HANA and SAP BW to Azure, so as to build your own intelligent solutions by leveraging Azure\u2019s first-class information management services, big data stores, advanced analytics tools, and intelligence toolkits to transform data into intelligent action. More specifically:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">The <b>SAP HANA connector<\/b> supports copying data from HANA information models (such as Analytic and Calculation views) as well as Row and Column tables using SQL queries. To establish the connectivity, you need to install the latest Data Management Gateway (version 2.8) and the SAP HANA ODBC driver. Refer to <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/data-factory-sap-hana-connector#supported-versions-and-installation\">SAP HANA supported versions and installation<\/a> on more details.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">The <b>SAP BW connector<\/b> supports copying data from SAP Business Warehouse version 7.x InfoCubes and QueryCubes (including BEx queries) using MDX queries. To establish the connectivity, you need to install the latest Data Management Gateway (version 2.8) and the SAP NetWeaver library. Refer to <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/data-factory-sap-business-warehouse-connector#supported-versions-and-installation\">SAP BW supported versions and installation<\/a> on more details.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-s-next\">What\u2019s next<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Beyond SAP HANA and SAP BW support, we also want to learn from you what other services in SAP stack you are using and looking to integrate. Go vote and comment on <a href=\"https:\/\/feedback.azure.com\/forums\/270578-data-factory\/suggestions\/10203972-integrating-with-sap-using-azure-data-factory\">Azure feedback site<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"get-started\">Get started<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To try out the new capabilities, provision a Data Factory from the Azure portal if you don\u2019t have one, then click Copy Data to launch the <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/data-factory-copy-wizard\">intuitive copy wizard<\/a> which will guide you through the configurations. In the source data store gallery, you will find SAP HANA and SAP BW as follows:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2f05eeaa-d6ac-4c5e-a594-40ed51a18c91-1.webp\" alt=\"Data Factory source data store gallery\" title=\"Data Factory source data store gallery\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"sap-hana\"><b>SAP HANA<\/b><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">After selecting SAP HANA from the gallery, specify the connection info on Data Management Gateway name, HANA server, user name and password.\u00a0<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/252177e3-d210-41ef-8ff5-b2d9e5ed5c61-1.webp\" alt=\"Form\" class=\"wp-image-10428 webp-format\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/252177e3-d210-41ef-8ff5-b2d9e5ed5c61-1.webp\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Then you will see a page with navigator and query editor. Browse and pick the measures and dimensions, a base SQL query will be auto generated in the Query Editor as reference according to your selection, and you can review and further customize there. Click Validate Query to see the preview data and schema.\u00a0<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/cf5db490-5f47-4231-8989-0f39735da0fc-1.webp\" alt=\"graphical user interface, text, application, email\" class=\"wp-image-10430 webp-format\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/cf5db490-5f47-4231-8989-0f39735da0fc-1.webp\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"sap-bw\"><b>SAP BW<\/b><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">After selecting SAP BW from the gallery, specify the connection info on Data Management Gateway name, BW server, system number, client ID, user name and password. <\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2b9dd361-13ab-4e63-af38-dcb104da8921.webp\" alt=\"graphical user interface, text, application\" class=\"wp-image-10432 webp-format\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2b9dd361-13ab-4e63-af38-dcb104da8921.webp\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Then you will see a page with navigator and query editor. Browse and pick the measures and dimensions, a base MDX query will be auto generated in the Query Editor as reference according to your selection, and you can review and further customize there. Click Validate Query to see the preview data and schema.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/95fe8fd7-8485-40f9-849d-9c2cfecdc06c.webp\" alt=\"graphical user interface, text, application, email\" class=\"wp-image-10434 webp-format\" data-orig-src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/95fe8fd7-8485-40f9-849d-9c2cfecdc06c.webp\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Once you finish your settings on SAP source, continue following the wizard to configure the destination.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"reference-1\">Reference<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Learn more on Azure Data Factory from\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/data-factory-introduction\">Introduction to Azure Data Factory<\/a>\u00a0and\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/data-factory-data-movement-activities\">Move data by using Copy Activity<\/a><\/li>\n\n\n\n<li class=\"wp-block-list-item\">Refer to\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/data-factory-sap-hana-connector\">SAP HANA support<\/a>\u00a0and\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/data-factory-sap-business-warehouse-connector\">SAP Business Warehouse support<\/a>\u00a0respectively on connector details<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Today, we are excited to announce that Azure Data Factory newly enable loading data from SAP HANA and SAP Business Warehouse (BW) into various Azure data stores for advanced analytics and reporting.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1474,1473],"tags":[],"audience":[3054,3057,3053],"content-type":[1465],"product":[1821],"tech-community":[],"topic":[],"coauthors":[591],"class_list":["post-4050","post","type-post","status-publish","format-standard","hentry","category-analytics","category-databases","audience-business-decision-makers","audience-data-professionals","audience-it-decision-makers","content-type-announcements","product-azure-data-factory","review-flag-1680286581-364","review-flag-2-1680286581-601","review-flag-7-1680286581-146","review-flag-8-1680286581-263","review-flag-integ-1680286579-214","review-flag-new-1680286579-546"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Azure Data Factory offers SAP HANA and Business Warehouse data integration | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"Today, we are excited to announce that Azure Data Factory newly enable loading data from SAP HANA and SAP Business Warehouse (BW) into various Azure data stores for advanced analytics and reporting.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure Data Factory offers SAP HANA and Business Warehouse data integration | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"Today, we are excited to announce that Azure Data Factory newly enable loading data from SAP HANA and SAP Business Warehouse (BW) into various Azure data stores for advanced analytics and reporting.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-21T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-16T15:22:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2f05eeaa-d6ac-4c5e-a594-40ed51a18c91-1.webp\" \/>\n<meta name=\"author\" content=\"Linda Wang\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Linda Wang\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/linda-wang\/\",\"@type\":\"Person\",\"@name\":\"Linda Wang\"}],\"headline\":\"Azure Data Factory offers SAP HANA and Business Warehouse data integration\",\"datePublished\":\"2017-03-21T00:00:00+00:00\",\"dateModified\":\"2025-06-16T15:22:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/\"},\"wordCount\":619,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2f05eeaa-d6ac-4c5e-a594-40ed51a18c91-1.webp\",\"articleSection\":[\"Analytics\",\"Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/\",\"name\":\"Azure Data Factory offers SAP HANA and Business Warehouse data integration | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2f05eeaa-d6ac-4c5e-a594-40ed51a18c91-1.webp\",\"datePublished\":\"2017-03-21T00:00:00+00:00\",\"dateModified\":\"2025-06-16T15:22:28+00:00\",\"description\":\"Today, we are excited to announce that Azure Data Factory newly enable loading data from SAP HANA and SAP Business Warehouse (BW) into various Azure data stores for advanced analytics and reporting.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2f05eeaa-d6ac-4c5e-a594-40ed51a18c91-1.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2f05eeaa-d6ac-4c5e-a594-40ed51a18c91-1.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analytics\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/analytics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Azure Data Factory offers SAP HANA and Business Warehouse data integration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure Data Factory offers SAP HANA and Business Warehouse data integration | Microsoft Azure Blog","description":"Today, we are excited to announce that Azure Data Factory newly enable loading data from SAP HANA and SAP Business Warehouse (BW) into various Azure data stores for advanced analytics and reporting.","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:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/","og_locale":"en_US","og_type":"article","og_title":"Azure Data Factory offers SAP HANA and Business Warehouse data integration | Microsoft Azure Blog","og_description":"Today, we are excited to announce that Azure Data Factory newly enable loading data from SAP HANA and SAP Business Warehouse (BW) into various Azure data stores for advanced analytics and reporting.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2017-03-21T00:00:00+00:00","article_modified_time":"2025-06-16T15:22:28+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2f05eeaa-d6ac-4c5e-a594-40ed51a18c91-1.webp","type":"","width":"","height":""}],"author":"Linda Wang","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Linda Wang","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/linda-wang\/","@type":"Person","@name":"Linda Wang"}],"headline":"Azure Data Factory offers SAP HANA and Business Warehouse data integration","datePublished":"2017-03-21T00:00:00+00:00","dateModified":"2025-06-16T15:22:28+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/"},"wordCount":619,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2f05eeaa-d6ac-4c5e-a594-40ed51a18c91-1.webp","articleSection":["Analytics","Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/","name":"Azure Data Factory offers SAP HANA and Business Warehouse data integration | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2f05eeaa-d6ac-4c5e-a594-40ed51a18c91-1.webp","datePublished":"2017-03-21T00:00:00+00:00","dateModified":"2025-06-16T15:22:28+00:00","description":"Today, we are excited to announce that Azure Data Factory newly enable loading data from SAP HANA and SAP Business Warehouse (BW) into various Azure data stores for advanced analytics and reporting.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2f05eeaa-d6ac-4c5e-a594-40ed51a18c91-1.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2017\/03\/2f05eeaa-d6ac-4c5e-a594-40ed51a18c91-1.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-data-factory-offer-sap-hana-and-business-warehouse-data-integration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Analytics","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/analytics\/"},{"@type":"ListItem","position":3,"name":"Azure Data Factory offers SAP HANA and Business Warehouse data integration"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/4050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=4050"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/4050\/revisions"}],"predecessor-version":[{"id":41896,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/4050\/revisions\/41896"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=4050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=4050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=4050"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=4050"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=4050"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=4050"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=4050"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=4050"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=4050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}