Try our new research platform with insights from 80,000+ expert users
reviewer2125440 - PeerSpot reviewer
Senior Manager, Global Network Development at a comms service provider with 10,001+ employees
Real User
Scales well, has a wide range of features, and is easy to set up
Pros and Cons
  • "It's feature-rich. It has a wide range of features."
  • "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."

What is our primary use case?

It's used for business case analysis and bandwidth utilization, etc. 

We are using its latest version.

What is most valuable?

It's feature-rich. It has a wide range of features. 

What needs improvement?

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.

For how long have I used the solution?

I've been using this solution for more than four years.

Buyer's Guide
Microsoft Azure Synapse Analytics
March 2025
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
842,388 professionals have used our research since 2012.

What do I think about the stability of the solution?

It's quite stable. I'd rate it an eight out of ten in terms of stability. There are very few outages or errors during the configuration.

What do I think about the scalability of the solution?

It's scalable. I'd rate it an eight out of ten in terms of scalability. Our clients are enterprises. 

How are customer service and support?

I haven't contacted them, but it should be fairly good. I haven't had many issues with it.

How was the initial setup?

I'd rate it a nine out of ten in terms of the setup. It has a GUI, which is awesome. Its deployment duration varies based on the case to case. We have quite a few SMEs for deployment. 

It doesn't require many people for maintenance.

What other advice do I have?

It has been good so far. I'd recommend it to others. I'd rate it an eight out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.

