steve vazzano, sap solutions engineer matt iacoviello jr ... · matt iacoviello jr, sap solutions...
TRANSCRIPT
Enterprise Information Management
Steve Vazzano, SAP Solutions Engineer
Matt Iacoviello Jr, SAP Solutions Engineer
© 2014 SAP AG. All rights reserved. 2
Safe Harbor
The information in this presentation is confidential and proprietary to SAP and may not be disclosed without the permission of SAP. This presentation is not subject to your license agreement or any other service or subscription agreement with SAP. SAP has no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation and SAP's strategy and possible future developments, products and or platforms directions and functionality are all subject to change and may be changed by SAP at any time for any reason without notice. The information on this document is not a commitment, promise or legal obligation to deliver any material, code or functionality. This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. This document is for informational purposes and may not be incorporated into a contract. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent.
All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions.
© 2014 SAP AG. All rights reserved. 3
My Background
Owned & operated a data quality company
Five years - SAP R/3 Implementation
Focus exclusively on SAP Data Management solutions
© 2014 SAP AG. All rights reserved. 5
“In God we trust, all others bring data.”
W. Edwards Deming
Run Better
Smoother business processes
Standardized and high quality information
Reduced IT costs
Make Better Decisions
Enhanced customer service
Increased marketing effectivness
Increased revenue growth
Reduce Risk
Improved accountability
Better accuracy and consistency
Compliance with internal and external regulations
© 2014 SAP AG. All rights reserved. 6
information
information
Govern Information In Process with SAP Solutions for
Enterprise Information Management
Information Creation Information Consumption
Systems of Record
Non SAP Systems
SAP Business Suite
information
information
information
information
Data Warehouse
Systems of Analysis
Employees
Other Systems
Customers
Other Systems
SAP Master Data
Governance
SAP Information
Steward
SAP Data
Services
SAP Information
Steward
SAP Data
Services
Active Governance Passive Governance
© 2014 SAP AG. All rights reserved. 7
Data Quality Management
Cleanse, match, and enhance data quality
SAP Information Steward
SAP Data Services
© 2014 SAP AG. All rights reserved. 8
SAP Provides Your One-Stop Solution Data Integration, Data Quality, Text Analytics, and Information Stewardship
Information Platform Services
SAP BusinessObjects BI platform
SAP Data Services
SAP Information Steward
Data Steward /
Data Analyst IT / Developer
IT /
Administrator
Data
Integration
Data
Profiling
Data
Quality Text
Analytics
Metadata
Management
© 2014 SAP AG. All rights reserved. 9
SAP Data Services Your information highway serving SAP and NON-SAP environments
Imp
rove
relia
bility
of a
na
lytic
s
SAP ERP, SAP CRM,
SAP MDG* and MDM*,
SAP NetWeaver BW*,
…and non-SAP systems too!
BAPIs/IDocs/Web Services
Files, XML, HTML,
Mainframe,
Microsoft
Excel, text,
Qxtend, etc.
SAP HANA, Sybase,
Oracle, SQL,
DB2, HADOOP
PeopleSoft,
Oracle Apps,
Siebel, SFDC, etc.
SAP CRM,
SAP ERP,
SAP NetWeaver,
SAP BusinessOne,
SuccessFactors
Query,
Reporting,
Analysis,
and Dashboards
Data Migration,
Synchronization,
Real-Time, …
SAP HANA,
BW*, Sybase
Data
Pro
filin
g
Data
Services
Engine
Impact
Analysis
Data
Lineage
Text Data
Processing
Data
Validation
Data
Cleansing,
Enrichment
*SAP NetWeaver Business Warehouse (SAP NetWeaver BW); SAP Master Data Governance; SAP NetWeaver Master Data Management
© 2014 SAP AG. All rights reserved. 11
Working together for better information
“Good vs. Bad”
Define business rules
Business priorities
Find & fix errors
Business
IT
“Deploy”
Deploy business rules
Technical impact
Equip the business
© 2014 SAP AG. All rights reserved. 13
SAP Information Steward Product Overview
Monitor
Quality
continuously
Improve
Data quality &
governance
Discover
Understand & catalog
enterprise data
Assess
Overall
data quality
Define
Rules and
ownership
IT IT can share data quality metrics with
business users and involve them in owning
the data problem
Business Business users can see how their information
measures up against information governance rules
and standards. Mobile and Email alerts
Designed for Business Users
© 2014 SAP AG. All rights reserved. 14
Three Important Things
1. Data Lineage / Where Used
2. Business Terms
3. Data Profiling
© 2014 SAP AG. All rights reserved. 15
Single Solution for Data Stewardship
Validation Rules
for Business
Process Centric
Data Profiling,
Advanced Data
Profiling
Metadata
cataloging and
analysis
DQM
Functionality
for party and
non-party data
(Create/Maint
ain Cleansing
Packages)
Business
Concept
Taxonomy
(Search,
tagging,
ownership
etc.)
Data Quality
Scorecards &
Analytics
Data Lineage
& Impact
Views
Cleansing
Rules
Business
Glossary
Data Quality
Workflow
Match Review
Task Mgt.
( Review /
Correct Match
Results)
© 2014 SAP AG. All rights reserved. 16
Information Steward - Metadata Management Information you can trust with end-to-end metadata management
Report-to-source visibility
Lower TCO. Saves time.
See quality score of source
data
“Where did this number come from?”
“Where is this data field used?
© 2014 SAP AG. All rights reserved. 17
Centralize and Manage Essential Metadata
“Where did
this number
come from?”
Data Lineage
Impact Analysis
“How will this
change in the
source impact
my BI
reports?”
Custom Attributes
Annotations,
Metapedia
Impact
Usage
Lineage
Trends
Search
Metadata
Integrators Analysis
Central
Repository
Metadata
Repository BI
Systems
Databases
ETL
Modeling
Tools
Business Metadata
Universe Creation
Audit Integrate
Co
ns
olid
ate
© 2014 SAP AG. All rights reserved. 18
Metadata Integrators
SAP Information Steward’s Metadata Management Metadata Integrators (native and through additional MITI Bridge)
Metadata Management Integration to:
BI Systems
Databases
ETL
Modeling
Tools
Other Metadata Integrators available* Altova
Borland
CA
COBOL
Embarcadero
EMC
Gentleware
Silverun
Knightbridge (HP)
IBM
Informatica
Micsosoft
MicroStrategy
NoMagic
OMG
Oracle
SELECT
SPARX Systems
SUN
Sybase
Teradata
Tigris
Visible Systems Corp W3C
Metadata Integrators bundled with
Information Steward
SAP Software: BI Platform, Data Services, Data
Federator and SAP NetWeaver BW
NON SAP Software: CWMXML (CWM), RDBMS:
MSSQL Server, DB2, Teradata and JDBC Sources
Other metadata integrators available via Meta Integration Technology, Inc. (MITI);
http://www.metaintegration.net/Products/MIMB/SupportedTools.html
Re
du
ce
risk o
f pro
ject d
ela
ys o
r co
st o
ve
rrun
s
© 2014 SAP AG. All rights reserved. 19
Single Solution for Data Stewardship
Validation Rules
for Business
Process Centric
Data Profiling,
Advanced Data
Profiling
Metadata
cataloging and
analysis
DQM
Functionality
for party and
non-party data
(Create/Maint
ain Cleansing
Packages)
Business
Concept
Taxonomy
(Search,
tagging,
ownership
etc.)
Data Quality
Scorecards &
Analytics
Data Lineage
& Impact
Views
Cleansing
Rules
Business
Glossary
Data Quality
Workflow
Match Review
Task Mgt.
( Review /
Correct Match
Results)
© 2014 SAP AG. All rights reserved. 20
Business Term Encyclopedia
An Environment for Managing Business Terms
Terms can be
imported /
exported via Excel
Promote proactive data
governance with common
understanding and agreement on
business concepts
Central location for defining
standard business vocabulary (words, phrases, or business concepts)
© 2014 SAP AG. All rights reserved. 21
Associate Terms with Other Terms and (Any) Objects
Business definition, Synonyms
and Data steward
Related business terms
Related information /
metadata resources
Enables easier and more usable navigation by
Name and Synonym, leading to related terms
and associated objects
© 2014 SAP AG. All rights reserved. 22
Single Solution for Data Stewardship
Validation Rules
for Business
Process Centric
Data Profiling,
Advanced Data
Profiling
Metadata
cataloging and
analysis
DQM
Functionality
for party and
non-party data
(Create/Maint
ain Cleansing
Packages)
Business
Concept
Taxonomy
(Search,
tagging,
ownership
etc.)
Data Quality
Scorecards &
Analytics
Data Lineage
& Impact
Views
Cleansing
Rules
Business
Glossary
Data Quality
Workflow
Match Review
Task Mgt.
( Review /
Correct Match
Results)
© 2014 SAP AG. All rights reserved. 23
Deep Profiling (Column Analysis) Point and Click (without coding)
Profiling summary +
statistics
Drill down to values
Drill down to source records
© 2014 SAP AG. All rights reserved. 24
Advanced Profiling
Redundancy Profiling
Address Profiling
Validate address data
Dependency Profiling
Identify attribute-level
connections in data.
(Normalization rules practice)
Redundancy Profiling
Identify degree of duplication
Uniqueness Profiling
Identify non-unique data
Drill down to
duplicate and
non-duplicate
records
© 2014 SAP AG. All rights reserved. 25
Harness the POWER of HANA
Instant response and faster time-to-value by
harnessing the power of HANA
Real-time insight into your data with instant
profiling and data quality validations
Push down data processing to HANA for faster
and more efficient processes
Parallel operations with Data Services and
HANA to support multi-source data processing
DS IS
Note: These are current observations and may be updated later
© 2014 SAP AG. All rights reserved. 26
Visualization of Data Quality High-level balanced Data Quality Scorecard
Data quality score
metrics
Latest quality score
Quality trend
over time / run
Key Quality
Dimensions (KPI
for data),
customizable
© 2014 SAP AG. All rights reserved. 27
Business Value Analysis
Data Quality Financial Impact Calculator
Connect financial ROI to data quality
and information governance initiatives
Understand and demonstrate how bad
data effects business bottom line
Identify potential savings using what-if
analysis of quality level and costs
See drivers and metrics of financial
impact calculation per failure
© 2014 SAP AG. All rights reserved. 28
Find and Fix Compliance Errors within MDG Information Steward Compliance Scorecard within MDG (via RDS*)
MDG User
Interface
Scorecard
Embedded in
MDG
Create Data
Remediation
Change Requests
* Rapid Deployment Solution via SAP Services & partners
© 2014 SAP AG. All rights reserved. 31
Demonstration Scenario
Business Analyst
Investigate Data Quality 1. View Report 2. Review Data Lineage 3. Check Data Profile
Data Steward
Monitor Data Quality 1. Analyze Data Profile 2. Create New Rule 3. Review Data
Scorecard
Provide Trusted, Consistent, and Clear Information
Ensure Continuous Data Quality Monitoring
Improve BI Maintenance time and Responsiveness
Increase Business Engagement in BI Data Quality
© 2014 SAP AG. All rights reserved. 32
New! Information Governance Model + Self-Assessment
Information Governance model:
• Expand your approach to solving information problems, so you aren’t
caught in endless cycles of “keeping the lights on”.
Self-assessment:
• Highlight what good looks like for key organizational and
technology components, including which to target.
Information as an Asset Roadmap
• Map your funded, information-heavy projects to
strategic EIM initiatives.
Result:
• A vetted, reviewed, and focused plan for your information
strategy!
Get the tools here: http://scn.sap.com/community/enterprise-information-
management/blog/2014/07/08/new-information-governance-model-from-sap
© 2014 SAP AG. All rights reserved. 34
© 2014 SAP AG. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose
without the express permission of SAP AG. The information contained herein may be
changed without prior notice.
Some software products marketed by SAP AG and its distributors contain proprietary
software components of other software vendors.
Microsoft, Windows, Excel, Outlook, PowerPoint, Silverlight, and Visual Studio are
registered trademarks of Microsoft Corporation.
IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x,
System z, System z10, z10, z/VM, z/OS, OS/390, zEnterprise, PowerVM, Power
Architecture, Power Systems, POWER7, POWER6+, POWER6, POWER, PowerHA,
pureScale, PowerPC, BladeCenter, System Storage, Storwize, XIV, GPFS, HACMP,
RETAIN, DB2 Connect, RACF, Redbooks, OS/2, AIX, Intelligent Miner, WebSphere, Tivoli,
Informix, and Smarter Planet are trademarks or registered trademarks of IBM Corporation.
Linux is the registered trademark of Linus Torvalds in the United States and other countries.
Adobe, the Adobe logo, Acrobat, PostScript, and Reader are trademarks or registered
trademarks of Adobe Systems Incorporated in the United States and other countries.
Oracle and Java are registered trademarks of Oracle and its affiliates.
UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.
Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin
are trademarks or registered trademarks of Citrix Systems Inc.
HTML, XML, XHTML, and W3C are trademarks or registered trademarks of W3C®,
World Wide Web Consortium, Massachusetts Institute of Technology.
Apple, App Store, iBooks, iPad, iPhone, iPhoto, iPod, iTunes, Multi-Touch, Objective-C,
Retina, Safari, Siri, and Xcode are trademarks or registered trademarks of Apple Inc.
IOS is a registered trademark of Cisco Systems Inc.
RIM, BlackBerry, BBM, BlackBerry Curve, BlackBerry Bold, BlackBerry Pearl, BlackBerry
Torch, BlackBerry Storm, BlackBerry Storm2, BlackBerry PlayBook, and BlackBerry App
World are trademarks or registered trademarks of Research in Motion Limited.
Google App Engine, Google Apps, Google Checkout, Google Data API, Google Maps,
Google Mobile Ads, Google Mobile Updater, Google Mobile, Google Store, Google Sync,
Google Updater, Google Voice, Google Mail, Gmail, YouTube, Dalvik and Android are
trademarks or registered trademarks of Google Inc.
INTERMEC is a registered trademark of Intermec Technologies Corporation.
Wi-Fi is a registered trademark of Wi-Fi Alliance.
Bluetooth is a registered trademark of Bluetooth SIG Inc.
Motorola is a registered trademark of Motorola Trademark Holdings LLC.
Computop is a registered trademark of Computop Wirtschaftsinformatik GmbH.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects Explorer,
StreamWork, SAP HANA, and other SAP products and services mentioned herein as well
as their respective logos are trademarks or registered trademarks of SAP AG in Germany
and other countries.
Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal
Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services
mentioned herein as well as their respective logos are trademarks or registered trademarks
of Business Objects Software Ltd. Business Objects is an SAP company.
Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other Sybase
products and services mentioned herein as well as their respective logos are trademarks or
registered trademarks of Sybase Inc. Sybase is an SAP company.
Crossgate, m@gic EDDY, B2B 360°, and B2B 360° Services are registered trademarks
of Crossgate AG in Germany and other countries. Crossgate is an SAP company.
All other product and service names mentioned are the trademarks of their respective
companies. Data contained in this document serves informational purposes only. National
product specifications may vary.
The information in this document is proprietary to SAP. No part of this document may be
reproduced, copied, or transmitted in any form or for any purpose without the express prior
written permission of SAP AG.