Azure HDInsight vs. IBM Db2 Big SQL

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure HDInsight
Score 5.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 8.7 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
Top Pros
Top Cons
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.7 out of 10
Cloudera Manager
Cloudera Manager
Score 9.7 out of 10
Enterprises
IBM Analytics Engine
IBM Analytics Engine
Score 8.8 out of 10
IBM Analytics Engine
IBM Analytics Engine
Score 8.8 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure HDInsightIBM Db2 Big SQL
Likelihood to Recommend
9.1
(5 ratings)
9.0
(2 ratings)
Usability
8.9
(4 ratings)
8.0
(1 ratings)
Support Rating
8.9
(4 ratings)
8.8
(2 ratings)
User Testimonials
Azure HDInsightIBM Db2 Big SQL
Likelihood to Recommend
Microsoft
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
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
I highly recommend it.
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
  • Less implementation cost.
  • No hosting services cost.
  • Faster data retrieval.
Read full review
IBM
  • better data visibility
  • solid reliability for mission critical data
Read full review
ScreenShots