We performed a comparison between IBM Db2 Database, 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."Scales well enough for a relational database."
"Db2 database scalability and performance capabilities match our database needs. It covers pretty much everything a database administrator or engineer might need."
"We are dealing with millions of transactions a month and the performance is very good."
"The most valuable feature of the IBM Db2 Database is the ease of use, and the ability to do query writing of any SQL statement and have an output."
"The most valuable feature of IBM Db2 Database is its ability to perform automatic self-management, reducing the need for manual tasks such as managing logs and folders."
"The most valuable features are the simplicity of the database and the access to Db2 and Db2 information."
"It's very secure."
"The most valuable feature of this solution is the integration with other IBM products."
"What I like most is the management, as it is very easy compared with other products."
"Backups hardly get corrupt."
"The performance is great."
"SQL Server's performance is fine."
"One of the most valuable features of SQL Server is that it's easy to use."
"It's a flexible solution."
"The solution can be deployed in a few minutes."
"The performance is reliable."
"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."
"Viewpoint, the detailed query logs and performance statistics are valuable features."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"The flexibility in design is very good."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"The solution scales well on the cloud."
"The price should be lower."
"The queries can be difficult for beginners because there are so many. I would like to see more use cases for flow analysis that enable us to correlate the flow with events. Adding this feature in a QI format would be good for beginners."
"IBM's products tend to be quite costly, especially given the availability of free, open-source alternatives."
"There could be more user-friendly tools with features such as drag-and-drop functionality, visual basics, and low-code capabilities."
"They should simplify the management of Db2 as a relational database system. There should be the simplification of management. This is probably one of the most important asks for being successful in the future."
"The product’s user interface is not easy to use."
"There are some issues with Db2's database file system not being readable. The storage could also be increased, and the monitoring could be improved."
"The only drawback that we see in Db2 Database is the crash recovery. When there is a crash and somebody has to do the recovery, Db2 Database first stops, and then it does any crash recovery. In Oracle Database, crash recovery happens within the database. The database is not shut down."
"Sometimes we experience issues with its stability."
"The configuration process can be a little complex."
"Could have additional security."
"SQL Server could improve the integration with nonrational database solutions, such as MongoDB."
"For a big amount of data, when we are speaking about IoT Segments, and Big Data projects, there are performance issues."
"We have no vision. We don't know when or how we have been hacked."
"Scalability of the database could be improved if it could handle increased volumes of data."
"I would like to see SQL Server add the ability to write to multiple sites or support replication between multiple sites at the transaction level."
"Since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time. What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good."
"The increasing volumes of data demand more and more performance."
"Limited interest and success in some areas make us hesitate about upgrading."
"Teradata's UI could be improved."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"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."