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×tamp=
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: theobald-software.com/en/