Preface

17

Who Should Read This Book?

17

How This Book is Organized

18

Personas

18

Chapter Overview

19

Text Boxes

22

Acknowledgments and Dedication

24

1 Introduction

27

1.1 What Is SAP HANA?

27

1.2 Key Capabilities

30

1.2.1 Application Development

30

1.2.2 Advanced Analytical Processing

31

1.2.3 Data Management

33

1.2.4 Database Management

33

1.3 Key Benefits

34

1.3.1 Reduce Complexity

35

1.3.2 Run Anywhere

36

1.3.3 Real Results

38

1.4 Finding Customer Stories and Use Cases

39

1.5 Industry Analysts

41

1.5.1 Gartner and the Magic Quadrant

41

1.5.2 Forrester Wave and IDC MarketScapes

42

1.6 The Road Ahead

43

1.7 Licensing and Maintenance

46

1.7.1 Licensing

46

1.7.2 Software Maintenance

47

1.8 Summary

49

2 Technology Overview

51

2.1 In-Memory Database Concepts

52

2.1.1 Database History in a Nutshell

52

2.1.2 SanssouciDB

54

2.2 System Architecture Overview

57

2.2.1 Implementation Scenarios

57

2.2.2 Services and Processes

58

2.2.3 Memory and Persistence

62

2.2.4 Single-Host and Distributed Systems

63

2.2.5 Database and Application Server

65

2.2.6 Data Tiering

66

2.3 Editions

67

2.3.1 SAP HANA, Platform Edition

67

2.3.2 SAP HANA, Express Edition

67

2.3.3 SAP HANA, Cloud Edition

68

2.3.4 Licensing, Options, and the Feature Scope Description

68

2.4 What’s New: Support Package Stacks and Revisions

70

2.4.1 SAP HANA Platform Edition 1.0

72

2.4.2 SAP HANA Platform Edition 2.0

78

2.5 Deployment Options

84

2.5.1 On-Premise

85

2.5.2 Cloud Deployments

85

2.6 Summary

93

3 Administration

95

3.1 Role and Tools

96

3.1.1 The SAP HANA Administrator

96

3.1.2 Tools

97

3.2 System Administration

105

3.2.1 System Configuration

105

3.2.2 Performance Monitoring and Analysis

108

3.2.3 Resource Management

118

3.2.4 Security

123

3.2.5 Backup and Recovery

124

3.2.6 Additional Responsibilities

129

3.3 SAP HANA Lifecycle Management

130

3.3.1 Platform Lifecycle Management

131

3.3.2 Product Availability Matrix

133

3.3.3 Installation and Update

135

3.3.4 Application Lifecycle Management

139

3.4 Application Server Administration

141

3.4.1 SAP HANA XS Admin Tool

142

3.4.2 Deploying SAP HANA XS Advanced Applications

142

3.5 Summary

145

4 Development

147

4.1 Role and Tools

148

4.1.1 The SAP HANA Developer

148

4.1.2 Tools

150

4.2 SQL and SQLScript

154

4.2.1 SQL

154

4.2.2 SQLScript

156

4.2.3 ABAP Managed Database Procedures

158

4.3 Analytic Modeling

160

4.4 SAP HANA Extended Application Services

163

4.4.1 SAP HANA XS

164

4.4.2 SAP HANA XS Advanced

165

4.5 Core Data Services

169

4.6 SAP HANA Deployment Infrastructure

171

4.7 Application Lifecycle Management

173

4.8 JSON Document Store

174

4.9 SAP Cloud Platform

177

4.9.1 Cloud Foundry and Neo

178

4.9.2 SAP Cloud Application Programming Model

179

4.9.3 SAP Cloud Platform, SAP HANA Service

180

4.10 Client Interfaces

181

4.10.1 SAP HANA Client Installation

181

4.10.2 SQLDBC

183

4.10.3 JDBC

183

4.10.4 ODBC

184

4.10.5 ODBO

187

4.10.6 Python

188

4.10.7 Node.js

190

4.10.8 Go

192

4.10.9 ADO.NET

193

4.10.10 Ruby

194

4.11 Web-Based Data Access

195

4.11.1 OData

196

4.11.2 Information Access

198

4.11.3 XMLA

200

4.12 SAP HANA, Express Edition

201

4.12.1 Deployment Options

202

4.12.2 Getting Started

204

4.13 SAP HANA Interactive Education

206

4.13.1 Deployment Options

207

4.13.2 Getting Started

208

4.14 Summary

210

5 Advanced Analytics

213

5.1 Roles and Tools

215

5.1.1 The SAP HANA Data Scientist

215

5.1.2 Tools

215

5.2 Predictive Analytics and Machine Learning

218

5.2.1 Application Function Library

220

5.2.2 Predictive Analysis Library

220

5.2.3 R Integration

222

5.2.4 External Machine Learning Library

225

5.2.5 Automated Predictive Library

227

5.3 Spatial Data Processing

228

5.4 Graph Data Processing

232

5.5 Series Data Processing

235

5.6 Text Analytics and Search

237

5.6.1 Search

238

5.6.2 Text Analysis

240

5.6.3 Text Mining

242

5.7 SAP HANA Streaming Analytics

243

5.8 Summary

246

6 Security

247

6.1 Roles and Tools

248

6.1.1 The SAP HANA Security Architect

248

6.1.2 Tools

249

6.2 User Management

251

6.2.1 Implementation Scenarios

252

