OpenText Analytics Database and Snowflake Analytics are contenders in the data analytics space. Snowflake seems to have the upper hand due to its cloud-based features and user-friendly platform, which provide seamless scalability and strong data-sharing capabilities.
Features: OpenText Analytics Database handles large data volumes at high speed, with notable strengths in scalability and data compression. It supports complex query processing and offers fast query performance. Snowflake Analytics boasts a cloud-based platform, allowing seamless scalability. It features strong data-sharing options and a user-friendly interface.
Room for Improvement: OpenText Analytics Database struggles with transactional capabilities and performance issues under peak loads. It lacks direct integration between various data sources, and the SQL optimizer could be improved. Snowflake Analytics could enhance its transactional processing and machine learning integration while optimizing its pricing model for heavy computational usage.
Ease of Deployment and Customer Service: OpenText Analytics Database supports various deployment options like On-premises and Hybrid Cloud, though customer support experiences vary. Snowflake excels in cloud deployment but doesn't offer on-premises solutions. Snowflake's cloud integration is favored for ease of deployment.
Pricing and ROI: OpenText Analytics Database bases its pricing on data size and provides a community edition with up to three nodes and 1TB for free. Snowflake's pricing is usage-based, offering flexibility but potentially leading to higher costs with heavy computations. Both platforms offer good ROI, with Snowflake providing value through managed service benefits.
The Snowflake Analytics documentation is excellent.
Recently we had a two-day session where the Snowflake Analytics team provided a demo on Cortex AI and its features.
The technical support for Snowflake Analytics is excellent based on what I have heard from others.
Maintaining security and data governance becomes easier with an entire data lake in place, and the scalability improves performance.
Storage is unlimited because they use S3 if it is AWS, so storage has no limit.
It supports both horizontal and vertical scaling effectively.
Snowflake Analytics has been stable and reliable in my experience.
They connected with us to resolve the issue.
Snowflake Analytics is stable, scoring around eight point five to nine out of ten.
If it offered flexibility similar to Oracle and supported more heterogeneous data sources and database connectivity, it would be even better.
Most companies are using these cloud technologies, so additional features and some transformation capabilities while exporting to different data buckets would be very helpful.
AIML-based SQL prompt and query generation could be an area for enhancement.
Snowflake charges per query, which amounts to a very minor cost, such as $0.015 per query.
Snowflake is better and cheaper than Redshift and other cloud warehousing systems.
Snowflake Analytics is quite economical.
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.
It is a data offering where I can see data lineage, data governance, and data security.
| Product | Market Share (%) |
|---|---|
| Snowflake Analytics | 1.5% |
| OpenText Analytics Database (Vertica) | 6.1% |
| Other | 92.4% |
| Company Size | Count |
|---|---|
| Small Business | 29 |
| Midsize Enterprise | 23 |
| Large Enterprise | 38 |
| Company Size | Count |
|---|---|
| Small Business | 11 |
| 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.
