Chart Key
Average Rating
Average rating based on reviews
Views
Number of total page views
Comparisons
Number of times compared to another product
Reviews
Total number of reviews on IT Central Station
Followers
Number of followers on IT Central Station
The total ranking of a product, represented by the bar length, is based on a weighted aggregate score. The score is calculated as follows: The product with the highest count in each area gets the highest available score. (20 points for Reviews; 16 points for Views, Comparisons, and Followers.) Every other product gets assigned points based on its total in proportion to the #1 product in that area. For example, if a product has 80% of the number of reviews compared to the product with the most reviews then the product's score for reviews would be 20% (weighting factor) * 80% = 16. For Average Rating, the maximum score is 32 points awarded linearly based on our rating scale of 1-10. If a product has fewer than ten reviews, the point contribution for Average Rating is reduced (one-third reduction in points for products with 5-9 reviews; two-thirds reduction for products with fewer than five reviews). Reviews that are more than 24 months old, as well as those written by resellers, are completely excluded from the ranking algorithm.

Comparison of Best Cloud Data Warehouse Solutions & Vendors

Read top reviews of Cloud Data Warehouse solutions from the IT Central Station community:
Your trust is our top concern, so companies can't alter or remove reviews.
Micro Focus
Real User
BI Manager, Vertica ASE Certified DBA at a marketing services firm with 1,001-5,000 employees
Jun 23 2016

What is most valuable?

I have found great use out of many features, most notably the Management Console and the Database Designer. Many people with lots of experience creating table projections can get frustrated trying to optimize some complex queries, however, in... more»

How has it helped my organization?

The fast columnar store database structure allows our query times to be at least 10x faster than on any other database. This enables us to get answers to data questions as well as numerous analytics on our data out to our internal and... more»

What needs improvement?

Documentation has become much better, but can always use some improvement. Love the tech support, but hoping Micro Focus will invest in some additional training for the Level 1 responders so they are much more familiar with more areas of the... more»
Real User
Big Data Solution Architect - Spatial Data Specialist at Sciera, Inc.
Apr 10 2017

What is most valuable?

Scalability: Ability to load huge number of datasets (I have experience with petabytes of data) and process those things. Storage is not limited. We can increase whatever we want. Performance: The distributed architecture of Redshift has the... more»

How has it helped my organization?

We were using MySQL & MongoDB for our regular operations, but when we grew, we were forced to handle a huge number of datasets. It could be petabytes of data in and out on a regular basis. We struggled a lot to complete the operations in... more»

What needs improvement?

Of course, every product has pluses and minuses. From that perspective, Amazon Redshift has some issues with snapshot restoring when we handle huge datasets. When our snapshot size is really huge, like 20 TB+, we are forced to wait a long... more»
Find out what your peers are saying about Micro Focus, Amazon, IBM and others in Cloud Data Warehouse.
279,075 professionals have used our research since 2012.
Real User
SAP BW/BOBJ Solution Architect/Developer/Administrator at a non-tech company with 1,001-5,000 employees
Feb 15 2017

What is most valuable?

Note: My opinion here is NOT specifically focused on SAP BW. It is based on overall experience I have on SAP software. As we know BW user always involve in different SAP modules for data extraction, transformation and load process for... more»

How has it helped my organization?

It has helped our financial transactions and the HR-related functions to communicate across our organization. All our processes such as funds management, grant, payroll transactions are processed automatically through this system and BW helps... more»

What needs improvement?

Our system is old. After the system upgrade, it will open opportunities to explore so many new functions in the FI and HCM modules that could be very valuable to our organization. The upgrade will allow improvement in the below-mentioned... more»
Real User
Client Engagement Manager at a tech services company with 51-200 employees
Jan 26 2017

What is most valuable?

IBM dashDB’s availability on the cloud and integration with IBM Bluemix gives universal access to our teams that are spread over different geolocations. It’s a high-performance columnar database and stores data at 10x compression in... more»

How has it helped my organization?

Our analytics teams really like the integrated RStudio feature with which they can instantly connect to structured data and do their analysis. Traditionally, our analytics team would ask for data in flat files. They had to write the codes in... more»

