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."The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"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."
"Cuts time to process huge amounts of data with efficient analytical queries."
"Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"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."
"It's very, very fast"
"It's a pre-configured appliance that requires very little in terms of setting-up."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"The solution's banking model, called FSLDM (Financial Services Logical Data Model), is sophisticated and good."
"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."
"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."
"Concurrency and functional error messaging."
"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 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."
"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."
"Data synchronization to the DR site."
"The user interface needs to be improved."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"Teradata could improve by being less complicated. There are some aspects that are not available on the Unix server and a Unix system is required to access some data, such as in case of an emergency."
"It needs a teaching web site with more training on third-party tools used for BI."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"Teradata's UI could be improved."
"They should add more connectors to different platforms."
"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 only issue our company has with Teradata IntelliFlex is that it is not cost-effective because of the way the product has been designed."
"The solution’s pricing, scalability, and technical support response time could be improved."