2019-07-28T07:35:00Z

What needs improvement with Microsoft Azure Synapse Analytics?

Julia Miller - PeerSpot reviewer
  • 0
  • 950
PeerSpot user
61

61 Answers

Ibrahim_Rasras - PeerSpot reviewer
Real User
Top 5
2024-01-04T00:05:00Z
Jan 4, 2024

The security performance and cost are the two things that needs improvement.

Search for a product comparison
Peter Aderoju - PeerSpot reviewer
Real User
Top 20
2024-01-02T14:01:30Z
Jan 2, 2024

One area that could be improved is the schema management. For instance, with Azure Data Lake, I sometimes try to create mappings. In MySQL or MongoDB, I can easily see the datasets and create connections without knowing the exact schema beforehand. I'm not as familiar with that process in Azure Synapse Analytics. It might be possible through tutorials, but it would be helpful to have more integrated tools for data scanning and schema exploration within the studio itself. This could help streamline the workflow and reduce the need to switch between different applications. So, I'd like to have additional tools for data scanning and schema exploration within the Azure Synapse Analytics studio.

Salam Romim - PeerSpot reviewer
Reseller
Top 10
2023-08-22T08:26:02Z
Aug 22, 2023

The platform is not flexible, and the graphical user interface needs to be improved because the interface makes it hard for the end user to use it. Also, artificial intelligence could be used to improve analytics.

AM
Reseller
Top 20
2023-05-12T16:00:27Z
May 12, 2023

Real-time integration is hard to do in Microsoft Azure Synapse Analytics.

AA
Real User
Top 20
2023-04-26T15:12:00Z
Apr 26, 2023

There are some limitations based on the fact that it is a new platform. Some of our users have recommended switching to a different platform they are more familiar with. However, from an infrastructure standpoint, I believe it can be more secure in terms of availability. Currently, even though we have locked down public access, the Synapse can still be viewed with the URL without VPN access. It only allows viewing the configuration and not any sensitive data or pipelines. We are working with Microsoft to address this issue, but it seems like they have recommended that it be open, and there is currently no solution. Perhaps there will be improvements in other aspects in the future.

YP
Real User
Top 20
2023-03-13T10:32:58Z
Mar 13, 2023

It's stable, but its stability could be better. However, we understand that it's in production, and new features are getting added and upgraded, so you do get hiccups sometimes.

Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
BS
Real User
Top 20
2023-03-10T11:36:40Z
Mar 10, 2023

One area for improvement could be better integration with Power BI, as well as data integration with BW. If we could find a connector or process to export data from BW into Azure, that would be helpful.

Pankaj Rathod - PeerSpot reviewer
Real User
Top 10
2023-03-01T12:23:00Z
Mar 1, 2023

Generally, people have differing opinions on whether to use Azure Synapse Analytics or Azure Databricks. These are two different services from Microsoft, and customers often struggle to decide which is best suited for their particular use case. Both services have some features in common and some that are exclusive to one or the other. It is a trade-off and ultimately depends on the use case that best serves the organization. Incorporating the features of both Azure Synapse Analytics and Azure Databricks would meet most use-case scenarios. The cost of the solution has room for improvement. Azure Database has a very good Unity Catalog functionality, which is a form of governance within Azure Databricks. Similarly, for Azure Analytics, having a governance product would be great. However, Microsoft already has Azure Purview, which is meant for governance, but it would be nice to have that functionality built into Azure Synapse Analytics.

Erick Oliveira Da Silva - PeerSpot reviewer
Real User
Top 5Leaderboard
2023-01-23T15:56:41Z
Jan 23, 2023

The linked services can be improved. We can create dynamic linked services to access a lot of databases but only those of the same type. For example, I can use the same linked services to access 11 SQL databases. However, if I have 11 SQL databases and five Oracle databases, I need two dynamic linked services. I cannot do it with only one linked service. The UI also needs to be improved. When I have used Azure Synapse for programming with PySpark, Scala, or .NET, for example, the UI has been unstable. If I open two notebooks for programming, one notebook will queue the session of the other.

