We performed a comparison between Microsoft Azure Synapse Analytics and Oracle Big Data Appliance based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
"The solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge."
"The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is a benefit."
"The architecture, including compute and storage, is good."
"What I found most valuable in Microsoft Azure Synapse Analytics is that it's native only for Azure, so you get better performance and there's no issue. To explain further, many different types of data come, in particular, structured and unstructured data. For audit purposes, there's also unstructured data, so the most important aspect is that with Microsoft Azure Synapse Analytics, you have the capability of using both technologies, meaning that you can use or mix structured and unstructured data which is important. This can also be done in Hadoop, and on other platforms, so you have everything in one place. You don't have to worry about how to manage both structured and unstructured data and where to store information. With Microsoft Azure Synapse Analytics, you can take care of everything, particularly in Azure. The solution also provides you with many features apart from analytics, for example, storage which makes it better."
"I like SQL post, which is for storage and distributed computing. Another good feature is the copy activity."
"Fills the gap between big data and classic data warehouses."
"The solution has been working well overall."
"It's user-friendly and has a good dashboard."
"Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard."
"Indicating what areas need improvement in this solution is a difficult question because the organizations that I am working for are really new in this area. However, an even better more simple interface, or perhaps an extension of a connector app store solution, would be helpful."
"Microsoft Azure Synapse Analytics can improve by increasing the size of the files that we can load on the platform. We have some files that are too large to be loaded and it would be a benefit to us if the limit was increased. Additionally, the way we use the tool for generating reports can be made better. They should add some drag-and-drop rules without the need of programming these rules using some programming language. It would be helpful if we did not need someone that was technically advanced to be able to do it with, such as someone with no IT background. Having a reporting tool without code would be great."
"The performance and data consistency need to be improved."
"The filing can be improved."
"We'd, of course, always like to pay less for the service if we can."
"Scaling this solution up and down is not quick and easy. This could be improved. The pricing of this solution could also be improved."
"It could be more stable."
"I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head."
"From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 48 reviews while Oracle Big Data Appliance is ranked 13th in Data Warehouse with 1 review. Microsoft Azure Synapse Analytics is rated 7.8, while Oracle Big Data Appliance is rated 8.0. The top reviewer of Microsoft Azure Synapse Analytics writes "Multifeatured, has better performance over other solutions, and lets users manage structured and unstructured information, but the platform needs to be more user-friendly". On the other hand, the top reviewer of Oracle Big Data Appliance writes "Provides clean, centralized data ". Microsoft Azure Synapse Analytics is most compared with Snowflake, Amazon Redshift, Azure Data Factory, SAP BW4HANA and Apache Hadoop, whereas Oracle Big Data Appliance is most compared with Oracle Exadata, Apache Hadoop, Teradata, IBM Integrated Analytics System and IBM Netezza Performance Server.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
