Packt+ | Advance your knowledge in tech

0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Real Time Analytics with SAP Hana

You're reading from Real Time Analytics with SAP Hana Enhance your SAP HANA skills using this step-by-step guide to creating and reporting data models for real-time analytics

Product type Paperback

Published in Oct 2015

Publisher

ISBN-13 9781782174110

Length 226 pages

Edition 1st Edition

Tools

SAP Hana

Concepts

Data Analysis

Author (1):

Vinay Singh

View More author details

Table of Contents (16) Chapters

Real Time Analytics with SAP HANA

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

1. Kickoff – Before We Start FREE CHAPTER

2. SAP HANA Data Modeling Approach

3. Different Ways of SAP HANA Data Load

4. Creating SAP HANA Artifacts Attribute Views and Analytical Views

5. Creating SAP HANA Artifacts – Analytical Privileges and Calculation Views

6. Understanding Text Search and Hierarchies in SAP HANA

7. Using Decision Tables and Transporting SAP HANA Content

8. Consuming SAP HANA Data Models

9. An Introduction to Application Function Library

Index

Smart Data Access

SAP HANA Smart Data Access enables easy access to remote data, without copying the data into SAP HANA, so it feels like you are accessing a local table in SAP HANA.

Data Access helps to integrate data from multiple systems in real time regardless of where the data is located. With SDA, you can create virtual tables in SAP HANA that point to remote tables in different data sources, giving complete operatiability to these tables via SQL queries. The following diagram explains the flexibility and operatabilty of SAP SDA:

SAP HANA Smart Data Access supports the following databases (as of SAP HANA SP08):

Oracle 12c, Microsoft SQL Server 2012, Teradata ver13,14, IBM DB2 UDB ver10.1, and Netezza ver7
Sybase IQ: versions 15.4 ESD#3 and 16.0
SAP Sybase Adaptive Service Enterprise: version 15.7 ESD#4
SAP Sybase ESP 5.1 SP04
Apache Hive 0.9.0. or higher and the Simba HiveODBC driver
SAP HANA (BW on HANA, Suite on HANA)

For details on how to install the drivers for the databases supported by...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $15.99/month. Cancel anytime

Authors (1)

Vinay Singh

Vinay Singh

Vinay Singh is a data science manager at BASF, Germany. He has over 12 years' experience in data warehousing and BI. Before joining BASF, he worked with multiple companies/customers, including SAP, Adobe Systems, Freudenberg, and T-Systems, which provided him with a good mix of product development and consulting experience. His other publications include Real-Time Analytics with SAP HANA, published by Packt, Manage Your SAP Projects with SAP Activate, also published by Packt, and Creating and Using Advanced DSOs in SAP BW on SAP HANA, by SAP PRESS. He is a visiting research scholar at the National Central University of Taiwan, and a distinguished speaker at various forums.

See other products by Vinay Singh

Personalised recommendations for you

Based on your interests and search pattern

Mathematics of Machine Learning

Mathematics of Machine Learning

Deepen your theoretical knowledge and enhance your ability to solve complex machine learning problems with structured guidance. Gain the confidence to engage with advanced ML literature and tailor algorithms to meet your project requirements.

May 2025 24h 20m

Generative AI with Python and PyTorch

Generative AI with Python and PyTorch

Learn how to create images and text using VAEs, GANs, LSTMs, and transformers. Implement applications in natural language processing and computer vision through practical tutorials.

Mar 2025 15h 0m

Practical Generative AI with ChatGPT

Practical Generative AI with ChatGPT

This book helps you unlock ChatGPT's potential to make your working life better. From prompt engineering to creating custom GPTs, you'll enhance your productivity, creativity, and efficiency with practical insights and advanced techniques.

Apr 2025 12h 52m

Generative AI with LangChain

Generative AI with LangChain

Gain a solid foundation in LangChain, agentic AI, and LangGraph, and learn to build production-ready systems with multi-agent architectures, advanced RAG pipelines, Tree of Thought reasoning, agent handoffs, and fine-grained error handling.

May 2025 15h 52m

Architecting Power BI Solutions in Microsoft Fabric

Architecting Power BI Solutions in Microsoft Fabric

Power BI provides several options to solve common data problems, and designing the correct solution for each scenario can be a daunting task. This book makes it easier by guiding you through designing optimal solutions using Power BI.

Apr 2025 14h 16m

Microsoft Identity and Access Administrator SC-300 Exam Guide

Microsoft Identity and Access Administrator SC-300 Exam Guide

This comprehensive guide covers key topics such as Microsoft Entra ID implementation, authentication and access management, external user management, and hybrid identity solutions, providing practical insights and techniques for SC-300 exam success.

Mar 2025 19h 48m

LLM Design Patterns

LLM Design Patterns

This book helps you gain practical skills to develop and deploy LLMs. You'll learn data prep, training, pruning, quantization, and evaluation, as well as explore RAG, advanced prompting, and optimization to build robust, scalable language models.

May 2025 17h 48m

Tableau Cookbook for Experienced Professionals

Tableau Cookbook for Experienced Professionals

Advance your Tableau knowledge beyond the basics, streamline dashboard performance, tackle advanced geospatial challenges, and unlock API potential while fortifying your corporate data infrastructure with proven best practices.

Apr 2025 12h 24m

Time Series Analysis with Spark

Time Series Analysis with Spark

This book offers a complete guide to time series analysis with Apache Spark and Databricks, covering essential concepts and advanced techniques including Generative AI to equip readers with skills for real-world challenges across industries.

Mar 2025 9h 56m

Hands-On Artificial Intelligence for IoT

Hands-On Artificial Intelligence for IoT

Transform IoT systems with the power of artificial intelligence using this hands-on guide. Dive into practical techniques and expert insights to innovate and optimize your IoT devices, making them smarter and more efficient.

May 2025 15h 44m