SS
Real User
Top 5
2022-11-28T15:34:58Z
Nov 28, 2022

Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial.

RM
Real User
Top 5
2022-10-21T13:22:26Z
Oct 21, 2022

Microsoft Azure Synapse Analytics could improve the section in the solution where you can implement the Python Spark pipelines, it's not the same as in Databricks which would be better. The data visualization in Microsoft Azure is provided by Power BI, it's not needed to have something in Synapse. The data governance tool is outside Synapse, but there is a data governance tool that is called Purview in Microsoft Azure. They need to improve the Spark part of the solution then it would be complete.

AT
Real User
Top 5
2022-09-20T17:58:37Z
Sep 20, 2022

In Azure, when you do the scaling up, it is not totally simple. It takes time to scale up. It actually kind of rebuilds the database behind this when you scale. If I am utilizing 1,000 of what they call the Data Warehouse and you need 1,200, there is downtime required. There is a limit on the number of concurrent queries to around 125 for Azure Synapse.

BS
Consultant
2022-08-24T16:30:10Z
Aug 24, 2022

Microsoft Azure Synapse Analytics could improve in usability. I have found the same issue with all Microsoft solutions.

Dhruv Singh - PeerSpot reviewer
Real User
Top 5
2022-08-04T09:59:00Z
Aug 4, 2022

The product needs a tool that allows for work from a laptop instead of a browser. When working in on-premises environments, it is important to have all tools installed on a laptop rather than relying on internet connectivity which is a big inconvenience. For example, it would be brilliant to add an integration on Visual Studio to create all pipelines in an offline mode. The solution cannot store much data and might require purchasing additional storage. For example if you have 1 TB of data, processing it in the solution will cost ten times more than processing it in Databricks.

Muralidharan Lakshmanachar - PeerSpot reviewer
Real User
Top 20
2022-07-20T11:46:35Z
Jul 20, 2022

Synapse Analytics' performance slows down if you don't get your distribution right because it gets queued and goes into a single node. In addition, the integration with other solutions like Power BI and Azure SQL Database is very slow and leaves a lot to be desired. In the next release, I would like to see a feature to offload Synapse files directly into Gen2.

JoseArguello - PeerSpot reviewer
Real User
Top 20
2022-07-05T18:48:31Z
Jul 5, 2022

There are some limitations. The filing can be improved. Some improvement in the filing is necessary. It needs some kind of growth in the filing development in order to reuse some activities.

VarunJoshi - PeerSpot reviewer
Real User
Top 20
2022-06-06T08:20:36Z
Jun 6, 2022

We'd, of course, always like to pay less for the service if we can.

Sunil Gidwani - PeerSpot reviewer
Real User
Top 20
2022-05-29T13:17:00Z
May 29, 2022

Synapse Analytics needs to develop an automation framework because now you have to build a cache yourself. You have to build a pipeline in WhereScape, which does end-to-end pipeline automation well. Microsoft should come up with a framework to save people time. If they developed a tool like WhereScape, it would dramatically reduce development time. I'm waiting for Microsoft to implement a feature that automatically detects and processes the copy activity. That feature is available in Databricks, but I hope they will add it to Synapse Analytics' data factory integration run-time.

VK
MSP
2022-05-12T06:53:59Z
May 12, 2022

The only concern for us is the cost part. When it comes to the implementation and the support and maintenance, we see high-cost implications. Of course, it varies from use case to use case. Before we get into the implementation part, we have to validate the pros and cons of the architectural components as part of the design and development. Once that's clear, then we'll go for implementation. We might get into technical glitches, however, there are multiple ways to work around them by putting in the right architectural component, which can solve the problem. There is always a workaround. We've had a couple of interactive sessions with Microsoft already. We have already recommended that they need to strengthen their presence in the data governance part, the data quality part, and then the metadata management, for example, data lineage. We need more data governance to give the flexibility to handle these data quality issues. It would be great if they update their data features.

