We mainly use this product for real-time data injection and reporting purposes.
Cloud Enterprise Architect at a tech services company with 10,001+ employees
A scalable, easy to use solution with a cost-effective licensing style
Pros and Cons
- "We find the query editor feature of this solution extremely valuable for our business."
- "The solution doesn't handle large data packets very efficiently, which could be improved upon."
What is our primary use case?
What is most valuable?
We find the query editor feature of this solution extremely valuable for our business.
Also, the multiple window types that are available in this solution, are extremely helpful.
What needs improvement?
The solution doesn't handle large data packets very efficiently, which could be improved upon.
We would also like more variation in the output types that this solution can produce.
For how long have I used the solution?
We have been using this solution for three or four years.
Buyer's Guide
Azure Stream Analytics
December 2024
Learn what your peers think about Azure Stream Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
What do I think about the stability of the solution?
The stability of this solution was problematic initially, but it has improved as later versions have been released, and is now very good.
What do I think about the scalability of the solution?
We have found this product to be easily scalable.
How was the initial setup?
The initial setup of this solution is very easy, and the deployment takes place instantly.
What's my experience with pricing, setup cost, and licensing?
The licensing for this product is payable on a 'pay as you go' basis. This means that the cost is only based on data volume, and the frequency that the solution is used.
What other advice do I have?
This solution is easy to use and has good fault tolerance, so I would recommend it to other organizations.
I would rate this solution an eight 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
Collaboration Consultant at a tech services company with 201-500 employees
It is good for real-time analytics, but requires some development skills
Pros and Cons
- "Real-time analytics is the most valuable feature of this solution. I can send the collected data to Power BI in real time."
- "It is not complex, but it requires some development skills. When the data is sent from Azure Stream Analytics to Power BI, I don't have the access to modify the data. I can't customize or edit the data or do some queries. All queries need to be done in the Azure Stream Analytics."
What is our primary use case?
I used it once for a project demo to a customer for an IoT solution. In this demo, the data was collected from the sensors, and it was sent to Power BI reports. The collected data was analyzed by using the analytics tools to get some insights.
This project was the first project for our company to start the development of IoT solutions. We have only used it for a demo, and we have kept it for demo for other customers. If any customer wants to deploy it, we would use it in production.
What is most valuable?
Real-time analytics is the most valuable feature of this solution. I can send the collected data to Power BI in real time.
What needs improvement?
It is not complex, but it requires some development skills. When the data is sent from Azure Stream Analytics to Power BI, I don't have the access to modify the data. I can't customize or edit the data or do some queries. All queries need to be done in the Azure Stream Analytics.
For how long have I used the solution?
I have used this solution for a few months.
What do I think about the stability of the solution?
I don't know about its stability because we didn't use it in production. We only used it for testing.
What do I think about the scalability of the solution?
Its scalability is okay. In Azure Stream Analytics, I can add more data sources through reference or IoT hub.
For the demo, we had a team of 20 users. The customer was looking at allowing around 20,000 users for this solution.
How are customer service and technical support?
I contacted their technical support once because I found an issue with Azure Stream Analytics. The technical support engineer was very supportive.
How was the initial setup?
The initial setup was straightforward for me. I read some articles on the Internet, and it worked fine for me. It took us one to two weeks to deploy it.
What other advice do I have?
If you want to deploy IoT services, this solution will be very helpful for real-time applications and for collecting data.
I would rate Azure Stream Analytics a seven out of ten.
Which deployment model are you using for this solution?
Private Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. The reviewer's company has a business relationship with this vendor other than being a customer: Partner
Buyer's Guide
Azure Stream Analytics
December 2024
Learn what your peers think about Azure Stream Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
Team Lead at a tech services company with 1,001-5,000 employees
Easy provisioning, helpful support, and straightforward setup
Pros and Cons
- "The most valuable features of Azure Stream Analytics are the ease of provisioning and the interface is not terribly complex."
- "Azure Stream Analytics could improve by having clearer metrics as to the scale, more metrics around the data set size that is flowing through it, and performance tuning recommendations."
What is our primary use case?
We are using Azure Stream Analytics for small to medium size streaming datasets where you would like to flag patterns from the stream. It works well or pairs well with IoT edge scenario use cases that are on Azure. If you have exceptional conditions, such as a sensor being way off the average for the last one to five hours, then you can flag a scenario. It works well with the IoT infrastructure that Azure provides.
How has it helped my organization?
We didn't end up using Azure Stream Analytics in production, or for a client, we implemented it. However, Azure Stream Analytics is something that you can use to test out streaming scenarios very quickly in the general sense and it is useful for IoT scenarios. If I was to do a project with IoT and I needed a streaming solution, Azure Stream Analytics would be a top choice.
What is most valuable?
The most valuable features of Azure Stream Analytics are the ease of provisioning and the interface is not terribly complex.
What needs improvement?
Azure Stream Analytics could improve by having clearer metrics as to the scale, more metrics around the data set size that is flowing through it, and performance tuning recommendations.
For how long have I used the solution?
I have been using Azure Stream Analytics for approximately three months.
What do I think about the stability of the solution?
Azure Stream Analytics is stable.
What do I think about the scalability of the solution?
Azure Stream Analytics can improve the scaling and the connectivity to external datasets.
We are not using this solution extensively and we do not plan to increase usage.
How are customer service and support?
The level of support quality depends on how much you purchased.
I rate the support from Azure Stream Analytics a four out of five.
How would you rate customer service and support?
Positive
How was the initial setup?
The initial setup of Azure Stream Analytics was straightforward. It has a quick startup time and is easy to start.
What about the implementation team?
I did the implementation of Azure Stream Analytics for my client. We have the developer setting the solution up and once it's in production, your infrastructure team can monitor it just like any other solution. Since it's Azure, it has a lot of metrics that allow you to be proactive to flag an issue if there is one.
What was our ROI?
I have seen a return on investment with Azure Stream Analytics. If you're not doing terribly complex scenarios, this is a quick and fast way to have your streaming pipeline set up. You won't have to invest a lot into its deployment because it's the cloud. You are not paying any upfront capital.
What's my experience with pricing, setup cost, and licensing?
I rate the price of Azure Stream Analytics a four out of five.
Which other solutions did I evaluate?
I have evaluated other solutions, such as Databricks
What other advice do I have?
Azure Stream Analytics it's good for proofs of concept and for scenarios that are not too complex. It's promising in the future, but if you start to scale out, you might want to consider other scaling solutions, such as Databricks.
Got it. And do you see a return on investment with this one?
I rate Azure Stream Analytics 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: I am a real user, and this review is based on my own experience and opinions.
Senior Xamarin Developer at Ezyhaul
Valuable life cycle, report management and crash management features but it requires more detailed analytics
Pros and Cons
- "The life cycle, report management and crash management features are great."
- "The solution could be improved by providing better graphics and including support for UI and UX testing."
What is our primary use case?
Our primary use case involves using the app centre to retrieve lifeline data. However, the lifeline is not retrievable from the app centre due to recent changes, so we get it from Azure.
What is most valuable?
The life cycle, report management and crash management features are great.
What needs improvement?
The product could be improved by providing more detailed analytics. For example, a graph to identify the past, present and current users. Additionally, UI and UX testing could be supported on this solution.
For how long have I used the solution?
We have been using this solution for approximately 3 years on-premises.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
The solution is scalable. We can add users when needed. Over 50 employees, including developers and QA managers use this product in our company.
How are customer service and support?
We do not have any experience with customer service and support.
How was the initial setup?
I cannot comment on the initial setup process because my manager set it up.
What's my experience with pricing, setup cost, and licensing?
I am unsure of what the licensing costs are for this solution.
What other advice do I have?
I rate this solution a six out of ten because we do not use it very often. I believe this solution has a good user interface but the solution could be improved by providing better graphics and including support for UI and UX testing.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Software Quality Assurance Analyst at M-KOPA
A scalable solution with efficient SQL features
Pros and Cons
- "The solution's most valuable feature is its ability to create a query using SQ."
- "The solution's interface could be simpler to understand for non-technical people."
What is our primary use case?
We use the solution to analyze application logs. It helps review incidents and production issues.
What is most valuable?
The solution's most valuable feature is its ability to create a query using SQ.
What needs improvement?
The solution's interface could be simpler to understand for non-technical people. Also, the chart feature could be more user-friendly. Presenting or elaborating on an incident to management or executives from other non-technical departments becomes challenging. We have to create another graph and include it in the presentation slides.
For how long have I used the solution?
We have been using the solution for two years.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
The solution is scalable. We have around more than 100 developers using it.
How are customer service and support?
We follow virtual documentation in case of technical errors for the solution.
What other advice do I have?
If you have Azure DevOps or are using the Azure ecosystem, you must go for the solution. I rate it an eight out of ten.
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Consultant
A serverless scalable event processing engine with a valuable IoT feature
Pros and Cons
- "I like the IoT part. We have mostly used Azure Stream Analytics services for it"
- "The collection and analysis of historical data could be better."
What is our primary use case?
The company I'm working for is basically one of the biggest companies in the entire Gulf region, including Dubai, Qatar, and Oman. Our core domain is providing logistics. They have different warehouses across the country, and we use it to track the movement of forklifts and people working at the warehouses.
The main thing we are focusing on right now is accident avoidance. For example, one forklift is coming through one aisle, and another person is trying to enter the same aisle. We provide a solution that can track the person and forklift in real-time.
We're also using it to solve many business problems one by one. Stream Analytics plays a major role in streaming all these huge datasets because we have warehouses spread across the country. It's able to handle millions and millions of events in a few seconds.
How has it helped my organization?
If we're not using Stream Analytics, how can we track the real-time? From the end user's perspective, Stream Analytics forms the main backbone for the entire pipeline and all the technologies.
The company can see the real-time location and track everything, just because of Stream Analytics. Without Azure Stream Analytics, we can't do any real-time tracking. We can use other messaging systems like SQL, but when it comes to scaling, collecting, getting a lot of events, recalling it, find out where it's used, Stream Analytics is better. You might have to collect from millions and millions of services and devices and beacons. All of that would be pushing the data into the Stream Analytics.
What is most valuable?
I like the IoT part. We have mostly used Azure Stream Analytics services for it. This is the most valuable part because this is using the streaming service. It's valuable because there's no other way for us to handle it.
It has the support of Azure storage, long storage, and access data. It has support from the SQL server. Azure also supports added access to data because we need the data from static data and dynamic data to represent them, and that's not going to change very frequently.
When we are getting the warehouse's location through this stream analytics, we have to merge some information from our static database, and finally, we have to show it all within a dashboard or something on the map.
Without the streaming analytics part, I don't think it's possible to handle it. We can use some other messaging system, but we might have some scaling issues and among others too. I know that Stream Analytics is fantastic in that we don't have to worry about any other activities. We can further scale it too. We can go for the upgraded service if needed, based on our traffic and the number of data we have been receiving.
Natively, I found it beneficial, and the integration was smooth. We're already using some other Microsoft technology packs, so it's easy to integrate them all.
As the Stream input and output enables very smooth integration with other cloud services, for example, Azure Cloud Concepts, or Cosmos DB, with minimum coding, and with the minimum level of queries, we can directly output all these outputs and push the normal data for historical data storage.
What needs improvement?
The collection and analysis of historical data could be better. We use historical data and an assimilating algorithm to give us insights into the entire business process.
We can collect all the historical data periodically to get insights into current business trends. For example, which area is getting emptied most of the time or which area is getting underutilized, and so on.
For how long have I used the solution?
I've been working with Azure Stream Analytics for about two years.
What do I think about the scalability of the solution?
We don't have to worry about scalability. It's in the cloud and can have millions and millions of things connected. The software part is easy to scale. You just have to add all the hardware. For the web application, the hosting part can be scaled. We don't have to worry about the desktop as the solution is deployed in the cloud. The scalability is based on our choices. It's not like it's manually hosted in private, and we have to scale it vertically.
How are customer service and technical support?
Our infrastructure team has the flexibility to call the Microsoft guys to look into the matter if there is something wrong on their part.
How was the initial setup?
The initial setup was very complex because of the hardware. We had to spend almost an entire day just to put the hardware part in the right places, following some best practices.
It took us more than one and a half years, and we're still left with some deployments to do. We initially tested it in a few small areas, and then we expanded it to cover the entire area.
I found it a little challenging, we struggled, and we did it. We're still doing a lot of stuff for the elite features and other deployments. We follow the deployment strategy, and it's almost automated. We're trying to add a few features and deploying them. The final stage of deployment is where the rest of the entire process is done through continuous integration.
It requires maintenance in terms of hardware and the software part. I don't think any solution is totally bug-free. We generate service requests all the time, and they are fixing it.
The IoT hardware requires more maintenance because we know we have limited battery life, and we have to check all the devices. We need to keep checking those things, and we have automated that. But it still needs to be manually reconnected to the battery.
What about the implementation team?
We have a team of people supporting this project. We have about ten members, some of whom were core developers. Four or five developers developed the cloud part. Two hardware engineers were responsible for all these deployments in the warehouse.
What other advice do I have?
I would advise potential users to properly plan and structure their static data and the reference data before putting it into the Stream Analytics.
On a scale from one to ten, I would give Azure Stream Analytics an eight.
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
BI Developer at a tech services company with 51-200 employees
Great integration with other Azure resources, is simple, and has been a great time-saver for us
Pros and Cons
- "Provides deep integration with other Azure resources."
- "If something goes wrong, it's very hard to investigate what caused it and why."
What is our primary use case?
Our primary use case is mainly to ingest real time data streams into permanent storage places like databases, block storage, etc.
How has it helped my organization?
The biggest improvement for us has been that it now takes much less time for us to receive valuable information. Basically, as soon as it appears in our real time data source, in a matter of seconds, it is already in our database.
What is most valuable?
The value of this solution is the deep integration it provides with other Azure resources which we use a lot. Our whole infrastructure is pretty much based on Azure so ease of integration is a valuable feature. Secondly, the simplicity of the solution is great. You don't need to set up much, you just make a selection, select a destination, and you're off.
What needs improvement?
There are some improvements that could be made, first of all in pricing, because right now the pricing is a bit unclear. It's hard to estimate how much of that is a local issue but you can't figure out how prices are calculated or the proprietary part of the cost. Another area that could be improved is that if something does go wrong, it's very hard to investigate what caused it and why. The logging is available but it lacks detail and doesn't provide much information.
For how long have I used the solution?
I've been using this solution for two years.
What do I think about the stability of the solution?
The solution has an acceptable level of stability although, as mentioned, if it does fail, it's pretty difficult to find out the cause.
What do I think about the scalability of the solution?
It's very easy to scale this solution. We probably have a couple of hundred users and we have developers who deal with maintenance. This is our main tool for real time data streaming.
How was the initial setup?
The initial setup is quite straightforward. Because of the good integration, you select your real time data, store the destination where you want to write it and you probably don't even need to transform with data. You basically create a mapping descent source. We had a proof of concept in place, so I would say deployment took two working days without having a deployment plan.
What was our ROI?
We have a good ROI because we are able to deliver solutions very quickly and customers are happy with that.
Which other solutions did I evaluate?
We evaluated and carried out a comparison with Oracle. The results were pretty much the same for both in terms of real time data streams, but were very much tied to their own cloud solutions. If you work with Oracle i'ts probably best to go with Amazon.
What other advice do I have?
My simple advice would be to not scale up initially. Also, if you have questions don't just rely on the official documentation, but use other resources such as a blog by a developer, because sometimes that can be more helpful than documentation provided by the company.
The best advice I can offer would be that if there is a simple solution available, do not try to complicate things.
I would rate this solution an eight out of 10.
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.
Business Architect Expert at a government with 51-200 employees
Stable, with a quick setup and lots of functionality
Pros and Cons
- "The solution has a lot of functionality that can be pushed out to companies."
- "The solution offers a free trial, however, it is too short."
What is most valuable?
When it comes to doing partitioning for the data, if you are working with both ModiB and MongoDB, it's very powerful in Microsoft Azure - the clustering platform. If it's Spark Apache, Spark will be very powerful due to the fact that you have the option to have the Delta factory, which makes all that things available within the platform.
It allows you to take a proactive decision for any abnormal functionality. For IoT, it will give you the facility to make quick decisions on any kind of metrics or output, et cetera.
The solution has a lot of functionality that can be pushed out to companies. There's a lot of analytics to take advantage of. What they have available on the market now is more than enough for companies to work with.
You can install the solution quite quickly and start using it right away.
What needs improvement?
While it depends on the business scenario, in some cases AWS offers better features. It's hard to speak to missing features at it really depends on the business case. However, in general, it has all the features a typical company might need.
The solution needs to be marketed better. Developers should be pushed or enticed to use the solution more to get it more well-known on the market. It needs more of a presence.
The solution offers a free trial, however, it is too short. You can't really properly test it before you have to start paying. They need to give companies a longer period of time to try it out risk-free. Also, the functionality is very limited. If you want to do a POC, you need the solution to offer more flexibility. Right now, you get a 14-day window, and that's not enough for a proper test.
For how long have I used the solution?
I've used the solution in the past 12 months.
What do I think about the stability of the solution?
The solution is very secure. Occasionally we might get a bug or to, however, this typically happens outside of the solution. If you are within the scope of Azure, it functions very well and there is good support from Microsoft if you run into issues. Basically, there are no major bugs or glitches to contend with, unless you have a design flaw. It works quite well.
What do I think about the scalability of the solution?
Scaling is okay, so long as the cluster isn't overloaded.
How are customer service and technical support?
Microsoft offers excellent technical support. They are very helpful and supportive. We are quite satisfied with the level of service they provide.
How was the initial setup?
The initial setup is very fast. You can set it up and just start using it. In that sense, it's great. A company shouldn't have any issues with getting it up and running.
What's my experience with pricing, setup cost, and licensing?
The product does have a free trial offer, however, it is much too short. It's only 14 days and that's not enough time to run a proper POC.
What other advice do I have?
Overall, we've been quite happy with the product. I would rate it at a nine out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Azure Stream Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2024
Product Categories
Streaming AnalyticsPopular Comparisons
Databricks
Confluent
Amazon Kinesis
Apache Flink
Amazon MSK
Google Cloud Dataflow
PubSub+ Platform
Apache Spark Streaming
Apache Pulsar
Aiven Platform
IBM Streams
Buyer's Guide
Download our free Azure Stream Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which would you choose - Databricks or Azure Stream Analytics?
- How do you select the right cloud ETL tool?
- What is the best streaming analytics tool?
- What are the benefits of streaming analytics tools?
- What features do you look for in a streaming analytics tool?
- When evaluating Streaming Analytics, what aspect do you think is the most important to look for?
- Why is Streaming Analytics important for companies?