SAP HANA alternatives and competitors

The experience was good. It was really easy to work with, and we had no problems.

The speed was good with the high volume of data. We mainly chose Exasol for its performance reasons, and it was better compared to SAP Hana. However, we decided to go with Snowflake instead of Exasol because the performance was almost equal, but working with the roles was more flexible.

The only area where we found it could improve was in custom role creation and security, and it was difficult to work with.

There were some workarounds to handle situations like row-level security. Still, it was not a standard feature or a configurable role that you could set up for your requirements in Exasol. So, we compared it to existing tools like Synapse SQL and found that it was better supported in handling TB.

I used Exasol six months ago and tested it for two months. I just used the latest version; it was the community version.

It is a scalable solution. The assessment was done among four or five. We didn't scale it.

The idea was to use and test successfully and to check the performance, and we did it successfully. But we did not use it because of this challenge of implementation of security and rules. We didn't go beyond that. We didn't put it into production mode. We didn't even do any development in this. We only used it for the test purpose, for POC, for about two months, and that's it. Then we closed it.

We have been in touch with sales and the tech team for Exasol, and that's how we could make it work in Exasol for those roles. But, of course, every product has its own development cycle, and the requirement that we had at that time was in the roadmap of Exasol. I'm sure they will get it in the future, but it wasn't present at the moment, about a year ago.

The pricing was reasonable compared to any other cloud platform, and it wasn't that high.

We mainly chose Exasol for its performance reasons, and it was better compared to SAP Hana. However, we chose Snowflake instead of Exasol because the performance was almost equal, but working with the roles was more flexible.

Therefore, it was just a collective agreement to choose Snowflake.

Overall, I would rate the solution a seven out of ten because of the role creation security issues.

The areas that I explored, like the creation of the tables and the speed, were pretty good, and I may not have discovered or used all the features, so I may not be able to give my rating based on all the features. It is based on what I have used and what I've experienced. There might be more features of Exasol that I have not discovered, but I would not comment on that.

Our company uses the solution to extract data from databases. We perform the create, read, write, and operations in databases.  

The number of users depends on the project. If there is a demand, then people good with SQL will jump in on projects. 

The solution helps us perform with our databases and extract data. 

The solution is free. 

Clusters are hard to perform so we use no SQL alternates like MongoDB. 

The solution should manage large data sets better because data that is around one lakh or two lakh fails to load. In these cases, we use no SQL structures like MongoDB. 

I have been using the solution for three years. 

The solution is stable. 

The solution is decently, but not largely scalable. It works very well and is comfortable with 50K or 60K of data. If you have large-scale data, then the solution is slower and has some errors. 

I have not needed technical support. 

The setup is pretty easy. All resources are available on YouTube so configuration is quite easy. 

We implemented the solution in-house and setup was pretty fast. You just set up the application, create queries, and connect with the front end or whatever you are trying to do. 

If you are handling large data, then it is a good idea to maintain the solution weekly because it will be better. 

The solution is open source so is free. 

The solution is good for smaller data or new users. If you are maintaining large data and want to build a fully-furnished application, then you have to use something else like PostgreSQL. 

If you are new to database management, then the solution will be the best choice. 

I rate the solution an eight out of ten. 

Our company uses the solution to create relational databases. We use both public and private clouds. 

The solution has a simplicity that makes it very easy to use. 

The scalability is very good. 

The solution should move to the new way of writing software code with AI that is intelligent and learns. 

I have been using the solution for 15 years. 

The solution is very scalable and that is the feature we like most. 

I rate scalability a nine out of ten. 

The technical support could be improved. I don't recall specifics, but know that I expect more from them. 

Sometimes, support doesn't understand the environment of a business so they give irrelevant solutions. That is the biggest problem with support. 

I rate support a seven out of ten. 

Neutral

The setup is pretty straightforward and easy so I rate setup a nine out of ten. 

We implemented the solution in-house and it did not take long to deploy. 

The pricing is pretty good so I rate it an eight out of ten. 

Before choosing the solution, evaluate the on-premises, public, and private cloud environments. Speak with a representative about what environment best meets your needs.

In the public cloud arena, Azure and AWS also offer good products that compete with the solution.

I rate the solution a seven because there are better public cloud options. 

The solution is used for database management.

The solution has very good data compression of up to 50%. For example, if you have 50 terabytes of data, it can be reduced to 25 terabytes.

The capabilities of this solution could improve.

I have been using this solution for many years.

In my experience, it has been stable.

The scalability is good. We have some clients that have over 9,000 users using this solution.

The technical support has been very friendly, responsive, and it is quick to escalate an issue.

I have used previously Cisco MySQL, SQL Server, SAP HANNA, and IBM DB2.

We have approximately 14 technicians doing the deployment and maintenance of this solution.

We normally handle large size businesses and as far as I am aware, the license is negotiable based on the number of users and the quantitative data.

I would recommend this solution to others.

I rate IBM Db2 Database an eight out of ten.

We use SQL Server as a database solution.

The performance of the SQL Server is very good.

I have been using SQL Server for a few years.

The stability is very good.

The solution is scalable. However, we do not have many large servers using SQL Server anymore, we have moved to SAP HANA.

We have approximately 2,000 users using this solution in my organization.

The support offered by Microsoft is very good. We have not faced any issues with SQL Server to need to contact their support.

We use SAP HANA as a database solution for certain use cases.

We have technical managers and engineers that do the maintenance and support for this solution.

We are on an annual enterprise license for the solution and the cost of the license could be reduced.

I rate SQL Server an eight out of ten.