IBM ILOG CPLEX Optimization Studio vs. Microsoft R Open / Revolution R Enterprise

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
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.
$199
Per User Per Month
Microsoft R Open / Revolution R Enterprise
Score 8.9 out of 10
N/A
Microsoft R Open and Revolution R Enterprise are big data R distribution for servers, Hadoop clusters, and data warehouses. Microsoft acquired original developer Revolution Analytics in 2016. Microsoft R is available in two editions: Microsoft R Open (formerly Revolution R Open) and Revolution R Enterprise.N/A
Pricing
IBM ILOG CPLEX Optimization StudioMicrosoft R Open / Revolution R Enterprise
Editions & Modules
Developer Subscription
$199.00
Per User Per Month
No answers on this topic
Offerings
Pricing Offerings
IBM ILOG CPLEX Optimization StudioMicrosoft R Open / Revolution R Enterprise
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
IBM ILOG CPLEX Optimization StudioMicrosoft R Open / Revolution R Enterprise
Top Pros

No answers on this topic

Top Cons
Features
IBM ILOG CPLEX Optimization StudioMicrosoft R Open / Revolution R Enterprise
Platform Connectivity
Comparison of Platform Connectivity features of Product A and Product B
IBM ILOG CPLEX Optimization Studio
8.0
2 Ratings
6% below category average
Microsoft R Open / Revolution R Enterprise
5.3
3 Ratings
46% below category average
Connect to Multiple Data Sources9.02 Ratings6.13 Ratings
Extend Existing Data Sources7.02 Ratings6.03 Ratings
Automatic Data Format Detection8.02 Ratings6.03 Ratings
MDM Integration8.02 Ratings3.01 Ratings
Data Exploration
Comparison of Data Exploration features of Product A and Product B
IBM ILOG CPLEX Optimization Studio
10.0
2 Ratings
17% above category average
Microsoft R Open / Revolution R Enterprise
7.0
3 Ratings
19% below category average
Visualization10.02 Ratings7.03 Ratings
Interactive Data Analysis10.02 Ratings7.03 Ratings
Data Preparation
Comparison of Data Preparation features of Product A and Product B
IBM ILOG CPLEX Optimization Studio
7.3
2 Ratings
12% below category average
Microsoft R Open / Revolution R Enterprise
4.8
3 Ratings
53% below category average
Interactive Data Cleaning and Enrichment5.01 Ratings5.13 Ratings
Data Transformations7.01 Ratings5.03 Ratings
Data Encryption8.02 Ratings3.01 Ratings
Built-in Processors9.02 Ratings6.03 Ratings
Platform Data Modeling
Comparison of Platform Data Modeling features of Product A and Product B
IBM ILOG CPLEX Optimization Studio
8.0
2 Ratings
6% below category average
Microsoft R Open / Revolution R Enterprise
6.0
3 Ratings
34% below category average
Multiple Model Development Languages and Tools10.02 Ratings5.03 Ratings
Automated Machine Learning5.01 Ratings5.02 Ratings
Single platform for multiple model development8.02 Ratings8.03 Ratings
Self-Service Model Delivery9.01 Ratings6.03 Ratings
Model Deployment
Comparison of Model Deployment features of Product A and Product B
IBM ILOG CPLEX Optimization Studio
10.0
2 Ratings
15% above category average
Microsoft R Open / Revolution R Enterprise
6.5
2 Ratings
28% below category average
Flexible Model Publishing Options10.02 Ratings6.02 Ratings
Security, Governance, and Cost Controls10.02 Ratings6.92 Ratings
Best Alternatives
IBM ILOG CPLEX Optimization StudioMicrosoft R Open / Revolution R Enterprise
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
IBM ILOG CPLEX Optimization StudioMicrosoft R Open / Revolution R Enterprise
Likelihood to Recommend
9.0
(2 ratings)
6.0
(5 ratings)
Likelihood to Renew
-
(0 ratings)
7.0
(1 ratings)
Usability
9.0
(1 ratings)
7.0
(1 ratings)
Support Rating
7.0
(1 ratings)
8.0
(2 ratings)
User Testimonials
IBM ILOG CPLEX Optimization StudioMicrosoft R Open / Revolution R Enterprise
Likelihood to Recommend
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.
Read full review
Microsoft
If you are a MS shop specifically, or have more generic data requirement needs from Microsoft sourced data this will work well. If you have a lot of disparate data across a number of unique platforms/cloud systems/3rd party hosted data warehouses then this product will have issues or a lack of documentation on the net. Performance-wise this product is equal to other R platforms out there.
Read full review
Pros
IBM
  • Linear Programming
  • Mixed-Integer Linear Programming
  • Non-Linear Convex-Optimization
  • Visualization
  • Shadow Price Analysis
  • Parameter Tuning
Read full review
Microsoft
  • It allows distributed algorithm runs on Hadoop HDFS cluster
  • It allows using different file formats such as SAS7BAT files or complex files in tab or comma delimited making data munging easier
  • It provides scalable solutions by allowing users to re-use R scripts and distributing the computing over nodes through RHadoop
Read full review
Cons
IBM
  • Data handling from different sources like Note Pad, etc.
  • Large size of MILP problems.
  • Various parameters to set.
Read full review
Microsoft
  • Very steep learning curve... for such a quick and useful tool the learning curve is unacceptable.
  • Very dangerous in the wrong hands. Because most add-ons are pre-written, you have to trust the community that malicious script is not used.
Read full review
Likelihood to Renew
IBM
No answers on this topic
Microsoft
In general, Revolution Analytics brings a lot of value to the organization. The renewal decision would be based on return on investment in terms of quantified actionable insights that are getting generated against the cost of the product. Additionally, market brand of the tool and reputation risk in terms of possible acquisition and its impact to overall organizational analytic strategy would be considered as well.
Read full review
Usability
IBM
It's nice to use and with good optimization.
Read full review
Microsoft
It is good, easy to use, improvements are being made to the product and more info being shared in the community. It just needs some more time to become more integrated to other platforms and tools/data out there.
Read full review
Support Rating
IBM
Honestly, to say, I never contacted CPLEX but used its forum to know/clarify any issues I faced.
Read full review
Microsoft
Generally support comes through the forums and user generated channels which are helpful, easy to access, quickly turned around and provided by knowledgeable users. However the support channels are not employees and the channels are often used as a way to learn quick difficult elements of R. Better design, users interface and tutorial options would alleviate the need for this sort of interaction.
Read full review
Alternatives Considered
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.
Read full review
Microsoft
The two are different products for different purposes. But for someone who has little or no experience in R programming, Power BI would be better for starting with. Having said that, Microsoft R is built on R, thus allowing for customization of complex calculations not typically available otherwise.
Read full review
Return on Investment
IBM
  • Faster computation leading to better internal customer relations
  • Able to solve high variable problems with ease
  • Anomaly detection became easier within business
Read full review
Microsoft
  • Helped save company money versus buying other stat software
Read full review
ScreenShots