TrustRadius: an HG Insights company

Azure Databricks vs. IBM ILOG CPLEX Optimization Studio

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Azure Databricks

    Score8.5 out of 10
    N/AAzure 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

    Score9.7 out of 10
    N/AIBM® 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
    Features
    Azure DatabricksIBM ILOG CPLEX Optimization Studio
    Platform Connectivity
    Comparison of Platform Connectivity features of Azure Databricks and IBM ILOG CPLEX Optimization Studio
    Feature
    Azure Databricks
    7.2
    4 Ratings
    15% below category average
    IBM ILOG CPLEX Optimization Studio
    8.0
    2 Ratings
    4% below category average
    Connect to Multiple Data Sources6.04 Ratings9.02 Ratings
    Extend Existing Data Sources7.64 Ratings7.02 Ratings
    Automatic Data Format Detection7.14 Ratings8.02 Ratings
    MDM Integration8.03 Ratings8.02 Ratings
    Data Exploration
    Comparison of Data Exploration features of Azure Databricks and IBM ILOG CPLEX Optimization Studio
    Feature
    Azure Databricks
    6.9
    4 Ratings
    19% below category average
    IBM ILOG CPLEX Optimization Studio
    10.0
    2 Ratings
    18% above category average
    Visualization6.04 Ratings10.02 Ratings
    Interactive Data Analysis7.93 Ratings10.02 Ratings
    Data Preparation
    Comparison of Data Preparation features of Azure Databricks and IBM ILOG CPLEX Optimization Studio
    Feature
    Azure Databricks
    8.7
    4 Ratings
    6% above category average
    IBM ILOG CPLEX Optimization Studio
    7.3
    2 Ratings
    12% below category average
    Interactive Data Cleaning and Enrichment8.44 Ratings5.01 Ratings
    Data Transformations9.04 Ratings7.01 Ratings
    Data Encryption9.54 Ratings8.02 Ratings
    Built-in Processors8.04 Ratings9.02 Ratings
    Platform Data Modeling
    Comparison of Platform Data Modeling features of Azure Databricks and IBM ILOG CPLEX Optimization Studio
    Feature
    Azure Databricks
    7.9
    4 Ratings
    7% below category average
    IBM ILOG CPLEX Optimization Studio
    8.0
    2 Ratings
    6% below category average
    Multiple Model Development Languages and Tools6.14 Ratings10.02 Ratings
    Automated Machine Learning8.54 Ratings5.01 Ratings
    Single platform for multiple model development8.54 Ratings8.02 Ratings
    Self-Service Model Delivery8.54 Ratings9.01 Ratings
    Model Deployment
    Comparison of Model Deployment features of Azure Databricks and IBM ILOG CPLEX Optimization Studio
    Feature
    Azure Databricks
    8.3
    4 Ratings
    3% below category average
    IBM ILOG CPLEX Optimization Studio
    10.0
    2 Ratings
    15% above category average
    Flexible Model Publishing Options8.04 Ratings10.02 Ratings
    Security, Governance, and Cost Controls8.54 Ratings10.02 Ratings
    Best Alternatives
    Azure DatabricksIBM ILOG CPLEX Optimization Studio
    Small Businesses
    RapidMiner
    Score8.9 out of 10
    RapidMiner
    Score8.9 out of 10
    Medium-sized Companies
    Anaconda
    Score8.8 out of 10
    Anaconda
    Score8.8 out of 10
    Enterprises
    IBM Watson Studio
    Score10 out of 10
    IBM Watson Studio
    Score10 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Azure DatabricksIBM ILOG CPLEX Optimization Studio
    Likelihood to Recommend
    7.6
    (5 ratings)
    9.0
    (2 ratings)
    Usability
    7.5
    (3 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
    Centralised notebooks are out directly into production. This can lead to poorly engineered code. It is very good for fast queries and our data team are always able to provide what we ask for. It is a big cost to our business so it is important it runs efficiently and returns on our investment.
    Incentivized
    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.
    Read full review
    Pros
    Microsoft
    • Data Processing and Transformations based on Spark
    • Delta Lakehouse when clubbed with an external cloud storage
    • Governance using Unity Catalog to unify IAM
    • Delta Live Tables is a product, which although relatively newer, has a great potential with the visuals of a pipeline.
    Incentivized
    Read full review
    IBM
    • Linear Programming
    • Mixed-Integer Linear Programming
    • Non-Linear Convex-Optimization
    • Visualization
    • Shadow Price Analysis
    • Parameter Tuning
    Read full review
    Cons
    Microsoft
    • Intuitive interface
    • Ease of use
    • Providing FAQ or QRGs
    Incentivized
    Read full review
    IBM
    • Data handling from different sources like Note Pad, etc.
    • Large size of MILP problems.
    • Various parameters to set.
    Read full review
    Usability
    Microsoft
    The developers are able to switch between Python and SQL in the Notebook which allows the collaboration of SQL analyst and Data scientist. The integration of Mosaic AI allows users to write complex codes in natural languages. Unity catalog has centralized the security and governance features and simplified the process of maintaining it
    Incentivized
    Read full review
    IBM
    It's nice to use and with good optimization.
    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.
    Read full review
    Alternatives Considered
    Microsoft
    I have found Azure Databricks to be much better than Snowflake for handling bigger, diverse data types. Snowflake is much simpler and better for smaller warehousing. The real time processing is much better in Azure Databricks and we have much more language options. Snowflake is more expensive but simpler to use. Both are great for different needs.
    Incentivized
    Read full review
    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
    Return on Investment
    Microsoft
    • The support team is amazing, they help you at every stage of the projects, from sales to delivery.
    • On a framework level, it has had an amazing impact and has reduced the clients overall data platform costs by a staggering 65%
    • There has been a 40% Manual work requirement on average for the clients when they move to Azure Databricks Data Platform
    Incentivized
    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
    Read full review
    ScreenShots