SAP IQ and Teradata are prominent solutions in the data warehousing and business intelligence sector. Teradata appears to have the upper hand due to its scalability, performance, and comprehensive support, catering especially well to organizations with large, complex data needs.
Features: SAP IQ's columnar architecture is designed for optimal storage, high data compression, and fast query performance, making it apt for business intelligence and data warehousing. It is known for fast data loading, easy maintenance, and scalability for large datasets. Teradata offers massive parallel processing with a shared-nothing architecture, providing exceptional scalability and performance with strong workload management and integration capabilities for high-performance analytical tasks.
Room for Improvement: SAP IQ needs to improve in marketing, accessibility to training resources, and integration with other platforms like Hadoop for enhanced big data compatibility. Enhancements in backup solutions and administrative tool user-friendliness are also necessary. Teradata could focus on better cloud adoption, efficient management of unstructured data, and lowering licensing costs. Improved big data handling and more intuitive analytics tools are suggested for maintaining competitive edge and market expansion.
Ease of Deployment and Customer Service: SAP IQ typically deploys on-premises with limited cloud options and mixed reviews regarding customer support, particularly in technical assistance. Teradata supports a broad range of deployment options, including public and hybrid clouds, and receives consistently high ratings for customer service and technical support, with round-the-clock global coverage offering smoother issue resolution and enhanced user satisfaction.
Pricing and ROI: SAP IQ is less costly to implement than many RDBMS alternatives, with licensing designed for organizations of varying sizes, offering savings in hardware and low maintenance costs post-deployment. Teradata, while commanding a higher price due to its robust performance, is exploring more flexible licensing models to remain competitive, delivering substantial ROI through performance, stability, and advanced analytics capabilities.
We have realized a return on investment, with a reduction of staff from 27 to eight, and our current return on investment is approximately 14%.
It seems very difficult to get proper advanced assistance on advanced or complicated problems.
The quality of support from SAP is very good; if it's a known problem, they will have a knowledge base, so we will get immediate assistance.
The customer support for Teradata has been great.
The technical support from Teradata is quite advanced.
Customer support is very good, rated eight out of ten under our essential agreement.
We can span the read and write load into multiple nodes, and that scalability is there.
If we wanted to add more servers into this entire setup, that would be fairly easy, so it's rather good when it comes to scalability.
This expansion can occur without incurring downtime or taking systems offline.
Scalability is complex as you need to purchase a license and coordinate with Teradata for additional disk space and CPU.
Teradata's scalability is great; it's been awesome.
It's usually something external, such as lack of disk space or problems arising from the integration to other systems.
The workload management and software maturity provide a reliable system.
I find the stability to be almost a ten out of ten.
It is easy to deploy SAP IQ; the implementation and installation are easy.
When there is an issue, the error messaging we get is not always sufficient to do a fast and solid fix.
Unlike SQL and Oracle, which have in-built replication capabilities, we don't have similar functionality with Teradata.
The most challenging aspect is finding Teradata resources, so we are focusing on internal training and looking for more Teradata experts.
Initially, it may seem expensive compared to similar cloud databases, however, it offers significant value in performance, stability, and overall output once in use.
Teradata is much more expensive than SQL, which is well-performed and cheaper.
We spent roughly $295,000 on setup costs.
We can get historical data quickly, and you can fetch information very quickly because every column is indexed.
The most valuable feature of SAP IQ for us is that it works very effectively with the SAP BusinessObjects which we use it with.
It has resulted in better performance improvement within our team as we now cover nine business units instead of 18, thanks to the data performance, which has increased data visibility and helped the enterprise achieve a higher rate of internal return on financials.
The data mover is valuable over the last two years as it allows us to achieve data replication to our disaster recovery systems.
| Product | Market Share (%) |
|---|---|
| Teradata | 12.1% |
| SAP IQ | 2.6% |
| Other | 85.3% |
| Company Size | Count |
|---|---|
| Small Business | 7 |
| Midsize Enterprise | 2 |
| Large Enterprise | 15 |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 12 |
| Large Enterprise | 49 |
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 is a powerful tool for handling substantial data volumes with its parallel processing architecture, supporting both cloud and on-premise environments efficiently. It offers impressive capabilities for fast query processing, data integration, and real-time reporting, making it suitable for diverse industrial applications.
Known for its robust parallel processing capabilities, Teradata effectively manages large datasets and provides adaptable deployment across cloud and on-premise setups. It enhances performance and scalability with features like advanced query tuning, workload management, and strong security. Users appreciate its ease of use and automation features which support real-time data reporting. The optimizer and intelligent partitioning help improve query speed and efficiency, while multi-temperature data management optimizes data handling.
What are the key features of Teradata?In the finance, retail, and government sectors, Teradata is employed for data warehousing, business intelligence, and analytical processing. It handles vast datasets for activities like customer behavior modeling and enterprise data integration. Supporting efficient reporting and analytics, Teradata enhances data storage and processing, whether deployed on-premise or on cloud platforms.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
