Azure HDInsight vs. IBM Db2 Big SQL

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure HDInsight
Score 7.3 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
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.2 out of 10
IBM Analytics Engine
IBM Analytics Engine
Score 7.2 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure HDInsightIBM Db2 Big SQL
Likelihood to Recommend
4.0
(6 ratings)
9.0
(2 ratings)
Usability
8.9
(4 ratings)
8.0
(1 ratings)
Support Rating
1.0
(5 ratings)
8.8
(2 ratings)
User Testimonials
Azure HDInsightIBM Db2 Big SQL
Likelihood to Recommend
Microsoft
Well suited: A tiny-mid sized company with no immediate plans of growing the volume of their data processing, that can afford long response times from support. Also it helps if you are not prone to put your hands on Linux and Spark configuration. In fact, it can make things go really faster if you also work with the bundle-in Jupyter. And, if you need to perform some diagnostics and / or administrative tasks, that's full of tools to find an understand the Root Cause. Ideal for non experts. Less appropriate: Big Data company, intense on demand cluster creation, mission critical, costs reduction, latest versions of libraries required, sophisticate customizations required.
Read full review
IBM
My recommendation obviously would depend on the application. But I think given the right requirements, IBM DB2 Big SQL is definitely a contender for a database platform. Especially when disparate data and multiple data stores are involved. I like the fact I can use the product to federate my data and make it look like it's all in one place. The engine is high performance and if you desire to use Hadoop, this could be your platform.
Read full review
Pros
Microsoft
  • Data is presented without interfering others (IT or other dept).
  • Data is managed properly and is available for retrievable any time.
  • Legacy use of CD/DVD and Pendrive are not required.
Read full review
IBM
  • data storage
  • data manipulation
  • data definitions
  • data reliability
Read full review
Cons
Microsoft
  • The only problem I have come across is when loading large volumes of data I sometimes get an error message, I assume this means something is corrupt from within. I would love a way for this to be resolved without having to start over.
Read full review
IBM
  • Cloud readiness.
  • Ease of implementation.
Read full review
Usability
Microsoft
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
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
Microsoft
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
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
Microsoft
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.
Read full review
IBM
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
Microsoft
  • 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
IBM
  • better data visibility
  • solid reliability for mission critical data
Read full review
ScreenShots