OpenText Analytics Database (Vertica) and Snowflake Analytics compete in the analytics database market. Snowflake seems to have the upper hand due to its cloud-native capabilities and ease of use, which are increasingly sought after attributes.
Features: OpenText Analytics Database (Vertica) is valued for its fast data processing, cost-efficiency per TB, and scalability, making it suitable for managing VLDBs and providing high query performance. It offers OLAP support, enhancing database systems with traditional SQL. Snowflake Analytics excels with its cloud-native features, including easy deployment, time travel, zero maintenance, and flexible storage and compute usage options.
Room for Improvement: Vertica requires enhancements in transactional database capabilities and simplification of configurations. Users suggest improved SQL optimization and better documentation. Snowflake faces challenges with rising costs linked to computation and needs better integration with machine learning tools. Users also desire improvements in its on-premises user interface and ease of use.
Ease of Deployment and Customer Service: Vertica is deployed across private cloud, on-premises, and hybrid cloud environments. It receives mixed reviews for customer support, particularly on response times and skill levels. Snowflake is strong in public and hybrid cloud deployment and is widely regarded for its supportive customer service, although there is room for faster response times and better user guidance.
Pricing and ROI: Vertica's pricing is determined by data size, offering TCO benefits, although it's seen as expensive relative to server needs, but provides good ROI due to performance gains. It offers perpetual licensing. Snowflake’s usage-based pricing offers flexibility with pay-as-you-go options. Even though extensive computation can increase costs, it's seen as affordable compared to competitors, delivering positive ROI through scalability and operational efficiency.
Recently we had a two-day session where the Snowflake Analytics team provided a demo on Cortex AI and its features.
The Snowflake Analytics documentation is excellent.
The technical support for Snowflake Analytics is excellent based on what I have heard from others.
Storage is unlimited because they use S3 if it is AWS, so storage has no limit.
It supports both horizontal and vertical scaling effectively.
Maintaining security and data governance becomes easier with an entire data lake in place, and the scalability improves performance.
Snowflake Analytics has been stable and reliable in my experience.
Snowflake Analytics is stable, scoring around eight point five to nine out of ten.
They connected with us to resolve the issue.
If it offered flexibility similar to Oracle and supported more heterogeneous data sources and database connectivity, it would be even better.
AIML-based SQL prompt and query generation could be an area for enhancement.
I would prefer Snowflake Analytics to improve their support response times, as sometimes the responses we receive are not very prompt and ticket assignments may not be timely.
Snowflake charges per query, which amounts to a very minor cost, such as $0.015 per query.
Snowflake Analytics is quite economical.
Snowflake is better and cheaper than Redshift and other cloud warehousing systems.
Running a considerable query on Microsoft SQL Server may take up to thirty minutes or an hour, while Snowflake executes the same query in less than three minutes.
Snowflake Analytics supports data security with a single sign-on feature and complies with framework regulations, which is highly beneficial.
There are many capabilities which Snowflake Analytics offers that I find valuable, such as the storage and compute engine that allows working with any cloud system such as AWS or Azure, alongside its efficiencies in storage computation and cost-effectiveness, which saves money compared to on-premise systems.
| Product | Market Share (%) |
|---|---|
| Snowflake Analytics | 1.1% |
| OpenText Analytics Database (Vertica) | 6.1% |
| Other | 92.8% |
| Company Size | Count |
|---|---|
| Small Business | 29 |
| Midsize Enterprise | 23 |
| Large Enterprise | 38 |
| Company Size | Count |
|---|---|
| Small Business | 10 |
| Midsize Enterprise | 12 |
| Large Enterprise | 21 |
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.
Conventional data platforms and big data solutions struggle to deliver on their fundamental purpose: to enable any user to work with any data, without limits on scale, performance or flexibility. Whether you’re a data analyst, data scientist, data engineer, or any other business or technology professional, you’ll get more from your data with Snowflake.
To achieve this, we built a new data platform from the ground up for the cloud. It’s designed with a patented new architecture to be the centerpiece for data pipelines, data warehousing, data lakes, data application development, and for building data exchanges to easily and securely share governed data. The result, A platform delivered as a service that’s powerful but simple to use.
Snowflake’s cloud data platform supports a multi-cloud strategy, including a cross-cloud approach to mix and match clouds as you see fit. Snowflake delivers advantages such as global data replication, which means you can move your data to any cloud in any region, without having to re-code your applications or learn new skills.
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.