Matthew Spieth - PeerSpot reviewer
Real User
Top 5
2022-03-30T19:12:50Z
Mar 30, 2022

Microsoft Azure Synapse Analytics could improve its compatibility with Visual Studio. One of the challenges for people moving from an on-premise to a cloud solution, such as Microsoft Azure Synapse Analytics, is that you're constantly working in a browser. There are people that have been working for decades on desktop applications. For them to start working in a browser, it's quite a change. Allowing people to work and do their work inside Visual Studio than in the browser, would be a large advantage.

Fabio Xavier - PeerSpot reviewer
Real User
2022-03-03T09:24:13Z
Mar 3, 2022

Microsoft Azure Synapse Analytics can improve by increasing the size of the files that we can load on the platform. We have some files that are too large to be loaded and it would be a benefit to us if the limit was increased. Additionally, the way we use the tool for generating reports can be made better. They should add some drag-and-drop rules without the need of programming these rules using some programming language. It would be helpful if we did not need someone that was technically advanced to be able to do it with, such as someone with no IT background. Having a reporting tool without code would be great.

PedroNavarro - PeerSpot reviewer
Real User
Top 5
2022-02-03T12:09:00Z
Feb 3, 2022

The only issue that we have run into with the solution's performance is with regard to concurrency. We would also like to see faster response times from support.

HarishAjjarapu - PeerSpot reviewer
Real User
2022-01-26T14:11:00Z
Jan 26, 2022

I would like to see more ready-to-use products from Synapse. Right now, everything seems a bit futuristic without much modern use.

VY
Real User
2021-12-27T19:04:00Z
Dec 27, 2021

Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better. I would like to see support for cross-DB queries.

SZ
Real User
2021-11-24T05:15:04Z
Nov 24, 2021

An area for improvement would be advanced analytics. The product also comes with a pretty steep learning curve, which could be improved. In the next release, I would like an improvement in internal security, which currently doesn't work at all.

CG
Consultant
2021-10-22T18:44:48Z
Oct 22, 2021

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.

VP
Real User
2021-09-14T10:13:56Z
Sep 14, 2021

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.

NT
Real User
2021-08-17T18:39:37Z
Aug 17, 2021

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.

MT
Real User
2021-05-17T12:28:28Z
May 17, 2021

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.

AS
Real User
2021-03-11T12:40:17Z
Mar 11, 2021

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.

SB
Real User
2021-02-23T09:59:56Z
Feb 23, 2021

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.

AB
Real User
Top 5Leaderboard
2021-02-17T03:48:28Z
Feb 17, 2021

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.

NN
Real User
2021-02-12T18:16:50Z
Feb 12, 2021

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.

RG
Real User
2021-02-06T07:34:59Z
Feb 6, 2021

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.

ML
Real User
2021-01-28T22:53:34Z
Jan 28, 2021

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.

KG
Real User
2021-01-27T17:20:19Z
Jan 27, 2021

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

Mullai Selvan - PeerSpot reviewer
Real User
Top 20
2020-12-31T08:39:34Z
Dec 31, 2020

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.

AB
Real User
Top 5Leaderboard
2020-12-31T07:00:12Z
Dec 31, 2020

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.

JL
MSP
2020-12-28T16:02:54Z
Dec 28, 2020

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.

HG
Real User
2020-12-23T01:30:36Z
Dec 23, 2020

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.

EI
Real User
2020-12-16T06:41:32Z
Dec 16, 2020

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

EI
Real User
2020-12-15T23:36:52Z
Dec 15, 2020

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.

AP
Real User
2020-11-26T21:01:19Z
Nov 26, 2020

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.

JT
Real User
2020-11-20T10:07:03Z
Nov 20, 2020

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.

RP
Real User
2020-10-11T08:58:07Z
Oct 11, 2020

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.

JS
Real User
Top 20
2020-09-13T07:02:24Z
Sep 13, 2020

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.

MB
Real User
2020-09-10T07:35:43Z
Sep 10, 2020

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.

