WIXLIB

Monitoring & Scheduling 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC21

SAP HANA smart data quality

SAP HANA smart data qualityPowerful, natively integrated data quality servicesIn-memory data quality performanceSAP HANA Data Quality processes performed in-memory break downperformance barriersSmart Data QualityNative data quality capabilities– Cleanse person, firm, and address data– Identify duplicates within a single or across multiple sources andselect best record from group of duplicates– Geocoding to enrich address data with latitude and longitudeinformation– Geocode is fully integrated with SAP HANA Spatial GeocodingIndex– Search for addresses using latitude and longitude coordinatesDQ AssessmentCleansingMatching & GeocodingBest RecordMetadata and SemanticsThird-Party Enrichmententerprise semantic servicesDataset discoveryDataset relationshipsSmart Data Integrationsmart data ise and cloud sources of dataRelational, semi-structured, and unstructuredOut-of-the-box adaptersSimple user interfaceCustom adapters– Parse, standardize, validate, correct, and enhance person,firm, address in ONE transformationRDBMS / Hadoop 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICText DataStructured DataSocial Network23

SAP HANA smart data qualityArchitectureData Quality transformations are executed inthe Script Server.SAP HANACalc EngineName ServerStatistics ServerCleanseCleanseIndex ServerScript ServerGeocodeGeocodeData ProvisioningServerMatchRelational Engines(Column/Row)Extended Application Services (XS)Monitoring 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC24

SAP HANA smart data qualityAccurate data enables trusted operations and analyticsSource DataSAP ERPMicrosoftSQL ServerMicrosoftExcelParsed, Formatted, Validatedand Corrected DataSun & Ski32 rue Gustve Eifei,Ris OrangisÄle-de-France91001FRSun & Ski32 rue Gustave EiffelRis Orangis, Île-de-France91000FranceSun & Ski32 rue Gustave Eiffel,RIS-ORANGISÎle-de-France91000 France01.20.98.16.43Sun & Ski32 rue Gustave EiffelRis Orangis, Île-de-France91000 France 33-01-20-98-16-43Sunn & Ski32 rue Gustave EiffelSun & Ski32 rue Gustave EiffelRis Orangis, Île-de-France91000 France 33-01-20-98-16-43Île-de-France91000 France33 01 20 98 16 43 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICSurvival/Master RecordSun & Ski32 rue Gustave EiffelRis Orangis Île-de-France91000 France 33-01-20-98-16-4325

SAP HANA smart data qualityEnsure accurate geolocation informationBI reports deliver more insight whenaccurate location data is availableRetailLocation Rapidly process large volumes of data in bothCustomerResidentbatch and real time modes Provides address cleansing to increase qualityof geolocation results Enhance addresses with geocode informationto support geo-dependent business operations Return nearby addresses and census data(U.S. only) for even more geo-dependentbusiness scenarios 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICExample: Find the closest store for each customerCust NameCustomer AddressGeo CodeClosest Store #MargaretRoberts1801 Dowling St.,Fort Collins, CO 80522(40.575874, -105.101652)1544Neil Nevue942 California Ave,Salt Lake City, UT, 84115(40.74043, -111.935701)440326

Common Usecases

Common scenariosAgile data warehouse / martSAP Business SuiteDatabasesbatch orreal timeHadoopSDI / SDQData Warehouse / MartSAP HANAFilesBISAP BWReplicate or transform data – batch or real time – into a data warehouse or mart with / without BWMost efficient way to populate SAP HANA 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC28

Common scenariosSAP Master Data GovernanceSAP Master Data GovernanceDe-centralized ApplicationsSDI / SDQCloud ApplicationsSAP HANAERPSAP HANASAPS/4HANAApplications SAP HANA smart data integration loads data into MDG hub MDG invokes SAP HANA smart data quality to perform cleansing or de-duplication processMost performant ETL / DQ support for SAP MDG 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC29

Common scenariosData quality firewall for SAP S/4HANA Real-time data quality checkon incorrect data entries (e.g.incomplete or wronglystructured address information)SAP HANA Real-time verification checkagainst duplicate data entriesProvides data trust andconfidence up-frontSAPS/4HANASAP HANAsmart data quality 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC30

