Data Provisioning for SAP HANA
1st Edition
Published on 28. July 2018
Book
Hardback
352 pages
978-1-4932-1671-0 (ISBN)
Description
Before making data available in SAP HANA, you must standardize, integrate, and secure it-that's where data provisioning comes in. In this guide, you'll learn about each of your options, from SAP HANA-based tools like SDI and SDQ to SAP Data Services and SAP LT Replication Server. Whether you'll be provisioning data in batches or in real-time, you'll understand when to use each tool, its requirements, and how it works. A detailed case study will show you how to establish a successful data provisioning practice!Highlights include:SAP HANA smart data integration (SDI)SAP HANA smart data quality (SDQ)SAP HANA smart data access (SDA)SAP Agile Data PreparationSAP Data ServicesSAP Landscape Transformation Replication ServerSAP Data Quality Management, microservicesCloud dataCase study
Highlights:
SAP HANA smart data integration (SDI)
SAP HANA smart data quality (SDQ)
SAP HANA smart data access (SDA)
SAP Agile Data Preparation
SAP Data Services
SAP Landscape Transformation Replication Server
SAP Data Quality Management, microservices
Cloud data
Case studies
More details
Persons
Author
Russel Lamb is a manager at Protiviti. He has dedicated his career to implementing end-to-end business intelligence solutions for numerous organizations in a variety of environments. Originally focusing on enterprise data modeling and ETL architecture, Russ has spent the last several years specializing in empowering organizations to use SAP HANA in by enhancing their EDW's, analyzing previously unwieldy ERP tables, cleansing and storing SaaS-sourced CRM data, and extending their landscape into the cloud. His diverse experience has resulted in numerous ASUG and SAP speaking engagements, ranging from SAP Data Services to cloud architecture best practices.
Don Loden is a director of Data and Analytics at Protiviti, with full lifecycle data warehouse and information governance experience in multiple industries. He is an SAP Certified Application Associate of SAP Data Services, and he is very active in the SAP community, speaking globally at numerous SAP and ASUG conferences and events. He has more than 18 years of information technology experience in the following areas: ETL architecture, development, and tuning; logical and physical data modeling; and mentoring on data warehouse, data quality, information governance, and ETL concepts. He is the author of three books and twelve articles on data management topics. You can follow Don on Twitter at @donloden. You can contact Don by email at don.loden@decisionfirst.com.
Content
... Preface ... 13
... Who This Book Is for ... 13
... How This Book Is Organized ... 14
... Acknowledgments ... 16
... Conclusion ... 16
1 ... Introduction ... 17
1.1 ... What Are the Tools for Provisioning Data? ... 17
1.2 ... How Are These Tools Used Together? ... 31
1.3 ... Summary ... 36
2 ... SAP HANA Smart Data Integration ... 37
2.1 ... What Is SAP HANA Smart Data Integration? ... 37
2.2 ... Use Cases for SAP HANA Smart Data Integration ... 38
2.3 ... Installation and Configuration ... 39
2.4 ... Using SAP HANA Smart Data Integration ... 48
2.5 ... Summary ... 89
3 ... SAP HANA Smart Data Quality ... 91
3.1 ... What Is SAP HANA Smart Data Quality? ... 91
3.2 ... How Do SAP HANA Smart Data Integration and SAP HANA Smart Data Quality Work Together? ... 92
3.3 ... Installation and Configuration ... 93
3.4 ... Using SAP HANA Smart Data Quality ... 103
3.5 ... Summary ... 122
4 ... SAP Agile Data Preparation ... 123
4.1 ... What Is SAP Agile Data Preparation? ... 123
4.2 ... SAP Agile Data Preparation and SAP HANA ... 124
4.3 ... SAP Agile Data Preparation: On-Premise versus Cloud ... 124
4.4 ... Installation and Configuration ... 126
4.5 ... Using SAP Agile Data Preparation ... 140
4.6 ... Summary ... 165
5 ... SAP Data Services ... 167
5.1 ... What Is SAP Data Services? ... 168
5.2 ... Installation and Configuration ... 194
5.3 ... Using SAP Data Services ... 202
5.4 ... Summary ... 217
6 ... SAP Landscape Transformation Replication Server ... 219
6.1 ... What Is the SAP Landscape Transformation Replication Server? ... 219
6.2 ... Installation and Configuration ... 222
6.3 ... Using the SAP LT Replication Server ... 225
6.4 ... Summary ... 238
7 ... SAP Data Quality Management, Microservices for Location Data ... 241
7.1 ... What Is SAP Data Quality Management, Microservices for Location Data? ... 241
7.2 ... Invoking Microservices for Location Data ... 243
7.3 ... Installation and Configuration ... 252
7.4 ... Using Prebuilt Functions ... 258
7.5 ... Summary ... 259
8 ... SAP HANA Data in the Cloud ... 261
8.1 ... Cloud Considerations ... 261
8.2 ... SAP Cloud Platform ... 265
8.3 ... Amazon Web Services ... 270
8.4 ... Microsoft Azure ... 275
8.5 ... Summary ... 279
9 ... Data Provisioning Case Studies ... 281
9.1 ... Data Preparation for an Omnichannel Initiative ... 281
9.2 ... Supply Chain Analytics for Reducing Cost of Goods Sold ... 303
9.3 ... Profile and Transform Customer Data ... 323
9.4 ... Cleaning and De-duplicating a Mailing List ... 332
9.5 ... Summary ... 343
... The Authors ... 345
... Index ... 347
... Who This Book Is for ... 13
... How This Book Is Organized ... 14
... Acknowledgments ... 16
... Conclusion ... 16
1 ... Introduction ... 17
1.1 ... What Are the Tools for Provisioning Data? ... 17
1.2 ... How Are These Tools Used Together? ... 31
1.3 ... Summary ... 36
2 ... SAP HANA Smart Data Integration ... 37
2.1 ... What Is SAP HANA Smart Data Integration? ... 37
2.2 ... Use Cases for SAP HANA Smart Data Integration ... 38
2.3 ... Installation and Configuration ... 39
2.4 ... Using SAP HANA Smart Data Integration ... 48
2.5 ... Summary ... 89
3 ... SAP HANA Smart Data Quality ... 91
3.1 ... What Is SAP HANA Smart Data Quality? ... 91
3.2 ... How Do SAP HANA Smart Data Integration and SAP HANA Smart Data Quality Work Together? ... 92
3.3 ... Installation and Configuration ... 93
3.4 ... Using SAP HANA Smart Data Quality ... 103
3.5 ... Summary ... 122
4 ... SAP Agile Data Preparation ... 123
4.1 ... What Is SAP Agile Data Preparation? ... 123
4.2 ... SAP Agile Data Preparation and SAP HANA ... 124
4.3 ... SAP Agile Data Preparation: On-Premise versus Cloud ... 124
4.4 ... Installation and Configuration ... 126
4.5 ... Using SAP Agile Data Preparation ... 140
4.6 ... Summary ... 165
5 ... SAP Data Services ... 167
5.1 ... What Is SAP Data Services? ... 168
5.2 ... Installation and Configuration ... 194
5.3 ... Using SAP Data Services ... 202
5.4 ... Summary ... 217
6 ... SAP Landscape Transformation Replication Server ... 219
6.1 ... What Is the SAP Landscape Transformation Replication Server? ... 219
6.2 ... Installation and Configuration ... 222
6.3 ... Using the SAP LT Replication Server ... 225
6.4 ... Summary ... 238
7 ... SAP Data Quality Management, Microservices for Location Data ... 241
7.1 ... What Is SAP Data Quality Management, Microservices for Location Data? ... 241
7.2 ... Invoking Microservices for Location Data ... 243
7.3 ... Installation and Configuration ... 252
7.4 ... Using Prebuilt Functions ... 258
7.5 ... Summary ... 259
8 ... SAP HANA Data in the Cloud ... 261
8.1 ... Cloud Considerations ... 261
8.2 ... SAP Cloud Platform ... 265
8.3 ... Amazon Web Services ... 270
8.4 ... Microsoft Azure ... 275
8.5 ... Summary ... 279
9 ... Data Provisioning Case Studies ... 281
9.1 ... Data Preparation for an Omnichannel Initiative ... 281
9.2 ... Supply Chain Analytics for Reducing Cost of Goods Sold ... 303
9.3 ... Profile and Transform Customer Data ... 323
9.4 ... Cleaning and De-duplicating a Mailing List ... 332
9.5 ... Summary ... 343
... The Authors ... 345
... Index ... 347