We performed a comparison between SAP IQ, Teradata, and Teradata IntelliFlex based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."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."
"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."
"Unbeatable speed and compression with a colummn-structured relational database."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"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."
"It's very mature from a technology perspective."
"The initial setup was straightforward."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"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."
"The most valuable features of Teradata are that it is a massively parallel platform and I can receive a lot of data and get the queries out correctly, especially if it's been appropriately designed. The native features make it very suitable for multiple large data tasks in a structured data environment. Additionally, the automation is very good."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"The solution's banking model, called FSLDM (Financial Services Logical Data Model), is sophisticated and good."
"It is very stable. It's 100% uptime. Speed and resilience are one of the greatest features of this product. In almost twenty years we've never had downtime, except for outages for patches and upgrades. We've never had a system failure in twenty years."
"IntelliFlex is easy to scale - one of its best features is that you can upscale it to the size you want."
"The product's scalability is great. Scalability-wise, I rate the solution a ten out of ten."
"Intelliflex is very scalable. In fact, scalability has improved 100 times by Intelliflex, in my personal opinion."
"I think the universe should be part of the Sybase IQ tool set."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"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."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"Teradata's UI could be more user-friendly."
"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."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"Teradata hardly supports unstructured data or semi-structured data"
"The setup is not straightforward."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
"The initial setup is complex because there are a lot of factors that come into play, including the amount of software and applications that require access."
"The reporting side wasn't very good in the past, but with the latest versions, it's getting better. Still, the friendliness of the PDC reporting and functionality needs to be improved."
"The solution’s pricing, scalability, and technical support response time could be improved."
"They should add more connectors to different platforms."
"The only issue our company has with Teradata IntelliFlex is that it is not cost-effective because of the way the product has been designed."