Overview

Microsoft Azure

Stacks25.2K

Followers17.6K

Votes768

Amazon Redshift

Stacks1.5K

Followers1.4K

Votes108

Amazon Redshift vs Microsoft Azure: What are the differences?

Scalability: Amazon Redshift and Microsoft Azure both offer scalability in terms of storage and compute resources. However, Amazon Redshift provides automatic scaling of both storage and compute, allowing users to easily add or remove nodes as needed. In contrast, Microsoft Azure provides manual scaling, requiring users to manually add or remove nodes to adjust the storage and compute capacity.
Pricing: When it comes to pricing, there are differences between Amazon Redshift and Microsoft Azure. Amazon Redshift offers a pay-as-you-go pricing model based on usage, with options for on-demand or reserved instances. On the other hand, Microsoft Azure offers a similar pay-as-you-go pricing model, but also provides options for purchasing reserved capacity to save costs in the long run.
Security and Compliance: Both Amazon Redshift and Microsoft Azure offer strong security features and compliance certifications. However, Amazon Redshift has more strict access control capabilities, allowing granular control over user permissions and access to data. Azure, on the other hand, offers strong security features and complies with various industry standards, but may require additional configuration for more granular access control.
Integration with Ecosystem: While Amazon Redshift is tightly integrated with the overall AWS ecosystem, including data ingestion, data lake storage, and various analytics services, Microsoft Azure provides a more comprehensive ecosystem with its own suite of data services, including Azure Data Lake Storage, Azure Data Factory, and Azure Analysis Services. This makes it easier for users who are already invested in the Azure ecosystem to work seamlessly with these services.
Data Warehousing Features: Amazon Redshift is specifically designed for data warehousing, offering a wide range of features optimized for performance, scalability, and analytical queries. On the other hand, Microsoft Azure offers a more diverse range of data services, including both data warehousing and database solutions. This allows users to choose the most appropriate solution based on their specific needs and requirements.
Geographical Availability: Amazon Redshift is available in multiple regions worldwide, allowing users to choose the location that best meets their needs for data residency and latency. Microsoft Azure also has a global presence, offering data warehousing services in several regions. However, the availability may vary across regions, and users should consider the available regions when selecting a provider.

In summary, Amazon Redshift and Microsoft Azure differ in terms of scalability, pricing models, security and compliance features, integration with ecosystem, data warehousing features, and geographical availability. Both platforms have their own strengths and users should evaluate these differences to choose the most suitable solution for their specific requirements.

Advice on Microsoft Azure, Amazon Redshift

datocrats-org

Jul 29, 2020

Needs adviceon

Amazon EC2

Tableau

PowerBI

We need to perform ETL from several databases into a data warehouse or data lake. We want to

keep raw and transformed data available to users to draft their own queries efficiently
give users the ability to give custom permissions and SSO
move between open-source on-premises development and cloud-based production environments

We want to use inexpensive Amazon EC2 instances only on medium-sized data set 16GB to 32GB feeding into Tableau Server or PowerBI for reporting and data analysis purposes.

319k views319k

Comments

Detailed Comparison

