Over 258,953 professionals have used IT Central Station research.
Compare the best Cloud Data Warehouse vendors based on product reviews, ratings, and comparisons.
All reviews and ratings are from real users, validated by our triple authentication process.
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.
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»
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»
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»
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»
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»
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»
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»
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»
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»
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»
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»
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»
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»
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»
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»
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»
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»
* 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.
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.
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»
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»
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»
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»
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»
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»
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»
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»
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.
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»
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»
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»
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»
Speed of query response time for complicated queries on tables with billions of rows including joins on varchar columns. There is no limitation on which columns can be queried or joined on and we see query times in the milliseconds for a lot... more»
We can have insight into data we never had before. We can provide that insight to internal users so we do not have to generate reports for them all the time. With response times like these there is no concern of having them wait for results... more»
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»
It provides very fast query performance after good designs of projections. It's easy to implement for 24/7 data load and usage because you don’t have to worry about “load time slots” since you can load data into reporting tables at all times... more»
We have been able to move from nightly batch loads to continuous data flow and usage. This hasn’t happened just because of Vertica, we have renewed our data platform pretty thoroughly, but definitely Vertica is one major part of our new data... more»
We are running our data transformations as an ELT process inside Vertica; we have data at least on the landing area, temporary staging area, and final data model. Data transformations require lots of deletes and updates. Delete in Vertica... more»
This product has enabled us to keep very large amounts of data at hand for fast querying. With enough hardware force behind it, we were able to use Vertica as our primary reporting database without having to aggregate data, thus enabling us... more»
We would like to see better documentation and examples as well as further simplicity in creating clusters, adding nodes, etc. I understand the GUI is very simple but sometimes more insight into what the product is doing and where errors are... more»
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»
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»
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»
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»
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»
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»
The most valuable feature is the merge function, which is essentially the upsert function. It's become our ELT pattern. Previously, when we used the ETL tool to manage upserts, the load time was significantly longer. The merge function load... more»
We've had issues with query time taking longer than expected for our volume of data. However, this is due to not understanding the characteristics of the database and how to better tune its performance.
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»
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»
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
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>>
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>>