ClickHouse vs. SAP HANA Cloud

ClickHouse delivers exceptional speed and performance, positioning it as the top choice for managing large-scale analytical workloads. With a bunch of built-in functions, it empowers analysts to extract maximum insights from data effortlessly. If your scenario is to deal with analytical questions, then ClickHouse is for you, but if you are looking into a transactional database, that's not the case; even their table engines are not made for this.

Incentivized

SAP HANA Cloud works effectively with SMBs or small to medium-sized enterprises and requires an affordable, scalable ERP system. Companies that must implement SAP S/4 HANA as soon as possible. Companies looking to take advantage of the newest innovation from SAP are looking to cut expenses on their IT infrastructure. SAP HANA CLOUD is not suitable for 1. Large companies with intricate operational procedures. 2. Companies with stringent policies regarding data residency. 3. Businesses with a sizable SAP landscape on premises 4. Companies must closely integrate SAP HANA CLOUD with non-SAP systems.

• Their MergeTree table engine provide impressive performance for data insert in bulk
• Not only data insert but also the way MergeTree engine uses Primary Keys to sort the data and perform data skipping based on the granules its also their secret for ridiculous fast queries
• Data compression its also great
• They provide especial table engines that allow you to read data directly from other sources like S3
• Since its written with C++ you have very granular data types and especial ones like enum, LowCardinality and etc, they save you a lot of storage since are stored as integer values
• ClickHouse functions besides the ones that respect ANSI Standards are also awesome and useful

Incentivized

• SAP HANA Cloud can help drive data analytics, data migration, and data management exceptionally well.
• It offers an integration service that lets you integrate data and processes with 3rd party app or any other cloud app.
• In-memory capability helps in faster data processing.

Incentivized

• Avro data manipulation
• Kafka consistency
• DDL operations errors (by replica configuration)

Incentivized

• Requires higher processing power, otherwise it won't fly. How ever computing costs are lower. Incase you are migrating to cloud please do not select the highest config available in that series . Upgrading it later against a reserved instance can cost you dearly with a series change
• Lack of clarity on licensing is one major challenge
• Unless S/4 with additional features are enabled mere migration HANA DB is not a rewarding journey. Power is in S/4

Incentivized

At this moment we are not focusing on SAP, however would love to in the future. This is primarily because of our limited ability to generate more revenue to fund for SAP partnerships and products. Our initial tryst with SAP Partneredge open ecosystem didn't go as planned and we have shelved that for now. Hope we can revive in the future

Incentivized

SAP HANA Cloud requires significant expertise on technical side to admin and manage it.It surely is lot of improvement over previous versions of SAPThe modern, role-based SAP Fiori interface has enhanced the user experience for applications like S/4HANA, though the complexity of the underlying database remains. For the average business user, the usability of SAP solutions running on the HANA database has seen a major transformation, largely thanks to the Fiori user interface.

Incentivized

One specific example of how the support for SAP HANA Cloud impacted us is in our efforts to troubleshoot and resolve technical issues. Whenever we encountered an issue or had a question, the support team was quick to respond and provided us with clear and actionable guidance. This helped us avoid downtime and keep our analytics operations running smoothly.

Incentivized

Professional GIS people are some of the most risk-averse there are, and it's difficult to get them to move to HANA in one step. Start with small projects building to 80% use of HANA spatial over time.

Incentivized

ClickHouse was not compared to them as a competitor but as the ideal partner to complete an information analysis system, providing users with the most complete and efficient tools. Therefore, in this case it was considered that it would be the ideal candidate due to its characteristics compared to the other competitors.

Incentivized

It enables preview and better cloud service than other cloud platforms. Easy document transfer and faster document transfer are the key points for the selection of the HANA cloud server. The preview of data before its execution is also one of the factors in the selection of the HANA server.

Incentivized

Limitation of training deliverable by organization

Incentivized

• Queries that used to take more than 2 minutes now take less than 1 second
• Possibility to analyze use cases in real time (before was impossible)
• The applications are more complete and the users decisions are better

Incentivized

• perception that it is "expensive" - this is a messaging issue, not a real issue
• perception that it only runs ERP - SAP is a victim of it's own success in this regard
• perception that it isn't an industrial strength DBMS when, in fact, it is

Incentivized