Apr 13, 2014
I think hands down it's Exadata since for the front end apps it's just another Oracle database which means everything under the sun is compatible with it.
Microsoft Parallel Data Warehouse and Teradata offer comprehensive data warehousing solutions. Teradata is favored for its advanced features and performance, despite being more expensive, while Microsoft Parallel Data Warehouse is valued for its competitive pricing and strong support.
Features: Microsoft Parallel Data Warehouse is known for its scalability, seamless integration with Microsoft products, and robustness. Teradata is recognized for advanced analytics capabilities, flexibility in handling diverse data types, and suitability for complex analytical tasks.
Room for Improvement: Microsoft could improve its speed, expand analytical features, and enhance user interface intuitiveness. Teradata users highlight learning complexity, the need for system simplification, and a streamlined onboarding process.
Ease of Deployment and Customer Service: Microsoft Parallel Data Warehouse offers straightforward deployment and prompt customer service. Teradata provides a rich set of deployment tools requiring expertise, making it challenging for users without adequate support.
Pricing and ROI: Microsoft Parallel Data Warehouse is considered cost-effective with quicker ROI due to lower setup costs. Teradata's higher initial investment is justified by its extensive capabilities and significant long-term ROI as experienced by users.
Customer support is very good, rated eight out of ten under our essential agreement.
The technical support from Teradata is quite advanced.
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.
I find the stability to be almost a ten out of ten.
The workload management and software maturity provide a reliable system.
When there are many users or many expensive queries, it can be very slow.
Unlike SQL and Oracle, which have in-built replication capabilities, we don't have similar functionality with Teradata.
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.
The interface is very user-friendly.
The data mover is valuable over the last two years as it allows us to achieve data replication to our disaster recovery systems.
The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.
Teradata is a scalable data analytics platform designed to meet enterprise demands for large-scale data management and processing, focusing on performance, scalability, and security for complex query executions.
As a leading data warehousing solution, Teradata integrates advanced analytics enabling organizations to derive insights from massive datasets. It supports high-volume data workloads with its architecture optimized for analytical queries. Users benefit from its robust scalability, allowing seamless expansion as data grows. Teradata's SQL engine is compatible with a wide range of data types, ensuring flexibility in data analysis. With advanced security measures, it protects sensitive data across various environments, providing peace of mind to users handling critical information.
What are the most important features of Teradata?Teradata is widely used in industries like finance, telecommunications, and healthcare, where data-driven decisions are critical. Companies leverage its robust analytics capabilities to enhance customer experiences, streamline operations, and ensure compliance with regulatory requirements. In these sectors, quick access to data insights can significantly impact competitive advantage.
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.
