TrustRadius

Azure Databricks vs. IBM ILOG CPLEX Optimization Studio

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure Databricks
Score 8.2 out of 10
N/A
Azure Databricks is a service available on Microsoft's Azure platform and suite of products. It provides the latest versions of Apache Spark so users can integrate with open source libraries, or spin up clusters and build in a fully managed Apache Spark environment with the global scale and availability of Azure. Clusters are set up, configured, and fine-tuned to ensure reliability and performance without the need for monitoring. The solution includes autoscaling and auto-termination to improve…N/A
IBM ILOG CPLEX Optimization Studio
Score 9.3 out of 10
N/A
IBM® ILOG® CPLEX® Optimization Studio is a prescriptive analytics solution that enables rapid development and deployment of decision optimization models using mathematical and constraint programming.
$285
per month per user
Pricing
Azure DatabricksIBM ILOG CPLEX Optimization Studio
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Azure DatabricksIBM ILOG CPLEX Optimization Studio
Free Trial
NoYes
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 DatabricksIBM ILOG CPLEX Optimization Studio
Top Cons

No answers on this topic

Features
Azure DatabricksIBM ILOG CPLEX Optimization Studio
Platform Connectivity
Comparison of Platform Connectivity features of Product A and Product B
Azure Databricks
9.7
1 Ratings
14% above category average
IBM ILOG CPLEX Optimization Studio
8.0
2 Ratings
5% below category average
Connect to Multiple Data Sources10.01 Ratings9.02 Ratings
Extend Existing Data Sources9.01 Ratings7.02 Ratings
Automatic Data Format Detection10.01 Ratings8.02 Ratings
MDM Integration00 Ratings8.02 Ratings
Data Exploration
Comparison of Data Exploration features of Product A and Product B
Azure Databricks
4.0
1 Ratings
71% below category average
IBM ILOG CPLEX Optimization Studio
10.0
2 Ratings
17% above category average
Visualization4.01 Ratings10.02 Ratings
Interactive Data Analysis4.01 Ratings10.02 Ratings
Data Preparation
Comparison of Data Preparation features of Product A and Product B
Azure Databricks
8.5
1 Ratings
3% above category average
IBM ILOG CPLEX Optimization Studio
7.3
2 Ratings
12% below category average
Interactive Data Cleaning and Enrichment7.01 Ratings5.01 Ratings
Data Transformations8.01 Ratings7.01 Ratings
Data Encryption10.01 Ratings8.02 Ratings
Built-in Processors9.01 Ratings9.02 Ratings
Platform Data Modeling
Comparison of Platform Data Modeling features of Product A and Product B
Azure Databricks
9.0
1 Ratings
6% above category average
IBM ILOG CPLEX Optimization Studio
8.0
2 Ratings
6% below category average
Multiple Model Development Languages and Tools10.01 Ratings10.02 Ratings
Automated Machine Learning8.01 Ratings5.01 Ratings
Single platform for multiple model development9.01 Ratings8.02 Ratings
Self-Service Model Delivery9.01 Ratings9.01 Ratings
Model Deployment
Comparison of Model Deployment features of Product A and Product B
Azure Databricks
9.0
1 Ratings
5% above category average
IBM ILOG CPLEX Optimization Studio
10.0
2 Ratings
15% above category average
Flexible Model Publishing Options8.01 Ratings10.02 Ratings
Security, Governance, and Cost Controls10.01 Ratings10.02 Ratings
Best Alternatives
Azure DatabricksIBM ILOG CPLEX Optimization Studio
Small Businesses
IBM SPSS Modeler
IBM SPSS Modeler
Score 7.8 out of 10
IBM SPSS Modeler
IBM SPSS Modeler
Score 7.8 out of 10
Medium-sized Companies
Mathematica
Mathematica
Score 8.2 out of 10
Mathematica
Mathematica
Score 8.2 out of 10
Enterprises
IBM SPSS Modeler
IBM SPSS Modeler
Score 7.8 out of 10
IBM SPSS Modeler
IBM SPSS Modeler
Score 7.8 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure DatabricksIBM ILOG CPLEX Optimization Studio
Likelihood to Recommend
8.5
(2 ratings)
9.0
(2 ratings)
Usability
-
(0 ratings)
9.0
(1 ratings)
Support Rating
-
(0 ratings)
7.0
(1 ratings)
User Testimonials
Azure DatabricksIBM ILOG CPLEX Optimization Studio
Likelihood to Recommend
Microsoft
Having access to all databases and tables in one place is what has helped me and my team to function better. The in built functionality/access to SQL and Python is definitely an added bonus! The icing on the cake is the ability to export your data into an Excel spreadsheet for additional analysis. If you have less to no working knowledge of SQL or Python, its better to look at alternatives.
Verified User
Anonymous
Read full review
IBM
It is well suited for solving large-sized, mixed-integer, and integer programming problems. Now, the new version supports for Multi-Objective optimization along with some new algorithms such as Benders Decomposition. It is less appropriate for quadratic programming problems where the objective function is the product of multiple variables. However, it's very easy to code any problem.
Verified User
Anonymous
Read full review
Pros
Microsoft
  • Consistently great performance when dealing with huge scale data with the help of spark architecture
  • Magic commands such as spark sql, pyspark, scala . This comes really handy in day to day work
  • Integration with other Azure services is super smooth and robust
Pranshu Gupta | TrustRadius Reviewer
Pranshu Gupta
Associate Data Engineer
Read full review
IBM
  • Linear Programming
  • Mixed-Integer Linear Programming
  • Non-Linear Convex-Optimization
  • Visualization
  • Shadow Price Analysis
  • Parameter Tuning
Verified User
Anonymous
Read full review
Cons
Microsoft
  • Intuitive interface
  • Ease of use
  • Providing FAQ or QRGs
Verified User
Anonymous
Read full review
IBM
  • Data handling from different sources like Note Pad, etc.
  • Large size of MILP problems.
  • Various parameters to set.
Verified User
Anonymous
Read full review
Usability
Microsoft
No answers on this topic
IBM
It's nice to use and with good optimization.
Verified User
Anonymous
Read full review
Support Rating
Microsoft
No answers on this topic
IBM
Honestly, to say, I never contacted CPLEX but used its forum to know/clarify any issues I faced.
Verified User
Anonymous
Read full review
Alternatives Considered
Microsoft
No answers on this topic
IBM
IBM CPLEX Optimization Studio covers wide range of problems in comparison to Gurobi and also offers a number of visualization tools for results analysis. It has better customization and parameter tuning options in comparison to Gurobi. It offers various API integrations such as Python, Java and C++ which is not the case with Gurobi.
Verified User
Anonymous
Read full review
Return on Investment
Microsoft
  • Helped reduce time for collecting data
  • Reduced cost in maintaining multiple data sources
  • Access for multiple users and management of users/data in a single platform
Verified User
Anonymous
Read full review
IBM
  • Faster computation leading to better internal customer relations
  • Able to solve high variable problems with ease
  • Anomaly detection became easier within business
Verified User
Anonymous
Read full review
ScreenShots