What needs improvement?

One of the biggest advantage of cloud computing is Auto-scaling. AWS Redshift allows you to add more storage and CPUs/instances without any significant downtime. With dashDB, scalability and uptime need more improvement. dashDB is not... more»
Micro Focus
Consultant
Vertica Database Architect at a tech consulting company with 51-200 employees
Jun 23 2016

What is most valuable?

* Speed * Parallelization * SQL language * High Availability

How has it helped my organization?

I have seen queries that take over 24 hours on MS SQL Server to complete, complete in less than 10 minutes on Vertica. I have seen queries that take several minutes, up to an hour, on MS SQL Server, complete in less than 10 seconds, sometime... more»

What needs improvement?

While the documentation is very extensive and relatively complete, it’s poorly organized and there are way too few examples. It’s come a long way since the first version I saw, but it still has a long way to go. Plus, there is very little... more»
Micro Focus
Consultant
Associate at a tech services company with 501-1,000 employees
Sep 14 2016

What is most valuable?

The biggest, most valuable feature for us is the clustering aspect with a share-nothing mentality. Most clusters usually require their own shared storage, shared subnet, etc. and this becomes a pain and a nightmare to maintain. The second... more»

How has it helped my organization?

Loading raw data and leveraging column store to quickly aggregate the values as well as run a general analysis were the biggest improvements we found. Before, we had to scrub the data or reformat, load it, possibly scrub it some more, and... more»

What needs improvement?

Developer Tools - Vertica really needs some kind of IDE plugin for a system such as Eclipse or IntelliJ. Developing external functions in Vertica can kind of be like shooting in the dark sometimes. Also, an improved monitor or monitoring with... more»
Real User
chief of systems development at a non-tech company with 10,001+ employees
May 17 2018

What is most valuable?

We are currently in a basic stage of analytics and the first goal we have is to make sure the numbers are correct. BW has some features that help you to build factors and ETL in such a way that it's easy to get to correct responses. That's... more»

How has it helped my organization?

The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us.

What needs improvement?

One of our requirements is the ability to easily get answers regarding trends and exceptions. In BW, it is not that easy to get such information. I expect better trend and exception detection, better pattern detection. When I think about the... more»
Real User
Rails Developer at a recruiting/HR firm with 51-200 employees
Feb 20 2017

What is most valuable?

* It is based on PostgreSQL. * It’s managed. Meaning, AWS takes care of handling infrastructure, deployments, encryption, and uptime for you. * It’s cheap when you consider the price per terrabyte per year. * It’s integrated into the AWS stack.

How has it helped my organization?

At my previous company that does mobile analytics as its core product, we moved all the analytics backend from MongoDB to Redshift. Where I currently work, we use it as our main data lake/data warehouse.

What needs improvement?

While It's probably the best product of its category (managed SQL-based data warehouse at scale), it has a few shortcomings, although very few. The main issue people complain about, and I agree with the claim, is that it's hard to load your... more»
Micro Focus
Real User
Senior Data Warehouse Architect at a media company
Jun 24 2016

What is most valuable?

Storage abstraction through projections. It gives you the possibility to react to any kind of query with an optimal performance. The Workload Analyzer helps you easily to analyze your database workloads and recommends tuning opportunities to... more»

How has it helped my organization?

We are now able to procde real-time insights into our tracking data, and with that show how our customers are using the products that we have. Furthermore, it is now possible for our Data Science department to easily, and quickly train their... more»

What needs improvement?

I would love to see direct connections to other DMSs. Something like a direct connector to Oracle, MySQL, MS SQL, MongoDB, etc. so that you can copy data between Vertica and other vendors directly and more easily without an ETL tool, dump,... more»
Micro Focus
Real User
Managing Partner at Thorium Data Science
Jul 20 2017

What is most valuable?

Vertica’s analytic capabilities are its key strength. It can aggregate and analyze data at massive scale and neatly bring the calculation logic to the data with external procedures in C, Java and R. The Vertica architecture means it can... more»

How has it helped my organization?

