Analytisches Information Lifecycle Managment

Werbung
1. Juli 2016
Analytisches Information Lifecycle Management
Prof. Dr. Detlev Steinbinder, PBS Infotag 2016, Bensheim
Seite 1
Thank You!
Danke!
Seite 2
PBS-Infotag 2016: Analytisches Information Lifecycle Management
Agenda
 25 Years Add-ons for SAP
 HANA Cut?
 SAP Strategy
 PBS Strategy for BW
 PBS Strategy for ERP
 PBS Strategy for Decommissioning
 Advanced Data Analysis – Introduction
 Data Analysis – Showcases
 Summary
Seite 3
PBS-Infotag 2016: Analytisches Information Lifecycle Management
25 Years PBS Add-ons for SAP
SAP Data
SAP Applications
ERP, BW, etc
Primary DB
(large)
(small)
Nearline-DB
(analytic)
Nearline
Archive
Data Archiving
Primary DB
SAP-independant
Components
SAP Applications
Integrated PBS Solutions
- Add-ons for ERP
- Add-ons for SAP IS
- ContentLink (PCL)
- Nearline for BW (CBW)
- Nearline for ERP (NAI)
- NAI CPOS
- SE16_Personal, CDART, ...
- Data Extracts
- Archive Session Cockpit
Cloud
PCL Archive
Server
ECS
Enterprise
Content Store
Various
Vendors
MS-SQL
Compliant
Storage
Decommissioning
Non-SAP
Data
(POS, Z,..)
Extracts Tax Audits, etc.
WINS: DB Growth * Backup * Release Changes * Migration * Compliance *
Performance * Analytics * External Data Integration * Costs
Seite 4
PBS-Infotag 2016: Analytisches Information Lifecycle Management
SAP Data
SAP Applications
ERP, BW, etc
Primary DB
(large)
(small)
Nearline-DB
(analytic)
Nearline
Archive
Data Archiving
Primary DB
SAP-independant
Components
SAP Applications
Integrated PBS Solutions
- Add-ons for ERP
- Add-ons for SAP IS
- ContentLink (PCL)
- Nearline for BW (CBW)
- Nearline for ERP (NAI)
- NAI CPOS
- SE16_Personal, CDART, ...
- Data Extracts
- Archive Session Cockpit
Cloud
PCL Archive
Server
ECS
Enterprise
Content Store
Various
Vendors
MS-SQL
Compliant
Storage
Decommissioning
Non-SAP
Data
(POS, Z,..)
Extracts Tax Audits, etc.
WINS: DB Growth * Backup * Release Changes * Migration * Compliance *
Performance * Analytics * External Data Integration * Costs
Seite 5
PBS-Infotag 2016: Analytisches Information Lifecycle Management
SAP Strategy
Source: Hasso Plattner, SAPPHIRE 2016, Orlando
Seite 6
PBS-Infotag 2016: Analytisches Information Lifecycle Management
SAP Strategy
Source: Hasso Plattner, SAPPHIRE 2016, Orlando
Seite 7
PBS-Infotag 2016: Analytisches Information Lifecycle Management
PBS Strategy for BW
On
Premise
SAP BW
any DB
SAP BW
HANA
SAP
Nearline Solution
with IQ

(* restrictions)
!
PBS CBW NLS
(Incl. DB
IQ,DB2,MS SQL)
PBS CBW for
for SAP NLS IQ
(Add-on, no DB)
!


!
non-unicode
* restrictions see SAP
Use NLS in classical environments to prepare for a HANA migration
 No need to migrate NLS data
Use NLS in BW on any DB/HANA to control size, license and costs
 Move inactive/historical data to nearline database
NLS is a proven and cost saving technology!
Seite 8
PBS-Infotag 2016: Analytisches Information Lifecycle Management
PBS Strategy for ERP
On
Premise
SAP
Data Archiving
SAP BS
any DB

SAP BS
HANA

SAP
S/4HANA

(* restrictions)
SAP
Data Aging

(* restrictions)

(* restrictions)
PBS Add-ons
PBS ContentLink
PBS ECS
PBS NAI
Nearline Analytic
Infrastructure





(in preparation)

