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