We performed a comparison between SAP SQL Anywhere, SQL Server, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."We've found the solution very reliable overall. It's very fast."
"It works well in general."
"The most valuable features of SAP SQL Anywhere are the ease of use and the user interface is intuitive."
"The auto-backup replication is a perfect feature. That is the feature I liked the most."
"SAP SQL Anywhere is very helpful."
"It is a simple query language. It is consistent across all versions. If you start with an older version, move to the newer version. The same code will still work."
"The solution seems to be pretty flexible."
"The product has been on the market for over 25 or 30 years. It's an extremely mature solution."
"It's great that the database engine is always on."
"Technical support is very good."
"SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational."
"The most valuable feature of SQL Server is that it is easy to set up."
"There is a lot of information about the solution readily available online."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"The most valuable feature is Vertica's performance and the ease of using the database."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"Its projections and encoding are excellent tools for tuning large volumes."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"We have had some stability issues with SAP SQL Anywhere, but I am not sure if it is an application or network issue. We sometimes have a large amount of data being queried and it cannot handle it."
"A problem we are experiencing now is when doing a backup in SQL 2012 and 14."
"It is not as secure as it could be."
"SAP SQL Anywhere needs to incorporate functionalities like SAP S/4HANA."
"The interface is not easy in comparison to the SQL Server. It could be more user-friendly."
"It would be great if we were able to run it on multiple operating systems and not only stick with Windows."
"There is room for improvement in terms of pricing for SQL Server."
"When we are talking about event space architecture, scalability generally comes into play. For example, I might have a hundred thousand transactions a second, and then all of a sudden, I build something that everybody in the world wants. The next thing I know is that I have a million transactions a second. So, to be able to process the throughput, I'd have to scale up, and then when the holidays are over, I'm again down to a hundred thousand transactions, and I want to scale back down. SQL Server is not going to do that. In this way, it is not very scalable. One of the reasons why they want us to use Kafka is so that if we need to, we can do that, but our base program is on SQL Server. So, this is where we would use a Kafka event stack so that if I need more servers, I can just write a command, and I can have more consumers, more brokers, and more producers, and when the holiday season is over, it scales right back down again. SQL Server is not going to do that."
"The remote access aspect needs to be improved in terms of security."
"Primarily, the data replication and the backup areas can be improved. It should have data replication capabilities and uptime capabilities."
"The price could be better. In the next release, it would be better if the database was more easily extendable."
"I would say that people should know how to get a SQL setup in place since it might be an area where they lack when it comes to the solution."
"I would like Microsoft to evolve SQL Server because stateful databases dying are in a way. We would like to find out if it can absorb Hadoop and other similar things. They should make it useful for data mining. Data is evolving forever, and how we store it is also changing constantly. So, SQL Server also needs to change."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"The integration with AI has room for improvement."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"Suboptimal projection design causes queries to not scale linearly."