(in preparation)
* restrictions see SAP
First PBS add-ons for S/4HANA to be released in Q4/2016
Priority 1  Provide PBS functionality for archive data from BS in S/4HANA
Data archiving is the key for a lean DB migration to S/4HANA!
BS = SAP Business Suite
Seite 9
PBS-Infotag 2016: Analytisches Information Lifecycle Management
PBS Strategy for System Decommisioning
The move to S/4HANA will create many SAP legacy ERP systems.
How will these legacy systems be managed?
SAP-independant Applications
SAP ERP
PBS
Extractors
- CONEX, etc.
- EMC
Connector
ERP DB
(tables)
ERP Archive
(tables, documents)
ECS
Enterprise
Content Store
(MS Application)
EMC
InfoArchive
MS-SQL
(Tables, Documents)
XML DB
ERP Extracts
(DART, PBS AIS, Tax data)
Non-SAP Data
(any type)
The PBS Connector for EMC InfoArchive is available!
PBS ECS and EMC InfoArchive provide SAP-independant reporting of SAP data.
Seite 10
PBS-Infotag 2016: Analytisches Information Lifecycle Management
Advanced Data Analysis – Introduction
Basic Idea: Bring SAP data together with external data via SAP ERP
Integrated data analysis with advanced tools
SAP ERP
Reporting
PBS NAI
Data Sources
-
User
Operational Intelligence
- Reporting via BI Tools
- Prediction (Data Mining)
SAP ERP DB
SAP ERP Archive
External Data 1
External Data 2
....
Operational Data
(ERP, POS, CRM,...)
Data Services
(Big Data)
Analytical
NAI DB
NAI Archive
Advantages:
No DW overhead, Quick implementation, NAI templates, high speed reporting,
data mining, mass data support, big data support
Seite 11
PBS-Infotag 2016: Analytisches Information Lifecycle Management
Advanced Data Analysis – Showcase I
Operational intelligence on ERP data with NAI/IBM DB2 BLU, IBM Cognos
SAP ERP
Operational Data
(ERP SD Invoices DB + A)
IBM Cognos BI Frontend
NAI Query
PBS NAI
Data Services
Data Sources
-
User
SAP ERP DB
SAP ERP Archive
NAI DB
IBM DB2 BLU
Data Modelling NAI  PBS Software GmbH
BI Modelling Cognos  RSM Consult GmbH, Neu-Isenburg
Seite 12
PBS-Infotag 2016: Analytisches Information Lifecycle Management
Live Demo
NAI/DB2 BLU/COGNOS
LIVE Demo
Seite 13
PBS-Infotag 2016: Analytisches Information Lifecycle Management
Advanced Data Analysis – Showcase II
Data mining on POS data with NAI/DB2 BLU, IBM SPSS
Example: Market basket analysis with retail data (Warenkorbanalyse)
SAP ERP
Operational Data
(POS Data)
IBM SPSS
NAI Query
PBS NAI
Data Services
Data Source
-
User
POS Data
(Kassenbons)
NAI DB
IBM DB2 BLU
Data Modelling NAI
Data Mining
Seite 14
 PBS Software GmbH
 Smart Statistical Consulting GbR, Göttingen
PBS-Infotag 2016: Analytisches Information Lifecycle Management
Live Demo
Market Basket Analysis (Warenkorbanalyse)
SPSS
LIVE Demo
Seite 15
PBS-Infotag 2016: Analytisches Information Lifecycle Management
… there’s one more thing …
Gartner MQ 2016
Seite 16
PBS-Infotag 2016: Analytisches Information Lifecycle Management
Thank you very much for your attention!
Prof. Dr. Detlev Steinbinder
PBS Management
PBS Software GmbH
Schwanheimer Straße 144a
64625 Bensheim
Seite 17
T:
F:
06251-174 0
06251-174 174
info@pbs-software.com
www.pbs-software.com
Copyright
© Copyright 2016 PBS Software GmbH. All rights reserved.
No part of this presentation may be reproduced or transmitted in any form or for any purpose without the written permission of PBS Software GmbH. The
information of this presentation might change without prior notice.
PBS archive add ons is a registered trademark of PBS Software GmbH.
SAP, SAP ERP, R/3, SAP HANA, S/4 HANA, SAP ILM, SAP NetWeaver, SAP NetWeaver Business Warehouse and other SAP products and services mentioned
herein as well as their respective logos are trademarks or registered trademarks of SAP SE in Germany and other countries.
All other product and service names mentioned are the trademarks of their respective companies.
Data contained in this document serves informational purposes only. PBS Software GmbH shall not be liable for errors or omissions with respect to the materials.
The only warranties for products and services are those that are set forth in the express warranty statements accompanying such products and services, if any.
Nothing herein should be construed as constituting an additional warranty.
Seite 18
PBS-Infotag 2016: Analytisches Information Lifecycle Management
Herunterladen
Random flashcards
Laser

2 Karten anel1973

lernen

2 Karten oauth2_google_6c83f364-3e0e-4aa6-949b-029a07d782fb

Literaturepochen

2 Karten oauth2_google_55780ed8-d9a3-433e-81ef-5cfc413e35b4

Erstellen Lernkarten