We compared Teradata and MySQL based on our user's reviews in several parameters.
Teradata stands out for its powerful analytics, scalability, and security features, while users appreciate its thorough customer support. On the other hand, MySQL is praised for its efficiency in managing data, user-friendly interface, and strong performance. While both have positive ROI, Teradata requires improvements in speed and user interface, while MySQL needs enhancements in performance optimization and documentation.
Features: Teradata's valuable features include powerful analytics, scalability, efficient data management, reliable performance, robust security, easy integration, user-friendly interface, and extensive support. MySQL, on the other hand, boasts efficient data handling, strong performance, compatibility, ease of use, flexibility, and robust security measures.
Pricing and ROI: The setup cost for Teradata is mentioned to be minimal, allowing for a smooth implementation process. On the other hand, MySQL is praised for its affordable setup cost. Both products offer flexible pricing and licensing options to cater to different business needs., Teradata's ROI is significant, with users benefiting from improved data management and informed decision-making. MySQL also has a positive ROI, praised for its reliability, cost-effectiveness, scalability, and community support.
Room for Improvement: Teradata product has room for improvement in areas such as performance, user interface, workflow, and support resources. In comparison, MySQL needs enhancements in performance, documentation, support, scalability, compatibility, and security features.
Deployment and customer support: User reviews for Teradata indicate varying experiences and time requirements for the deployment, setup, or implementation phases. In contrast, with MySQL, some users reported several months for deployment and an additional week for setup, while others mentioned both processes taking only a week in total., Teradata's customer service focuses on addressing needs and resolving issues, while MySQL's support team is praised for their prompt, helpful, and knowledgeable assistance, offering efficient solutions with clear and effective communication.
The summary above is based on 45 interviews we conducted recently with Teradata and MySQL users. To access the review's full transcripts, download our report.
"The solution has been very easy to scale so far."
"I rate the solution's stability a ten out of ten since it has been running flawlessly."
"The solution is great for small applications in particular."
"The solution helps us perform with our databases and extract data."
"Apart from the features that are in the enterprise part, we find the database to be valuable. The connectors and the backup features are valuable as well. We use the basic database. We don't really use the extra features. Our clients like the security features in the database."
"Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run."
"The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
"The main advantage is the very large user base. This enables users to fix about any issue by answering any question."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"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."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"Designing the database is easy."
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"The most valuable feature of Teradata is the quick processing of large data."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"The auto-tuning and NDB cluster has some limitations regarding foreign keys."
"If it had something similar to Microsoft’s DTS engine then it would be the best database system out there."
"In terms of what I'd like to see in the next release, one thing that's always missing is dash boarding. There's no real BI tool for MySQL, like there is in Yellowfin and all the different tools that you get. They all have MySQL connectors, but there's no specific BI tool for MySQL. These open source projects have sprung up, but they're more general purpose."
"Integration is a key feature in need of improvement."
"The solution could improve by having better performance and security."
"We have encountered some performance issues, and the solution takes time for performing complex queries."
"There are some issues with compatibility with Java environments that need to be improved. When Oracle bought this solution there were some driver changes that caused some issues with operations."
"When I run into issues, I really have to research how to fix them."
"I would like to see an improved Knowledge Base on the web."
"Teradata is a bit late for the cloud."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"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."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"Teradata hardly supports unstructured data or semi-structured data"
"The cloud is the new challenge and the new opportunity."
MySQL is ranked 4th in Relational Databases Tools with 142 reviews while Teradata is ranked 7th in Relational Databases Tools with 54 reviews. MySQL is rated 8.2, while Teradata is rated 8.2. The top reviewer of MySQL writes "Good beginner base but it should have better support for backups". On the other hand, the top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, SAP HANA and SQL Server, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, BigQuery and IBM Db2 Database. See our MySQL vs. Teradata report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.