We performed a comparison between Oracle Exadata, SAP IQ, 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 performance of the data is the most important part."
"The most valuable feature of Oracle Exadata is the smart scan. We have large TB sessions of approximately 100 per second for each of our three instances. The smart scan allows us the obtain data in time in the enterprise manager."
"Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement."
"The data replication is very good."
"Oracle is easy to use for peripheral things, such as the data vault and the data firewall, data sync, and partitions. These are the features that give an edge to other databases."
"They just have a lot of products, and they work well together."
"A very stable solution, which we have hardly any problems with."
"This product can noticeably enhance performance of contextual Oracle databases."
"The initial setup is easy."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"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."
"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."
"The product is easy to learn."
"Columnar storage allows high compression, high load rates and high query performance."
"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."
"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."
"IntelliFlex is easy to scale - one of its best features is that you can upscale it to the size you want."
"Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly."
"It's too expensive per terabyte. It's complex."
"There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements."
"The solution lacks a visualized console."
"The management monitoring tools are quite important and an area that needs some improvement."
"It would be nice to have a single click button to, say, migrate my VMware VM into the Oracle VM, or vice-versa."
"Since the product is an appliance, it is very costly."
"Oracle Exadata could improve the monitoring system in the enterprise manager, it could be more user-friendly. In most Oracle tools there is a lot of functionality, and sometimes you need to do five or six clicks to find metrics, and sometimes it's a waste of time."
"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."
"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."
"I think the universe should be part of the Sybase IQ tool set."
"There is very little documentation available."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"Concurrency and functional error messaging."
"They should add more connectors to different platforms."
"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."
"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."