We performed a comparison between SAP IQ, SQL Server, and Tibero based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"Unbeatable speed and compression with a colummn-structured relational database."
"The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves moving data from SAP HANA to SAP NLS, which is essentially archiving. This allows us to retain access to the data via a link whenever it is required."
"Columnar storage allows high compression, high load rates and high query performance."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"For me, the initial setup is very easy as I have years of experience with the product."
"SQL Server's performance is fine."
"It's a very capable, efficient, price-performant OLAP server."
"The solution is easy to set up."
"The installation is pretty straightforward."
"Backups hardly get corrupt."
"Technical support is very good."
"SQL Server is a highly stable solution."
"The most valuable feature is compatibility with the Oracle database."
"Tibero is a relational database management system, which supports disaster recovery, active cluster, active storage, etc."
"Tibero uses Hyper-Threading architecture, which is incredibly fast."
"Tibero is very easy to setup and maintain."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"Concurrency and functional error messaging."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"I think the universe should be part of the Sybase IQ tool set."
"Better integration with other platforms would be an improvement."
"Sometimes, the tool doesn't support all the native features, and because of this, our company has to customize it to meet our requirements, which is a challenging process for our company's engineers."
"It would be nice if there was a feature to search for a specific value across multiple tables. This would save a lot of time for its users."
"Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions."
"You do need to have technical knowledge in order to install the solution. It's not something a layperson can do."
"They can build more performance-tuning tools in it. They can also make the stuff a little more user-friendly and provide the ability to schedule jobs. They can perhaps also streamline it a little bit so that it is not so resource-intensive, which would be helpful. SQL Server has a tendency to consume all the memory you allow it to. If you are not careful, you can basically break your server. I would like to see it having a smaller footprint in terms of system resource consumption. They might want to consider re-evaluating their pricing. It is expensive."
"SQL Server could improve by providing something similar to an interface or dashboard where a developer can do debugging, this would make a developer's work easier. Additionally, the optimization could be better. If there was an interface showing information needed for the optimization it would help because there can be some data loss making it difficult to optimize the SQL Server."
"The scalability is adequate but could improve."
"The knowledge base is quite small and should be expanded."
"In PL/SQL code, there is a scope of improvement. We expect more PL/SQL packages should be included in the next release."
Earn 20 points