Microsoft Azure	Amazon Redshift
Azure is an open and flexible cloud platform that enables you to quickly build, deploy and manage applications across a global network of Microsoft-managed datacenters. You can build applications using any language, tool or framework. And you can integrate your public cloud applications with your existing IT environment.	It is optimized for data sets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions.
Use your OS, language, database, tool;Global datacenter footprint;Enterprise Grade with up to a 99.95% monthly SLA;Web Sites- Get started for free and scale up as your traffic grows. Build with ASP.NET, PHP or Node.js and deploy in seconds with FTP, Git or TFS.;Infrastructure Services- Access scalable, on-demand infrastructure using Virtual Machines and Virtual Networks. Take advantage of what you already know to achieve new capabilities in the cloud.;Mobile Services- App development with a scalable and secure backend hosted in Windows Azure. Incorporate structured storage, user authentication and push notifications in minutes.;Cloud Services- Create highly-available, infinitely scalable applications and services using a rich Platform as a Service (PaaS) environment. Support multi-tier scenarios, automated deployments and elastic scale.;Big Data- Process, analyze, and gain new insights from big data using the power of Apache Hadoop.;Media- Create, manage and distribute media in the cloud. This PaaS offering provides everything from encoding to content protection to streaming and analytics support.	Optimized for Data Warehousing- It uses columnar storage, data compression, and zone maps to reduce the amount of IO needed to perform queries. Redshift has a massively parallel processing (MPP) architecture, parallelizing and distributing SQL operations to take advantage of all available resources.;Scalable- With a few clicks of the AWS Management Console or a simple API call, you can easily scale the number of nodes in your data warehouse up or down as your performance or capacity needs change.;No Up-Front Costs- You pay only for the resources you provision. You can choose On-Demand pricing with no up-front costs or long-term commitments, or obtain significantly discounted rates with Reserved Instance pricing.;Fault Tolerant- Amazon Redshift has multiple features that enhance the reliability of your data warehouse cluster. All data written to a node in your cluster is automatically replicated to other nodes within the cluster and all data is continuously backed up to Amazon S3.;SQL - Amazon Redshift is a SQL data warehouse and uses industry standard ODBC and JDBC connections and Postgres drivers.;Isolation - Amazon Redshift enables you to configure firewall rules to control network access to your data warehouse cluster.;Encryption – With just a couple of parameter settings, you can set up Amazon Redshift to use SSL to secure data in transit and hardware-acccelerated AES-256 encryption for data at rest.<br>
Statistics
Stacks 25.2K	Stacks 1.5K
Followers 17.6K	Followers 1.4K
Votes 768	Votes 108
Pros & Cons
Pros 114 Scales well and quite easy 96 Can use .Net or open source tools 81 Startup friendly 73 Startup plans via BizSpark 62 High performance Cons 7 Confusing UI 2 Expensive plesk on Azure	Pros 41 Data Warehousing 27 Scalable 17 SQL 14 Backed by Amazon 5 Encryption
Integrations
New Relic Twilio SendGrid Cloudinary Redis Cloud Bitnami AWS Cloud9 MongoLab AppDynamics Cloudant CopperEgg	SQLite MySQL Oracle PL/SQL

What are some alternatives to Microsoft Azure, Amazon Redshift?

DigitalOcean

We take the complexities out of cloud hosting by offering blazing fast, on-demand SSD cloud servers, straightforward pricing, a simple API, and an easy-to-use control panel.

Amazon EC2

It is a web service that provides resizable compute capacity in the cloud. It is designed to make web-scale computing easier for developers.

Google Compute Engine

Google Compute Engine is a service that provides virtual machines that run on Google infrastructure. Google Compute Engine offers scale, performance, and value that allows you to easily launch large compute clusters on Google's infrastructure. There are no upfront investments and you can run up to thousands of virtual CPUs on a system that has been designed from the ground up to be fast, and to offer strong consistency of performance.

Linode

Get a server running in minutes with your choice of Linux distro, resources, and node location.

Scaleway

European cloud computing company proposing a complete & simple public cloud ecosystem, bare-metal servers & private datacenter infrastructures.

Google BigQuery

Run super-fast, SQL-like queries against terabytes of data in seconds, using the processing power of Google's infrastructure. Load data with ease. Bulk load your data using Google Cloud Storage or stream it in. Easy access. Access BigQuery by using a browser tool, a command-line tool, or by making calls to the BigQuery REST API with client libraries such as Java, PHP or Python.

Rackspace Cloud Servers

Cloud Servers is based on OpenStack, the open and scalable operating system for building public and private clouds. With the open cloud, you get reliable cloud hosting, without locking your data into one proprietary platform.

Qubole

Qubole is a cloud based service that makes big data easy for analysts and data engineers.

Amazon EMR

It is used in a variety of applications, including log analysis, data warehousing, machine learning, financial analysis, scientific simulation, and bioinformatics.

Altiscale

we run Apache Hadoop for you. We not only deploy Hadoop, we monitor, manage, fix, and update it for you. Then we take it a step further: We monitor your jobs, notify you when something’s wrong with them, and can help with tuning.