We performed a comparison between SAP IQ, SQL Server, and Teradata based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"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."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"Unbeatable speed and compression with a colummn-structured relational database."
"Columnar storage allows high compression, high load rates and high query performance."
"It will do clustering, so you can have two database servers looking at the same data simultaneously."
"The technical support that Microsoft provides is great."
"There was an online system in which we had about 2500 requests to the DB per second. Every request had a completion window of one second to process and retrieve data. After switching to SQL Server, and AlwaysOn, and Snapshot, and tinkering, and configuring and tinkering, the handling capacity we measured increased to about 5000 requests per second, while the time decreased to 0.5 seconds per request."
"I have found the most valuable features to be the flexibility and the vast amount of features available."
"It's a very capable, efficient, price-performant OLAP server."
"From a security perspective, we have no complaints."
"The solution is easy to use, has rich feature sets, and is business-oriented."
"Its security is good. The GUI of SQL Server is also very good."
"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."
"I've never had any issues with scalability."
"Cuts time to process huge amounts of data with efficient analytical queries."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"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 effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"Concurrency and functional error messaging."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"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 universe should be part of the Sybase IQ tool set."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"I would like to see more integration with other platforms."
"The licensing costs are very high."
"The solution needs to be more secure. It's lacking, compared to, for example, Oracle."
"In my experience, I've found that scalability can be improved."
"The performance could improve."
"It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting."
"As a software developer, it can be hard to do something in Oracle that is SQL Server specific, and vice-versa, sometimes."
"Only one CPU core can be used. Can’t move a database between servers easily. Can’t use triggers."
"Teradata's UI could be more user-friendly."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."
"It could use some more advanced analytics relating to structured and semi-structured data."
"Teradata's UI could be improved."
"It needs a teaching web site with more training on third-party tools used for BI."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"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."