... Preface ... 15

... About This Book ... 15

... Our Demo Scenario ... 16

... Who Should Read This Book ... 17

... Structure of the Book ... 17

... Acknowledgments ... 20

... Part I: Getting Started ... 23

1 ... Introduction to the SAP HANA Development Platform ... 25

1.1 ... Business Cases for SAP HANA Applications ... 25

1.2 ... SAP HANA Components and Architecture ... 29

1.3 ... Application Design Considerations ... 38

1.4 ... Summary ... 40

2 ... SAP HANA Development Environment ... 43

2.1 ... System Landscape ... 43

2.2 ... SAP HANA, Express Edition ... 47

2.3 ... SAP Cloud Appliance Library ... 54

2.4 ... SAP Cloud Platform ... 60

2.5 ... SAP HANA XS Advanced Organizations and Spaces ... 69

2.6 ... Git Code Repository ... 74

2.7 ... Summary ... 80

3 ... SAP HANA Development Tools ... 83

3.1 ... Command-Line Client ... 83

3.2 ... SAP Web IDE for SAP HANA ... 101

3.3 ... SAP HANA Database Explorer ... 104

3.4 ... SAP HANA XS Advanced Cockpit ... 109

3.5 ... Other SAP HANA Database Development Tools ... 113

3.6 ... Summary ... 118

4 ... SAP HANA XS Advanced Architecture ... 119

4.1 ... Microservices Architecture ... 119

4.2 ... SAP HANA XS Advanced Architecture ... 122

4.3 ... SAP HANA XS Advanced Application Concepts ... 140

4.4 ... Summary ... 147

... Part II: Developing an Application ... 149

5 ... Defining the Data Model ... 151

5.1 ... Data Model Overview ... 152

5.2 ... The Demo Application ... 154

5.3 ... Data Model Design in SAP HANA ... 159

5.4 ... SAP HANA Deployment Infrastructure ... 189

5.5 ... SAP HANA Database Module ... 196

5.6 ... Core Data Services: The Physical Data Model ... 208

5.7 ... Loading Table Data ... 228

5.8 ... Synonyms and Cross-Schema Access ... 237

5.9 ... Virtual Data Model ... 243

5.10 ... SQLScript for Stored Procedures ... 275

5.11 ... Table Creation without Core Data Services Documents ... 279

5.12 ... Other Database Artifacts ... 281

5.13 ... Summary ... 288

6 ... Developing the Application Layer ... 289

6.1 ... Tasks of the Application Layer ... 290

6.2 ... Node.js as Application Layer ... 292

6.3 ... Java as Application Layer ... 358

6.4 ... Summary ... 391

7 ... Developing a Presentation Layer ... 393

7.1 ... SAPUI5 Frontend Development ... 394

7.2 ... SAP HANA XS Advanced Application Routing ... 426

7.3 ... Demo Application ... 436

7.4 ... Summary ... 446

... Part III: Refining the Application ... 447

8 ... Securing Your Application ... 449

8.1 ... SAP HANA XS Advanced Security Concepts ... 450

8.2 ... Authorization in SAP HANA XS Advanced ... 455

8.3 ... Enable Security in your SAP HANA XS Advanced Application ... 467

8.4 ... Maintaining Users and Roles in SAP HANA XS Advanced ... 482

8.5 ... Assigning HDI Container Roles to Classic Database Users ... 495

8.6 ... Default Access Role for HDI Containers ... 500

8.7 ... Permissions for Container Objects ... 503

8.8 ... Summary ... 506

9 ... Troubleshooting Your Application ... 507

9.1 ... Debugging ... 507

9.2 ... Application Logs and Logging ... 519

9.3 ... Database Traces ... 536

9.4 ... Performance Optimization ... 541

9.5 ... Summary ... 555

10 ... Deploying Your Application ... 557

10.1 ... Building the Multi-Target Application Archive ... 557

10.2 ... Deployment Process ... 560

10.3 ... Transporting SAP HANA XS Advanced Applications ... 566

10.4 ... Summary ... 570

... Appendices ... 571

A ... Migrating an SAP HANA XS Application to SAP HANA XS Advanced ... 573

B ... Additional Resources ... 593

C ... The Authors ... 595

... Index ... 597