<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>article Navigating the SAP Data Ocean: Demystifying SAP Data Extraction for Databricks Integration using ODP in Technical Blog</title>
    <link>https://community.databricks.com/t5/technical-blog/navigating-the-sap-data-ocean-demystifying-sap-data-extraction/ba-p/94617</link>
    <description>&lt;H2&gt;&lt;SPAN&gt;Introduction&lt;/SPAN&gt;&lt;/H2&gt;
&lt;P&gt;&lt;SPAN&gt;Data silos affect businesses across all industries, not just Manufacturing, where IT/OT convergence is a game-changer. To address this, Databricks has built a Unified Analytics Platform that brings together all types of data - structured, semi-structured, unstructured. This platform enables organizations to break down data barriers and gain a single, unified view of their operations&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;At Databricks, we're passionate about empowering data teams to unlock insights from all their data, regardless of where it resides. In this blog, we'll tackle one of the most complex and intimidating types of data out there: SAP. Yes, we're talking about the behemoth of business software, known for its intricate systems and daunting data structures.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;As former SAP insiders, we've lived through the challenges of extracting data from SAP systems. We've developed a deep understanding of the complexities and nuances of SAP data extraction, gained through extensive hands-on experience and expertise.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;That's why we're excited to share our expertise on the recent changes to SAP's data extraction policy and how it impacts third-party extraction tools. And don't worry, we won't make you learn “&lt;/SPAN&gt;&lt;I&gt;&lt;SPAN&gt;SAPanese&lt;/SPAN&gt;&lt;/I&gt;&lt;SPAN&gt;” (read SAP jargon)! Our goal is to break down the technical barriers and make SAP data extraction accessible to everyone.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;H2&gt;&lt;SPAN&gt;Understanding the ODP Framework and SAP Notes Restrictions&lt;/SPAN&gt;&lt;/H2&gt;
&lt;P&gt;&lt;SPAN&gt;SAP has recently implemented stricter controls on data extraction from its applications, particularly affecting third-party extraction tools. This shift has been a topic of significant discussion among customers and partners.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;
&lt;LI aria-level="1"&gt;&lt;STRONG&gt;&lt;I&gt;ODP Framework and its key role in extracting SAP data&lt;/I&gt;&lt;/STRONG&gt;&lt;/LI&gt;
&lt;UL class="lia-list-style-type-square"&gt;
&lt;LI style="font-weight: 400;" aria-level="2"&gt;&lt;SPAN&gt;Operational Data Provisioning (ODP) is a framework widely used for ETL processes in SAP environments, including the ERP (be it legacy ECC or the latest S/4HANA), and the SAP Data Warehouse (a.k.a. Business Warehouse - BW). ODP allows access to various data sources and replication tools.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI style="font-weight: 400;" aria-level="2"&gt;&lt;SPAN&gt;The ODP framework enables data transfers between SAP systems and SAP as well as non-SAP data targets while preserving business context. The framework involves an "ODP Provider" (the source SAP system, like the Core Data Services or CDS Views) and an "ODP Consumer" (the target application). The ODP provider can act as a data source for OData services, as illustrated in the below schema, allowing REST-based integrations with external consumers.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI style="font-weight: 400;" aria-level="2"&gt;&lt;SPAN&gt;ODP is increasingly recognized as the central infrastructure for data extraction and replication in SAP environments. Its ability to efficiently manage delta processes, and supports various consumer systems.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI style="font-weight: 400;" aria-level="2"&gt;&lt;SPAN&gt;SAP’s data extractors like SAP Datasphere Replication Flow and Data Services use the ODP Framework via Remote Function Calls (RFC), which allow native access to the ERP Application Layer components.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;/UL&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Jerome_Ivain_0-1729183153737.png" style="width: 400px;"&gt;&lt;img src="https://community.databricks.com/t5/image/serverpage/image-id/12040iFEDF667DABC430E3/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Jerome_Ivain_0-1729183153737.png" alt="Jerome_Ivain_0-1729183153737.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&lt;LI-WRAPPER&gt;&lt;/LI-WRAPPER&gt;&lt;/P&gt;
&lt;P class="lia-align-center"&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;SAP Layered Stack Architecture: A High-Level View of Database, Application, and Extraction Components (&lt;/SPAN&gt;&lt;A href="https://aws.amazon.com/blogs/awsforsap/building-data-lakes-with-sap-on-aws/" target="_blank" rel="noopener"&gt;&lt;SPAN&gt;source: «&amp;nbsp;AWS for SAP&amp;nbsp;» Blog Post&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;
&lt;LI aria-level="1"&gt;&lt;STRONG&gt;&lt;I&gt;Restriction on ODP-based Extraction&lt;/I&gt;&lt;/STRONG&gt;
&lt;UL class="lia-list-style-type-square"&gt;
&lt;LI aria-level="1"&gt;&lt;A style="font-family: inherit; background-color: #ffffff;" href="https://me.sap.com/notes/3255746" target="_blank" rel="noopener"&gt;&lt;SPAN&gt;A support note (3255746)&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN&gt; issued in October 2022 initially stated that third-party applications using the native ODP RFC method were unsupported. This was updated on February 2nd, 2024, changing the term "&lt;EM&gt;unsupported&lt;/EM&gt;" to "&lt;STRONG&gt;&lt;EM&gt;unpermitted&lt;/EM&gt;&lt;/STRONG&gt;" and indicating that SAP would implement technical measures to restrict and audit the use of RFC modules for data extraction.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI aria-level="1"&gt;&lt;SPAN&gt;The July 11th, 2024 update of the same SAP note (&lt;/SPAN&gt;&lt;A href="https://me.sap.com/notes/3255746" target="_blank" rel="noopener"&gt;&lt;SPAN&gt;3255746&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN&gt;) clearly advises the use of SAP Datasphere for "&lt;EM&gt;realizing data replication scenarios to move data from various SAP sources (such as SAP S/4HANA, SAP BW, SAP ECC sources, etc.) into third-party applications and tools"&lt;/EM&gt;.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;/UL&gt;
&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;
&lt;LI aria-level="1"&gt;&lt;STRONG&gt;&lt;I&gt;ABAP Add-ons Certification Changes&lt;/I&gt;&lt;/STRONG&gt;&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;I&gt;&lt;/I&gt;&lt;LI-WRAPPER&gt;&lt;/LI-WRAPPER&gt;&lt;/P&gt;
&lt;UL&gt;
&lt;UL class="lia-list-style-type-square"&gt;
&lt;LI style="font-weight: 400;" aria-level="2"&gt;&lt;SPAN&gt;ABAP (Advanced Business Application Programming) is a high-level programming language developed by SAP for building business applications. It is primarily used for developing SAP ERP applications, as well as for customizing and extending SAP systems.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI style="font-weight: 400;" aria-level="2"&gt;&lt;SPAN&gt;SAP &lt;/SPAN&gt;&lt;A href="https://me.sap.com/notes/3420331/E" target="_blank" rel="noopener"&gt;&lt;SPAN&gt;has announced&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN&gt; it will discontinue certifying classic ABAP Add-Ons (Tier 3) from independent partners, including &lt;/SPAN&gt;&lt;A href="https://community.sap.com/t5/technology-blogs-by-sap/guidance-for-partners-on-certifying-their-data-integration-offerings-with/ba-p/13578551" target="_blank" rel="noopener"&gt;&lt;SPAN&gt;extraction tools&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN&gt;. This change affects proprietary tools that previously used SAP certification as an endorsement. However, partners can still provide and support these add-ons; only the certification process is being phased out.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;/UL&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;H2&gt;&lt;SPAN&gt;Implications for Customers&lt;/SPAN&gt;&lt;/H2&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;
&lt;LI style="font-weight: 400;" aria-level="2"&gt;&lt;STRONG&gt;&lt;I&gt;SAP ODP support note impact on popular non-SAP extraction tools&lt;/I&gt;&lt;/STRONG&gt;&lt;I&gt;&lt;/I&gt;&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;TABLE&gt;
&lt;TBODY&gt;
&lt;TR style="background-color: #f3f3f3;"&gt;
&lt;TD width="58.7344px" height="50px"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;STRONG&gt;System&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="50px" scope="col" style="width: 260px; height: 50px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;STRONG&gt;Connector&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="50px"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;STRONG&gt;Is Impacted&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="50px" scope="col" style="width: 600px; height: 50px; text-wrap: balance;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;STRONG&gt;Comments/Notes&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Azure&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;I&gt;&lt;SPAN&gt;SAP Table Connector (legacy)&lt;/SPAN&gt;&lt;/I&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #d8ead3; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;No&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Does not use ODP so not impacted by the SAP Note.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Azure&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;I&gt;&lt;SPAN&gt;ECC Connector&lt;/SPAN&gt;&lt;/I&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #d8ead3; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;No&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Does not use ODP.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Azure&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;I&gt;&lt;SPAN&gt;BW Open Hub Connector&lt;/SPAN&gt;&lt;/I&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #d8ead3; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;No&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Does not use ODP.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Azure&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;I&gt;&lt;SPAN&gt;BW MDX Connector&lt;/SPAN&gt;&lt;/I&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #d8ead3; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;No&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Does not use ODP.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Azure&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;I&gt;&lt;SPAN&gt;HANA Copy Activity Connector&lt;/SPAN&gt;&lt;/I&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #d8ead3; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;No&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Does not use ODP.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Azure&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;I&gt;&lt;SPAN&gt;SAP CDC Connector&lt;/SPAN&gt;&lt;/I&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #f4cccc; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Yes&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Uses ODP RFC API, now unpermitted for third-party tools.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Azure&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;I&gt;&lt;SPAN&gt;ADF OData CDC Connector&lt;/SPAN&gt;&lt;/I&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #d8ead3; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;No&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Workaround introduced in March 2024, uses ODP OData API, less performant.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Fivetran&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;I&gt;&lt;SPAN&gt;HVR (LDP)&lt;/SPAN&gt;&lt;/I&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #d8ead3; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;No&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Uses database log replication.&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN&gt;For HANA database, log replication is not supported by SAP&lt;/SPAN&gt;&lt;SPAN&gt; (&lt;/SPAN&gt;&lt;A href="https://me.sap.com/notes/2971304/E" target="_blank" rel="noopener"&gt;&lt;SPAN&gt;Note 2971304&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN&gt;).&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Fivetran&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;I&gt;&lt;SPAN&gt;SAP ERP on HANA Connector&lt;/SPAN&gt;&lt;/I&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #d8ead3; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;No&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;ABAP add-on, does not use ODP.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Fivetran&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;I&gt;&lt;SPAN&gt;ODP OData Connector&lt;/SPAN&gt;&lt;/I&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #d8ead3; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;No&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Uses ODP OData API. Released in preview, is compliant.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Qlik&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;I&gt;&lt;SPAN&gt;Qlik Replicate SAP HANA&lt;/SPAN&gt;&lt;/I&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #d8ead3; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;No&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Uses database log replication.&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN&gt;For HANA database, log-based replication is not supported by SAP&lt;/SPAN&gt;&lt;SPAN&gt; (&lt;/SPAN&gt;&lt;A href="https://me.sap.com/notes/2971304/E" target="_blank" rel="noopener"&gt;&lt;SPAN&gt;Note 2971304&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN&gt;) and trigger-based replication requires premium HANA licence for ERP.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Qlik&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;EM&gt;Qlik Replicate ODP Connector&lt;/EM&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #f4cccc; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Yes&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Uses ODP RFC API, for &lt;/SPAN&gt;&lt;/FONT&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;&lt;A href="https://help.qlik.com/en-US/replicate/May2024/Content/Replicate/Main/SAP%20ODP/SAP_ODP_advanced_prop_source.htm" target="_self"&gt;CDS views/BW Objects/SAP Extractors/HANA Views/SLT&lt;/A&gt;, n&lt;/SPAN&gt;&lt;/FONT&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;ow unpermitted for third-party tools.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="58.7344px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Qlik&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="213.07px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;I&gt;&lt;SPAN&gt;&lt;EM&gt;Qlik Replicate &lt;/EM&gt;ODP OData Connector&lt;/SPAN&gt;&lt;/I&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="86.6406px" height="105px" style="background-color: #d8ead3; width: 93px; height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;No&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="477.055px" height="105px" style="height: 105px;"&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;SPAN&gt;Uses ODP OData API. Planned for Q4 2024, will be compliant.&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&lt;FONT size="2"&gt;&lt;EM&gt;&lt;STRONG&gt;Impacted connectors &lt;/STRONG&gt;are concerned by the SAP ODP Support Note because they leverage the ODP RFC API, which poses a high risk for customers using it since it became unpermitted by SAP. The above list may not be exhaustive regarding all the SAP connectors, especially the ones that are &lt;U&gt;not impacted&lt;/U&gt; by the SAP Note. We wanted to include the main SAP connectors for these vendors.&amp;nbsp;&lt;SPAN&gt;For the most up-to-date and comprehensive information, it's advisable to consult directly with specific vendors.&lt;/SPAN&gt;&lt;/EM&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;
&lt;LI aria-level="1"&gt;&lt;STRONG&gt;&lt;I&gt;Operational Concerns&lt;/I&gt;&lt;/STRONG&gt;&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;I&gt;&lt;/I&gt;&lt;LI-WRAPPER&gt;&lt;/LI-WRAPPER&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;SAP's Datasphere Replication Flow is now the SAP recommended tool for data extraction, but it has limitations, including costs associated with data egress and a cap on concurrent replication threads &lt;/SPAN&gt;&lt;A href="https://community.sap.com/t5/technology-blogs-by-sap/replication-flow-blog-series-part-4-sizing/ba-p/13579486" target="_blank" rel="noopener"&gt;&lt;SPAN&gt;as specified in the Replication Flow Blog Series Part 4 - Sizing&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN&gt;. This limitation has raised concerns for high-volume customers needing to replicate numerous source objects simultaneously.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Regarding an OData-based connection, some customers have reported that the overall performance of OData and &lt;/SPAN&gt;&lt;A href="https://community.sap.com/t5/technology-blogs-by-members/exposing-sap-bw-extractors-via-odp-as-an-odata-service/ba-p/13473362" target="_blank" rel="noopener"&gt;&lt;SPAN&gt;the additional setup required on the source side&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN&gt; act as significant barriers to adoption.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;
&lt;LI aria-level="1"&gt;&lt;STRONG&gt;&lt;I&gt;Future Considerations with Databricks&lt;/I&gt;&lt;/STRONG&gt;&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;I&gt;&lt;/I&gt;&lt;LI-WRAPPER&gt;&lt;/LI-WRAPPER&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;The existing partnership between SAP Datasphere and Databricks continues to drive joint exploration of integration enhancements based on customer requests. This collaboration aims to enable seamless data convergence, allowing businesses to leverage SAP's structured data alongside Databricks' analytics and AI capabilities, thereby unlocking greater value from their combined data assets.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;H2&gt;&lt;SPAN&gt;Key Takeaways&lt;/SPAN&gt;&lt;/H2&gt;
&lt;UL&gt;
&lt;LI style="font-weight: 400;" aria-level="1"&gt;&lt;STRONG&gt;SAP recommended tool:&lt;/STRONG&gt; &lt;A href="https://community.sap.com/t5/technology-blogs-by-sap/replication-flow-blog-series-part-1-overview/ba-p/13581472" target="_blank" rel="noopener"&gt;&lt;SPAN&gt;SAP Datasphere Replication Flow&lt;/SPAN&gt;&lt;/A&gt;&lt;SPAN&gt; is now the SAP recommended tool for data extraction.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI style="font-weight: 400;" aria-level="1"&gt;&lt;STRONG&gt;ODP Support Note Implications: &lt;/STRONG&gt;&lt;SPAN&gt;The SAP ODP support note prohibits third-party tools from using the ODP RFC API, posing significant challenges for non-SAP extraction tools reliant on this API. However, tools that utilize the ODP OData API or non-ODP interfaces remain unaffected by these restrictions.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI style="font-weight: 400;" aria-level="1"&gt;&lt;STRONG&gt;Vendor Adaptations: &lt;/STRONG&gt;&lt;SPAN&gt;Vendors such as Microsoft (Azure), Fivetran, and Qlik are actively developing workarounds or new connectors to comply with the SAP support note, ensuring continued functionality for their users.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI style="font-weight: 400;" aria-level="1"&gt;&lt;STRONG&gt;Performance Considerations:&lt;/STRONG&gt;&lt;SPAN&gt; ODP OData-based connectors are compliant with the ODP support note, though are noted to be less performant compared to the ODP RFC interface.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;LI style="font-weight: 400;" aria-level="1"&gt;&lt;STRONG&gt;Future Enhancements:&lt;/STRONG&gt;&lt;SPAN&gt; SAP and third-party vendors are actively enhancing their data extraction and integration capabilities, with SAP focusing on improving Datasphere Replication Flow while vendors like Microsoft, Fivetran, and Qlik develop compliant solutions. As the landscape evolves, organizations can expect a wider range of options for efficiently extracting and integrating SAP data, with improvements in performance, scalability, and compliance across both SAP-native and third-party solutions.&lt;/SPAN&gt;&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;H2&gt;&lt;SPAN&gt;Conclusion&lt;/SPAN&gt;&lt;/H2&gt;
&lt;P&gt;&lt;SPAN&gt;SAP's recent policy changes regarding data extraction have significant implications for customers and third-party vendors.&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN&gt;By understanding the implications of the SAP ODP support note, organizations can assess the risks and opportunities associated with their non-SAP extraction tools and plan accordingly.&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN&gt;Organizations relying on third-party extraction tools must adapt to these new restrictions and consider SAP's own solutions for compliance and support.&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN&gt;As organizations navigate these changes, Databricks stands ready to facilitate seamless integration with SAP systems and its Unified Analytics Platform by providing best practices through its team of experts.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Ultimately, as both SAP and Databricks continue to innovate, businesses can look forward to more efficient and effective ways to leverage their data across platforms, breaking down silos and unlocking valuable insights for informed decision-making.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;H2&gt;&lt;SPAN&gt;Call to Action&lt;/SPAN&gt;&lt;/H2&gt;
&lt;P&gt;&lt;SPAN&gt;Feel free to reach out to your Databricks account team to engage with our SAP team to discuss the complexities of your SAP applications data integration and explore customer use cases for the SAP Lakehouse powered by Databricks.&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Mon, 21 Oct 2024 08:20:27 GMT</pubDate>
    <dc:creator>Jerome_Ivain</dc:creator>
    <dc:date>2024-10-21T08:20:27Z</dc:date>
    <item>
      <title>Navigating the SAP Data Ocean: Demystifying SAP Data Extraction for Databricks Integration using ODP</title>
      <link>https://community.databricks.com/t5/technical-blog/navigating-the-sap-data-ocean-demystifying-sap-data-extraction/ba-p/94617</link>
      <description>&lt;P&gt;&lt;SPAN&gt;Unlocking the complexities of SAP data extraction has never been more crucial, especially in an era where data silos hinder business efficiency across all industries. &lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;In our upcoming blog, we delve into the intricacies of the Operational Data Provisioning (ODP) framework and discuss how recent changes to SAP's data extraction policies are reshaping the landscape for third-party ETL tools. &lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;With insights from former SAP insiders, we'll break down the technical barriers and provide best practices for navigating these new restrictions. &lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Additionally, we will explore how these changes impact customers using third-party ETL tools and highlight strategies for effectively extracting SAP data into Databricks' Unified Analytics Platform, enabling organizations to break down data silos and enhance their business insights.&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 21 Oct 2024 08:20:27 GMT</pubDate>
      <guid>https://community.databricks.com/t5/technical-blog/navigating-the-sap-data-ocean-demystifying-sap-data-extraction/ba-p/94617</guid>
      <dc:creator>Jerome_Ivain</dc:creator>
      <dc:date>2024-10-21T08:20:27Z</dc:date>
    </item>
    <item>
      <title>Re: Navigating the SAP Data Ocean: Demystifying SAP Data Extraction for Databricks Integration using</title>
      <link>https://community.databricks.com/t5/technical-blog/navigating-the-sap-data-ocean-demystifying-sap-data-extraction/bc-p/95221#M321</link>
      <description>&lt;P&gt;This is very valuable,tnx!&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;I made a small correction for you :-):&lt;BR /&gt;&lt;EM&gt;"Ultimately, as &lt;STRIKE&gt;both SAP and&lt;/STRIKE&gt; Databricks continues to innovate, businesses can look forward to more efficient and effective ways to leverage their data across platforms, breaking down silos and unlocking valuable insights for informed decision-making."&lt;/EM&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 21 Oct 2024 11:06:17 GMT</pubDate>
      <guid>https://community.databricks.com/t5/technical-blog/navigating-the-sap-data-ocean-demystifying-sap-data-extraction/bc-p/95221#M321</guid>
      <dc:creator>-werners-</dc:creator>
      <dc:date>2024-10-21T11:06:17Z</dc:date>
    </item>
  </channel>
</rss>