RV
Real User
2020-08-24T05:54:00Z
Aug 24, 2020

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.

AM
Real User
2020-08-02T08:16:00Z
Aug 2, 2020

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

SS
Consultant
2020-07-29T07:45:56Z
Jul 29, 2020

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.

JS
Real User
2020-07-12T11:48:49Z
Jul 12, 2020

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.

JS
Real User
2019-12-18T05:44:00Z
Dec 18, 2019

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.

AD
Real User
2019-12-15T05:58:00Z
Dec 15, 2019

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.

PP
Real User
2019-12-12T07:48:00Z
Dec 12, 2019

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

BT
Real User
2019-12-12T07:48:00Z
Dec 12, 2019

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.

JS
MSP
2019-12-11T05:40:00Z
Dec 11, 2019

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

MD
Real User
2019-11-13T05:29:00Z
Nov 13, 2019

There are several specific features and functions available on the on-premises version that do not work with the cloud version. There are many issues regarding migration. They are building it more and more, but if you have the same version on local you cannot just go to the cloud because some of the functionalities don't work yet. You would have to re-code everything, and maybe even do it differently. In terms of documentation, they can make it easier or start with some advising or instruction. As it is now, it's like making a puzzle. Technical support needs some improvement. They will need to include some features for the Cloud version. They can make subsets of the database so you can schedule the marking department to work only between nine to five, but ETL can run at night. With a subset database, you can cut costs, similar to Snowflake whose price is a lot lower.

EK
Real User
2019-11-13T05:28:00Z
Nov 13, 2019

As far as improvements to the product, I think the Data Factory integration should be enhanced to be properly implemented because right now it is still lagging behind other vendors like Informatica. We ended up having to use Data Factory because we don't have any expertise in Informatica. But I want to see Data Factory get better overall. An enhancement I would like to see is in data loading for Data Factory. Right now we are seeing a little bit of a performance lapse in the cloud server. Specifically, this happens between Azure and our clients maybe because we are connecting to SQL Server Management Studio. There is a slight but noticeable delay. I do not know if it has to do with Azure and whether it is their problem or our problem. I can't complain much about Data Factory, but because I used to use SSIS (SQL Server Integration Services) which was the prior on-prem version, I know what capabilities it is missing in comparison. They changed it over to Data Factory, but by comparison, Data Factory has a long way to go to reach the level of SSIS as a product.

RR
Real User
2019-10-15T05:02:00Z
Oct 15, 2019

It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database.

CK
Consultant
2019-09-23T06:34:00Z
Sep 23, 2019

The initial setup process needs improvement. When you're moving to the cloud it takes a bit of time. It would be great if they could implement something that would make it faster. It takes a bit of time but once you're done, you're done. The simplicity is good, but it should be that anyone can use it. You shouldn't have to be technical because, with the way it is now, only a technical person who has had training can set it up. If you have a dashboard that anyone can use, it would be easier.

it_user937602 - PeerSpot reviewer
Real User
2019-07-28T07:35:00Z
Jul 28, 2019

There are several things that I would like to see improved with this solution, including: * The price of this solution could be improved. * I would like to see better integration with Active Directory, because we have had problems, and we still do. * I expected that Microsoft would have had something out of the box for Office 365, but they do not. * It is difficult to configure, especially if you have multiple domains. * I would like to see a simpler interface for the Azure portal because it is kind of complicated. * It would be nice to have better monitoring of the usage of the data inside Azure SQL. What we don't use could be achieved in cloud storage. This would allow us to cut down the price. * Better customization would improve this solution.

Microsoft Azure Synapse Analytics is an end-to-end analytics solution that successfully combines analytical services to merge big data analytics and enterprise data warehouses into a single unified platform. The solution can run intelligent distributed queries among nodes, and provides the ability to query both relational and non-relational data. Microsoft Azure Synapse Analytics is built with these 4 components: Synapse SQL Spark Synapse Pipeline Studio Microsoft Azure Synapse Analytics...
Download Microsoft Azure Synapse Analytics ReportRead more