Common scenariosSelf-service data preparationSAP Agile DataPreparationSAP BWCombineSAP Business SuiteIngestDatabasesSDI / SDQExploreShapeDistributeSAPHANAEnrichSAP HANASAPHANASDI SDQDelimited pin SAP Agile Data Preparation to support the ingestion of data, perform data shaping / enrichment /cleansing and distribution of dataFoundation for SAP Agile Data Preparation 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC31

SAP Data Hub – SDI Integration

SAP Data HubSimplify, understand and govern the flow of data at scaleMetadata CatalogConnection managementCrawling, browsing & searchingData preview & profilingData PipelinesBatch & streamsStructured & unstructuredMachine LearningData OrchestrationMulti system data workflowsEnterprise application integrationScheduling and monitoring 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC33

SAP Data HubOutlook for Data Integration & Processing PortfolioAgile Data Preparation (ADP)SAP Data HubSAP SLTSmart Data Integration (SDI)Data Quality Management(DQaas)SAP VORASmart Data Quality (SDQ)Information Steward (IS)Data Services (DS) 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC34

SAP Data HubConnected SystemsSAP Integration & Open ConnectivityCurrent architecture viewSAP LT Replication ServerConfigurationsReplication JobsApplicationSAP HANA, XS Advanced ModelSAP BWProcess ChainsPlatform ServicesUAASDIGitDistributed RuntimeKubernetes Cluster MetadataCatalogData Discovery Scheduling& Profiling& rationData Warehousing ProcessesSAP HANASDI FlowgraphsSAP VoraSAP Data Hub PipelinesServerless aphDocumentScripting(JS, Python)TemplatesBuilt-inConnectorsSAP Data HubFlowagentConnectivityData Integration into SAP HANASAP Data ServicesData Services JobCustomOperatorsHeterogeneous LandscapesDB EnginesFlow-based applicationsConnections3rd party, Open SourceDirect ConnectivityData StoragesCloud / On PremiseCloud StoresAWS S3, GCP GCS,Azure ADL & WASB 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICHadoopHDFS(optional)SAP Data HubAdapterSAP Vora SparkExtensionsMessaging, APIs35

Roadmap

SAP HANA smart data integrationProduct road map overview – Key innovationsRecent innovations1Connectivity Apache Cassandra,DB2 on AS/400 Enhanced MSSQL adapter to support dynamicports and windows authentication Enhanced Hive adapter to support advancedoptions Enhanced PostgreSQL adapter to supportreal-time CDC for LOB types Whitelists for adapters to limit access to sourcedatabase Support for using credentials stored in dataprovisioning agent secure storage WS-Security support for SOAP adapter Support Kerberos authentication for file adapterwhen writing to HDFS targetFlowgraph Autopartitioning Enhanced hierarchical transform to supportvirtual tables R-script nodeReplication task New editor for SAP HANA extended applicationservices, advanced modelDeployment SAP HANA smart data integration on CloudFoundry, SAP HANA, enterprise edition2018 – Planned innovations1,2Connectivity AWS RDS for Oracle, SQL Server,PostgreSQL Enhancement to MSSQL Log reader adapter tosupport configuring multiple remote sourcesfrom single MSSQL serverFlowgraph Enhancements to projection node in SAPHANA extended application services, advancedmodel, to support drag and drop Parameter passing to SAP HANA proceduresReal-time replication IBM DB2 on z/OSOperations SAP HANA cockpit content in SAP HANAextended application services, advanced model REST API – support batch, real-time,transactional scenarios in XSA with EIM RESTAPIDeployment Agent group load balancing Agent JDBC WebSockets configuration SAML security2019 – Product direction2Connectivity SOAP Web service as target REST adapter SharePoint Cloud Office 365 Connectivity using SAP Cloud Platform OpenConnectors serviceFlowgraph Autopartitioned data read Spatial data support Parsing, un-nesting, and nesting of NRDMdata formats SAP HANA extended application services,classic model, to advanced model migrationtool2020 – Product vision2Connectivity Intelligent payload handling and routing Extended data type support and processing (suchas geospatial) Self-healing data movementOperations Enhanced hybrid cloud capabilities Extended DevOps capabilities Advanced data governance Enhanced lifecycle management Data consistency verification and remediationReal-time replication SAP S/4HANA ABAP core data services view SAP HANA to SAP HANA in the cloudReplication task ODP objects as sourceOperations DP agent–based access controlDeployment Schema-level multitenancy Support active/active data systems (SAPHANA)1. Potential data protection and privacy features include simplified deletion of personal data, reporting of personal data to an identified data subject, restricted access to personal data, masking of personal data, read access logging to specialcategories of personal data, change logging of personal data, and consent management mechanisms. 2. This is the current state of planning and may be changed by SAP at any time without notice. 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC37

