We just raised a $30M Series A: Read our story

Microsoft Azure Synapse Analytics Room for Improvement

Information Architect at Systems Analysis & Design Engineering

Technical support needs to improve.

Microsoft improves all of the time, but there are some things where different vendors offer data warehousing and data governance that you can build and workaround. It would be beneficial to take the top vendors and identify some kind of straightforward action to work with them. Instead of having to employ a separate vendor tool to be able to move this, it would be nice to be able to go through Microsoft.

View full review »
CHTO at Timp-iT

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. For example, if your organization, has an electronic client dossier and you want to connect that information system in real-time towards Power BI, you just go to the app store and see if there is an ONS connector, introduce it, set it up, and go from there.

In an upcoming release, it would be beneficial to have the ability to have dashboards on mobile devices to receive a better experience for the user.

View full review »
Sr. Teradata Consultant at a tech services company with 201-500 employees

There are features coming int he next few quarters that will be helpful. Soon, Power BI will be directly integrated into Azure. We need to have some Spark tools also available so we can directly select customers and don't need to install everything.

There will be features added that relate to application development. There's hopefully going to be more flexibility with the XML. Right now, for example, Data Warehouse is not able to give XML files and your file put is not correct. The feature will hopefully allow us to read XML.

The performance needs to improve in future releases.

We're hoping that Microsoft will add integration with the Amazon AWS platform.

View full review »
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
552,407 professionals have used our research since 2012.
STI Data Leader at grupo gtd

Unfortunately, we have had some issues with the dashboard reporting. Sometimes, the data for specific periods would just appear blank on the dashboard. To investigate this, we worked with a Microsoft incident agent and it turned out to be a result of bugs in the platform when dealing with specific types of queries in Azure Data Factory.

We have also encountered some bugs regarding incompatibility with certain versions of Power BI. In the past, Power BI used to integrate nicely with Azure Analysis Services which we used as a bridge between Power BI and Synapse Analytics, but they have since discontinued the features that worked so well for us.

Apart from fixing bugs, I would also suggest:

  • The learning features and documentation could be improved and expanded on.
  • The calculation and forecasting tools could be made more clear and easy to use.
  • The price could be lower.
View full review »
Director, Consulting, Technology Services at a financial services firm with 1,001-5,000 employees

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.

View full review »
Enterprise Solutions at Celebal Technologies

What I would like to see more and more of in Azure is its support for IoT and streaming media information.

It needs strong support for social media, internet data, and native support for NoSQL. At this time, it works very well with the structured data

Stability could be improved.

Technical support is very good, but could also be improved.

View full review »
Managing Director at a consultancy with 1-10 employees

The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them.

If the project keeps growing we will need to link some of the documents to the data warehouse. However, at that time, I'm not sure about the possibility of keeping the same systems that we are using right now. We may need some kind of migration. I cannot say for sure, as I am not an expert. We'll need advice on that.

The initial setup is not straightforward.

The solutions not user-friendly and does require training of some sort.

The solution requires a lot of the memory of the different devices.

View full review »
Analytics Engineer at a tech services company with 51-200 employees

The major concern is that I have a hard time with having to version control the data warehouse all the time. As it is now, I have to open all of the ports and push everything onto the server. I would like to see version control implemented into the data warehouse. This would make the tool perfect. 

View full review »
Senior Architect at a tech services company with 51-200 employees

I think that there should be better governance. Actual pipeline level security, if you create a pipeline within the tool, because it's a one-stop-shop for everything, you control who has access to what, and that goes for anything, whether it's an internal or an externally managed table. 

I think there needs to be an improvement with support for external tables supporting Spark, but further support of Lakehouse to make it a true data warehousing product where you have this true separation of computes and you have a separation of storage. 

I think it kind of dips its toes in there, but in order to achieve, I think with a vision that Microsoft is doing, trying to get at to replace Bolt, but compete with Snowflake and Databricks at the same time, it needs to have those features on.

In the next release, I would like to see Lakehouse and better governance.

View full review »
Data Architect at a insurance company with 1,001-5,000 employees

What I would like to see is a possibility for time travel on the data. For instance, a financial department would like to do an analysis of the data set as it was for the first of the month while another department wants to run the analysis about how things went yesterday or last week. They have different starting points for the queries. I've seen Snowflake handle tasks such as these. It's got a feature called time shuffling, which can show me what's there on a certain variety of dates. It's very convenient.

It would be great if we could query the data of the day as well as in the data warehouse. 

They should have scalable memory processor options for the data warehouse.

While the solution is flexible, sometimes this works against the user.

View full review »
Practice Director at a tech services company with 51-200 employees

The product could be easier to use. For example, I find Snowflake more user-friendly. They should offer simpler operations.

The initial setup could be faster.

Technical support can get expensive as they charge per use. The product could do more around crowdsourcing to help users find answers or answer questions without having to resort to contacting technical support directly.

The product could be more feature-rich.

They should look at some of what AWS and Snowflake are doing. They've both got a feature stack and also push the integration of things. This is a little bit lacking with Azure.

The analytics side of the solution is pretty weak right now. 

View full review »
Senior Project Manager at a tech company with 501-1,000 employees

After only using the solution for three months, we haven't yet really gotten into every corner of its capabilities. It's hard to say what might be missing in terms of features.

