Project Manager at a tech services company with 5,001-10,000 employees
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.
Analytics Engineer at a tech services company with 51-200 employees
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.
Senior Business Analyst: BI Team Lead at a logistics company with 1,001-5,000 employees
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.
Managing Partner at a tech services company with 11-50 employees
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.
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
Data Architect at a tech services company with 10,001+ employees
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.
Executive Board Member / General Manager at a comms service provider with 51-200 employees
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.
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.
EMEA IT Program Manager for Sales, Marketing & eCommerce at a transportation company with 10,001+ employees
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...
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.
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.
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.
The configuration for things like high-availability could be more user-friendly for non-technical users.
With respect to what needs to be improved, concurrent connectivity has some limitations.
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.
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.
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.
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.
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.