... 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