SAP HANA Cloud in a Nutshell: Design, Develop, and Deploy Data Models using SAP HANA Cloud

Description

This book introduces SAP HANA Cloud and helps you develop an understanding of its key features, including technology, architecture, and data modeling. SAP HANA Cloud in a Nutshell will help you develop the skills needed to use the core features of the completely managed and in-memory cloud-based  data foundation available in the SAP Business Technology Platform.  The book covers modern modeling concepts and equips you with practical knowledge to unleash the best use of SAP HANA Cloud. As you progress, you will learn how to provision your own SAP HANA Cloud instance, understand how to work with different roles, and work with data modeling for analytical and transactional use cases. Additionally, you will learn how to pilot SAP BTP Cockpit and work with entitlements, quotas, account structure, spaces, instances, and cloud providers. You will learn how to perform administration tasks such as stop and start an SAP HANA Cloud instance and make it available for use. To fully leverage the knowledge this book offers, you will find practical step-by-step instructions for how to establish a cloud account model and create your first SAP HANA Cloud artifacts. The book is an important prerequisite for those who want to take full advantage of SAP HANA Cloud.  What You Will Learn  Master the concepts and terminology of SAP Business Technology Platform (BTP) and SAP HANA Cloud  Understand the key roles of an SAP HANA Cloud implementation  Become familiar with the key tools used by administrators, architects, and application developers  Upgrade an SAP HANA Cloud database  Understand how to work with SAP HANA Cloud modeling supporting analytical and transactional use cases Who This Book Is For SAP consultants, cloud engineers, and architects; application consultants and developers; and project stakeholders Table of Contents About the Author About the Technical Reviewer Acknowledgments Introduction Chapter 1: Introduction to SAP HANA Cloud The New Digital World IT Challenges The Intelligent Enterprise The SAP HANA Cloud Provisioning with Flexible Scalability Usage Scenarios Working in a Mixed Landscape The SAP HANA Toolbox Feature Differences Simplified Data Models Traditional Applications Simplified Applications with SAP HANA Cloud Classic Approach New Approach A Single Point of Truth Modern Applications Embedding Insights Working with Different Data Types and Sources Key Technologies New Technologies and Opportunities The Path to In-Memory Database So, There’s No Need for a Disk? Row and Column Store Supporting Transactional and Analytical Applications Data Footprint Reduction Key Roles The Administrator Role The Modeler Role The Application Developer Role The Security Architect Role The Data Architect Role Summary Chapter 2: Administration of SAP HANA Cloud Entitlements and Quotas Global Accounts Space and Instance Hyperscalers Setting Up a SAP HANA Cloud Database Instance Working with Administration Tools SAP HANA Cloud Central SAP HANA Cockpit Command-Line Interfaces SAP BTP Command-Line Interface (btp CLI) Cloud Foundry Command-Line Interface (cf CLI) SAP HANA Database Explorer HDI Cockpit Administration Tasks Launching and Shutting Down Working with New Releases Cycle of SAP HANA Cloud Releases Backup and Recovery of the SAP HANA Cloud Database Back Up the SAP HANA Cloud Database Recover the SAP HANA Cloud Database Manage and Monitor Performance Secure the SAP HANA Cloud Database Manage Users, Roles, and Permissions Summary Chapter 3: Analytical Processing with SAP HANA Cloud Modeling in SAP HANA Cloud Classic Approach: Data-Modeling Code in the Application New Approach: Data Modeling in the Database Reuse of Models Advanced Data Processing Types of Calculation Views Modeling Dimensions Modeling Cubes Modeling Star Schemas Modeling with SAP Business Application Studio Extending Calculation Views with SQLScript Securing Data Models Advanced Analytics with SAP HANA Cloud SAP HANA Cloud Spatial Predictive Analysis SAP HANA Predictive Analysis Library (PAL) Automated Predictive Library (APL) Graph Modeling Graph Model: Example Summary Chapter 4: Developing Applications on SAP HANA Cloud Choosing an Environment on Business Technology Platform Introducing Cloud Foundry Introducing SAP Cloud Application Programming Model (CAP) Hierarchical Structure of Cloud Foundry Applications Service Plans Key Tools Used by Developers SAP Business Application Studio Git for Source Code Management SAP HANA Database Explorer Choosing Content Types UI Development Services OData Services Core Data Services SQLScript Calculation Views Summary Chapter 5: Working with SAP BTP Estimator and SAP HANA Cloud Adopting SAP Business Technology Platform Missions Services Estimator Customize Estimate SAP HANA Cloud Capacity Unit Estimator Summary Chapter 6: How to Activate Your SAP BTP Account Your Journey Starts Here Registering Your Account Activating Your Account Accessing the SAP BTP Trial Check Your Account Go to the Welcome Page Working with Subaccounts Exploring the Service Marketplace Creating an SAP HANA Cloud Instance Set Up SAP HANA Cloud Creating an SAP HANA Cloud Instance Create Database Managing Instances Set Up SAP Business Application Studio Starting with SAP BTP Trial Login Accessing the SAP Business Application Studio Subscribing to SAP Business Application Studio Launching SAP Business Application Studio Starting with a New Dev Space Summary Chapter 7: How to Create Artifacts in SAP HANA Cloud Creating a New Project Creating Database Artifacts Creating a Text Index Deploy the Database Add Data from a Local File Check the Data Creating Calculations Views Configure Differential Privacy via SQL View Create a Calculation View of Type Cube Join the SQL View and Table Configure the Join Configure Semantics Build and Test Summary Index