We performed a comparison between SAP IQ, SQL Server, and Teradata based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."Unbeatable speed and compression with a colummn-structured relational database."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"Columnar storage allows high compression, high load rates and high query performance."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"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."
"The solution is valuable because it seamlessly extracts reports and enables the collection of information from different tables."
"The solution is user-friendly, is a robust tool and is always reliable to users."
"The most valuable features are programmability and reliability."
"It integrates well with other platforms."
"It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale. PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades. Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching."
"A big advantage is the ability to store any type of data in SQL Server."
"It helps with moving the design of the database into reality."
"As a data warehouse and storage solution, it's quite good."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"Viewpoint, the detailed query logs and performance statistics are valuable features."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"The initial setup was straightforward."
"Designing the database is easy."
"Cuts time to process huge amounts of data with efficient analytical queries."
"Teradata's most valuable feature is that it's easy to use."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"Concurrency and functional error messaging."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"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."
"I think the universe should be part of the Sybase IQ tool set."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"Scalability is an area that needs improvement, and the deployment is difficult, which why I'm looking for an appliance to deploy it in a much more scalable way."
"SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable."
"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."
"The reporting services of the solution (SSRS and now Power BI) are the less valuable items of the SQL Server suite."
"We have no vision. We don't know when or how we have been hacked."
"With so much data, things can get slow, which is why I would like to be able to understand how to better optimize queries."
"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."
"I would like to see more integration with other platforms."
"Limited interest and success in some areas make us hesitate about upgrading."
"Teradata can improve the way it handles big data and unstructured data."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"I would like to see an improved Knowledge Base on the web."
"The following could be better: licensing, architecture openness, integration with other tools."
"The increasing volumes of data demand more and more performance."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."