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 from Flat file in SAP HANA


Prior to Revision 28 (SPS04) of SAP HANA Studio, loading data from flat file was a tedious task. Users had to use SAP Information Composer or go into a complex process of creating a control file, moving the files to server, and then executing SQL scripts to load the data. With Data from Local File in SAP HANA Studio (SPS04, rev28 and above), it takes just a few mouse clicks to upload data into SAP HANA from files that have CSV, XLS, or XLSX extensions.

Try to understand this step-by-step using an example. We have an XLS file that contains sales data for xyz customer and we need this data in SAP HANA.

* common currency ($) is used irrespective of country

We will proceed as follows:

  1. Open SAP HANA Studio | Quick Launch | Content Section | Import | SAP HANA Content | Data from Local File.

  2. Choose Data from Local File and click Next.

  3. You will be prompted to select Target System (where the data will be imported), so choose choose the system, the target system,...