Azure HDInsight vs. IBM Db2 Big SQL

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure HDInsight
Score 4.0 out of 10
N/A
HDInsight is an implementation of the Apache Hadoop technology stack on the Microsoft Azure cloud platform: It is based on the Hortonworks Hadoop distribution. Microsoft Azure HDInsight includes implementations of Apache Spark, HBase, Storm, Pig, Hive, Sqoop, Oozie, Ambari, etc. It also integrates with with business intelligence (BI) tools such as Power BI, Excel, SQL Server Analysis Services, and SQL Server Reporting Services.N/A
Db2 Big SQL
Score 9.0 out of 10
N/A
IBM offers Db2 Big SQL, an enterprise grade hybrid ANSI-compliant SQL on Hadoop engine, delivering massively parallel processing (MPP) and advanced data query. Big SQL offers a single database connection or query for disparate sources such as HDFS, RDMS, NoSQL databases, object stores and WebHDFS.N/A
Pricing
Azure HDInsightIBM Db2 Big SQL
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Azure HDInsightDb2 Big SQL
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Azure HDInsightIBM Db2 Big SQL
Considered Both Products
Azure HDInsight
Chose Azure HDInsight
Many times you just need spark performing fast and cheap. Azure HDInsight Includes lots of features and not required software. Also its libraries and runtime versions are pritty old. But, what is great Is you don't need to have an expert in your team and things -when work- …
Chose Azure HDInsight
Azure HD Insight is the one only used and it works well and serves its purpose. Azure Blob Storage could be an alternative, but if you really want to work on a large-scale workload, then HD analytics is best with Azure Data Lakes. PowerBI could be useful for small scale data …
Chose Azure HDInsight
At this time I have not used any other similar products... I am open to it but Azure HDInsight and its components really work well for our organization.
Db2 Big SQL
Chose Db2 Big SQL
MS SQL Server was ruled out given we didn't feel we could collapse environments. We thought of MS-SQL as more of a one for one replacement for Sybase ASE, i.e., server for server. SAP HANA was evaluated and given a big thumbs up but was rejected because the SQL would have …
Best Alternatives
Azure HDInsightIBM Db2 Big SQL
Small Businesses

No answers on this topic

No answers on this topic

Medium-sized Companies
Cloudera Manager
Cloudera Manager
Score 9.9 out of 10
Cloudera Manager
Cloudera Manager
Score 9.9 out of 10
Enterprises
IBM Analytics Engine
IBM Analytics Engine
Score 7.1 out of 10
IBM Analytics Engine
IBM Analytics Engine
Score 7.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure HDInsightIBM Db2 Big SQL
Likelihood to Recommend
4.0
(0 ratings)
9.0
(0 ratings)
Usability
8.9
(0 ratings)
8.0
(0 ratings)
Support Rating
1.0
(0 ratings)
8.8
(0 ratings)
User Testimonials
Azure HDInsightIBM Db2 Big SQL
Likelihood to Recommend
If you want to save costs and just pay for what you use, I highly recommend it. It will help you also to work with data for your reports and analytics. on the other hand I think it could be the subscription you have but high volume of data make it slow but not so much. anyway I think it's really good because it's from Microsoft which always is friendly to use it as all the suit they have.
Read full review
IBM Db2 is a legacy database and is primarily great for supporting certain legacy applications. It's simply not as competitive as many solutions on the market now.
Read full review
Pros
  • Shows live changes in analytics. Shows you how social media is working for us. Since we promote weekly events this is something that we really need to pay attention to.
  • Azure in itself is very user-friendly, HDInsight is a great addition. For our purposes, we definitely also utilized the power query to translate data to Excel.
Read full review
  • data storage
  • data manipulation
  • data definitions
  • data reliability
Read full review
Cons
  • Had issues while using Azure ARM Templates for deployments.
  • The cost structure suited for high end temporary data analytics, rather than a traditional frequently queried data warehouse.
Read full review
  • Cloud readiness.
  • Ease of implementation.
Read full review
Usability
Azure HDInsight is usable on the top of Azure Data Lake and gives us the benefit of analyzing large scale data workload in Hadoop. Usability and support from Microsoft are outstanding.
Read full review
IBM DB2 is a solid service but hasn't seen much innovation over the past decade. It gets the job done and supports our IT operations across digital so it is fair.
Read full review
Support Rating
Inexpert, isolated teams... not good for support an excessively complex platform. Lots of weeks or months for a complex problem troubleshoot. Many time lost stuck on MindTree, before the case was finally escalated with Microsoft!
Read full review
IBM did a good job of supporting us during our evaluation and proof of concept. They were able to provide all necessary guidance, answer questions, help us architect it, etc. We were pleased with the support provided by the vendor. I will caveat and say this support was all before the sale, however, we have a ton of IBM products and they provide the same high level of support for all of them. I didn't see this being any different. I give IBM support two thumbs up!
Read full review
Alternatives Considered
Many times you just need spark performing fast and cheap. Azure HDInsight Includes lots of features and not required software. Also its libraries and runtime versions are pritty old. But, what is great Is you don't need to have an expert in your team and things -when work- performs always in the exact same way. Also, as I mentioned, for a starter that's a great ROI.
Read full review
MS SQL Server was ruled out given we didn't feel we could collapse environments. We thought of MS-SQL as more of a one for one replacement for Sybase ASE, i.e., server for server. SAP HANA was evaluated and given a big thumbs up but was rejected because the SQL would have to be rewritten at the time (now they have an accelerator so you don't have to). Also, there was a very low adoption rate within the enterprise. IBM DB2 Big SQL was not selected even though technically it achieved high scores, because we could not find readily available talent and low adoption rate within the enterprise (basically no adoption at the time). We ended up selecting Exadata because of the high adoption rate within the enterprise even though technically HANA and Big SQL were superior in our evaluations.
Read full review
Return on Investment
  • ROI is of course there, as no legacy software for data presentation.
  • No manual intervention for data retrieval.
  • Data is available anywhere as requested.
Read full review
  • Performance gains were positive.
  • Finding resources on the street with knowledge at the time was hard.
Read full review
ScreenShots