Placeholder image

Partners leveraging Fabric mirroring with SAP - II

| Jakob Vogelsang | Christoph Schuler | Fabian Steffan |

Fabric Partner

YouTube

Anchor

Spotify

Apple

Episode #234

Introduction

In episode 234 of our SAP on Azure video podcast we continue our coverage of SAP and Microsoft Fabric integration. We really see a huge interest from customers on how to integrate SAP data with Fabric. Luckily the open mirroring platform functionalities make the integration quite easy. In the past few episodes we already had partners like dab and Simplement who offer out of the box solutions for this kind of integration, but also Interdobs and Powerdobs who showed how to integrate via SAP Datasphere. This time we start with the partner asapio followed by Theobald who also have worked on an out of the box integration of SAP data into Microsoft Fabric.

Asapio Microsoft Fabcris Connector - ASAPIO: https://asapio.com/fabric-connector/

Theobald Theobald Xtract Universal - https://theobald-software.com/en/microsoft-fabric/

Find all the links mentioned here: https://www.saponazurepodcast.de/episode234

Reach out to us for any feedback / questions:

#Microsoft #SAP #Azure #SAPonAzure #Fabric #OpenMirror #Data #BW

Summary created by AI

  • Introduction to SAP on Azure Video Podcast:
  • Holger introduced the episode 234 of the SAP on Azure Video podcast, mentioning that the focus would be on SAP and Microsoft integration, specifically the Microsoft Fabric integration.
  • Microsoft Fabric Integration Overview:
  • Holger and Ulrich discussed the integration of SAP data with Microsoft Fabric, highlighting the open mirroring platform functionalities that make the integration easy. They mentioned various partners who offer out-of-the-box solutions for this integration.
    • Open Mirroring Functionality:
  • Ulrich explained the concept of database mirroring in Fabric, describing the built-in mirroring experiences and the open mirroring functionality that allows third parties to integrate their solutions with Fabric.
  • Partner Integration with Open Mirroring:
  • Ulrich provided an overview of the status of open mirroring and the integration with SAP, mentioning that many partners are already on board with their solutions. He introduced Jacob from ASAPIO to demonstrate their specific solution.
    • Introduction to ASAPIO:
  • Jacob introduced himself and ASAPIO, a Munich-based software and consulting company. He explained their mission to make SAP integration seamless and their experience in building bridges between SAP core systems and other platforms.
  • ASAPIO Integration Add-On:
  • Jacob described the ASAPIO integration add-on, which provides direct connectivity to various Microsoft Azure services without the need for additional middleware or staging areas. He highlighted the performance and compliance benefits of their solution.
  • Real-Time and Batch Data Replication:
  • Jacob explained the capabilities of their add-on in terms of real-time and batch data replication, allowing for various transmission frequencies and performance optimization.
  • Predefined and Custom Data Products:
  • Jacob discussed the importance of meaningful and consumable data replication, offering predefined and custom data products to help customers build a great analytics layer. He emphasized the need for a standardized and error-proof approach.
    • Demonstration of ASAPIO Integration:
  • Jacob demonstrated the ASAPIO integration add-on, showing how sales order data is replicated from the SAP system to Microsoft Fabric in real-time. He also showcased the configuration and monitoring capabilities of their solution.
  • Evaluation Licenses and Customer Support:
  • Jacob mentioned that ASAPIO offers free evaluation licenses for customers to experience their solution on their own systems. He emphasized the importance of customer support and collaboration with Microsoft. ############
  • Introduction of Christoph and Fabian:
  • Holger introduced Christoph and Fabian from Theobald Software, expressing excitement about reconnecting with Christoph after many years. Christoph and Fabian provided brief introductions about their roles and experiences.
    • Christoph’s Background: Christoph Schuler is the General Manager for Theobald Software in the Americas and has been with the company for over 10 years. He previously worked at Microsoft, focusing on SAP interoperability.
    • Fabian’s Role: Fabian has been with Theobald Software for over 6 years, focusing on technical issues and explaining SAP integration solutions to customers and prospects.
  • Overview of Theobald Software:
  • Christoph provided an overview of Theobald Software, highlighting its 20-year history, focus on SAP and Microsoft integration solutions, and its global presence with offices in Stuttgart and Seattle. He also mentioned their extensive customer base and partner network.
    • Company History: Theobald Software has been in operation for over 20 years, celebrating its 20th anniversary last year. The company focuses on developing, marketing, and supporting SAP integration solutions.
    • Global Presence: The company has offices in Stuttgart, Germany, and Seattle, USA, with around 60 employees. They serve approximately 4000 SAP customers globally across various industries, including industrial manufacturing, automotive, chemical, pharmaceutical, and life sciences.
    • Partnerships: Theobald Software is an SAP certified partner and has a long-standing partnership with Microsoft, which has been beneficial for their integration solutions.
  • Technical Issues with Screen Sharing:
  • Christoph experienced technical difficulties while trying to share his screen, leading to a brief interruption in the presentation. Fabian eventually shared his screen to continue the presentation.
  • Introduction to Extract Universal:
  • Christoph explained the Extract Universal tool, which enables extract and load scenarios with SAP environments. He highlighted its change data capture (CDC) capabilities and its integration with Microsoft Fabric for near real-time data replication.
    • Tool Overview: Extract Universal is a standalone tool that facilitates extract and load scenarios with SAP environments. It supports near real-time data replication through its change data capture (CDC) capabilities.
    • Integration with Microsoft Fabric: The tool integrates with Microsoft Fabric, leveraging its database mirroring capabilities to achieve near real-time data replication from SAP environments to Microsoft Fabric.
  • Table CDC and Data Replication:
  • Christoph discussed the Table CDC component, which captures changes in SAP tables and replicates them into the Microsoft Fabric environment. This allows for near real-time data replication from various SAP environments.
    • Table CDC Functionality: The Table CDC component captures changes in SAP tables as they occur and replicates these changes into the Microsoft Fabric environment, enabling near real-time data replication.
    • Supported SAP Environments: The Table CDC component supports various SAP environments, including ECC, S/4HANA, BW, Data Sphere, and APO, for near real-time data replication.
  • Support for Different SAP Systems:
  • Christoph mentioned that Extract Universal supports various SAP systems, including ECC, S/4HANA, BW, Data Sphere, and APO, for near real-time data replication.
  • Certification and Compatibility:
  • Christoph confirmed that Extract Universal is SAP certified and compatible with Rise with SAP. He also mentioned that the tool has been in the market for several years and is available for customers to use immediately.
  • Demo of Extract Universal:
  • Fabian demonstrated the Extract Universal tool, showcasing its capabilities in extracting data from an SAP system and replicating it into the Microsoft Fabric environment. He highlighted the ease of use and the ability to schedule extractions for near real-time data replication.
    • Setup Process: Fabian demonstrated the setup process for Extract Universal, including defining SAP connections and destinations for data replication. He showed how to configure the tool to extract data from an SAP system and replicate it into the Microsoft Fabric environment.
    • Table CDC Demonstration: Fabian showcased the Table CDC functionality by extracting data from an SAP table, making changes to the data, and demonstrating how these changes are captured and replicated in near real-time into the Microsoft Fabric environment.
    • Scheduling Extractions: Fabian explained that extractions can be scheduled to run at regular intervals, such as every few minutes, to ensure continuous and near real-time data replication.
  • Handling Large Data Volumes:
  • Fabian and Christoph discussed the tool’s capability to handle large data volumes, with the initial load potentially taking longer but subsequent delta replications being much faster. They also mentioned the option to decouple the initial load and delta replication processes.
    • Initial Load: The initial load of data can handle millions of rows, which may take longer to complete. However, this process is necessary to set up the initial dataset for replication.
    • Delta Replication: Once the initial load is complete, subsequent delta replications are much faster as they only capture and replicate changes made to the data, significantly reducing the amount of data processed.
    • Decoupling Processes: Customers have the option to decouple the initial load and delta replication processes. This allows for the initial load to be done in multiple runs with filters, while the Table CDC component tracks changes independently in SAP.
  • Customer Use Cases and Integration:
  • Ulrich and Christoph discussed potential customer use cases and the importance of supporting both table-level and higher-level data extraction methods. They emphasized the flexibility and efficiency of the tool in real-life scenarios.
    • Table-Level vs. Higher-Level Extraction: Ulrich and Christoph discussed the importance of supporting both table-level and higher-level data extraction methods, such as CDS views, to cater to different customer needs and preferences.
    • Flexibility and Efficiency: The tool’s flexibility in supporting various extraction methods and its efficiency in handling large data volumes make it suitable for a wide range of real-life customer scenarios.
  • Availability and Future Plans:
  • Christoph confirmed that the Extract Universal tool with open mirroring support is available for customers to use today. He also mentioned their plans to showcase the tool at an upcoming event and their excitement about the integration with Microsoft Fabric.
    • Current Availability: The Extract Universal tool with open mirroring support is currently available for customers to use. The tool has been in the market for several years, and the new integration with Microsoft Fabric is ready for immediate use.
    • Future Plans: Christoph mentioned plans to showcase the tool at an upcoming event, highlighting their excitement about the new integration capabilities with Microsoft Fabric.

Links

Video index

Based on and using Hugo Cookbook Theme, Font Awesome Icons and Bulma CSS. | Thanks to Recipes4AJ to get me started. | Contact me via