Our consultancy has introduced Vertica to a number of clients, from small scale ones who benefit from the free tier and per TB pricing model to have a powerful analytics cluster fairly cheaply to large investment banks who have been able to... more»

What needs improvement?

We’ve built a data ingestion tool to sit alongside Vertica for easy data loading, and I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support, IDE with IntelliSense, and... more»
Consultant
Managing Consultant at Quaterne
Feb 20 2017

What is most valuable?

IBM has taken a new approach to database technology. One of the most amazing features of dashDB is how it uses compression to get results in lighting speed. dashDB uses advanced processing which doesn't require the entire dataset to fit in... more»

How has it helped my organization?

I believe that many organizations need to look at how they are servicing their customers. dashDB doesn't necessarily replace your existing infrastructure. However, as an add-on, you can now expand your overall operations and performance goals.

What needs improvement?

Every product has room for improvement. This is one of the most important things that comes to mind about IBM and their mind set when it comes to managing customers using dashDB. As a fully managed cloud service, the day-to-day backend of... more»
Micro Focus
Real User
Vertica Support Engineer at a media company with 1,001-5,000 employees
Feb 23 2017

What is most valuable?

Vertica is an excellent data warehouse platform. Its column-oriented architecture makes it a powerful database specialized for data warehouses. Data should be designed around a star schema. Data is accessed via SQL, which most developers are... more»

How has it helped my organization?

It provides very fast results for analysts running reports. These reports are crucial to help our clients strategize their targeted marketing.

What needs improvement?

Vertica is relatively new and needs some polish and refinement, but its core functionality is excellent. Documentation overall is fair to good; but lacks continuity or cohesiveness in places. Although its knowledge base is increasing, it is... more»
Real User
BI Architect & Developer (contract) at a retailer with 501-1,000 employees
Jan 31 2017

What is most valuable?

Column store and distributed processing is optimized for read access. We grew to 3000+ users with no impact. Column store is a data compression technique for relational data. I’m using it now in SQL Server 2016. We configured a 16-core VM for... more»

How has it helped my organization?

This has given us the ability to provide metrics to the large number of company staff on their performance without impacting core systems.

What needs improvement?

I’d like to see these RedShift features arrive in other languages, such as SQL's ColumnStore index. .
Real User
BI Architect at a comms service provider with 1,001-5,000 employees
Jan 29 2017

What is most valuable?

Columnar storage technology is the most valuable feature of this solution.

How has it helped my organization?

We can get the SLS/SLAs in our daily processes.

What needs improvement?

Some improvements can be brought about in: Restore table: I would like to use this option to move data across different clusters. Right now, you can only restore a table from the same cluster. Right now, the feature only permits bringing the... more»
Micro Focus
Real User
Co-Founder at a tech services company
Jan 28 2018

What is most valuable?

The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors. I think what also draws me to it... more»

How has it helped my organization?

We got something like a six-times improvement using Vertica.

What needs improvement?

I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing.
Micro Focus
Real User
Database Administrator (DBA) at a software R&D company with 501-1,000 employees
Oct 30 2016

What is most valuable?

The auto-distribution to all nodes for fault tolerance and query performance was pretty amazing.

How has it helped my organization?

Our data warehouse at the time was a multi-terabyte PostgreSQL cluster. It worked really well, but we wanted to increase the size to many TB's and our due to our query and loading patterns we found greater performance from Vertica's... more»

What needs improvement?

In the versions I worked with, if a majority of the nodes were being loaded under heavy, sustained rates the nodes would see some dramatic decreases in performance due to the data shuffling that needed to occur between all the nodes. To work... more»
Real User
Manager BI Development at a comms service provider with 1,001-5,000 employees
Feb 20 2017

What is most valuable?

Redshift gives extremely fast response involving large tables. This is the most important feature I look for in data warehouse solutions. Often you came across use cases where it is not possible to distribute data on a certain column, yet you... more»

How has it helped my organization?

One of my clients required large amounts of data but had a low budget. Amazon Redshift was the perfect choice for my client. We joined two tables containing billions of rows each and got results back in 27 seconds with a relatively small... more»

What needs improvement?

