Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Everand Logo

Welcome to Everand!

  • Discover millions of ebooks, audiobooks, and so much more with a free trial

    From $11.99/month after trial. Cancel anytime.

    Learn HANA in 24 Hours
    Learn HANA in 24 Hours
    Learn HANA in 24 Hours
    Ebook282 pages1 hour

    Learn HANA in 24 Hours

    By Alex Nordeen

    5/5

    ()

    Read preview

    About this ebook

    SAP Hana is popular due to its large main memories and massive parallel job processing capabilities. It makes SAP Hana real fast. The motive of this book is to develop a good understanding of how SAP Hana is used. The book doesn't need any experience with SAP HANA or software development. It’s a self-learning guide that even beginners can use. Everything about SAP HANA is explained like architecture, modeling, reporting, SQL script, and so on.


    This book is full of information, hands-on and real life project experience learning. In this edition, you will identify various components of SAP HANA and its working process. Though the book size is small, it tried to justify almost all important topics of SAP HANA with examples and images. These includes SLT, the connection between SAP system and HANA, Data services, etc. You will also learn how to use SQL script in HANA.


    By the end of this book, you will be able to integrate SAP HANA pretty much with any platform. Over a time you can use this edition as a handbook and harness your SAP Hana skills. So all and above this edition will save a lot of your expenses spend behind other courses and learning resources.


    Table Content


    Chapter 1: Introduction


    Introduction SAP HANA


    Why to choose SAP HANA?


    SAP HANA In-Memory Strategy


    SAP HANA Advantages


    SAP HANA Compare to BWA (Business Warehouse Accelerator)


    Chapter 2: Hana Architecture


    SAP HANA Architecture


    SAP HANA Landscape


    SAP HANA Sizing


    Chapter 3: SAP HANA Studio


    Pre-Requisite for SAP HANA Studio


    Supported Platform


    Download & Install SAP HANA Studio


    Add System in SAP HANA Studio


    Work With SAP HANA Studio


    Chapter 4: SQL Script, Data Type, Trigger, Sequence, Operator, Function, Expression, Identifiers


    What is SAP HANA SQL


    SAP HANA Identifiers


    SAP HANA Data Type


    SAP HANA Operator


    SAP HANA SQL FUNCTIONS


    SAP HANA SQL EXPRESSIONS


    SAP HANA SQL Stored Procedure


    SAP HANA Create Sequence


    SAP HANA Create Trigger


    Chapter 5: Data Provisioning


    Overview of Replication Technology


    SLT (SAP Landscape Transformation Replication Server)


    SAP DS (SAP DATA Services)


    SAP HANA Direct Extractor Connection (DXC)


    Flat file Upload to SAP HANA


    Chapter 6: Modeling


    SAP HANA Modelling Overview


    Join Method in SAP HANA


    SAP HANA Best Practices for Creating Information Models


    SAP HANA Attribute View


    SAP HANA Analytic View


    SAP HANA Calculation View


    SAP HANA Analytic Privileges


    SAP HANA Information Composer


    SAP HANA Import and Export


    SAP HANA Performance Optimization Technique


    Chapter 7: Security


    SAP HANA Security Overview


    SAP HANA Authentication


    SAP HANA Authorization


    SAP HANA User and Role Administration


    SAP HANA License Management


    SAP HANA Auditing


    Chapter 8: Reporting


    Reporting In SAP BI (Business Intelligence) Overview


    Reporting In Webi of SAP Business Objects (BO) on HANA


    Reporting In Crystal Report


    Reporting In SAP Lumira


    Reporting In Microsoft Excel

    LanguageEnglish
    PublisherPublishdrive
    Release dateOct 31, 2021
    Learn HANA in 24 Hours

    Read more from Alex Nordeen

    Related to Learn HANA in 24 Hours

    Related ebooks

    Computers For You

    View More
    View More

    Related podcast episodes

    Related categories

    Reviews for Learn HANA in 24 Hours

    5/5

    1 rating0 reviews

    What did you think?

    Tap to rate

    Review must be at least 10 words

      Book preview

      Learn HANA in 24 Hours - Alex Nordeen

      Chapter 1: Introduction

      SAP HANA is the latest ERP Solution from SAP, which is a combination of Hardware and Software. HANA has unprecedented adoption by the SAP customers.

      SAP HANA is latest, in-memory database, and platform which can be deployed on-premises or cloud. SAP HANA is a combination of hardware and software, which integrates different components like SAP HANA Database, SAP SLT (System Landscape Transformation) Replication server, SAP HANA Direct Extractor connection and Sybase replication technology 

      Introduction SAP HANA

      SAP HANA has two part –

      SAP HANA Database – SAP HANA Database is a hybrid in–memory database. SAP HANA Database is the heart of SAP in-memory technology. In SAP HANA, Database table are of two types –

      Row Store

      Column Store

      2) SAP HANA Platform – SAP HANA Platform is a development platform with an in-memory data store which allows the customers to analyze a large volume of data in real time. SAP HANA Platform works as a development platform, which provides infrastructure and tools for building a high-performance application based on SAP HANA Extended Application Services (SAP HANA XS).

      There are different types of SAP HANA edition, some of them as below-

      SAP HANA Platform Edition – It provides Core database technology. It Integrate SAP component like SAP HANA database, SAP HANA Studio and SAP HANA clients. It is for customers who want to use ETL-based replication and already have a license for SAP Business Objects Data Services.

      SAP HANA Enterprise Edition – It contains data provisioning (SLT, BODS, DXC) component including core database technology. It is for customers who want to use either trigger-based replication or ETL-based replication and do not have all of the necessary license for SAP Business Objects Data Services.

      SAP HANA Extended Edition – It contains data provisioning (Sybase) features more than Platform and Enterprises edition. It is for customers who want to use the full potential of all available replication scenarios including log-based replication.

      The following diagram shows difference between all editions –

      Why to choose SAP HANA?

      SAP HANA is a next-generation in-memory business platform. It accelerates analytics and application on a single and in-memory platform.

      Mentioned below are the few reasons why to choose SAP HANA –

      Real Time – SAP HANA Provides Real-Time Data Provisioning and Realtime Reporting.

      Speed – SAP HANA provide high speeds processing on massive data due to In-Memory Technology.

      Any Data/Source- SAP HANA can access various data source including Structured and Un-Structured data from SAP or Non-SAP data source.

      Cloud- SAP HANA database and application can be deployed to the Cloud environment.

      Simplicity – SAP HANA reduce efforts behind ETL process, Data Aggregation, Indexing, and Mapping.

      Cost – SAP claims that SAP HANA Software can reduce Total IT cost of a company.

      Choice Option – SAP HANA is supported by different hardware vendor and Software provider, so based on the requirement, the user can choose the best option.

      SAP HANA In-Memory Strategy

      SAP HANA has many processes running on the SUSE Linux Server. SUSE Linux server manages the reservation of memory to all process.

      When SAP HANA starts up, Linux OS reserves memory for the program code, program stack, and static data. OS can dynamically reserve additional data memory upon request from the SAP HANA Server.

      SAP HANA create a memory pool for managing and tracking the consumption of memory. The memory pool is used to store all the in-memory data and system tables, thread stack, temporary computations and all other data structure required for managing the database.

      When more memory is required for table growth or temporary computations, the SAP HANA memory manager obtains this from the pool.

      For an overview, check out the Memory Overview feature of the SAP HANA studio. To access it, right-click on a System ->Configuration and Monitoring -> Open Memory Overview in the context menu, as follows:

      SAP HANA Advantages

      Below are advantages of SAP HANA -

      By In-Memory Technology user can explore and analyze all transactional and analytic data in real time from virtually any data source.

      Data can be aggregated from many sources.

      Real-time replication services can be used to access and replicate data from SAP ERP.

      SQL and MDX interface from third party support.

      It provides information modeling and design environment.

      SAP HANA Compare to BWA (Business Warehouse Accelerator)

      SAP BW Accelerator: It is an in-memory accelerator for BW. BWA is focused on improving the query performance of SAP NetWeaver BW. BWA is specifically designed to accelerate BW queries reducing the data acquisition time by persisting copies of the infocube.

      SAP HANA: SAP HANA is in-memory database and platform for high-performance analytic reports and application. In SAP HANA data can be loaded from SAP and non-SAP Source System through SLT, BODS, DXC, and Sybase and can be viewed using SAP BO/BI, Crystal Reports, and Excel, etc.

      Currently, SAP HANA also work as in-Memory database for SAP BW, so in this way SAP HANA able to improve the overall performance of SAP Net weaver BW.

      Summary:

      SAP HANA is an in-memory database and application, which runs on SAP authenticated hardware and Software.

      SAP HANA have three version – platform, enterprises and extended.

      SAP HANA can load data from SAP and Non-SAP data source through SLT, BODS, DXC, and Sybase.

      SAP HANA provide real-time provisioning and reporting.

      SAP HANA provide high-performance real-time analytic reporting.

      SAP HANA reduces Total IT cost.

      Chapter 2: Hana Architecture

      SAP HANA Database is Main-Memory centric data management platform. SAP HANA Database runs on SUSE Linux Enterprises Server and builds on C++ Language.

      SAP HANA Database can be distributed to multiple machines.

      SAP HANA Advantages are as mentioned below –

      SAP HANA is useful as it's very fast due to all data loaded in-Memory and no need to load data from disk.

      SAP HANA can be used for the purpose of OLAP (On-line analytic) and OLTP (On-Line Transaction) on a single database.

      SAP HANA Database consists of a set of in-memory processing engines. Calculation engine is main in-memory Processing engines in SAP HANA. It works with other processing engine like Relational database Engine(Row and Column engine), OLAP Engine, etc.

      Relational database table resides in column or row store.

      There are two storage types for SAP HANA table.

      Row type storage (For Row Table).

      Column type storage (For Column Table).

      Text data and Graph data resides in Text Engine and Graph Engine respectively. There are some more engines in SAP HANA Database. The data is allowed to store in these engines as long as enough space is available.

      SAP HANA Architecture

      Data is compressed by different compression techniques (e.g. dictionary encoding, run length encoding, sparse encoding, cluster encoding, indirect encoding) in SAP HANA Column store.

      When main memory limit is reached in SAP HANA, the whole database objects (table, view,etc.) that are not used will be unloaded from the main memory and saved into the disk.

      These objects names are defined by application semantic and reloaded into main memory from the disk when required again. Under normal circumstances SAP HANA database manages unloading and loading of data automatically.

      However, the user can load and unload data from individual table manually by selecting a table in SAP HANA studio in respective Schema- by right-clicking and selecting the option Unload/Load.

      SAP HANA Server consists of

      Index Server

      Preprocessor Server

      Name Server

      Statistics Server

      XS Engine

      SAP HANA Index Server

      SAP HANA Database Main server are index server. Detail of each server is as below-

      It's the main SAP HANA database component

      It contains actual data stores and the engine for processing the data.

      Index Server processes incoming SQL or MDX statement.

      Below

      Enjoying the preview?
      Page 1 of 1