Book Image

Real Time Analytics with SAP Hana

By : Vinay Singh
Book Image

Real Time Analytics with SAP Hana

By: Vinay Singh

Overview of this book

SAP HANA is an in-memory database created by SAP. SAP HANA breaks traditional database barriers to simplify IT landscapes, eliminating data preparation, pre-aggregation, and tuning. SAP HANA and in-memory computing allow you to instantly access huge volumes of structured and unstructured data, including text data, from different sources. Starting with data modeling, this fast-paced guide shows you how to add a system to SAP HANA Studio, create a schema, packages, and delivery unit. Moving on, you’ll get an understanding of real-time replication via SLT and learn how to use SAP HANA Studio to perform this. We’ll also have a quick look at SAP Business Object DATA service and SAP Direct Extractor for Data Load. After that, you will learn to create HANA artifacts—Analytical Privileges and Calculation View. At the end of the book, we will explore the SMART DATA access option and AFL library, and finally deliver pre-packaged functionality that can be used to build information models faster and easier.
Table of Contents (16 chapters)
Real Time Analytics with SAP HANA
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Loading data in SAP HANA with Data Services Workbench


SAP Data Services is an all-in-one solution for data integration. It helps customers with various information management capabilities such as ETL, profiling, text analytics, and metadata management.

Up until now, before Data Service Workbench was introduced, we used to perform the following steps for data loading in SAP HANA via Data Services: Import Metadata into Data Services Workbench (source system HANA relevant) | create DS jobs to push data in SAP HANA | schedule/run the DS job | data is then available in the relevant schema in SAP HANA.

With Data Services Workbench, the job is much simpler, and we will focus on it here. Data Services Workbench is a new feature and was released with Data Services 4.1. It's part of the installation package for Data services 4.1.

Data Load with SAP Data Services Workbench

These are the steps to set up data provisioning in HANA using Data Services Workbench:

Note

Source Database setting | Test the connection...