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."It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"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."
"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."
"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."
"We have found the feature that allows us to publish web applications to be valuable."
"This solution has proven stability and operational power."
"Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better."
"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 SQL Server is low maintenance, it does not require advanced technical skills to maintain or use it as you might in other similar database solutions. You need some knowledge on how to access the solution and how to query it but it is fairly straightforward."
"The solution can be deployed in a few minutes."
"SQL Server's Management Studio is very user friendly. I like their database and the additional features it offers. It's also easy to integrate SQL Server with things like CLR, PowerShell, and command shell"
"I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"Improved performance of ETL procedures, reporting."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"The feature that we find most valuable is its ability to perform Massive Parallel Processing."
"Concurrency and functional error messaging."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"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 organization who owns the product does not support it well and appears not to be doing significant development for the future."
"I think the universe should be part of the Sybase IQ tool set."
"Sometimes the system hangs. Its databases should be able to deal with more data in a faster way. Its speed of processing larger amounts of information should be improved."
"There is a lot of room for improvement when it comes to limited compatibility across the platform and restricted performance with massive data sets."
"I would like to see SQL Server add the ability to write to multiple sites or support replication between multiple sites at the transaction level."
"Right now we don't get much technical support from Microsoft"
"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."
"They have too many licensing options. They may want to simplify its licensing and bring it down to two, three, or four categories from ten to fifteen categories. Having so many different licensing options makes it difficult to decide which one to choose from. They can club things together. This is an area where they can make things easier for customers."
"It is very costly, and that's the reason people are moving away from SQL Server."
"Better integration with other platforms would be an improvement."
"Teradata hardly supports unstructured data or semi-structured data"
"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."
"The setup is not straightforward."
"There is some improvement required on OLTP level and some analytical function is missing."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"GUI of administrative tools is really outdated."
"I would like to see an improved Knowledge Base on the web."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."