Theobald - BDE

Transcript

1. We make difficult easy >
2. Holistic analysis in the cloud by accessing business critical SAP data Khoder Elzein
3. Speaker Khoder Elzein SVP Product Management / Presales khoder.elzein@theobald-software.com 15 years experience with BI and SAP 3 Presales / Product Management 2 At Theobald Software since 2009 1
4. Agenda> Discussion 4 PERI: SAP Integration with Azure & Power BI 3 SAP Integration with Xtract Universal 2 Overview Theobald Software 1
5. 6 founded in 2004 ISV, specializing in SAP integration 3,200 SAP customers 200 partners 50 employees Seattle, USA Paris, France Stuttgart, Germany Dongguan, China Hong Kong SAR, China Who is Theobald Software?>
6. Products> Xtract Universal Azure DataLake, SQL Server etc. Xtract IS for SQL Server Integration Services Xtract IS for Azure for Azure SSIS-Integration Runtime ERPConnect Services for SharePoint On-Premises, Nintex ERPConnect for .NET development Process integration Xtract for Alteryx in Alteryx embedded solution Core development Data Extraction yunIO Process automation and integration for cloud environments
7. Xtract Universal> ERP • S/4HANA • BW • BW/4HANA BI Analytics Cloud Storage Database SAP Database Data Ingestion (Staging) RFC protocol Destinations Destinations ..und vieles mehr XU Designer Client n Client 2 Client 1 XU Server Xtract Universal Function/BAPI Query Report Table DeltaQ Cube/BEx Hierarchy Open Hub ODP
8. Orchestration & Scheduling> http API CLI Etc, your choice. 2 Azure Data Factory Pipeline
9. Xtract Universal > Web API ADF Pipeline Web Activity <asynchron Start> ?name=MARA&wait=false - Timestamp as http response <Status request> status/?name=MARA&timestamp= 2021-06-16_09:58:47.312 (Running, FinishedNoErrors FinishedErrors.). https://XUServer.domain.local:8165/ Self hosted Integration Runtime
11. Peri 2020> <70 Subsidiaries and 110 Yards> worldwide
12. Steady growth> Turnover and employee development
13. Start XU extraction + monitor runtime Use native DataFactory connector for SAP HANA … Business Logic 0 % 100 % SAP HANA SAP BW Query Azure Data Lake Storage Gen2 SAP PP Other SAP and non-SAP Source Systems SAP … PSD SAP HANA Connector raw use staging CRM CPQ CV Sales Data CV Finance Data … Power BI Dataflows Dataset Report BI Sales Reporting … DF Sales DF Sales Targets Azure Data Factory Scheduling, Refreshes Power BI Workspaces *PSD – PERI Sales and Distribution (self-developed ERP System) Power BI Workspaces Business Objects Report types Crystal Reports Power BI Datasets Start Dataflow refresh + Monitor runtime Start Dataset refresh + Monitor runtime Start XU extraction + monitor runtime Analysis for Office Workbooks Lumira Reports *CPQ – Configure Price Quote Use native DataFactory connectors Architecture development over time>
14. Challenge – Decision for Xtract Universal> > Bring logically consistent SAP data to PowerBI > BW/HANA logics developed over 5 years > Performance impacts on SAP Systems (Large datasets, Queries using cell references → Open Hub, BW via MDX, Odata) > HANA Connector: High level of detail → Loss of business logic > Minimal footprint on the source system (slicing) > Parameterization (Query Variables, Destination) > Integration into the DataFactory toolset (Starting extractions, status tracking → “Web Activities”) > Different types of extractions methods for SAP Source Systems > Easy to use and fast extraction set-up Challenges Xtract Universal
15. Extraction types used by PERI>
16. Xtract Universal Designer >
17. Xtract Universal Extraction Definition, Parametrization and Query Slicing>
18. Datafactory Master Pipeline> A B A C A A B C PowerBI Service
19. Xtract Universal Pipeline> @not(equals('Running', variables('JOB_STATUS'))) @activity('XU_START_JOB').output.response @equals('FinishedErrors', variables('JOB_STATUS')) Mail notification ► Logic App
20. Early Data Integration into Power BI Data Flows> PowerBI Service – Select desired Data source Replace blob by dfs. Combine multiple parquet files into one Data Flow
21. Current Data Integration into Power BI Data Flows> Enter Connection Parameters PowerBI Service – Select desired Data source Select Synapse View
22. Synapse View definition> Enter Connection Parameters Reading data from DataLake
23. Data Integration into Power BI Reports>
24. Self service Power BI Report>
25. Facts> <XU Extractions> 200 <DataFactory Pipelines> 250 <pipeline executions> 700 More than each day <PowerBI Users> 1600 Sales Engineering Finance Logistics Operations Production Group/Market Unit Management Product Management <Premium P2 PowerBI Capacity> 1 <transactions> 120.000 Storage Account using 1,2 TiB each day <Power BI reports> developed by central IT / developed in self service 60 / 250 <Power BI report executions> each month 45.000
26. XU Monitoring and HeatMap>
27. What‘s left to say…? We make difficult easy>
28. Service <Free Webinars> <Consulting & Support> We won't leave you out in the cold.
29. <Download your trial version> free | valid for 30 days | full scope | incl. support <Download now>
30. Thank you for your attention! See you at our booth #103>
31. 44 >> The best SAP interface is the one that no-one even notices. Patrick Theobald, Founder of Theobald Software Theobald Software GmbH Kernerstrasse 50 70182 Stuttgart Phone: +49 7 11 / 46 05 99 0 E-Mail: info@theobald-software.com Web: theobald-software.com/en/