Microsoft Azure Synapse Analytics Competitors and Alternatives

Get our free report covering Snowflake Computing, Oracle, SAP, and other competitors of Microsoft Azure Synapse Analytics. Updated: November 2020.
447,228 professionals have used our research since 2012.

Read reviews of Microsoft Azure Synapse Analytics competitors and alternatives

reviewer739716
Business Intelligence and Data Engineering at a tech services company with 201-500 employees
Real User
Top 10
Dec 15, 2019
Fast, convenient and requires almost no administration

What is our primary use case?

We needed a data warehouse and we made a decision on what is the right tool for us as a data warehousing tool by comparing products. We looked into Microsoft Azure, Red Shift and Snowflake. In the end, we decided on Snowflake because it looks more up to date, it seemed much better purposed as a data cloud solution. It was developed from scratch and dedicated to being used on the cloud and that was what we were looking for. It was not just an on-premises system which was then converted to use on the cloud. It was completely developed from scratch and purely focus on the cloud. Because it was… more »

Pros and Cons

  • The thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services.
  • Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway.

Cost and Licensing Advice

  • The whole licensing system is based on credit points. You can also make a license agreement with the company so that you buy credit points and then you use them. What you do not use in one year can be carried over to the next year.

What other advice do I have?

There is not really much advice I can give people considering this solution except that they should use it and enjoy it. It really sounds simple but that is it. Of course, you need to be careful with the usage of your credit points. Because there are so many possibilities in configuring the way you build your data warehouse or infrastructure, the data warehouse might seem logical, but it is not the best with respect to using credit points. You need to be careful about this. It probably takes half-a-year experience and then you will know how to do it. If you don't know what you are doing…
Andrew McLaren
Principal Consultant at DXC
Consultant
Top 20
Jul 22, 2020
Self-patching means I generally don't need a DBA; detailed analytics make it very capable

What is our primary use case?

Oracle Autonomous is a self-repairing version or cloud-based version of the Oracle Database. I typically use the new Data Warehouse capacity so I'll use it if I'm building anything connected to finance, HR, plus any of the standard business products. We also use it for other Oracle products if they're cloud-based; such as with ACM and all their other ERP tools, where the data resides on ADW. We're a consultancy so we partner with Oracle as well as other companies. I'm the principal consultant of the company.

Pros and Cons

  • Self-patching and runs machine-learning across its logs all the time
  • Ease of connectivity could be improved.

What other advice do I have?

It's worth looking at what Oracle has available because their ETL tool, for example, which is called ODI, Oracle Data Integration, is free if the target of the platform is Oracle ADW. So you can build an entire ETL or ODI process on a very capable tool and not have to pay for that tool if the target is an ADW database. I would rate this solution a nine out of 10.
Vishal Dhamke
Lead Security Architect at a comms service provider with 1,001-5,000 employees
Real User
Top 20
Sep 23, 2020
Good security, excellent online resources and easy to set up

What is our primary use case?

We primarily use the solution as a cloud data warehouse.

Pros and Cons

  • The solution has many features that are applicable to events such as audits.
  • The solution could make improvements around orchestration and doing some automation stuff on AWS front automation. It would be useful if we could use automation to build images and use hardened images which are CIS compliant.

What other advice do I have?

Our company does not have a business relationship with AWS. We're just a customer. I'm not sure which version of the solution we're using. The thing is that we are not forcing the end-user or the project team to deploy the application. They have the liberty to choose their own platform. Either they can go with AWS or they can go with Azure. Most of the projects which are deployed on non-Windows OS tend to go for AWS. My area of expertise is more in the auditing of the security standards and maintaining the security requirements as per the industry standard. I'm more in a security architect…
Sarfraz Nawaz
Chief Executive Officer at Ampcome
Real User
Top 20
Jun 23, 2020
Scales according to our needs, which saves a lot in terms of upfront costs

What is our primary use case?

We are a digital transformation services company, and we are using Amazon Redshift for one of our clients. They are a logistics company that has transportation and other needs. Their first requirement is for financial reporting, where we pull financial data from their many ERP systems and can provide a corporate-level view. There is also an operations standpoint, where they are looking for operational insights. For this, we again pull different information from their ERPs, bring it into Redshift, and then model it in such a way that they will be able to see a consolidated view in terms of… more »

Pros and Cons

  • The most valuable feature is the scalability, as it grows according to our needs.
  • The OLAP slide and dice features need to be improved.

Cost and Licensing Advice

  • The part that I like best is that you only pay for what you are using.

What other advice do I have?

I am interested in seeing a split between compute and storage, which is something that they are currently working on. We plan to start leveraging it at some point in the future. In summary, I think that Amazon Redshift is a very good data warehouse and we really like it a lot. I would rate this solution an eight out of ten.
reviewer1043649
Senior Analyst at a consultancy with 501-1,000 employees
Real User
Top 10
Dec 30, 2019
Easy to run queries, but very large datasets cause problems and technical support needs improvement

What is our primary use case?

Our primary use case for Teradata is reporting. I am a business analyst and I use this solution to first analyze my data and then visualize it.

Pros and Cons

  • The most valuable feature is the ease of running queries.
  • Stability-wise, we have had some issues with automation and the ability to handle large datasets.

What other advice do I have?

My advice for anybody who is considering this solution is first to look into the availability of customer support and make sure that it can be done. Teradata customer support in India is very bad. This is my main complaint. Fixing the problems that I have mentioned would make this a great tool. I would rate this solution a six out of ten.
Get our free report covering Snowflake Computing, Oracle, SAP, and other competitors of Microsoft Azure Synapse Analytics. Updated: November 2020.
447,228 professionals have used our research since 2012.