DB-EnginesextremeDB - Data management wherever you need itEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > InfluxDB vs. Microsoft Azure Synapse Analytics vs. SAP HANA

System Properties Comparison InfluxDB vs. Microsoft Azure Synapse Analytics vs. SAP HANA

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameInfluxDB  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonSAP HANA  Xexclude from comparison
DescriptionDBMS for storing time series, events and metricsElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerIn-memory, column based data store. Available as appliance or cloud service
Primary database modelTime Series DBMSRelational DBMSRelational DBMS
Secondary database modelsSpatial DBMS infowith GEO packageDocument store
Graph DBMS infowith SAP Hana, Enterprise Edition
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score21.47
Rank#28  Overall
#1  Time Series DBMS
Score16.84
Rank#33  Overall
#19  Relational DBMS
Score39.10
Rank#22  Overall
#15  Relational DBMS
Websitewww.influxdata.com/­products/­influxdb-overviewazure.microsoft.com/­services/­synapse-analyticswww.sap.com/­products/­hana.html
Technical documentationdocs.influxdata.com/­influxdbdocs.microsoft.com/­azure/­synapse-analyticshelp.sap.com/­hana
DeveloperMicrosoftSAP
Initial release201320162010
Current release2.7.6, April 20242.0 SPS07 (April 4, 2023), April 2023
License infoCommercial or Open SourceOpen Source infoMIT-License; commercial enterprise version availablecommercialcommercial
Cloud-based only infoOnly available as a cloud servicenoyesno infoalso available as a cloud based service
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageGoC++
Server operating systemsLinux
OS X infothrough Homebrew
hostedAppliance or cloud-service
Data schemeschema-freeyesyes
Typing infopredefined data types such as float or dateNumeric data and Stringsyesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonono
Secondary indexesnoyesyes
SQL infoSupport of SQLSQL-like query languageyesyes
APIs and other access methodsHTTP API
JSON over UDP
ADO.NET
JDBC
ODBC
JDBC
ODBC
Supported programming languages.Net
Clojure
Erlang
Go
Haskell
Java
JavaScript
JavaScript (Node.js)
Lisp
Perl
PHP
Python
R
Ruby
Rust
Scala
C#
Java
PHP
Server-side scripts infoStored proceduresnoTransact SQLSQLScript, R
Triggersnonoyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoin enterprise version onlySharding, horizontal partitioningyes
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factor infoin enterprise version onlyyesyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynono infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes infoDepending on used storage engineyes
User concepts infoAccess controlsimple rights management via user accountsyesyes
More information provided by the system vendor
InfluxDBMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseSAP HANA
Specific characteristicsInfluxData is the creator of InfluxDB , the open source time series database. It...
» more
Competitive advantagesTime to Value InfluxDB is available in all the popular languages and frameworks,...
» more
Typical application scenariosIoT & Sensor Monitoring Developers are witnessing the instrumentation of every available...
» more
Key customersInfluxData has more than 1,900 paying customers, including customers include MuleSoft,...
» more
Market metricsFastest-growing database to drive 27,500 GitHub stars Over 750,000 daily active instances
» more
Licensing and pricing modelsOpen source core with closed source clustering available either on-premise or on...
» more
News

LLM Monitoring and Observability
4 November 2024

System Tables Part 2: How We Made It Faster
31 October 2024

System Tables Part 1: Introduction and Best Practices
29 October 2024

MaaS: How to Store and Analyze Real-Time Stock Trading Data Using Next.js and InfluxDB
25 October 2024

MaaS: How to Monitor Node.js App Performance with PM2 & InfluxDB
23 October 2024

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
InfluxDBMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseSAP HANA
DB-Engines blog posts

Why Build a Time Series Data Platform?
20 July 2017, Paul Dix (guest author)

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

Time Series DBMS as a new trend?
1 June 2015, Paul Andlinger

show all

Recent citations in the news

Simplify Industrial IoT: Use InfluxDB edge replication for centralized time series analytics with Amazon Timestream
3 September 2024, AWS Blog

InfluxData avoids ’AI magic beans’ in InfluxDB time series database update for enterprises
4 September 2024, VentureBeat

InfluxData makes performance, storage improvements to InfluxDB 3.0
4 September 2024, InfoWorld

InfluxData Enhances InfluxDB 3.0 with Performance Upgrades and Self-Managed Option
5 September 2024, Datanami

InfluxData's Latest Updates Optimize Time Series Data for Better Performance, Scale and Management
19 September 2024, Integration Developers

provided by Google News

Azure Synapse Analytics: Transforming Data Management
7 November 2024, Simplilearn

General Available: Azure Synapse Runtime for Apache Spark 3.4 is now GA
8 April 2024, Microsoft

Azure Synapse Runtime for Apache Spark 3.2 End of Support
22 March 2024, Microsoft

Enable location analytics with Azure Maps
17 July 2024, Microsoft

Announcing General Availability of Graph Semantics in Kusto
27 May 2024, Microsoft

provided by Google News

Combine the Power of AI with Business Context Using SAP HANA Cloud Vector Engine
2 April 2024, SAP News

Automating application-consistent Amazon EBS Snapshots for SAP HANA databases
6 February 2024, AWS Blog

DEWA completes migration of SAP Hana Enterprise Cloud to SAP RISE
8 November 2024, Government of Dubai Media Office

SAPwned: SAP AI vulnerabilities expose customers’ cloud environments and private AI artifacts
17 July 2024, Wiz

The best way to modernize your close & consolidation process in an SAP S/4 HANA environment
9 April 2024, Wolters Kluwer

provided by Google News



Share this page

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Present your product here