The experience was good. It was really easy to work with, and we had no problems.
Competitor
# Comparisons
Rating
Buyer's Guide
Oracle Database In-Memory vs. SAP HANA
May 2023

Find out what your peers are saying about Oracle Database In-Memory vs. SAP HANA and other solutions. Updated: May 2023.
708,544 professionals have used our research since 2012.
Read reviews of SAP HANA alternatives and competitors
Digital Transformation Architect at Adage AB
Good speed for high volume data but lacks in custom role creation
Pros and Cons
- "We mainly chose Exasol for its performance reasons."
- "The only area where we found it could improve was in custom role creation and security, and it was difficult to work with."
What is our primary use case?
What is most valuable?
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.
What needs improvement?
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.
For how long have I used the solution?
I used Exasol six months ago and tested it for two months. I just used the latest version; it was the community version.
What do I think about the scalability of the solution?
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.
How are customer service and support?
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.
What's my experience with pricing, setup cost, and licensing?
The pricing was reasonable compared to any other cloud platform, and it wasn't that high.
Which other solutions did I evaluate?
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.
What other advice do I have?
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.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Apr 6, 2023
Flag as inappropriateAssociate Consultant at a computer software company with 501-1,000 employees
The best choice for new database management users and smaller data to 60K
Pros and Cons
- "The solution helps us perform with our databases and extract data."
- "Clusters are hard to perform so we use no SQL alternates like MongoDB."
What is our primary use case?
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.
What is most valuable?
The solution helps us perform with our databases and extract data.
The solution is free.
What needs improvement?
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.
For how long have I used the solution?
I have been using the solution for three years.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
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.
How are customer service and support?
I have not needed technical support.
How was the initial setup?
The setup is pretty easy. All resources are available on YouTube so configuration is quite easy.
What about the implementation team?
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.
What's my experience with pricing, setup cost, and licensing?
The solution is open source so is free.
Which other solutions did I evaluate?
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.
What other advice do I have?
If you are new to database management, then the solution will be the best choice.
I rate the solution an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Feb 5, 2023
Flag as inappropriateSr Quality Engineer at Optum
User friendly with great scalability but needs to move toward intelligent AI
Pros and Cons
- "The scalability is very good."
- "The solution should move to the new way of writing software code with AI that is intelligent and learns."
What is our primary use case?
Our company uses the solution to create relational databases. We use both public and private clouds.
What is most valuable?
The solution has a simplicity that makes it very easy to use.
The scalability is very good.
What needs improvement?
The solution should move to the new way of writing software code with AI that is intelligent and learns.
For how long have I used the solution?
I have been using the solution for 15 years.
What do I think about the scalability of the solution?
The solution is very scalable and that is the feature we like most.
I rate scalability a nine out of ten.
How are customer service and support?
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.
How would you rate customer service and support?
Neutral
How was the initial setup?
The setup is pretty straightforward and easy so I rate setup a nine out of ten.
What about the implementation team?
We implemented the solution in-house and it did not take long to deploy.
What's my experience with pricing, setup cost, and licensing?
The pricing is pretty good so I rate it an eight out of ten.
What other advice do I have?
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.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Other
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Last updated: Dec 28, 2022
Flag as inappropriateCEO at a tech services company with 51-200 employees
High data compression available, scalable, and customer service responsive
Pros and Cons
- "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."
What is our primary use case?
The solution is used for database management.
What is most valuable?
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.
What needs improvement?
The capabilities of this solution could improve.
For how long have I used the solution?
I have been using this solution for many years.
What do I think about the stability of the solution?
In my experience, it has been stable.
What do I think about the scalability of the solution?
The scalability is good. We have some clients that have over 9,000 users using this solution.
How are customer service and technical support?
The technical support has been very friendly, responsive, and it is quick to escalate an issue.
Which solution did I use previously and why did I switch?
I have used previously Cisco MySQL, SQL Server, SAP HANNA, and IBM DB2.
What about the implementation team?
We have approximately 14 technicians doing the deployment and maintenance of this solution.
What's my experience with pricing, setup cost, and licensing?
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.
What other advice do I have?
I would recommend this solution to others.
I rate IBM Db2 Database an eight out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
IT manager at a wholesaler/distributor with 10,001+ employees
Scalable, reliable, and good technical support
Pros and Cons
- "The performance of the SQL Server is very good."
What is our primary use case?
We use SQL Server as a database solution.
What is most valuable?
The performance of the SQL Server is very good.
For how long have I used the solution?
I have been using SQL Server for a few years.
What do I think about the stability of the solution?
The stability is very good.
What do I think about the scalability of the solution?
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.
How are customer service and support?
The support offered by Microsoft is very good. We have not faced any issues with SQL Server to need to contact their support.
Which solution did I use previously and why did I switch?
We use SAP HANA as a database solution for certain use cases.
What about the implementation team?
We have technical managers and engineers that do the maintenance and support for this solution.
What's my experience with pricing, setup cost, and licensing?
We are on an annual enterprise license for the solution and the cost of the license could be reduced.
What other advice do I have?
I rate SQL Server an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Oracle Database In-Memory vs. SAP HANA
May 2023

Find out what your peers are saying about Oracle Database In-Memory vs. SAP HANA and other solutions. Updated: May 2023.
708,544 professionals have used our research since 2012.