Oracle Exadata vs SAP IQ vs Teradata IntelliFlex comparison

Cancel
You must select at least 2 products to compare!
Oracle Logo
8,616 views|6,363 comparisons
89% willing to recommend
SAP Logo
567 views|442 comparisons
83% willing to recommend
Teradata Logo
484 views|296 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

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.
To learn more, read our detailed Data Warehouse Report (Updated: April 2024).
771,157 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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."

More Oracle Exadata Pros →

"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."

More SAP IQ Pros →

"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."

More Teradata IntelliFlex Pros →

Cons
"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."

More Oracle Exadata Cons →

"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."

More SAP IQ Cons →

"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."

More Teradata IntelliFlex Cons →

Pricing and Cost Advice
  • "In the sizing phase, you can also decide whether to license all cores, or reduce the number cores using capacity-on-demand features of Exadata, as well. This has a direct impact on licensing."
  • "The Initial investment price could use improvement"
  • "I think it's free."
  • "The price is very high."
  • "Exadata is an expensive tool, but, considering the ROI, it's worth going for the solution."
  • "Oracle is always costly but it's fine."
  • "It is an expensive product and you pay more for certain performance enhancements."
  • "All things considered, the price of this product is fairly high, as is always the case with Oracle."
  • More Oracle Exadata Pricing and Cost Advice →

  • "Evaluate all options; check to see if you need expensive add-ons."
  • "Negotiate based on the features required."
  • "Negotiation is very important."
  • "The only costs after standard licensing fees are for add-ons and upgrades."
  • "It's not that costly. So, the pricing is cheap."
  • More SAP IQ Pricing and Cost Advice →

  • "Users have to pay a yearly licensing fee for Teradata IntelliFlex, which is very expensive."
  • More Teradata IntelliFlex Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    771,157 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:It is the best solution for OLTP and data warehousing.
    Top Answer:The solution’s cost is a little bit more than the traditional databases. Less cost would enable most customers to choose… more »
    Top Answer:Patching must be simplified. We have various levels of patching in the solution. Most of them are online, split into… more »
    Top Answer:The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited… more »
    Top Answer:The solution’s pricing is high, but coverage is good with high implementation with customer requirements.
    Top Answer:The product should add more business intelligence factors.
    Top Answer:The solution's banking model, called FSLDM (Financial Services Logical Data Model), is sophisticated and good.
    Top Answer:The solution’s pricing, scalability, and technical support response time could be improved.
    Top Answer:We use Teradata IntelliFlex for data warehousing, which is a way of presenting data for faster retrieval.
    Ranking
    2nd
    out of 35 in Data Warehouse
    Views
    8,616
    Comparisons
    6,363
    Reviews
    21
    Average Words per Review
    494
    Rating
    8.7
    16th
    out of 35 in Data Warehouse
    Views
    567
    Comparisons
    442
    Reviews
    1
    Average Words per Review
    559
    Rating
    7.0
    11th
    out of 35 in Data Warehouse
    Views
    484
    Comparisons
    296
    Reviews
    3
    Average Words per Review
    606
    Rating
    8.3
    Comparisons
    Also Known As
    Sybase IQ
    Learn More
    Overview

    Oracle Exadata allows enterprises to run any Oracle Database workload with the highest performance, scale, availability, and security on fully compatible cloud and on-premises infrastructure. Exadata uses a scale-out design with unique optimizations that include persistent memory, SQL query offload, and built-in resource management to optimize performance for OLTP, analytics, machine learning, and mixed workloads running in consolidated environments. By running hundreds or thousands of optimized Autonomous Database and Exadata Database instances on Exadata Cloud or Cloud@Customer infrastructure, customers are able to minimize their infrastructure, reduce management, improve developer productivity, and lower total costs by up to 40%, as described in Wikibon’s analysis (PDF).

    The main benefit of Exadata is its speed. It hosts operating systems, CPU memory, and hard drives. It runs all types of databases, including online transaction systems, processors, and data warehouses, while remedying the poor performances of older databases.

    Oracle Exadata features a simple and fast database storage system that protects and backs up your critical data. It accelerates data warehouse performance for faster access to business information and data. It is the ideal database solution for companies looking to build up their infrastructure from scratch.

    Oracle Exadata Database Machine Key Benefits

    • Rapid, reliable, and scalable deployment: Exadata is the most cost-efficient and highest performance platform for running Oracle databases. Exadata’s deployment is very straightforward since the database servers, storage servers, and network are pre-configured, pre-tuned and pre-tested by Oracle experts. This ensures that all your components work seamlessly together. Any Oracle Database application can be seamlessly migrated to and from the Exadata Database Machine, with no changes to the original application.

    • Powerful, cutting-edge hardware: Exadata is the most versatile database platform. It uses powerful database servers and a scaled-out, intelligent storage layer.

    • Accelerate database processing: Exadata Storage Server implements a unique, highly efficient database-optimized storage infrastructure that enables Exadata’s unparalleled performance without any of the bottlenecks that traditional storage experiences. Each storage server contains CPU processors that are used to offload database processing. The CPUs in the storage servers do not replace database CPUs, but work alongside them to accelerate database workloads.

    Reviews from Real Users

    Oracle Exadata stands out among its competitors for a number of reasons. Two major ones are its robust performance and its wide variety of database features that make it a comprehensive database solution.

    Adriano S., an IT system integrator at a financial services firm, writes, "Oracle Exadata's performance is one of its best features. We are very satisfied with it. The previous equipment used to make a payment for all the government employees used to take at least two days for some of the transactions. Now, it will take hours to make the same amount of payments. Another thing is the flexibility to organize all our databases. We can use it with new features that come with this version of Oracle 19c, which is the container database. With container databases, we can work with many databases, organized, and segregated, and still access the functions and management, the things that most of the technical people like to have in place."

    Paulo X., a sales manager at LTA-RH Informatica, notes, "Regarding features, there are so many that we can offer to customers. When we sell Exadata Cloud, there are many options to choose from, especially when it comes to enterprise database options. In my experience, the main features that are appreciated are various ones like GPS and the assortment of security options."

    SAP® IQ software delivers speed and power for extreme-scale enterprise data warehousing and analytics. Its column-oriented, grid-based massively parallel processing (MPP) architecture and patented data compression and indexing technologies enable companies to exploit the value of huge amounts of data at the speed of business.

    Teradata IntelliFlex delivers real-time intelligence to place vital data into the hands of front-line decision makers, while extending traditional data warehouse functionality into the realm of tactical decision making. With IntelliFlex, you can combine both these strategic and operational workloads in a single data warehouse.

    Sample Customers
    PayPal, EBS, Organic Food Retailer, Garmin, University of Minnesota, Major Semiconductor Company, Deutsche Bank, Starwood, Ziraat Bank, SK Telecom, and P&G.
    ASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.
    Information Not Available
    Top Industries
    REVIEWERS
    Financial Services Firm24%
    Comms Service Provider17%
    Insurance Company16%
    Computer Software Company8%
    VISITORS READING REVIEWS
    Financial Services Firm28%
    Computer Software Company13%
    Manufacturing Company6%
    Energy/Utilities Company5%
    REVIEWERS
    Financial Services Firm55%
    Healthcare Company9%
    Insurance Company9%
    Manufacturing Company9%
    VISITORS READING REVIEWS
    Financial Services Firm39%
    Computer Software Company10%
    Manufacturing Company7%
    Government5%
    VISITORS READING REVIEWS
    Financial Services Firm28%
    Computer Software Company16%
    Manufacturing Company9%
    Retailer8%
    Company Size
    REVIEWERS
    Small Business30%
    Midsize Enterprise9%
    Large Enterprise61%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    REVIEWERS
    Small Business20%
    Midsize Enterprise10%
    Large Enterprise70%
    VISITORS READING REVIEWS
    Small Business11%
    Midsize Enterprise8%
    Large Enterprise81%
    VISITORS READING REVIEWS
    Small Business11%
    Midsize Enterprise6%
    Large Enterprise83%
    Buyer's Guide
    Data Warehouse
    April 2024
    Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: April 2024.
    771,157 professionals have used our research since 2012.