OpenText Analytics Database Vertica and Azure Data Factory compete in the data and analytics category. Vertica has the upper hand in speed and advanced analytics capabilities, while Azure Data Factory stands out in ETL integration and ease of use.
Features: Vertica offers remarkable speed through its columnar storage architecture and strong compression rates, benefitting large-scale queries. Its machine learning capabilities and concurrency improvements are notable assets. Azure Data Factory excels in its comprehensive ETL capabilities, easy connection to multiple data sources, and simple pipeline creation using a drag-and-drop interface.
Room for Improvement: Vertica experiences challenges with integration, high resource demands, and inconsistent support. Issues include fact table joins, metadata handling, and storage capacity. Azure Data Factory can improve its complex configurations, pricing transparency, and third-party connector support. Better monitoring and real-time processing are also needed.
Ease of Deployment and Customer Service: Vertica allows flexible deployment in on-premises and hybrid environments, with mixed reviews on customer support. Some users report effective assistance, while others rely on community solutions. Azure Data Factory benefits from public cloud deployment and Azure's reach, although support experience varies, with faster solutions often coming from the community.
Pricing and ROI: Vertica's pricing varies by database size and usage, and although some users find it costly, the performance justifies the expense with significant ROI. Azure Data Factory offers a competitive pay-as-you-go model but can be challenging in terms of cost predictability. It provides flexibility and scalability, contributing to a favorable ROI, especially for data integration tasks.
Our stakeholders and clients have expressed satisfaction with Azure Data Factory's efficiency and cost-effectiveness.
The technical support from Microsoft is rated an eight out of ten.
The technical support is responsive and helpful
The technical support for Azure Data Factory is generally acceptable.
Azure Data Factory is highly scalable.
The solution has a high level of stability, roughly a nine out of ten.
Incorporating more dedicated API sources to specific services like HubSpot CRM or Salesforce would be beneficial.
There is a problem with the integration with third-party solutions, particularly with SAP.
When using Git services, there are challenges with linked services and triggers getting overridden when moving between different environments (Dev, UAT, Prod).
The pricing is cost-effective.
It is considered cost-effective.
It connects to different sources out-of-the-box, making integration much easier.
The platform excels in handling major datasets, particularly when working with Power BI for reporting purposes.
I find the most valuable feature in Azure Data Factory to be its ability to handle large datasets.
Azure Data Factory efficiently manages and integrates data from various sources, enabling seamless movement and transformation across platforms. Its valuable features include seamless integration with Azure services, handling large data volumes, flexible transformation, user-friendly interface, extensive connectors, and scalability. Users have experienced improved team performance, workflow simplification, enhanced collaboration, streamlined processes, and boosted productivity.
OpenText Analytics Database Vertica is known for its fast data loading and efficient query processing, providing scalability and user-friendliness with a low cost per TB. It supports large data volumes with OLAP, clustering, and parallel ingestion capabilities.
OpenText Analytics Database Vertica is designed to handle substantial data volumes with a focus on speed and efficient storage through its columnar architecture. It offers advanced performance features like workload isolation and compression, ensuring flexibility and high availability. The database is optimized for scalable data management, supporting data scientists and analysts with real-time reporting and analytics. Its architecture is built to facilitate hybrid deployments on-premises or within cloud environments, integrating seamlessly with business intelligence tools like Tableau. However, challenges such as improved transactional capabilities, optimized delete processes, and better real-time loading need addressing.
What features define OpenText Analytics Database Vertica?OpenText Analytics Database Vertica's implementation spans industries such as finance, healthcare, and telecommunications. It serves as a central data warehouse offering scalable management, high-speed processing, and geospatial functions. Companies benefit from its capacity to integrate machine learning and operational reporting, enhancing analytical capabilities.
We monitor all Cloud 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.