Amazon should bring more SQL functions that are required in data warehouse implementations. It lacks SQL functions for complex data processing. A very small example is recursive queries. However, Amazon is developing the product at a fast... more»
Micro Focus
Real User
Big Data DBA & DevOps at a tech vendor with 51-200 employees
Jun 23 2016

What is most valuable?

The speed of Vertica out of the box with the ability it has to perform complex analytics queries. In other databases, information will return in hours or even days while in Vertica it will be finished in minutes or even seconds. This is the... more»

How has it helped my organization?

Vertica is in our core technology stack. We are serving reports and dashboard to clients from it. It's very important to us that it fulfills its function correctly and provides us with an advantage over our competitors.

What needs improvement?

The internal documentation. As a DBA, I really want to understand how its internals works. It needs to handle high concurrency short queries better as Vertica is not handling these well, and we have had to develop our own tool to help us with... more»
Real User
Manager Data Services at a logistics company with 201-500 employees
Jul 18 2017

What do you think of Amazon Redshift?

Valuable Features Easy to build out our snowflake design and load data Ability to dynamically increase space requirements Good speed Extremely reliable • Improvements to My Organization We use Redshift as our primary BI data repository. It provides BI for all four of our product lines, which run on Redshift. It is low cost and highly reliable! • Room for Improvement It would be nice if we could turn off an instance. However, it would retain the instance in history, thus allowing us to restart without beginning from scratch. • Use of Solution We have been using this a little over a year. • Deployment Issues It is pretty easy to learn and use. If you've worked with SQL before, you won't have any problems. Also, it works very well with Talend, which is our ETL tool....
Micro Focus
Real User
Sr. SW Engineer - Databases
Jan 17 2018

What is most valuable?

* Clustered database * Horizontal scaling * Disaster recovery * Columnar Storage * Compression (you read only columns you need) * Immutable storage * Fast ingesting

How has it helped my organization?

It enabled delivery of a new Agile Data Warehousing Service. It enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance.

What needs improvement?

Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata. Query performance: Improve either Database Designer... more»
Find out what your peers are saying about Micro Focus, Amazon, IBM and others in Cloud Data Warehouse.
279,075 professionals have used our research since 2012.

Cloud Data Warehouse Articles

Social Media & Community Coordinator
IT Central Station
What do users say about their cloud data warehouse tools? What do Users Look for when Choosing a Cloud Data Warehouse Tool? In 2012 Amazon Redshift introduced the business world to the concept of cloud data warehousing and the idea quickly took off. The savings that a business could expect... more»
Content and Community Manager
IT Central Station
Which data warehouse tools are users most satisfied with? What do BI analysts and big data professionals need to consider when choosing an ETL tool?  With all the software options on the cloud computing market, which data warehouse tools are users most satisfied with? At IT Central Station,... more»
3,496
Siempre innovador! Empresario, con la mirada fija en cumplir mis metas siempre ayudando a los demás y compartiendo conocimiento.....con el afán de hacer crecer el Software Libre en el país... Experto en Inteligencia de Negocios, Data Warehousing y Big Data
Reviewed Vertica: A Good Option for Big Data
62
Managing Consultant
I’m a highly motivated and accomplished technical professional with more than twenty years of High-Tech industry experience. In addition to exceptional technical expertise, I have also been acknowledged for being self-directed, dedicated, and resourceful, a team player with the ability to handle... more>>
3,539
TOP 20POPULAR
Senior business Intelligence consultant
Freelance MicroStrategy Professional. Author of the book: "Business Intelligence with MicroStrategy" I've been doing Business Intelligence projects with MicroStrategy and SQL Server/Oracle for the last 10 years now. I have experience in several sectors including Healthcare, Agriculture and... more>>
171
Management Consultant
Program Manager, R&D, Microsoft Corporation Director, Search Business Consulting, Fast Search & Transfer ASA. Specialties: Product innovation & development, business development, and search technology
448
Technology Leader Oracle / Senior Consultant
Oracle Certified Master (OCM 12c) and Oracle ACE Director Senior DBA, Oracle Expert, Data Architect, Performance specialist Architecture, DataModeling, Conception, Tuning, Exploitation, Training

Sign Up with Email