PeerSpot user
Rich text editor
    Enterprise Solutions Architect at a consultancy with 1-10 employees
    Reseller
    Top 20
    Integrates well with other solutions, but the interface is not as user-friendly or intuitive
    Pros and Cons
    • "I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
    • "Real-time integration is hard to do in Microsoft Azure Synapse Analytics."

    What is our primary use case?

    We use it for reporting purposes and for building data warehouses, pipelines, and data lakes for IoT projects.

    What is most valuable?

    I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions. 

    What needs improvement?

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

    For how long have I used the solution?

    I've been using Microsoft Azure Synapse Analytics for two years.

    What do I think about the stability of the solution?

    I would rate the solution's stability at nine out of ten.

    What do I think about the scalability of the solution?

    For the amount of data that we have, Microsoft Azure Synapse Analytics has worked perfectly fine in terms of scalability. Thus, for us the scalability is a ten out of ten.

    How was the initial setup?

    The documentation is good, but if you cannot find the right documentation and the right steps, then the initial setup can be hard. I would rate the initial deployment at seven out of ten.

    This solution is deployed on the cloud, and it took half a day to deploy it. I configured the data lake storage, created the workspace, and added users and user rights. Building pipelines is a straightforward process.

    What's my experience with pricing, setup cost, and licensing?

    I think Microsoft Azure Synapse Analytics is priced well, and I would rate the price at eight out of ten.

    What other advice do I have?

    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.

    Disclosure: My company has a business relationship with this vendor other than being a customer: Partner and reseller

    PeerSpot user
    Rich text editor
      Buyer's Guide
      Microsoft Azure Synapse Analytics
      March 2025
      Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
      842,388 professionals have used our research since 2012.
      reviewer1466190 - PeerSpot reviewer
      Manager: Data Analytics at a consultancy with 1,001-5,000 employees
      Real User
      User-friendly, has a good dashboard, and meets the needs of our clients
      Pros and Cons
      • "It's user-friendly and has a good dashboard."
      • "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."

      What is our primary use case?

      We are using this product data warehousing and analytics.

      What is most valuable?

      Pretty much all of the features are valuable, including storage and compute. All of the features are essential to what you do.

      It's very reliable and cost-effective. It meets the needs of our clients.

      It's user-friendly and has a good dashboard.

      What needs improvement?

      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.

      For how long have I used the solution?

      I have been using Microsoft Azure Synapse Analytics for a couple of years.

      What do I think about the stability of the solution?

      It's a stable product and we're satisfied and comfortable with it. Our clients and partners have found it to be very stable and scalable, as well.

      What do I think about the scalability of the solution?

      Synapse Analytics is a scalable product.

      How are customer service and technical support?

      Generally, support from Microsoft is always good. I can't recall the specific instance where we had to contact them, but it was good.

      How was the initial setup?

      The initial setup is very straightforward. It only took five minutes to set up.

      What about the implementation team?

      We deployed the solution in-house, and we also deploy it for our clients.

      What's my experience with pricing, setup cost, and licensing?

      This is a cost-effective product.

      What other advice do I have?

      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.

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner

      PeerSpot user
      Rich text editor
        it_user1459005 - PeerSpot reviewer
        Data Architect at a tech services company with 51-200 employees
        Real User
        Good support, offers advanced threat protection, and it integrates well with Polybase
        Pros and Cons
        • "The most important feature for me is the integration with PolyBase."
        • "The need to improve a little bit in terms of user-friendliness."

        What is our primary use case?

        We are mainly using this solution as an interface between the Data Lake and the users.

        We are consultants and this product assists with the services that we offer for our clients. Our company has a large number of consultants who are working in this space.

        What is most valuable?

        The most important feature for me is the integration with PolyBase.

        Other valuable features for me are advanced threat protection and data privacy.

        What needs improvement?

        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.

        For how long have I used the solution?

        In total, I have been using Microsoft Azure Synapse Analytics for one year.

        What do I think about the stability of the solution?

        This is a stable solution.

        What do I think about the scalability of the solution?

        You can scale it, although you need to put in more effort. We have approximately 800 users.

        How are customer service and technical support?

        In general, Microsoft support is pretty good.

        Which solution did I use previously and why did I switch?

        I have experience with similar products such as Snowflake and Firebolt.

        How was the initial setup?

        The initial setup is very complex compared to other products. It takes weeks to deploy.

        What about the implementation team?

        We implement this product for our clients.

        What's my experience with pricing, setup cost, and licensing?

        The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte. The charge might be several thousand dollars or more each month.

        There are multiple options that are available at an extra cost. For example, the advanced threat protection costs an extra $25 USD.

        Which other solutions did I evaluate?

        We evaluated several options before choosing Synaps Analytics.

        What other advice do I have?

        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.

        Which deployment model are you using for this solution?

        Hybrid Cloud
        Disclosure: My company has a business relationship with this vendor other than being a customer: Partner

        PeerSpot user
        Rich text editor
          Senior Business Analyst: BI Team Lead at a logistics company with 1,001-5,000 employees
          Real User
          The architectural design is very scalable but the services are expensive
          Pros and Cons
          • "The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs."
          • "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."

          How has it helped my organization?

          We haven't really implemented any SSIS. I haven't been in a project where it was implemented as part of the data we have been building.

          What is most valuable?

          The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs.

          What needs improvement?

          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.

          For how long have I used the solution?

          I have been using this solution for around 18 months.

          What do I think about the stability of the solution?

          It is very stable.

          What do I think about the scalability of the solution?

          I think the architectural design is very scalable.

          How are customer service and technical support?

          I never contacted Microsoft customer support. 

          We do have access to it, but we haven't needed to.

          Which solution did I use previously and why did I switch?

          I've used Tableau, I've used SQL DB, I've used SAP DB.

          How was the initial setup?

          The initial setup wasn't complex. It was okay. It wasn't complex at all.

          To set it up within full compliance with our cloud infrastructure team, I'd say maybe two weeks after beginning our testing. I'd say the team wasn't a hundred percent devoted to setting it up as they had other things to do. So I'd say I'll give it two weeks to be realistic for a large organization.

          What about the implementation team?

          It depends on whether you have those resources internally or not. If you have internal resources you wouldn't need to outsource, if you don't have, you would. So it's not a matter of how good that application is but a question of whether you have the capability in house.

          What's my experience with pricing, setup cost, and licensing?

          The enterprise services are pretty expensive.

          Which deployment model are you using for this solution?

          Public Cloud
          Disclosure: I am a real user, and this review is based on my own experience and opinions.

          PeerSpot user
          Rich text editor
            reviewer1524705 - PeerSpot reviewer
            Senior Systems Analyst at a non-profit with 201-500 employees
            Real User
            Easy to use, good performance, and useful documentation
            Pros and Cons
            • "The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
            • "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."

            What is our primary use case?

            We have been using Microsoft Azure Synapse Analytics as our proof of concept in our data warehouse. As for the analytics part, we have not used it because we do not have any SQL pools. We think it is a bit more than we need because our data is not implicated and the data sets are not very large. It is mostly been used for the detection functions and to link up the sources.

            What is most valuable?

            The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services.

            What needs improvement?

            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.

            For how long have I used the solution?

            I have been using Microsoft Azure Synapse Analytics for approximately six months.

            What do I think about the stability of the solution?

            The solution is incredibly stable. 

            The only thing that has not been stable are the pipelines that we are using runtime integration on our on-premise server and something is slowing everything down, it might be a particular ODBC connection. I am not sure if that is due to the Microsoft platform or it might be some other setup or settings that are causing the issue. However, other than this issue, the solution has been brilliant. It has been very reliable and stable.

            What do I think about the scalability of the solution?

            The solution is scalable. I have changed the interface and most of the operations can be done from the interface by clicking a few buttons, it is quick and easy.

            At the moment we only have approximately four people using the solution because it is a data warehouse creation in the back end. We have not reached the stage where our staff will use the product but we are building a single customer view using the platform and we will be increase usage in the future.

            How was the initial setup?

            The initial installation is straightforward. There is a lot of documentation provided by Microsoft making it very easy to get started.

            What was our ROI?

            Having used the serverless option for the database has saved us a lot of money.

            What's my experience with pricing, setup cost, and licensing?

            We chose the serverless option for the database which has saved us a lot of money. Our costs are approximately £600 per month.

            What other advice do I have?

            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.

            Disclosure: I am a real user, and this review is based on my own experience and opinions.

            PeerSpot user
            Rich text editor
              Mullai Selvan - PeerSpot reviewer
              Project Manager at MAQ Software
              Real User
              Very scalable with good documentation and fair pricing
              Pros and Cons
              • "The pricing seems to be quite fair."
              • "The initial setup has a bit of a learning curve."

              What is our primary use case?

              We are an IT service provider. We develop solutions for our clients and this solution is used in some aspects of that.

              What is most valuable?

              The dashboards are good.

              We haven't had any issues when it comes to customization.

              The security seems to be okay. It hasn't given us any problems and we don't feel insecure.

              The pricing seems to be quite fair.

              I know their roadmap, and I am looking forward to what they have already published.

              We've been happy with the level of reporting and documentation on offer.

              What needs improvement?

              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.

              For how long have I used the solution?

              We've been using the solution for the past 18 months so far.

              What do I think about the stability of the solution?

              The solution seems to be scalable. We haven't had any issues with bugs or glitches. It doesn't crash or freeze. It's quite good.

              What do I think about the scalability of the solution?

              The scalability has been pretty good, in our experience. We have been able to scale it twice to the number of users we needed. We were also able to double the amount of data load. We haven't had issues. If a company needs to expand, it should be able to do so without problems.

              How are customer service and technical support?

              We've dealt with technical support and have found them to be quite responsive and knowledgeable. We're quite satisfied with the level of support we have been getting so far. They're helpful.

              How was the initial setup?

              It's hard to gauge the difficulty or simplicity of the setup. For our company, we were learning the processes as we were doing it. In that sense, it was challenging due to the fact that we had to learn and then do. After a period of time, we were able to get comfortable.

              What about the implementation team?

              We handled the implementation ourselves. We taught ourselves about the process as we went.

              What's my experience with pricing, setup cost, and licensing?

              We pay a licensing fee on a monthly basis. We find the pricing to be fair among the competition.

              What other advice do I have?

              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.

              Which deployment model are you using for this solution?

              Public Cloud
              Disclosure: I am a real user, and this review is based on my own experience and opinions.

              PeerSpot user
              Rich text editor
                reviewer1466190 - PeerSpot reviewer
                Manager: Data Analytics at a consultancy with 1,001-5,000 employees
                Real User
                Cost-effective, reliable data warehousing that is user-friendly, and it is easy to scale
                Pros and Cons
                • "They are very reliable and cost-effective."
                • "I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head."

                What is our primary use case?

                We are using this solution for data warehousing and analytics.

                What is most valuable?

                Pretty much all of the features are valuable. The storage, compute, all essentially differentiate what you do.

                They are very reliable and cost-effective. It meets the client's requirements.

                It's user-friendly, has a good dashboard, and my team is happy with everything.

                What needs improvement?

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

                For how long have I used the solution?

                I have been using this solution for a while, I would say approximately two years.

                We are using the latest version. It's always updated on the cloud.

                What do I think about the stability of the solution?

                We found it to be a very stable product.

                What do I think about the scalability of the solution?

                It's a scalable solution and we find it to be easy to scale.

                How are customer service and technical support?

                Generally, support from Microsoft is always good.

                I can't recall where we had an issue that we had to contact technical support, but the support is very good.

                How was the initial setup?

                The initial setup was very straightforward. It took only five minutes to set up.

                What about the implementation team?

                We completed the deployment in-house, we did it ourselves. We also implement it for our clients. 

                It's pretty straightforward, we do not need help with this.

                What's my experience with pricing, setup cost, and licensing?

                Because it's a cloud solution, the cost is a different convention and the licensing costs are not the same.

                What other advice do I have?

                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.

                Which deployment model are you using for this solution?

                Public Cloud
                Disclosure: My company has a business relationship with this vendor other than being a customer: Partner

                PeerSpot user
                Rich text editor
                  Buyer's Guide
                  Download our free Microsoft Azure Synapse Analytics Report and get advice and tips from experienced pros sharing their opinions.
                  Updated: March 2025
                  Product Categories
                  Cloud Data Warehouse
                  Buyer's Guide
                  Download our free Microsoft Azure Synapse Analytics Report and get advice and tips from experienced pros sharing their opinions.
                  ...
                  ...