It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training. An organization should be able to adopt and operationalize it throughout their company with minimal training.

View full review »
STI Data Leader at grupo gtd

The solution needs to improve its integration capabilities. It needs better integration with SQL and other databases. 

The initial setup is complex.

The product needs to implement more machine learning and artificial intelligence.

If they had more IoT and streaming capabilities, it would be helpful.

The product could use more analytics tools.

It would be helpful if we could use the product with less coding.

View full review »
Project Manager at a tech services company with 501-1,000 employees

There aren't any features that are really lacking in the solution. We don't really have any issues with it in its current form.

When we used the on-premises deployment model, we had data latency issues and suffered from page performance problems. However, since we've moved to the cloud, we haven't had these problems.

The initial setup has a bit of a learning curve.

View full review »
Senior Systems Analyst at a non-profit with 201-500 employees

When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options.

View full review »
Sr. Principal, Vice President - Digital Transformation & Strategic Pursuits Leader at a tech services company with 10,001+ employees

Right now, we are really struggling with the performance. it's not as good as we had hoped. 

I cannot recall coming across any missing features. 

One problem is that getting the query cost is not easy. I need to use multiple tools. It can be accessed through the web, or we have Azure Data Studio, or SSMS, and I only get the query cost in SSMS, the SQL Server Management Studio. In other tools, I'm not getting it. For example, in the web version or in Azure Data Studio, it is not available. They need to make it accessible in both of those places as well. 

View full review »
Data Architect at a tech services company with 51-200 employees

I would like there to be more focus on the Software as a Service (SaaS) product. For example, Snowflake, one of their competitors, is more focused on SaaS.

They need to improve a little bit in terms of user-friendliness. I would rate them a three out of five, in terms of how user-friendly the interface is.

The auto-scaling capabilities are quite poor, especially compared to Snowflake or Firebolt.

View full review »
Software Engineer at a educational organization with 501-1,000 employees

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.

View full review »
Practice Head BI at a tech services company with 1,001-5,000 employees

With respect to what needs to be improved, concurrent connectivity has some limitations. 

View full review »
Solution Principal at a computer software company with 5,001-10,000 employees

This solution needs to have query caching so that if the same query is run and the results are available, it will return the data from the cache without having to re-run the query. As it is now, you still have to use compute for each query.

We would like to have integration with the data lake so that we can avoid retrieving the data from it, just to store it in Synapse before we can use it. From an architectural perspective, avoiding this replication would be good.

View full review »
Vice President Technologies at Excelencia

The configuration for things like high-availability could be more user-friendly for non-technical users.

View full review »
Senior Business Analyst: BI Team Lead at a logistics company with 1,001-5,000 employees

So far, with the current SQL that I'm using compared to what we've previously used, I'm happy with it. I wouldn't necessarily point out anything that needs improvement.

From my point of view from what we have implemented recently, I'm happy with the solution, I'm happy with the performance. I'm not entirely happy with the billing model. I'm not entirely happy with how the enterprise services are pretty expensive, but that's about it.

View full review »
Project Manager at a tech services company with 5,001-10,000 employees

I would like my team to be able to build pipelines that integrate with the Azure Data Factory. Some of the best-in-class ETL products that are available in the market, such as Informatica ETL, are far more mature than this solution.

View full review »
BI Consultant at a tech services company with 11-50 employees

Microsoft Azure Synapse Analytics can improve querying. I have recently used Microsoft Azure Synapse Analytics to connect to the Delta Lake file and I have noticed some issues. It has not been able to read the latest version of the Delta Lake file and I have found this to be a disadvantage that they can improve.

In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks.

View full review »
Manager: Data Analytics at a consultancy with 1,001-5,000 employees

I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head.

View full review »
Manager: Data Analytics at a consultancy with 1,001-5,000 employees

I am very sure that there are areas in need of improvement, but I can't recall what they are off the top of my head.

View full review »
Co-owner, Director at a tech services company with 1-10 employees

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.

View full review »
Azure Data Specialist at a financial services firm with 5,001-10,000 employees

We've only recently starting testing this solution and it would be helpful if the documentation was better or if the company could provide some kind of presentation to help us understand how the tool works and what's required to optimize use of the solution.

View full review »
Director of Data Analytics Practice at a computer software company with 501-1,000 employees

I would like to see them provide the ingestion of images.

View full review »
Enterprise architect at a computer software company with 201-500 employees

For improvement, I would like to see more connectors and better integration for Hadoop. There are currently limitations for Hadoop on-prem. I'd like to see better integration and more flexibility. 

View full review »
Director at Nihil Solutions

Microsoft should develop an interface to make it easier to shift from on-premise to the cloud.

There needs to be a lift and shift tool to move on-premise, IMS high-volume data to synopsis sequence data on the cloud.

View full review »
Director Of Software Development at a healthcare company with 5,001-10,000 employees

The performance and data consistency need to be improved.

Support for PSQL functionality should be included, as it is something that is missing right now.

View full review »
Associate Manager at a consultancy with 501-1,000 employees

More integration is needed to improve the product for the future. There needs to be more flexibility when developing applications with this product.

View full review »
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
552,407 professionals have used our research since 2012.