Slide 1

Slide 1 text

We make difficult easy >

Slide 2

Slide 2 text

Holistic analysis in the cloud by accessing business critical SAP data Khoder Elzein

Slide 3

Slide 3 text

Speaker Khoder Elzein SVP Product Management / Presales [email protected] 15 years experience with BI and SAP 3 Presales / Product Management 2 At Theobald Software since 2009 1

Slide 4

Slide 4 text

Agenda> Discussion 4 PERI: SAP Integration with Azure & Power BI 3 SAP Integration with Xtract Universal 2 Overview Theobald Software 1

Slide 5

Slide 5 text

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?>

Slide 6

Slide 6 text

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

Slide 7

Slide 7 text

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

Slide 8

Slide 8 text

Orchestration & Scheduling> http API CLI Etc, your choice. 2 Azure Data Factory Pipeline

Slide 9

Slide 9 text

Xtract Universal > Web API ADF Pipeline Web Activity ?name=MARA&wait=false - Timestamp as http response status/?name=MARA&timestamp= 2021-06-16_09:58:47.312 (Running, FinishedNoErrors FinishedErrors.). https://XUServer.domain.local:8165/ Self hosted Integration Runtime

Slide 10

Slide 10 text

No content

Slide 11

Slide 11 text

Peri 2020> <70 Subsidiaries and 110 Yards> worldwide

Slide 12

Slide 12 text

Steady growth> Turnover and employee development

Slide 13

Slide 13 text

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>

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

Extraction types used by PERI>

Slide 16

Slide 16 text

Xtract Universal Designer >

Slide 17

Slide 17 text

Xtract Universal Extraction Definition, Parametrization and Query Slicing>

Slide 18

Slide 18 text

Datafactory Master Pipeline> A B A C A A B C PowerBI Service

Slide 19

Slide 19 text

Xtract Universal Pipeline> @not(equals('Running', variables('JOB_STATUS'))) @activity('XU_START_JOB').output.response @equals('FinishedErrors', variables('JOB_STATUS')) Mail notification ► Logic App

Slide 20

Slide 20 text

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

Slide 21

Slide 21 text

Current Data Integration into Power BI Data Flows> Enter Connection Parameters PowerBI Service – Select desired Data source Select Synapse View

Slide 22

Slide 22 text

Synapse View definition> Enter Connection Parameters Reading data from DataLake

Slide 23

Slide 23 text

Data Integration into Power BI Reports>

Slide 24

Slide 24 text

Self service Power BI Report>

Slide 25

Slide 25 text

Facts> 200 250 700 More than each day 1600 Sales Engineering Finance Logistics Operations Production Group/Market Unit Management Product Management 1 120.000 Storage Account using 1,2 TiB each day developed by central IT / developed in self service 60 / 250 each month 45.000

Slide 26

Slide 26 text

XU Monitoring and HeatMap>

Slide 27

Slide 27 text

What‘s left to say…? We make difficult easy>

Slide 28

Slide 28 text

Service We won't leave you out in the cold.

Slide 29

Slide 29 text

free | valid for 30 days | full scope | incl. support

Slide 30

Slide 30 text

Thank you for your attention! See you at our booth #103>

Slide 31

Slide 31 text

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: [email protected] Web: