Coming October 25: PeerSpot Awards will be announced! Learn more
2017-10-10T12:04:00Z
PeerSpot user
Project Manager - HCM Solutions at Ramco Systems
  • 11
  • 29

Microsoft sql2017 VS SAP Hana

Looking for a comparison of Microsoft SQL 2017 and SAP Hana.


12
PeerSpot user
12 Answers
Satish kadam - PeerSpot reviewer
IT Manager with 1,001-5,000 employees
Real User
2017-11-02T04:42:03Z
02 November 17

SAP Hana and MS SQL can be compared on various parameters such as capabilities , securities , cost and other features . as my other colleagues pointed out it can be compare based on anyone of these parameters if objective of comparision is known to us .

it_user525360 - PeerSpot reviewer
Enterprise Programmes Architect at a logistics company with 10,001+ employees
Real User
2017-11-01T01:42:15Z
01 November 17

DP DHL does use both tools but the use is largely restricted by business function. To begin with I must set the context of which we use these tools.

I need to point out we also use Software AG's Terracotta and Mongo db for in-memory solutions as well as SAP's Hana. Terracotta is used for persistent memory associated with our ESB and Complex Event Processing, while Mongo db is primarily for report and user facing applications. Hana is largely confined to within the Global Business Management with limited use outside that division. All in-memory solutions are considered secondary drawing their data from relational data stores which is usually denormalized to support rapid access.

MS SQL is used for departmental level data stores and usually for non-mission critical applications. We have as primary data stores Oracle, Informix and Teradata (for data warehousing). MS SQL is usually defined as a functional data store (not really an ODS) and rarely connected to on-line transactional processing, but frequently as a localized data mart or in a supporting function.
The difference we have experienced between the tools was on speed of resolution for on-line requests, and if atomic, relational data was needed.

Hana worked well for us in areas where using large volumes of aggregated and unstructured data for analysis. It was primarily tied to our SAP ERP solutions with the native integration a prime feature. We rarely found it useful in big data search as we tend to approach big data in a non-standard and proprietary approach. Hana allowed close integration s well to a number of statistical modeling tools that support the financial analysis and forecasting.

MS SQL excelled in the areas of data quality validations, drill down of finite sets of data for a given subject area (limited business objects over small temporal windows). It integrated well and was actually a necessity for the use of the Microsoft BI stack, and tools. These are usually locally enabled, along with Tableau and Qlik-View by business functions. However, once “productionizing” the analytics we move to in-house developed solutions to reduce license and run costs.

Each tool has its own niche within DP DHL, and there is no view to replacing one with the other.

PeerSpot user
Security Data Analyst at a tech company with 10,001+ employees
Real User
2017-10-31T19:24:54Z
31 October 17

There are several similarities b/w the relational databases. I would go with one or the other only based on the use-case.
This particular tabular format helps compare and contrast the features.
https://db-engines.com/en/system/Microsoft+SQL+Server%3BSAP+HANA

Mordechai Danielov - PeerSpot reviewer
User at a tech services company
Real User
2017-10-31T17:58:20Z
31 October 17

SAP Hana under the full use license can support non-SAP applications that's not the problem, but I don't think anyone would want to do it because of its high cost. Also notice that SAP HANA uses it's own SQL flavor and has a limited choice of drivers.

PeerSpot user
Technology Director at a insurance company with 501-1,000 employees
Real User
2017-11-05T17:59:01Z
05 November 17

Sap hana is a in-memory database and expensive. If there is a sap r/3 , you may consider Hana, otherwise no need.

PeerSpot user
Software Architect at a tech consulting company with 51-200 employees
Real User
2017-10-31T18:23:14Z
31 October 17

I have NOT stated that HANA is a regular RDBMS, only I have done is to compare certain specific functionality that is similar between HANA and editions of SQL Server 2016, like for instance, columnstore indexes and xVelocity (I am using SQL Server monikers to describe similar functionality)

HANA as an appliance has functionality that roughtly corresponds with what Parallel Data Warehouse in SQL Server 2016 offers.

Kind regards, GEN

Find out what your peers are saying about SAP HANA vs. SQL Server and other solutions. Updated: September 2022.
634,550 professionals have used our research since 2012.
Vendor
2017-10-31T18:14:18Z
31 October 17

SAP Hana its not a RBMS, its an applications that run on memory and is only available as appliances and your data source can be a database coming RDBMS SQL. But are differents applications and filosofy.

PeerSpot user
Software Architect at a tech consulting company with 51-200 employees
Real User
2017-10-31T16:40:25Z
31 October 17

It is SQL Server 2016 that we should compare with SAP HANA, and not SQL Server 2017.

Before I get into the details of the comparisons, allow me to give you some feedack on why the comparison has to be with SQL Server 2016 and not with 2017.

Microsoft has embarked on a roadmap to have a SQL Server product line that offers the same tools and technologies on both Windows and Linux, but as of today, it is not there yet, so, for now, the full product line for SQL Server is only available in Windows with SQL Server 2016.

SQL Server 2017 does offer the same tools and technologies on both Windows and Linux, but SS 2017 only offers a subset of all the tools and technologies available with SQL Server 2016. As the roadmap for the common Windows/Linux codebase for SQL Server evolves over time, it is expected that coming versions of said products will widen the coverage of available tools and technologies.

Now that we have settled this point, we can get into the comparisons.

To start with, SAP HANA is only available as appliances for On Prem, and as a Cloud service, so, that gives you and idea of the budget range that would be involved.

Regarding SQL Server 2016, main functionality present in HANA, like In-Memory OLTP, or column store indexes and PowerPivot / xVelocity BI, is also available in SQL Server 2016 Enterprise, that runs on commodity hardware.

You also have this functionality as a Cloud Service in SQL Azure, and you could also design a hybrid solution of SQL Server 2016 Standard On Prem / SQL Azure for some tables that may require In-Memory OLTP support, and this is much less expensive than either only Enterprise or only SAP HANA.

It is SQL Server 2016 Parallel Datawarehouse (PDW) edition that offers all the functionality present in SAP HANA, and, just like HANA, PDW comes as appliances for On Prem and as a Cloud Service.

If you have any more questions pertaining to this, or some of point that I have covered are not clear, just ask.

Kind regards, GEN

Vendor
2017-10-31T14:47:33Z
31 October 17

Here is a useful tabular comparison of the two database engines:
          https://db-engines.com/en/system/Microsoft+SQL+Server%3BSAP+HANA

You could say that Microsoft SQL Server is more flexible than SAP HANA, and achieves a higher score and ranking.
On the other hand, if your environment is all SAP, SAP HANA may integrate better with the other application components.

Vendor
2017-10-31T14:04:36Z
31 October 17

The databases are completely different and I mean completely different.
Hana is an in-memory, columnar database that can mimic a row store in some cases.
SQL Server is anything from a classic relational DB to a distributed parallel warehouse, PDW.

If you are implementing SAP modules for your business, HANA gets consideration because of the expertise of the SAP people there to do the implementation. If you are implementing a home grown system or expecting to support the new system with in-house people, pick the DBMS that your in-house people are most comfortable working with.

From my limited perspective, I would only use HANA if I were depending on SAP to set up and maintain the system in perpetuity. If I wanted an in-memory columnar database and was expecting to support it with in-house people, I would look at other options, like Cassandra.
There are new languages to learn and many differences in how to properly architect columnar vs relational.
If you have Teradata in your environments already, you are well on the way to understanding the new NoSQL databases. If you are strictly a relational shop, the new NoSQL databases take some learning and a change in thinking.
Hans Chambers

PeerSpot user
Director of Technology at a tech services company
Consultant
2017-10-31T12:57:06Z
31 October 17

Lavanya,
What is the context for comparison? Are you trying to compare performance in relation to a specific hardware configration? As John pointed out, you are kind of comparing apples and donuts, unless you have a specific use-case that can provide more detail for the comparison. Hana may, in some environments, replace the role a SQL server is holding, particularly if the SQL server is a data bridge, but you need to get way more specific in the ask.

PeerSpot user
Engineered Systems Architect at a financial services firm
Real User
2017-10-31T12:40:15Z
31 October 17

SAP Hana is only to Support SAP , its an appliance for SAP its not an RDBMS like sql server
you can't you it to run your helpdesk app or anly thing .

Related Questions
CA
It Application Analyst at City of Corpus Christi
Jul 25, 2022
I work as an IT Application Analyst at a governmental organization (size: 1000+ employees). Currently, I'm researching Oracle Database and SQL Server. Which product is better and why?
See 1 answer
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
25 July 22
Hi @Ariful Mondal, @Anteneh Asnake, @OmidKoushki, @reviewer1488372 ​and @reviewer1362099, Would you have any recommendations for @Celes Agiriga? Thank for sharing your knowledge with PeerSpot community members!​​ ​ ​ ​
VK
User at Rostan Technologies
Jul 25, 2022
Hi peers, I would like to compare the pricing and costs of the following products:  Oracle Cloud (Oracle Fusion), SAP HANA and MS NAV. Can anyone assist and share this information? Thank you.
See 1 answer
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
25 July 22
Hi @SanilPrakashan, @Peter Haider, @Oleg Krivolapov, @Ali Mirnia, @reviewer1593270, @WilfredThomson, @reviewer1383855 ​and @reviewer1002447, Can you please help answer this @Vikash-Kumar's question by sharing your experience with those products? Thanks for sharing your knowledge with other peers. ​
Related Categories
Download Free Report
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
DOWNLOAD NOW
634,550 professionals have used our research since 2012.