We performed a comparison between SAP IQ, Teradata, and Teradata Cloud Data Warehouse based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"The initial setup is easy."
"Columnar storage allows high compression, high load rates and high query performance."
"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 product is easy to learn."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"Cuts time to process huge amounts of data with efficient analytical queries."
"It is a solid database a lot of different tools to move data."
"The product is reliable."
"The most valuable feature is the ease of running queries."
"The cloud is ten times better than physical hardware; it is more cost-effective and the upgrade process is ten times easier."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"There is very little documentation available."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"Concurrency and functional error messaging."
"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 tool gets stuck sometimes."
"I think the universe should be part of the Sybase IQ tool set."
"The setup is not straightforward."
"I would like to see more integration with many different types of data."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
"Teradata is an expensive tool. Like, if you're already using Microsoft products like Windows, they'll market all their products together. And with the rise of cloud technologies, companies will adopt solutions that offer them some privileges or facilities. Similar to how SAP does it in the market, so do Microsoft and other companies. Even Oracle and other such tools are quite commonly seen compared to Teradata's competitors in everyday solutions."
"Teradata's UI could be more user-friendly."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"The following could be better: licensing, architecture openness, integration with other tools."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"The cost of Teradata Cloud Data Warehouse has room for improvement."
"Stability-wise, we have had some issues with automation and the ability to handle large datasets."
"It could be a bit more user-friendly."
More Teradata Cloud Data Warehouse Pricing and Cost Advice →