"In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."
"The most valuable feature is the scalability, as it grows according to our needs."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"The initial setup is easy."
"It is quite simple to use and there are no issues with creating the tables."
"Has a very user-friendly SQL editor and it's very easy to use the connectors."
"The feature that we find most useful is the ability to do analytics on the fly."
"The pricing seems to be quite fair."
"They are available on the Cloud, and the platform is very intuitive."
"The solution has been working well overall."
"I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics."
"The most valuable feature is performance gains."
"The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs."
"We have found that it is easy to develop and to do the analytics in the modules of data."
"The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."
"In our experiments, the handling of unstructured data was not very smooth."
"It would be useful to have an option where all of the data can be queried at once and then have the result shown."
"Planting is the primary key enforcement that should be improved."
"It takes a lot of time to ingest and update the data."
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues."
"Pricing is one of the things that it could improve. It should be more competitive."
"There are too many limitations with respect to concurrency."
"The OLAP slide and dice features need to be improved."
"More integration is needed to improve the product for the future."
"They should provide a less expensive version with a smaller setup for small businesses. Currently, its price is quite high for entry-level or small businesses. In terms of integration, new connectors are always welcomed."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"The major challenge that we're seeing with Azure Synapse is around security concerns. The way it is working right now, it has Managed VNet by Microsoft option, similar to the implementation of Azure Databricks, which may pose a concern for financial institutions. For managed environments, the banks have very strict policies around data being onboarded to those environments. For some confidential applications, the banks have the policy to encrypt it with their own key, so it is sort of like Bring Your Own Key, but it is not possible to manage the resources with Microsoft or Databricks, which is probably the major challenge with Azure Synapse. There should be more compatibility with SQL Server. It should be easier to migrate solutions between different environments because right now, it is not really competitive. It is not like you can go and install SQL Database in some other environment. You will have to go through some migration projects, which probably is one of the major showstoppers for any bank. When they consider Synapse, they not only consider the investment in the actual service; they also consider the cost of the migration process. When you scale out or scale down your system, it becomes unavailable for a few minutes. Because it is a data warehouse environment, it is not such a huge deal, but it would be great if they can improve it so that the platform is available during the change of configuration."
"It needs strong support for social media, internet data, and native support for NoSQL."
"The initial setup is complex."
"I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good."
"Indicating what areas need improvement in this solution is a difficult question because the organizations that I am working for are really new in this area. However, an even better more simple interface, or perhaps an extension of a connector app store solution, would be helpful."
Amazon Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Customers can start small for just $0.25 per hour with no commitments or upfront costs and scale to a petabyte or more for $1,000 per terabyte per year, less than a tenth of most other data warehousing solutions.
Traditional data warehouses require significant time and resource to administer, especially for large datasets. In addition, the financial cost associated with building, maintaining, and growing self-managed, on-premise data warehouses is very high. Amazon Redshift not only significantly lowers the cost of a data warehouse, but also makes it easy to analyze large amounts of data very quickly.
Amazon Redshift gives you fast querying capabilities over structured data using familiar SQL-based clients and business intelligence (BI) tools using standard ODBC and JDBC connections. Queries are distributed and parallelized across multiple physical resources. You can easily scale an Amazon Redshift data warehouse up or down with a few clicks in the AWS Management Console or with a single API call. Amazon Redshift automatically patches and backs up your data warehouse, storing the backups for a user-defined retention period. Amazon Redshift uses replication and continuous backups to enhance availability and improve data durability and can automatically recover from component and node failures. In addition, Amazon Redshift supports Amazon Virtual Private Cloud (Amazon VPC), SSL, AES-256 encryption and Hardware Security Modules (HSMs) to protect your data in transit and at rest.
As with all Amazon Web Services, there are no up-front investments required, and you pay only for the resources you use. Amazon Redshift lets you pay as you go. You can even try Amazon Redshift for free.
Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 13 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 33 reviews. Amazon Redshift is rated 7.6, while Microsoft Azure Synapse Analytics is rated 8.0. The top reviewer of Amazon Redshift writes "Scales according to our needs, which saves a lot in terms of upfront costs". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". Amazon Redshift is most compared with Snowflake, Oracle Exadata, Vertica, Teradata and Oracle Autonomous Data Warehouse, whereas Microsoft Azure Synapse Analytics is most compared with Snowflake, SAP BW4HANA, Apache Hadoop, Oracle Autonomous Data Warehouse and AWS Lake Formation. See our Amazon Redshift vs. Microsoft Azure Synapse Analytics report.
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.