SAP HANA smart data qualityProduct road map overview – Key innovationsRecent innovations1Cleanse Supported country override option Locality official output columnGeocoding Geocoding now supported for IndiaaddressesMatch Match transform enhancements for SAPHANA extended application services,advanced model– Candidate selection– New output fields for match score andmatch policyData mask Support seed value as substitution variable2018 – Planned innovations1,2Cleanse Integration with SAP Data QualityManagement, microservices for location data New Chinese address directory for moreaccurate and current dataGeocode Integration with SAP Data QualityManagement, microservices for location dataMatch Match transform enhancements to supportpreconfigured component “incompleteperson” (SAP HANA extended applicationservices, advanced model only) Support matching with relational tables,including the complex SAP Business Suitedata model.2019 – Product direction2Cleanse Cleanse transform enhancements for SAPHANA extended application services,advanced model– Country identification enhancements– Allow users to select side-effect tables– Set schema name for side-effect tables2020 – Product vision2Cleanse Enhance cleansing to product and materialmaster data domainsData enrichment Enrich data from third-party sources for masterdata and transactional dataGeocode Points of interest searchBest record New transformMatch Proximity matching Cleanse transform enhancements for SAPHANA extended application services,advanced model– Match source output component when multipleinput sources used in matching– Custom and tie-breaker strategies for thesurvival rule settingsSAP HANA 2.0 SPS31. Potential data protection and privacy features include simplified deletion of personal data, reporting of personal data to an identified data subject, restricted access to personal data, masking of personal data, read access logging to specialcategories of personal data, change logging of personal data, and consent management mechanisms. 2. This is the current state of planning and may be changed by SAP at any time without notice. 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC38

SAP HANA smart data integration & smart data qualityGetting startedFind out more:http://sap.com/eimSubscribe to SAP HANASDI & SDQ videos:YouTube ChannelContact your SAPAccount Executivehttps://help.sap.com/viewer/p/HANASMART DATA INTEGRATIONhttps://www.sap.com/community.html 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC39

Thank you.Contact information:Shibajee Dutta Gupta - shibajee.dutta.gupta@sap.comVenkat Madireddi - venkat.madireddi@sap.com

Follow all of SAPwww.sap.com/contactsap 2018 SAP SE or an SAP affiliate company. All rights reserved.No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission ofSAP SE or an SAP affiliate company.The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and itsdistributors contain proprietary software components of other software vendors. National product specifications may vary.These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation orwarranty of any kind, and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials.The only warranties for SAP or SAP affiliate company products and services are those that are set forth in the express warrantystatements accompanying such products and services, if any. Nothing herein should be construed as constituting an additionalwarranty.In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document orany related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation,and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platforms, directions, andfunctionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reasonwithout notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, orfunctionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differmaterially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, and theyshould not be relied upon in making purchasing decisions.SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registeredtrademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product and service namesmentioned are the trademarks of their respective companies.See www.sap.com/corporate-en/legal/copyright/index.epx for additional trademark information and notices.

From the leader in data integration and quality SAP HANA smart data integration and smart data quality are the key data integration and data quality capabilities of the SAP HANA platform. These capabilities are delivered with one unified interface that radically simplifies IT l