6.2.2 User Types and User Groups

254

6.2.3 Authentication

256

6.2.4 Authorization

261

6.3 Data Privacy and Protection

268

6.3.1 Data Masking

268

6.3.2 Data Anonymization

270

6.3.3 Encryption

271

6.4 Auditing

278

6.5 SAP HANA XS Security

281

6.6 Additional Security Considerations and Concerns

281

6.7 Summary

282

7 Data Integration

285

7.1 Roles and Tools

286

7.1.1 The SAP HANA Data Integration Architect

286

7.1.2 Tools

287

7.2 SAP HANA Data Management Suite

287

7.2.1 SAP Data Hub

288

7.2.2 SAP Enterprise Architecture Designer

291

7.2.3 SAP Cloud Platform Big Data Services

291

7.3 Enterprise Information Management

291

7.3.1 SAP HANA Smart Data Integration and SAP HANA Smart Data Quality

292

7.3.2 SAP Data Services

295

7.3.3 SAP Agile Data Preparation

296

7.4 Data Federation with SAP HANA Smart Data Access

297

7.5 Remote Data Synchronization

298

7.6 Data Replication

300

7.6.1 SAP Landscape Transformation Replication Server

300

7.6.2 SAP Replication Server

302

7.7 Big Data

303

7.7.1 SAP Vora

304

7.7.2 SAP HANA Hadoop Integration

305

7.8 Summary

306

8 Data Architecture

309

8.1 Roles and Tools

310

8.1.1 The SAP HANA Data Architect

310

8.1.2 Tools

310

8.2 SAP Enterprise Architecture Designer

311

8.3 Scaling SAP HANA

314

8.3.1 Distributed Systems

315

8.3.2 Scale-Up

316

8.3.3 Scale-Out

317

8.3.4 Configuring Scale-Out Systems

318

8.3.5 Scale-Out for SAP HANA XS Advanced

319

8.4 Data Tiering

320

8.4.1 Persistent Memory

321

8.4.2 SAP HANA Native Storage Extension

321

8.4.3 SAP HANA Extension Nodes

322

8.4.4 SAP HANA Dynamic Tiering

323

8.4.5 SAP Data Hub and the Spark Controller

325

8.5 Data Distribution

326

8.5.1 Table Partitioning

326

8.5.2 Table Placement and Distribution

329

8.5.3 Table Replication

330

8.6 SAP HANA Data Warehousing Foundation

331

8.6.1 Data Distribution Optimizer

332

8.6.2 Data Lifecycle Manager

333

8.6.3 Native Datastore Objects

333

8.7 Summary

335

9 Data Center Architecture

337

9.1 Roles and Tools

338

9.1.1 The SAP HANA Data Center Architect

338

9.1.2 Tools

339

9.2 Implementation Overview

340

9.2.1 Sizing SAP HANA

340

9.2.2 Implementation Partners

342

9.3 Deployment Options

344

9.3.1 Hybrid and Multicloud

344

9.3.2 Single-Host and Distributed Systems

344

9.3.3 Technical Deployments (MCOS and MCOD)

345

9.3.4 Tenant Databases

347

9.3.5 Virtualization

348

9.4 On-Premise SAP HANA

350

9.4.1 Appliance

350

9.4.2 Tailored Data Center Integration

351

9.5 Hardware Technologies

352

9.5.1 Intel Optane Persistent Memory

353

9.5.2 IBM Power Systems

355

9.6 Operating System Platforms

356

9.6.1 SUSE

357

9.6.2 Red Hat

358

9.7 Infrastructure-as-a-Service Providers

360

9.7.1 Amazon Web Services

360

9.7.2 Microsoft Azure

362

9.7.3 Google Cloud Platform

362

9.7.4 Public Cloud Providers

364

9.8 Migration

364

9.8.1 AnyDB to SAP HANA

365

9.8.2 Software Update Manager Database Migration Option

366

9.8.3 Custom Applications

367

9.8.4 Third-Party Applications

368

9.9 High Availability and Disaster Recovery

368

9.10 System Replication

371

9.10.1 Configuration

371

9.10.2 Multitier and Multitarget

372

9.10.3 Active/Active Read-Enabled System Replication

373

9.11 Network Administration and Landscape Management

374

9.11.1 Network Administration

375

9.11.2 SAP Landscape Management

376

9.11.3 SAP Solution Manager

378

9.12 Summary

379

10 Training and Support

381

10.1 Training

381

10.1.1 SAP Education

382

10.1.2 openHPI and openSAP

391

10.1.3 SAP HANA Academy

396

10.1.4 SAP Developer Center

399

10.2 SAP Services and Support

400

10.2.1 SAP Digital Business Services

401

10.2.2 SAP Support

401

10.2.3 SAP Help Portal

405

10.2.4 SAP ONE Support Launchpad

408

10.3 SAP Community

411

10.4 SAP Events

413

10.4.1 SAPPHIRE NOW

413

10.4.2 SAP TechEd

413

10.4.3 CodeJams and SAP Inside Track

415

10.4.4 SAP HANA Operation Expert and Developer Summit

415

10.5 User Groups, Alliances, and More

416

10.5.1 SAP User Groups

416

10.5.2 Customer Engagement Initiatives

417

10.5.3 SAP University Alliances and SAP HANA Database Campus

417

10.5.4 HanaHaus and the Innovation Center Network

418

10.5.5 SAPinsider Magazine and Conferences

418

10.6 Summary

419