SAP HANA
{{Third-party|date=October 2022}}
{{Use mdy dates|date=January 2018}}
{{short description|Database management system by SAP}}
{{Infobox software
| name = SAP HANA
| logo = Image:{{#property:logo image}}
| developer = {{#statements:developer}}
| released = {{start date|2010}}
| operating system = {{#statements:operating system}}
| language = English
| genre = Multi-model database
| license = Proprietary commercial software
| website = {{URL|https://www.sap.com/products/hana.html}}
}}
SAP HANA (HochleistungsANalyseAnwendung or High-performance ANalytic Application) is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE.{{cite web |title= Primer on SAP HANA |author= Jeff Kelly |date= July 12, 2013 |access-date= October 9, 2013 |work= Wikibon |url= http://wikibon.org/wiki/v/Primer_on_SAP_HANA }}{{YouTube |id=adv25iZmgQc |title= SAP HANA - The Column Oriented (Based) Database }} (December 8, 2012) Its primary function as the software running a database server is to store and retrieve data as requested by the applications. In addition, it performs advanced analytics (predictive analytics, spatial data processing, text analytics, text search, streaming analytics, graph data processing) and includes extract, transform, load (ETL) capabilities as well as an application server.
History
During the early development of SAP HANA, a number of technologies were developed or acquired by SAP SE. These included TREX search engine (in-memory column-oriented search engine), P*TIME (in-memory online transaction processing (OLTP) Platform acquired by SAP in 2005), and MaxDB with its in-memory liveCache engine.{{cite web | url= http://www.redbooks.ibm.com/redpapers/pdfs/redp4814.pdf | title= SAP In-Memory Computing on IBM eX5 Systems | first1= Gereon | last1= Vey | first2= Ilya | last2= Krutov | date= January 2012 | archive-url=https://web.archive.org/web/20140607002054/http://www.redbooks.ibm.com/redpapers/pdfs/redp4814.pdf |archive-date=June 7, 2014}}{{cite web |title= SAP HANA Timeline |date= June 17, 2012 |author= SAP SE |publisher= SlideShare |url= http://www.slideshare.net/SAPTechnology/sap-hana-timeline |access-date= October 9, 2013 }}
The first major demonstration of the platform was in 2011: teams from SAP SE, the Hasso Plattner Institute and Stanford University demonstrated an application architecture for real-time analytics and aggregation using the name HYRISE.{{Cite book|title=In-memory data management : an inflection point for enterprise applications|last=Plattner, Hasso|date=2011|publisher=Springer|others=Zeier, Alexander|isbn=978-3-642-19363-7|location=Berlin|oclc=719363183}} Former SAP SE executive, Vishal Sikka, mentioned this architecture as "Hasso's New Architecture".{{cite web
| title=Vishal Sikka: Timeless Software
| date=October 22, 2008
| url=http://vishalsikka.blogspot.co.uk/2008/10/timeless-software.html
| access-date= March 10, 2017 }} Before the name "HANA" stabilized, people referred to this product as "New Database".{{cite web |work= Gucons web site |year= 2011 |title= What is SAP HANA Database |url= http://www.gucons.com/what-is-sap-hana-database/ |access-date= October 9, 2013 }} The software was previously called "SAP High-Performance Analytic Appliance".{{cite web|author=Jaikumar Vijayan |url=http://www.computerworld.com/article/2514617/business-intelligence/sap-s-hana-will-speed-real-time-data-analytics.html |title=SAP's HANA will speed real-time data analytics |work=Computerworld |date=December 1, 2010 |access-date=January 4, 2018}}
A first research paper on HYRISE was published in November 2010.{{Cite journal|last1=Grund|first1=Martin|last2=Krüger|first2=Jens|last3=Plattner|first3=Hasso|last4=Zeier|first4=Alexander|last5=Cudre-Mauroux|first5=Philippe|last6=Madden|first6=Samuel|date=2010-11-01|title=HYRISE: a main memory hybrid storage engine|journal=Proceedings of the VLDB Endowment|language=en|volume=4|issue=2|pages=105–116|doi=10.14778/1921071.1921077}} The research engine is later released open source in 2013,The history of the project on [https://github.com/hyrise/hyrise GitHub] shows a first commit on 4 February 2013. and was reengineered in 2016 to become HYRISE2 in 2017.{{Cite web|url=https://hpi.de/plattner/projects/hyrise.html|title=HYRISE|website=hpi.de|language=de|access-date=2019-11-27}}
The first product shipped in late November 2010.{{Cite news |title= SAP launches HANA for in-memory analytics: The in-memory analytic appliance will compete with next-generation data-processing platforms such as Oracle's Exadata machines |author= Chris Kanaracus |date= December 1, 2010 |work= Info World |url= http://www.infoworld.com/d/data-management/sap-launches-hana-in-memory-analytics-300 |access-date= September 24, 2013 }}
By mid-2011, the technology had attracted interest but more experienced business customers considered it to be "in early days".{{Cite news |title= SAP's HANA is hot, but still in early days |work= Network World |date= September 15, 2011 |author= Chris Kanaracus |url= http://www.networkworld.com/news/2011/091511-saps-hana-is-hot-but-250942.html |access-date= October 15, 2013 |url-status= dead |archive-url= https://web.archive.org/web/20111019082728/http://www.networkworld.com/news/2011/091511-saps-hana-is-hot-but-250942.html |archive-date= October 19, 2011 |df= mdy-all }}
HANA support for SAP NetWeaver Business Warehouse (BW) was announced in September 2011 for availability by November.{{Cite news |title= SAP Begins BW on HANA Ramp-Up, First Big Test for the HANA Database |author= Courtney Bjorlin |work= ASUG News |date= November 9, 2011 |url= http://www.asugnews.com/article/sap-begins-bw-on-hana-ramp-up-first-big-test-for-the-hana-database |access-date= October 15, 2013 |url-status= dead |archive-url= https://web.archive.org/web/20131129174222/http://www.asugnews.com/article/sap-begins-bw-on-hana-ramp-up-first-big-test-for-the-hana-database |archive-date= November 29, 2013 |df= mdy-all }}
In 2012, SAP promoted aspects of cloud computing.{{Cite news |title= SAP Headed For $71 On Cloud, Mobile And HANA Growth |author= Trevis Team |work= Forbes |date= April 30, 2012 |url= https://www.forbes.com/sites/greatspeculations/2012/04/30/sap-headed-for-71-on-cloud-mobile-and-hana-growth/ |access-date= October 9, 2013 }} In October 2012, SAP announced a platform as a service offering called the SAP HANA Cloud Platform{{cite web|url=http://www.dbta.com/Editorial/News-Flashes/SAP-Introduces-SAP-HANA-Cloud-an-In-Memory-Cloud-Platform-85724.aspx|title=SAP Introduces SAP HANA Cloud, an In-Memory Cloud Platform|date=October 24, 2012|website=Database Trends and Applications|access-date=June 18, 2016}}{{cite web|url=https://hcp.sap.com/index.html|title=Overview {{!}} SAP HANA Cloud Platform|website=hcp.sap.com|access-date=June 18, 2016}} and a variant called SAP HANA One that used a smaller amount of memory.[https://marketplace.ibmcloud.com/apps/3997#!overview/ IBM Cloud AMM for SAP HANA One] {{webarchive|url=https://web.archive.org/web/20151119122345/https://marketplace.ibmcloud.com/apps/3997 |date=November 19, 2015 }}{{Cite news |title= SAP Launches Cloud Platform Built On Hana |author= Doug Henschen |date= October 17, 2012 |work= InformationWeek |url= http://www.informationweek.com/software/enterprise-applications/sap-launches-cloud-platform-built-on-han/240009198 |url-status=live |archive-url= https://web.archive.org/web/20121019234617/http://www.informationweek.com/software/enterprise-applications/sap-launches-cloud-platform-built-on-han/240009198 |archive-date= October 19, 2012 |access-date= October 15, 2013 }}
In May 2013, a managed private cloud offering called the HANA Enterprise Cloud service was announced.{{cite web
| title=SAP unveils HANA Enterprise Cloud service Network World
| date=May 7, 2013
| url=https://www.networkworld.com/article/673186/software-sap-unveils-hana-enterprise-cloud-service.html
| access-date=July 13, 2017
}}
In May 2013, Business Suite on HANA became available, enabling customers to run SAP Enterprise Resource Planning functions on the HANA platform.{{Cite news |title= SAP puts Business Suite on HANA, joins transactional to analytical |work= Computer Weekly |author= Brian McKenna |date= January 11, 2013 |url= http://www.computerweekly.com/news/2240175913/SAP-puts-Business-Suite-on-HANA-joins-transactional-to-analytical |access-date= October 15, 2013 }}{{Cite news |title= Sapphire 2013: Business Suite on HANA goes to general availability |work= Computer Weekly |date= May 15, 2013 |url= http://www.computerweekly.com/news/2240184187/Sapphire-2013-Business-Suite-on-HANA-goes-to-general-availability |access-date= October 15, 2013 }}
S/4HANA, released in 2015, written specifically for the HANA platform, combines functionality for ERP, CRM, SRM and others into a single HANA system.{{cite web
| title=SAP unwraps a new enterprise suite based on Hana PCWorld
| url=http://www.pcworld.com/article/2879512/sap-unwraps-a-new-enterprise-suite-based-on-hana.html
| access-date=July 13, 2017
}}
S/4HANA is intended to be a simplified business suite, replacing earlier generation ERP systems.{{cite web
| title=SAP Business Suite on HANA vs. S/4HANA Symmetry
| url=http://symmetrycorp.com/blog/sap-business-suite-on-hana-vs-s4hana/
| access-date=July 13, 2017
}} While it is likely that SAP will focus its innovations on S/4HANA, some customers using non-HANA systems have raised concerns of being locked into SAP products. Since S/4HANA requires an SAP HANA system to run, customers running SAP business suite applications on hardware not certified by SAP would need to migrate to a SAP-certified HANA database should they choose the features offered by S/4HANA.{{cite web
| title=SAP's S4/HANA master plan: The lingering questions ZDNet
| website=ZDNet
| url=https://www.zdnet.com/article/saps-s4hana-master-plan-the-lingering-questions/
| access-date=August 1, 2017
}}
Rather than versioning, the software utilizes service packs, referred to as Support Package Stacks (SPS), for updates. Support Package Stacks are released every 6 months.{{cite web
| title=HANA 2 – What is it? SAP Blogs
| url=https://blogs.sap.com/2016/11/14/hana-2-what-is-it/
| access-date=July 13, 2017
}}
In November 2016 SAP announced SAP HANA 2, which offers enhancements to multiple areas such as database management and application management and includes two new cloud services: Text Analysis and Earth Observation Analysis.{{cn|date=December 2022}}
HANA customers can upgrade to HANA 2 from SPS10 and above. Customers running SPS9 and below must first upgrade to SPS12 before upgrading to HANA 2 SPS01.{{cite web
| title=SAP HANA 2 - The Next Generation Platform
| url=https://www.appseconnect.com/sap-hana-2/
| access-date=July 13, 2017
}}
Architecture
= Overview =
The key distinctions between HANA and previous generation SAP systems are that it is a column-oriented, in-memory database, that combines OLAP and OLTP operations into a single system; thus in general SAP HANA is an "online transaction and analytical processing" (OLTAP) system,{{cite web
| title=What is SAP HANA? Expert Insight from Symmetry
| url=http://symmetrycorp.com/blog/what-is-sap-hana/
| access-date=August 1, 2017
}} also known as a hybrid transactional/analytical processing (HTAP). Storing data in main memory rather than on disk provides faster data access and, by extension, faster querying and processing.{{cite web
| title=SAP HANA sales fly but there's more to the in-memory story ZDNet
| website=ZDNet
| url=https://www.zdnet.com/article/sap-hana-sales-fly-but-theres-more-to-the-in-memory-story/
| access-date=July 28, 2017
}} While storing data in-memory confers performance advantages, it is a more costly form of data storage. Observing data access patterns, up to 85% of data in an enterprise system may be infrequently accessed therefore it can be cost-effective to store frequently accessed, or "hot", data in-memory while the less frequently accessed "warm" data is stored on disk, an approach SAP began to support in 2016 and termed "Dynamic tiering".{{cite web
| title=SAP Unleashes Major Hana Upgrade - InformationWeek
| date=October 24, 2014
| url=http://www.informationweek.com/cloud/software-as-a-service/sap-unleashes-major-hana-upgrade/d/d-id/1316932
| access-date=July 28, 2017
}}
Column-oriented systems store all data for a single column in the same location, rather than storing all data for a single row in the same location (row-oriented systems). This can enable performance improvements for OLAP queries on large datasets and allows greater vertical compression of similar types of data in a single column. If the read times for column-stored data is fast enough, consolidated views of the data can be performed on the fly, removing the need for maintaining aggregate views and its associated data redundancy.{{cite web
| title=A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database
| url=http://www.sigmod09.org/images/sigmod1ktp-plattner.pdf
| access-date=August 1, 2017
}}
Although row-oriented systems have traditionally been favored for OLTP, in-memory storage opens techniques to develop hybrid systems suitable for both OLAP and OLTP capabilities,{{cite web
| title=Compacting Transactional Data in Hybrid OLTP&OLAP Databases
| url=http://vldb.org/pvldb/vol5/p1424_florianfunke_vldb2012.pdf
| access-date=August 1, 2017
}} removing the need to maintain separate systems for OLTP and OLAP operations.
File:Hana.jpg The index server performs session management, authorization, transaction management and command processing. The database has both a row store and a columnar store. Users can create tables using either store, but the columnar store has more capabilities and is most frequently used.{{citation needed|date=August 2016}} The index server also manages persistence between cached memory images of database objects, log files and permanent storage files. The XS engine allows web applications to be built.{{cite web|url=http://www.saphana.com/community/blogs/blog/2012/12 |title=Monthly Archives |publisher=SAP Hana Blog |date=December 2012 |access-date=January 4, 2018}}
SAP HANA Information Modeling (also known as SAP HANA Data Modeling) is a part of HANA application development. Modeling is the methodology to expose operational data to the end user. Reusable virtual objects (named calculation views) are used in the modelling process.
= MVCC =
SAP HANA manages concurrency through the use of multiversion concurrency control (MVCC), which gives every transaction a snapshot of the database at a point in time. When an MVCC database needs to update an item of data, it will not overwrite the old data with new data, but will instead mark the old data as obsolete and add the newer version.{{cite web|url=http://help.sap.com/saphelp_hanaplatform/helpdata/en/94/fc07fbeff1474aa878737f2c9921d3/content.htm?frameset=/en/63/d055985b2a4d19bc860c98ac5a02cb/frameset.htm¤t_toc=/en/85/d132c3f05e40a2b20c25aa5fd6331b/plain.htm&node_id=68&show_children=false |title=Multiversion Concurrency Control (MVCC) Issues |publisher=SAP Help Portal |access-date=January 4, 2018}}{{cite web|url=http://pi3.informatik.uni-mannheim.de/~norman/HANA_Debull_2013.pdf |title=High-Performance Transaction Processing in SAP HANA |work=Bulletin of the IEEE Computer Society Technical Committee on Data Engineering |date=n.d. |access-date=January 4, 2018}}
Big data
In a scale-out environment, HANA can keep volumes of up to a petabyte of data in memory while returning query results in under a second. However, RAM is still much more expensive than disk space, so the scale-out approach is only feasible for certain time critical use cases.{{cite web|url=https://felixweber.me/2017/04/sap-hana-and-big-data-scale-out-options/ |title=SAP HANA and Big Data – Scale-out Options |date=April 7, 2017 |publisher=Felix Weber Research |access-date=April 7, 2019}}
Analytics
SAP HANA includes a number of analytic engines for various kinds of data processing. The Business Function Library includes a number of algorithms made available to address common business data processing algorithms such as asset depreciation, rolling forecast and moving average.{{cite web
| title=Business Function Library - Real Time Analytics with SAP HANA
| url=https://www.packtpub.com/mapt/book/big_data_and_business_intelligence/9781782174110/9/ch09lvl1sec70/business-function-library
| access-date=October 2, 2017
}}
The Predictive Analytics Library includes native algorithms for calculating common statistical measures in areas such as clustering, classification and time series analysis.{{cite web
| title=SAPexperts An Introduction to SAP Predictive Analysis and How It Integrates with SAP HANA
| date=June 30, 2013
| url=http://sapexperts.wispubs.com/An-Introduction-to-SAP-Predictive-Analysis-and-How-It-Integrates-with-SAP-HANA
| access-date=October 2, 2017
}}
HANA incorporates the open source statistical programming language R as a supported language within stored procedures.{{cite web
| title=When SAP HANA met R – What's new? R-bloggers
| date=February 18, 2013
| url=http://www.r-bloggers.com/when-sap-hana-met-r-whats-new/
| access-date=October 2, 2017
}}
The column-store database offers graph database capabilities. The graph engine processes the Cypher Query Language and also has a visual graph manipulation via a tool called Graph Viewer. Graph data structures are stored directly in relational tables in HANA's column store.{{cite web
| url=https://archive.fosdem.org/2017/schedule/event/graph_processing_sap_hana/
| title=FOSDEM 2017 - Graph Processing on SAP HANA, express edition
| access-date=October 2, 2017
}} Pre-built algorithms in the graph engine include pattern matching, neighborhood search, single shortest path, and strongly connected components. Typical usage situations for the Graph Engine include examples like supply chain traceability, fraud detection, and logistics and route planning.{{cite web
| url=https://www.slideshare.net/Mahican/the-graph-story-of-the-sap-hana-database
| title=The Graph Story of the SAP HANA Database
| access-date=October 2, 2017
}}
HANA also includes a spatial database engine which implements spatial data types and SQL extensions for CRUD operations on spatial data. HANA is certified by the Open Geospatial Consortium,{{cite web
| url=http://searchsap.techtarget.com/news/4500269418/SAP-HANA-SPS11-tackles-analytics-IT-and-development
| title=SAP HANA SPS11 tackles analytics, IT and development
| access-date=October 2, 2017
}} and it integrates with ESRI's ArcGIS geographic information system.{{cite web
| url=http://support.esri.com/en/technical-article/000012246
| title=FAQ: Does the ArcGIS platform support the SAP HANA database?
| access-date=October 2, 2017
}}
In addition to numerical and statistical algorithms, HANA can perform text analytics and enterprise text search. HANA's search capability is based on “fuzzy” fault-tolerant search, much like modern web-based search engines. Results include a statistical measure for how relevant search results are, and search criteria can include a threshold of accuracy for results.{{cite web
| url=http://www.destinationcrm.com/Articles/CRM-News/CRM-Featured-News/SAP-Releases-Sentiment-Analysis-Solution-84129.aspx
| title=SAP Releases Sentiment Analysis Solution - CRM Magazine
| access-date=October 2, 2017
}} Analyses available include identifying entities such as people, dates, places, organizations, requests, problems, and more. Such entity extraction can be catered to specific use cases such as Voice of the Customer (customer's preferences and expectations), Enterprise (i.e. mergers and acquisitions, products, organizations), and Public Sector (public persons, events, organizations).{{cite web
| url=https://blogs.sap.com/2017/05/21/sap-hana-ta-text-analysis/
| title=SAP HANA TA – Text Analysis
| access-date=October 2, 2017
}} Custom extraction and dictionaries can also be implemented.
Application development
Besides the database and data analytics capabilities, SAP HANA is a web-based application server, hosting user-facing applications tightly integrated with the database and analytics engines of HANA. The "XS Advanced Engine" (XSA) natively works with Node.js and JavaEE languages and runtimes. XSA is based on Cloud Foundry architecture and thus supports the notion of “Bring Your Own Language”, allowing developers to develop and deploy applications written in languages and in runtimes other than those XSA implements natively, as well as deploying applications as microservices. XSA also allows server-side JavaScript with SAP HANA XS Javascript (XSJS).{{cite web
| url=http://sapinsider.wispubs.com/Assets/Articles/2016/April/SPI-A-New-Development-Platform-for-Native-SAP-HANA-Applications
| title=A New Development Platform for Native SAP HANA Applications
| date=April 26, 2016
| access-date=October 2, 2017
}}
Supporting the application server is a suite of application lifecycle management tools allowing development deployment and monitoring of user-facing applications.
Deployment
HANA can be deployed on-premises or in the cloud from a number of cloud service providers.{{cite web
| title=SAP HANA Deployment Options On Premise, Cloud, or Hybrid
| url=https://www.sap.com/products/hana/implementation/deployment.html
| access-date=July 14, 2017
}}
HANA can be deployed on-premises as a new appliance from a certified hardware vendor.{{cite web|url=https://global.sap.com/community/ebook/2014-09-02-hana-hardware/enEN/appliances.html|title=Certified SAP HANA® Hardware Directory|website=global.sap.com|access-date=June 30, 2016}}
Alternatively, existing hardware components such as storage and network can be used as part of the implementation, an approach which SAP calls "Tailored Data Center Integration (TDI)".{{cite web|url=http://siliconangle.com/blog/2016/05/18/datacenter-integration-is-the-new-table-stakes-sapphirenow/|title=Datacenter integration is the new 'table stakes' {{!}} #SAPPHIRENOW|date=May 18, 2016 |access-date=June 30, 2016}}{{cite web|url=http://help.sap.com/saphelp_hanaplatform/helpdata/en/0b/15a92d554c4941a452c9ca127f8c70/content.htm|title=SAP HANA Tailored Data Center Integration - SAP HANA Technical Operations Manual - SAP Library|website=help.sap.com|access-date=June 30, 2016}}
HANA is certified to run on multiple operating systems{{cite web
|title=SAP HANA Hardware and Software Requirements
| url= http://help.sap.com/saphelp_hanaplatform/helpdata/en/d3/d1cf20bb5710149b57fd794c827a4e/content.htm }}
including SUSE Linux Enterprise Server{{cite web
| title=SUSE Linux Enterprise Server for SAP Applications
| url=https://www.suse.com/products/sles-for-sap/
| access-date=July 14, 2017
}}
and Red Hat Enterprise Linux.{{cite web
| title=Red Hat launches Enterprise Linux for SAP HANA ZDNet
| website=ZDNet
| url=https://www.zdnet.com/article/red-hat-launches-enterprise-linux-for-sap-hana/
| access-date=July 14, 2017
}}
Supported hardware platforms for on-premise deployment include Intel 64{{cite web
| title=SAP HANA Wrings Performance From New Intel Xeons
| date=February 19, 2014
| url=https://www.enterprisetech.com/2014/02/19/sap-hana-wrings-performance-new-intel-xeons/
| access-date=July 14, 2017
}} and POWER Systems.{{cite web
|title=SAP HANA on Power with SUSE Linux Enterprise Server for SAP Applications
| date= January 14, 2016 | url= https://www.suse.com/communities/blog/sap-hana-on-power-with-suse-linux-enterprise-server-for-sap-applications }}
The system is designed to support both horizontal and vertical scaling.
Multiple cloud providers offer SAP HANA on an Infrastructure as a Service basis, including:
| title=AWS - SAP HANA
| url=https://aws.amazon.com/sap/solutions/saphana/
| access-date=May 12, 2017
}}
| title=SAP HANA on Azure Virtual Machines - Microsoft Azure
| url=https://azure.microsoft.com/en-gb/services/virtual-machines/sap-hana/
| access-date=May 12, 2017
}}
| title=Google Cloud and SAP forge partnership to develop enterprise solutions
| date=March 7, 2017
| url=https://www.blog.google/topics/google-cloud/google-cloud-and-sap-forge-partnership-develop-enterprise-solutions/
| access-date=May 12, 2017
}}
- IBM Softlayer{{cite web|url=http://www-935.ibm.com/services/us/en/it-services/cloud-services/sap-selects-ibm/|title=SAP chooses IBM as a premier strategic provider of Cloud infrastructure services for its business critical applications|publisher=IBM}}
- Huawei FusionSphere{{cite web|url=http://www.huawei.com/en/news/2016/5/Huawei-Announces-Availability-of-SAP-HANA|title=Huawei Announces Availability of SAP HANA® Running on Huawei FusionSphere-huawei press center|website=huawei|access-date=September 8, 2016}}
SAP also offer their own cloud services in the form of:
- SAP HANA Enterprise Cloud, a private managed cloud{{cite web
| title=SAP unveils HANA Enterprise Cloud service Network World
| date=May 7, 2013
| url=https://www.networkworld.com/article/673186/software-sap-unveils-hana-enterprise-cloud-service.html
| access-date=July 14, 2017
}}
- SAP Business Technology Platform (previously known as SAP Cloud Platform and HANA Cloud Platform), Platform as a service{{cite web
| title=What is SAP Cloud Platform ? - Definition from WhatIs.com
| url=http://searchsap.techtarget.com/definition/SAP-HANA-Cloud-Platform
| access-date=July 14, 2017
}}
Editions
SAP HANA licensing is primarily divided into two categories.{{cite web|url=http://www.bluefinsolutions.com/blogs/john-appleby/may-2012/update-iii-the-sap-hana-faq-answering-key-sap#How%2520is%2520HANA%2520licensed|title=Update IV: The SAP HANA FAQ - answering key SAP In-Memory questions|website=bluefinsolutions.com|access-date=July 8, 2016}}
Runtime License:
Used to run SAP applications such as SAP Business Warehouse powered by SAP HANA and SAP S/4HANA.
Full Use License:
Used to run both SAP and non-SAP applications. This licensing can be used to create custom applications.{{cite web|url=http://searchdatamanagement.techtarget.com/feature/SAP-HANA-in-memory-DBMS-overview|title=SAP HANA in-memory DBMS overview|access-date=July 8, 2016}}
As part of the full use license, features are grouped as editions targeting various use cases.
- Base Edition: Provides core database features and development tools but does not support SAP applications.
- Platform Edition: Base edition plus spatial, predictive, R server integration, search, text, analytics, graph engines and additional packaged business libraries.
- Enterprise Edition: Platform edition plus additional bundled components for some of the data loading capabilities and the rule framework.
In addition, capabilities such as streaming and ETL are licensed as additional options.{{cite web|url=http://help.sap.com/hana_options?current=hana_options_adp&show_children=false|title=SAP HANA Options and Additional Capabilities – SAP Help Portal Page|website=help.sap.com|access-date=July 8, 2016}}
As of March 9, 2017, SAP HANA is available in an Express edition; a streamlined version which can run on laptops and other resource-limited environments. The license for SAP HANA, express edition is free of charge, even for productive use up to 32 GB of RAM.{{cite web|url=https://developers.sap.com/topics/sap-hana-express.html|title=SAP Developer center - SAP HANA express edition|website=developers.sap.com|access-date=January 28, 2019}} Additional capacity increases can be purchased up to 128 GB of RAM.{{cite web|url=https://www.graz.se/sap-hana-express/|title=OS Licensing requirements for SAP HANA Express Edition|date=November 30, 2021 |access-date=December 11, 2021}}
See also
References
{{Reflist|30em}}
External links
- {{Official website}}
- [http://go.sap.com/developer/topics/sap-hana.html SAP HANA, Developer edition]
- [https://blogs.sap.com/2017/01/31/why-not-to-use-an-in-memory-database/ When to Use an In-Memory Database]
- [https://www.ibm.com/it-infrastructure/power/sap-hana SAP HANA on IBM Power Systems]
- [https://www.decivision.com/blog/sap-hana/presentation-sap-hana SAP HANA : In-Memory made in SAP]
- [https://www.opkey.com/blog/accelerate-the-sap-s-4hana-journey-with-automation/ SAP S/4HANA Journey with Automation]
- [https://help.sap.com/docs/SAP_HANA_PLATFORM/52715f71adba4aaeb480d946c742d1f6/ade083aeded84e289d1710a1cf131499.html SAP HANA Studio]
Category:Proprietary database management systems