Overall, Microsoft Azure Synapse Analytics offers good integration, is user-friendly for data analysts, and helps in centralizing data. I'd rate the solution ten out of ten.
My advice would be to remain open to learning new things, particularly because working with Synapse Analytics requires a shift in mindset from traditional tools like SQL Management Studio to newer tools and approaches. I rate it an eight out of ten.
Vice President of Technology at Park Avenue Finance
Real User
Top 20
2024-08-07T14:42:00Z
Aug 7, 2024
The tool's on-demand query capabilities help enhance our analytical tasks. I like the way the tool works, as I have people doing queries and an analyst doing a lot of stuff in the product. I love the way that we can manage Microsoft Azure Synapse Analytics. One person can maintain the tool. I rate the tool a seven out of ten.
Chief Manager at a insurance company with 10,001+ employees
Real User
Top 5
2024-04-25T08:20:00Z
Apr 25, 2024
Microsoft Azure Synapse Analytics is a cloud-based solution. Since we are migrating, the cost is high. We assume the cost will be reduced post-migration, increasing the company's profitability. Microsoft Azure Synapse Analytics will be more profitable for any company in the long run. I would recommend the solution to other users. Overall, I rate the solution an eight out of ten.
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
It's about how it integrates into your work. If it's easy to integrate into your workflow, then I'd recommend it. It's quite easy to use, scalable, and has good processing time. Those are the major things for me. It's easy to use, scalable, and integrates well, then it's a good choice. Overall, I would rate the solution an eight out of ten.
Senior Intelligent Software Research & Development Engineer at Orange Innovation Egypt
Reseller
Top 10
2023-08-22T08:26:02Z
Aug 22, 2023
Microsoft is a good platform because it's compatible with data warehouse, power analytics, and visualization, and you now have excellent machine learning and AI tools like GPT-4. The platform is also very stable, and support can be migrated for software. I rate Microsoft Azure Synapse Analytics a ten out of ten.
Infrastructure Architect at a hospitality company with 1,001-5,000 employees
Real User
Top 20
2023-04-26T15:12:00Z
Apr 26, 2023
This is the first solution that we are trying out. But if we plan to compare it with another solution called Snowflake, it will open up more dimensions for our thoughts to work. However, based on what we have achieved so far, I can rate it as an eight out of ten overall.
I would recommend using Microsoft Azure Synapse Analytics because it includes everything from integration to transformation and storage. Overall, I would rate the solution an eight out of ten.
Data Architect at a retailer with 1,001-5,000 employees
Real User
Top 10
2023-03-01T12:23:00Z
Mar 1, 2023
I give the solution a nine out of ten. Depending on the organization's use case, there are multiple options available. For example, if the workload is medium, there are different products available such as Azure SQL Database for small or medium-sized data, and Azure Synapse Analytics for extremely large volumes of data. Ultimately, it is the use case of the organization that will determine the need for these particular services.
There is going to be competition in the market with the release of SAP Cloud Analytics. The solution does not require maintenance because it is sized-based. I would recommend this solution to others. I have evaluated the fact sheet on the solution. I rate Microsoft Azure Synapse Analytics an eight out of ten.
Head of Business Integration and Architecture at Jakala
Real User
2022-10-21T13:22:26Z
Oct 21, 2022
Once a service is managed as a service in a cloud platform, the maintenance is very easy. You have to monitor it, but the maintenance infrastructure is extremely easy. This solution is very easy once you have a Microsoft Azure subscription to go straight to Microsoft Azure Synapse Analytics because it's native. However, there are other kinds of technologies one can use. I would suggest before using this solution, look at other solutions, such as Databricks or Snowflake, and not stop at the first solution that you can receive in Microsoft Azure. I rate Microsoft Azure Synapse Analytics an eight out of ten.
We are Microsoft partners. Potential customers should check out the ease of management. This solution is easier to maintain compared toother options. I'd rate the solution seven out of ten. There are some challenges related to this replication and then there is quite a lot of design thinking to be done.
Founder and Managing Director at a tech services company with 1-10 employees
Consultant
2022-08-24T16:30:10Z
Aug 24, 2022
My advice to others is they should leverage other Azure components if they can. If they are looking for an integrated solution that's easy to use, they should look at competitors. I rate Microsoft Azure Synapse Analytics an eight out of ten.
Data Engineer at a manufacturing company with 10,001+ employees
Real User
2022-07-05T18:48:31Z
Jul 5, 2022
We buy direct from Microsoft. Our company may be partners with them. As Microsoft Azure Cloud, it only has one version. I don't know if there is a version number. I would advise users to start loading the data beforehand and understand very well how the tool works and how it's useful. That way, you can evaluate the best solution. Sometimes you need to start to load data and review all the alternatives in the solution. I’d rate the solution a nine out of ten.
Cloud Solution Development Manager at Stryker Corporation
Real User
2022-05-29T13:17:00Z
May 29, 2022
I rate Azure Synapse Analytics eight out of 10. No competitors provide the entire solution to one place like Synapse. For example, a database just focuses moving and manipulating data, etc. But Synapse is like an all-inclusive workspace. I advise other people to go with Databricks Notebook if you need a computation engine. It has a solid SQL storage procedure. Suppose you are dealing with complex transformation logic and manipulation of run-time data flows. In that case, it's better to use Databricks than any Microsoft ADF. DataBricks looks more promising in terms of computing in memory, so we integrated Databricks in Synapse.
While we do not have a business relationship with Azure, we are trying to become partners. Most of our implementations happen on Azure itself. Wherever we go, we take the solutions and we go to the other customers and we propose them. We tend to recommend this solution. I'd rate the solution seven out of ten. There is a scope for improvement. Eventually, as they come across different case by case, they'll enhance things. Currently, what I see here is the data governance part is missing here from a development life cycle point of view.
Senior Database Administrator at Summa Health System
Real User
2022-03-30T19:12:50Z
Mar 30, 2022
My advice to those wanting to use this solution is to start small to get an understanding of how it operates. I rate Microsoft Azure Synapse Analytics a nine out of ten.
BI Development & Validation Manager at JT International SA
Real User
2022-02-03T12:09:00Z
Feb 3, 2022
I would recommend others to use this product but urge them to understand that it is more of a technical database used to prepare data as opposed to serving it. I would rate this solution a seven out of ten.
Be sure to be clear about the ideal pipeline for Synapse, differentiate your needs, and validate based on use-case. I would rate this solution a six out of ten overall.
There are many available versions of Azure Synapse, such as Azure Synapse SQL Datawarehouse, Azure Synapse Analytics, and Azure Synapse Analytics workspace. You need to be aware of the features that you are looking for and accordingly choose the offering. I would rate it a five out of 10.
One of the main pros of Synapse is the ability to work with the classic data warehouse and the big data. Another is the ability to use the Spark engine for preparation. Before implementing this product, consider whether it will provide the results you want. If you are already using Microsoft products, Synapse is easy to integrate. I would score this solution as eight out of ten.
BI Consultant at a tech services company with 11-50 employees
Consultant
2021-10-22T18:44:48Z
Oct 22, 2021
I would recommend this solution to others. The client that I am working for, their preferred database is Synapse. I rate Microsoft Azure Synapse Analytics a seven out of ten.
Sr. Principal, Vice President - Digital Transformation & Strategic Pursuits Leader at a tech services company with 10,001+ employees
Real User
2021-09-14T10:13:56Z
Sep 14, 2021
We're just customers and end-users. My company does not have any relationship. It's our client who has a relationship with Microsoft. I'm not sure which version we are using, however, I would guess it is the latest version. I'm not 100% sure. Since the solution is still new to me, and I am having issues with performance, it's too early to say if I would recommend the solution to other users or companies. I'd rate the solution at an eight out of ten.
Senior Systems Analyst at a non-profit with 201-500 employees
Real User
2021-08-17T18:39:37Z
Aug 17, 2021
It is beneficial to always plan exactly what the main aims are and then choose the solution that can do it. If you want something quick, I set something up without any knowledge with Azure in three weeks. Once you get going, everything will be at your fingertips. I rate Microsoft Azure Synapse Analytics an eight out of ten.
My advice to those wanting to implement this solution would be to "Think big and act small." See what is up ahead. One of the organizations that I am working for, the big picture is population health management. We are not going to start with that, we are going to start to improve one small process, which is a cumbersome process that is been difficult for many years. That is the process that we are going to make transparent towards the organization, to see where the bottlenecks could be or are, and improve that process. We want the user experience to improve and that the amount of time you can save is monitored, which can be used for other care processes. Start with a cumbersome problem, resolve them first. You can actually tell within the organization, if the solution is already working, not on the larger scale, but on the small scale. Once you start seeing these results move on to the next problem. The solution is secure. However, the organization has to be aware that if you use the security by default, the security is there. It has security by design. It is not the optimal security, I would always recommend that organizations use multi-factor authentication for an additional security layer. Additionally, if possible, have a next-generation firewall within their network in use or, if not, start implementing that if they are planning to move forward into an outsource Azure platform-based eco landscape. I rate Microsoft Azure Synapse Analytics an eight out of ten.
We are both partners and end-users of the product. We use it internally and we use it with some of our clients. I would caution new users that there is one parameter they need to watch carefully. That is the size of the data warehouse. If you don't configure this parameter to be as small as possible, your costs will be quite high. I would rate the solution at a seven out of ten. It's a stable platform, however, the price model is questionable in comparison to Amazon and Google and the contact with support is a problem for me.
Data Architect at a insurance company with 1,001-5,000 employees
Real User
2021-02-12T18:16:50Z
Feb 12, 2021
We are using the latest version of the solution. I would rate the solution at an eight out of ten. I would recommend Synapse, however, it depends on which industry an organization is working in. It can be complex, and often, you have to choose between several tools. They're all able to do the same job, they're just more industry-specific in some cases. If you want to transform your data, you can choose between the database, data factory, and SQL, and even other tools. This means it is very flexible, however, it also makes it difficult to administer. It's not that one of these sources is harder per se. It's more about what is the best for the job. Sometimes you create something and it doesn't perform and you have to start from scratch.
Azure Data Specialist at a financial services firm with 5,001-10,000 employees
Real User
2021-02-06T07:34:59Z
Feb 6, 2021
I think Synapse Analytics is definitely better than the traditional high solution data solutions that we've previously used. It's definitely worth considering and I haven't come across anything negative, only advantages for now. I would rate this solution an eight out of 10.
Managing Director at a consultancy with 1-10 employees
Real User
2021-01-28T22:53:34Z
Jan 28, 2021
I'm just an end-user and customer. I'd rate the solution at a seven out of ten. I'd rate them higher if they could make it more user-friendly in terms of those more sophisticated capabilities that the system offers. Also, the training requires long hours. That's something difficult to organize when people have to be allocated to specific training sessions, instead of being on the projects. There's a kind of complex way of balancing the possibility of some people using the more sophisticated solutions and getting trained.
We're just end-users and customers. We don't have a business relationship with the organization. We're using the latest version of the solution right now. I'd recommend the solution to other organizations. I'd rate the solution at a nine out of ten.
There is always room for improvement with Azure Synapse Analytics, but for our use cases it works very well. I would rate Microsoft Azure Synapse Analytics a seven out of ten.
Senior Architect at a tech services company with 51-200 employees
MSP
2020-12-28T16:02:54Z
Dec 28, 2020
I would recommend this solution to others who are interested in using it. I think it's definitely something that they should consider. It's come a long way from where it started. It's just finished out a public preview and it's great if you're looking to combine a lot of tools into one and you're running a smaller shop. I think it's a great tool. I would rate this solution a seven out of ten.
Manager: Data Analytics at a consultancy with 1,001-5,000 employees
Real User
2020-12-16T06:41:32Z
Dec 16, 2020
I would highly recommend this solution to others who are interested in using it. We recommend it to our clients. It's exceptionally good, and our clients and other partners find it both stable and scalable. I would rate this solution a nine out of ten.
Manager: Data Analytics at a consultancy with 1,001-5,000 employees
Real User
2020-12-15T23:36:52Z
Dec 15, 2020
I highly recommend this solution to others, and we recommend it to our clients. Overall, it's exceptionally good. I would rate this solution a nine out of ten.
Data Architect at a tech services company with 51-200 employees
Real User
2020-11-26T21:01:19Z
Nov 26, 2020
The suitability of this product really depends on the use case. It is good if your company is using only Microsoft products and you don't want to use another stack. If you want to use other platforms then you should consider Snowflake, which is also deployed on Azure. It really depends on what it is that you need. I would rate this solution an eight out of ten.
Senior Project Manager at a tech company with 501-1,000 employees
Real User
2020-11-20T10:07:03Z
Nov 20, 2020
I'd recommend the solution to other organizations. If they have time, I would suggest a company spends more effort looking at some different offerings. That said, generally, if you don't have a whole lot of money to do something, it's a decent option. We haven't used the solution for too long, however, it's offered us everything we need in terms of features and capabilities. On a scale from one to ten, I'd rate it at an eight.
Software Engineer at a educational organization with 501-1,000 employees
Real User
2020-10-11T08:58:07Z
Oct 11, 2020
It is a powerful asset if we can use it and learn more about it. If Microsoft can give some free training sessions for students and amateurs, it would be helpful in knowing more about this product from inside. I would rate Microsoft Azure SQL Data Warehouse an eight out of ten.
Information Architect at a analyst firm with 201-500 employees
Real User
2020-09-13T07:02:24Z
Sep 13, 2020
Clients will look at Pro Dell Compare. They use the tool to determine how simple it is or how complicated it will be to move their data. They consider whether they need to make use of one of Microsoft's partners to have them help, or can they do it themselves, and they determine how risky it is along with how simple it will be. Will they have enough manpower, and whether or not they're going to have to hire external consultants to help them. They also consider whether they are going to move their applications or are they going to wait? and what's going to come first. They create a plan. You want your onsite team to look at, our use cases, look at what we're getting back for information, and then problem-solve. Think about any additional questions, and is this really feasible, because it's not free. You can start out using it for free for a short amount of time. Microsoft is improving and as they grow, I see that they are pushing towards the enterprise. If you don't quite fit, then you are pushed into it whether you are ready or not. You really have to consider where you want to be and what you are currently doing. Anyone looking to use Microsoft Azure SQL Data Warehouse, I would advise them to do the research, hire an architect, screen them well, and know their background to ensure that they are going to provide a service for you. Have them work alongside the project manager to identify the resources and what needs to take place and build a plan. I would rate this solution a nine out of ten.
We use the serverless platform as a service, that is only available with Microsoft Azure. You don't have to hire experienced engineers to set up and implement the solution, saving you money, because it is very intuitive and the turnaround time is very low compared to other data warehouses. I would put it in par with solutions such as Redshift and BigQuery. It's very modern, easy, and intuitive. Most of the services are cheaper than other vendors. This definitely falls into one of the top three or top four solutions and platforms in the world. I would definitely recommend it. If someone should ask me if they should use Microsoft Azure SQL Data Warehouse, I would say yes. Personally, I don't see one great solution that exceeds in all aspects. Every solution has some good points and I think they have very beautifully found their strength and they're building upon it. When asked what would best suit me, I would assess their environment requirements and could easily recommend any of the top four, being AWS Redshift, Google, Big Query, and Microsoft Azure. I would rate this solution an eight out of ten.
Director of Data Analytics Practice at a computer software company with 501-1,000 employees
Real User
2020-08-02T08:16:00Z
Aug 2, 2020
My advice would be to move your on-premises data warehouse to the cloud. Move it there faster, as you can get more performance gains and it's also a robust infrastructure. I would rate this solution an eight out of ten.
Sr. Teradata Consultant at a tech services company with 201-500 employees
Consultant
2020-07-29T07:45:56Z
Jul 29, 2020
We're a Microsoft partner. I have experience with the Microsoft Cloud Data Warehouse specifically within the Unix cloud environment. We're using the latest version of the solution. It's important for organizations considering the solution to consider their business requirements and expectations. They need to be clear about what type of cloud solution they are looking for. We help our clients do this and interview them to find out what their needs are so that the best platform can be chosen for them. It may be Azure. It may be Snowflake. It depends on the company's needs. At the end of the day, the customer will always want the best possible pricing. They'll typically ask how they can save money but have high throughput or more input with less price. If that's the case, Microsoft may be the perfect solution. I'd rate the solution eight out of ten.
Solution Principal at a computer software company with 5,001-10,000 employees
Real User
2020-07-12T11:48:49Z
Jul 12, 2020
The Azure SQL Data Warehouse has been renamed to Synapse, although not all of the features have been implemented yet. I am looking forward to a more mature version of this product in the future. I would rate this solution a seven out of ten.
Project Manager at a tech services company with 5,001-10,000 employees
Real User
2019-12-18T05:44:00Z
Dec 18, 2019
If you are using Microsoft products, such as Office 365, then this solution is good because it can take the data from multiple sources. This is a good product, but when you compare to Oracle Data Warehouse there are differences in scalability, high availability, and implementation. I would rate this solution a seven out of ten.
Analytics Engineer at a tech services company with 51-200 employees
Real User
2019-12-15T05:58:00Z
Dec 15, 2019
There are certain design concepts that can be used to design a data warehouse. My advice to anybody who is implementing this solution is to first study the user's needs, and then go with that approach. The design will be specific to the needs. I would rate this solution an eight out of ten.
The core strength of Microsoft technologies is ease of use and administration, regardless of the type of product. This is a good solution to go with, the cost is reasonable, and I recommend it. I would rate this solution an eight out of ten.
Practice Head BI at a tech vendor with 1,001-5,000 employees
MSP
2019-12-11T05:40:00Z
Dec 11, 2019
This solution is being changed from day-to-day. Now it has become Synapse Analytics and a lot of things are being added to it. I'm curious to see how that turns out. They have a lot of new integrations and features, including predictive analysis and big data integration. They may have solved the issues with concurrent connectivity, so I'm curious to put my hands on it. The product is being upgraded and updated to support a lot of analytic features, and it is a great tool to use. I would rate this solution a nine out of ten.
Managing Partner at a tech services company with 11-50 employees
Real User
2019-11-13T05:29:00Z
Nov 13, 2019
It's a nice solution for a simple data warehousing, but it's still an immature solution. It is stable but it takes a lot of time. Smaller companies have better products, but the problem will always be there and the smaller company will not survive. Customers will have tools that are not supported anymore. Microsoft is so big that people trust them, they will eventually get there but it will take time to get the features with quality. There are, however, some solutions available that are better and cheaper. You can purchase them instead of having to reprogram everything that you have already done. My advice would be to compare this solution with others. Snowflake would be a comparable solution. It's cheaper, faster, and better. I would rate this solution a seven out of ten.
Data Architect at a tech services company with 10,001+ employees
Real User
2019-11-13T05:28:00Z
Nov 13, 2019
My advice to other people considering this solution is that this is a great product. But there is one problem and that is the rate that Microsoft is changing its software implementations. The rapid changes could make it hard to keep up with upgrades. Some of the features get enabled and disabled very quickly. So we are waiting now until everything settles down because cloud technology is still evolving. We understand that. But, on the other hand, as they make so many changes to keep up with the technology, it remains hard to predict what the future of the product is. I might say to anyone that they wait for some time in 2020 and then start using the product. On a scale from one to ten where one is the worst and ten is the best, I would rate the product as somewhere between a seven or an eight. If I have to choose seven or eight, I would pick seven-out-of-10.
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
My advice for anybody researching this or a similar solution is to list the pros and cons, along with the price, and estimate your needs before starting the project. I would also suggest contacting support for Microsoft, Google, and Amazon. Finally, look into other, better-niched providers, like Teradata. Scaling this solution is easy and the uptime is okay. It is easy to use, and the support is excellent. My biggest complaint is the cost. I would rate this solution a nine out of ten.
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...
Definitely, it's the right approach. Always monitor your costs and optimize your database's performance. I'd rate the solution eight out of ten.
Overall, Microsoft Azure Synapse Analytics offers good integration, is user-friendly for data analysts, and helps in centralizing data. I'd rate the solution ten out of ten.
My advice would be to remain open to learning new things, particularly because working with Synapse Analytics requires a shift in mindset from traditional tools like SQL Management Studio to newer tools and approaches. I rate it an eight out of ten.
The tool's on-demand query capabilities help enhance our analytical tasks. I like the way the tool works, as I have people doing queries and an analyst doing a lot of stuff in the product. I love the way that we can manage Microsoft Azure Synapse Analytics. One person can maintain the tool. I rate the tool a seven out of ten.
Microsoft Azure Synapse Analytics is a cloud-based solution. Since we are migrating, the cost is high. We assume the cost will be reduced post-migration, increasing the company's profitability. Microsoft Azure Synapse Analytics will be more profitable for any company in the long run. I would recommend the solution to other users. Overall, I rate the solution an eight out of ten.
Overall, I would rate the solution a nine out of ten.
It's about how it integrates into your work. If it's easy to integrate into your workflow, then I'd recommend it. It's quite easy to use, scalable, and has good processing time. Those are the major things for me. It's easy to use, scalable, and integrates well, then it's a good choice. Overall, I would rate the solution an eight out of ten.
Microsoft is a good platform because it's compatible with data warehouse, power analytics, and visualization, and you now have excellent machine learning and AI tools like GPT-4. The platform is also very stable, and support can be migrated for software. I rate Microsoft Azure Synapse Analytics a ten out of ten.
On a scale from one to ten, I would rate Microsoft Azure Synapse Analytics at seven. Other solutions have more user-friendly and intuitive interfaces.
This is the first solution that we are trying out. But if we plan to compare it with another solution called Snowflake, it will open up more dimensions for our thoughts to work. However, based on what we have achieved so far, I can rate it as an eight out of ten overall.
It has been good so far. I'd recommend it to others. I'd rate it an eight out of ten.
I would recommend using Microsoft Azure Synapse Analytics because it includes everything from integration to transformation and storage. Overall, I would rate the solution an eight out of ten.
I give the solution a nine out of ten. Depending on the organization's use case, there are multiple options available. For example, if the workload is medium, there are different products available such as Azure SQL Database for small or medium-sized data, and Azure Synapse Analytics for extremely large volumes of data. Ultimately, it is the use case of the organization that will determine the need for these particular services.
On a scale from one to ten, I would rate Microsoft Azure Synapse Analytics at eight.
There is going to be competition in the market with the release of SAP Cloud Analytics. The solution does not require maintenance because it is sized-based. I would recommend this solution to others. I have evaluated the fact sheet on the solution. I rate Microsoft Azure Synapse Analytics an eight out of ten.
Once a service is managed as a service in a cloud platform, the maintenance is very easy. You have to monitor it, but the maintenance infrastructure is extremely easy. This solution is very easy once you have a Microsoft Azure subscription to go straight to Microsoft Azure Synapse Analytics because it's native. However, there are other kinds of technologies one can use. I would suggest before using this solution, look at other solutions, such as Databricks or Snowflake, and not stop at the first solution that you can receive in Microsoft Azure. I rate Microsoft Azure Synapse Analytics an eight out of ten.
We are Microsoft partners. Potential customers should check out the ease of management. This solution is easier to maintain compared toother options. I'd rate the solution seven out of ten. There are some challenges related to this replication and then there is quite a lot of design thinking to be done.
My advice to others is they should leverage other Azure components if they can. If they are looking for an integrated solution that's easy to use, they should look at competitors. I rate Microsoft Azure Synapse Analytics an eight out of ten.
I rate the solution an eight out of ten.
I'd give Synapse Analytics a rating of seven out of ten.
We buy direct from Microsoft. Our company may be partners with them. As Microsoft Azure Cloud, it only has one version. I don't know if there is a version number. I would advise users to start loading the data beforehand and understand very well how the tool works and how it's useful. That way, you can evaluate the best solution. Sometimes you need to start to load data and review all the alternatives in the solution. I’d rate the solution a nine out of ten.
I'd recommend this solution to other users. I'd rate the solution eight out of ten.
I rate Azure Synapse Analytics eight out of 10. No competitors provide the entire solution to one place like Synapse. For example, a database just focuses moving and manipulating data, etc. But Synapse is like an all-inclusive workspace. I advise other people to go with Databricks Notebook if you need a computation engine. It has a solid SQL storage procedure. Suppose you are dealing with complex transformation logic and manipulation of run-time data flows. In that case, it's better to use Databricks than any Microsoft ADF. DataBricks looks more promising in terms of computing in memory, so we integrated Databricks in Synapse.
While we do not have a business relationship with Azure, we are trying to become partners. Most of our implementations happen on Azure itself. Wherever we go, we take the solutions and we go to the other customers and we propose them. We tend to recommend this solution. I'd rate the solution seven out of ten. There is a scope for improvement. Eventually, as they come across different case by case, they'll enhance things. Currently, what I see here is the data governance part is missing here from a development life cycle point of view.
My advice to those wanting to use this solution is to start small to get an understanding of how it operates. I rate Microsoft Azure Synapse Analytics a nine out of ten.
I would recommend others to use this product but urge them to understand that it is more of a technical database used to prepare data as opposed to serving it. I would rate this solution a seven out of ten.
Be sure to be clear about the ideal pipeline for Synapse, differentiate your needs, and validate based on use-case. I would rate this solution a six out of ten overall.
There are many available versions of Azure Synapse, such as Azure Synapse SQL Datawarehouse, Azure Synapse Analytics, and Azure Synapse Analytics workspace. You need to be aware of the features that you are looking for and accordingly choose the offering. I would rate it a five out of 10.
One of the main pros of Synapse is the ability to work with the classic data warehouse and the big data. Another is the ability to use the Spark engine for preparation. Before implementing this product, consider whether it will provide the results you want. If you are already using Microsoft products, Synapse is easy to integrate. I would score this solution as eight out of ten.
I would recommend this solution to others. The client that I am working for, their preferred database is Synapse. I rate Microsoft Azure Synapse Analytics a seven out of ten.
We're just customers and end-users. My company does not have any relationship. It's our client who has a relationship with Microsoft. I'm not sure which version we are using, however, I would guess it is the latest version. I'm not 100% sure. Since the solution is still new to me, and I am having issues with performance, it's too early to say if I would recommend the solution to other users or companies. I'd rate the solution at an eight out of ten.
It is beneficial to always plan exactly what the main aims are and then choose the solution that can do it. If you want something quick, I set something up without any knowledge with Azure in three weeks. Once you get going, everything will be at your fingertips. I rate Microsoft Azure Synapse Analytics an eight out of ten.
My advice to those wanting to implement this solution would be to "Think big and act small." See what is up ahead. One of the organizations that I am working for, the big picture is population health management. We are not going to start with that, we are going to start to improve one small process, which is a cumbersome process that is been difficult for many years. That is the process that we are going to make transparent towards the organization, to see where the bottlenecks could be or are, and improve that process. We want the user experience to improve and that the amount of time you can save is monitored, which can be used for other care processes. Start with a cumbersome problem, resolve them first. You can actually tell within the organization, if the solution is already working, not on the larger scale, but on the small scale. Once you start seeing these results move on to the next problem. The solution is secure. However, the organization has to be aware that if you use the security by default, the security is there. It has security by design. It is not the optimal security, I would always recommend that organizations use multi-factor authentication for an additional security layer. Additionally, if possible, have a next-generation firewall within their network in use or, if not, start implementing that if they are planning to move forward into an outsource Azure platform-based eco landscape. I rate Microsoft Azure Synapse Analytics an eight out of ten.
I rate this solution a nine out of 10.
I would rate Microsoft Azure Synapse Analytics a nine out of ten.
We are both partners and end-users of the product. We use it internally and we use it with some of our clients. I would caution new users that there is one parameter they need to watch carefully. That is the size of the data warehouse. If you don't configure this parameter to be as small as possible, your costs will be quite high. I would rate the solution at a seven out of ten. It's a stable platform, however, the price model is questionable in comparison to Amazon and Google and the contact with support is a problem for me.
We are using the latest version of the solution. I would rate the solution at an eight out of ten. I would recommend Synapse, however, it depends on which industry an organization is working in. It can be complex, and often, you have to choose between several tools. They're all able to do the same job, they're just more industry-specific in some cases. If you want to transform your data, you can choose between the database, data factory, and SQL, and even other tools. This means it is very flexible, however, it also makes it difficult to administer. It's not that one of these sources is harder per se. It's more about what is the best for the job. Sometimes you create something and it doesn't perform and you have to start from scratch.
I think Synapse Analytics is definitely better than the traditional high solution data solutions that we've previously used. It's definitely worth considering and I haven't come across anything negative, only advantages for now. I would rate this solution an eight out of 10.
I'm just an end-user and customer. I'd rate the solution at a seven out of ten. I'd rate them higher if they could make it more user-friendly in terms of those more sophisticated capabilities that the system offers. Also, the training requires long hours. That's something difficult to organize when people have to be allocated to specific training sessions, instead of being on the projects. There's a kind of complex way of balancing the possibility of some people using the more sophisticated solutions and getting trained.
I would recommend this solution to others. I rate Microsoft Azure Synapse Analytics a nine out of ten.
We're just end-users and customers. We don't have a business relationship with the organization. We're using the latest version of the solution right now. I'd recommend the solution to other organizations. I'd rate the solution at a nine out of ten.
There is always room for improvement with Azure Synapse Analytics, but for our use cases it works very well. I would rate Microsoft Azure Synapse Analytics a seven out of ten.
I would recommend this solution to others who are interested in using it. I think it's definitely something that they should consider. It's come a long way from where it started. It's just finished out a public preview and it's great if you're looking to combine a lot of tools into one and you're running a smaller shop. I think it's a great tool. I would rate this solution a seven out of ten.
I would rate this solution an eight out of ten.
I would highly recommend this solution to others who are interested in using it. We recommend it to our clients. It's exceptionally good, and our clients and other partners find it both stable and scalable. I would rate this solution a nine out of ten.
I highly recommend this solution to others, and we recommend it to our clients. Overall, it's exceptionally good. I would rate this solution a nine out of ten.
The suitability of this product really depends on the use case. It is good if your company is using only Microsoft products and you don't want to use another stack. If you want to use other platforms then you should consider Snowflake, which is also deployed on Azure. It really depends on what it is that you need. I would rate this solution an eight out of ten.
I'd recommend the solution to other organizations. If they have time, I would suggest a company spends more effort looking at some different offerings. That said, generally, if you don't have a whole lot of money to do something, it's a decent option. We haven't used the solution for too long, however, it's offered us everything we need in terms of features and capabilities. On a scale from one to ten, I'd rate it at an eight.
I would rate Microsoft Azure SQL Data Warehouse a nine out of ten.
It is a powerful asset if we can use it and learn more about it. If Microsoft can give some free training sessions for students and amateurs, it would be helpful in knowing more about this product from inside. I would rate Microsoft Azure SQL Data Warehouse an eight out of ten.
Clients will look at Pro Dell Compare. They use the tool to determine how simple it is or how complicated it will be to move their data. They consider whether they need to make use of one of Microsoft's partners to have them help, or can they do it themselves, and they determine how risky it is along with how simple it will be. Will they have enough manpower, and whether or not they're going to have to hire external consultants to help them. They also consider whether they are going to move their applications or are they going to wait? and what's going to come first. They create a plan. You want your onsite team to look at, our use cases, look at what we're getting back for information, and then problem-solve. Think about any additional questions, and is this really feasible, because it's not free. You can start out using it for free for a short amount of time. Microsoft is improving and as they grow, I see that they are pushing towards the enterprise. If you don't quite fit, then you are pushed into it whether you are ready or not. You really have to consider where you want to be and what you are currently doing. Anyone looking to use Microsoft Azure SQL Data Warehouse, I would advise them to do the research, hire an architect, screen them well, and know their background to ensure that they are going to provide a service for you. Have them work alongside the project manager to identify the resources and what needs to take place and build a plan. I would rate this solution a nine out of ten.
We use the serverless platform as a service, that is only available with Microsoft Azure. You don't have to hire experienced engineers to set up and implement the solution, saving you money, because it is very intuitive and the turnaround time is very low compared to other data warehouses. I would put it in par with solutions such as Redshift and BigQuery. It's very modern, easy, and intuitive. Most of the services are cheaper than other vendors. This definitely falls into one of the top three or top four solutions and platforms in the world. I would definitely recommend it. If someone should ask me if they should use Microsoft Azure SQL Data Warehouse, I would say yes. Personally, I don't see one great solution that exceeds in all aspects. Every solution has some good points and I think they have very beautifully found their strength and they're building upon it. When asked what would best suit me, I would assess their environment requirements and could easily recommend any of the top four, being AWS Redshift, Google, Big Query, and Microsoft Azure. I would rate this solution an eight out of ten.
I would recommend this solution to other enterprises. On a scale from one to ten, I would give this solution a rating of seven.
My advice would be to move your on-premises data warehouse to the cloud. Move it there faster, as you can get more performance gains and it's also a robust infrastructure. I would rate this solution an eight out of ten.
We're a Microsoft partner. I have experience with the Microsoft Cloud Data Warehouse specifically within the Unix cloud environment. We're using the latest version of the solution. It's important for organizations considering the solution to consider their business requirements and expectations. They need to be clear about what type of cloud solution they are looking for. We help our clients do this and interview them to find out what their needs are so that the best platform can be chosen for them. It may be Azure. It may be Snowflake. It depends on the company's needs. At the end of the day, the customer will always want the best possible pricing. They'll typically ask how they can save money but have high throughput or more input with less price. If that's the case, Microsoft may be the perfect solution. I'd rate the solution eight out of ten.
The Azure SQL Data Warehouse has been renamed to Synapse, although not all of the features have been implemented yet. I am looking forward to a more mature version of this product in the future. I would rate this solution a seven out of ten.
If you are using Microsoft products, such as Office 365, then this solution is good because it can take the data from multiple sources. This is a good product, but when you compare to Oracle Data Warehouse there are differences in scalability, high availability, and implementation. I would rate this solution a seven out of ten.
There are certain design concepts that can be used to design a data warehouse. My advice to anybody who is implementing this solution is to first study the user's needs, and then go with that approach. The design will be specific to the needs. I would rate this solution an eight out of ten.
The core strength of Microsoft technologies is ease of use and administration, regardless of the type of product. This is a good solution to go with, the cost is reasonable, and I recommend it. I would rate this solution an eight out of ten.
This solution is being changed from day-to-day. Now it has become Synapse Analytics and a lot of things are being added to it. I'm curious to see how that turns out. They have a lot of new integrations and features, including predictive analysis and big data integration. They may have solved the issues with concurrent connectivity, so I'm curious to put my hands on it. The product is being upgraded and updated to support a lot of analytic features, and it is a great tool to use. I would rate this solution a nine out of ten.
It's a nice solution for a simple data warehousing, but it's still an immature solution. It is stable but it takes a lot of time. Smaller companies have better products, but the problem will always be there and the smaller company will not survive. Customers will have tools that are not supported anymore. Microsoft is so big that people trust them, they will eventually get there but it will take time to get the features with quality. There are, however, some solutions available that are better and cheaper. You can purchase them instead of having to reprogram everything that you have already done. My advice would be to compare this solution with others. Snowflake would be a comparable solution. It's cheaper, faster, and better. I would rate this solution a seven out of ten.
My advice to other people considering this solution is that this is a great product. But there is one problem and that is the rate that Microsoft is changing its software implementations. The rapid changes could make it hard to keep up with upgrades. Some of the features get enabled and disabled very quickly. So we are waiting now until everything settles down because cloud technology is still evolving. We understand that. But, on the other hand, as they make so many changes to keep up with the technology, it remains hard to predict what the future of the product is. I might say to anyone that they wait for some time in 2020 and then start using the product. On a scale from one to ten where one is the worst and ten is the best, I would rate the product as somewhere between a seven or an eight. If I have to choose seven or eight, I would pick seven-out-of-10.
I will rate this solution an eight out of ten. Not a ten due to the lack of integration.
I would rate it a seven out of ten.
My advice for anybody researching this or a similar solution is to list the pros and cons, along with the price, and estimate your needs before starting the project. I would also suggest contacting support for Microsoft, Google, and Amazon. Finally, look into other, better-niched providers, like Teradata. Scaling this solution is easy and the uptime is okay. It is easy to use, and the support is excellent. My biggest complaint is the cost. I would rate this solution a nine out of ten.