CockroachDB vs SAP IQ comparison

Cancel
You must select at least 2 products to compare!
Cockroach Logo
4,264 views|2,852 comparisons
SAP Logo
475 views|372 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between CockroachDB and SAP IQ based on real PeerSpot user reviews.

Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed CockroachDB vs. SAP IQ Report (Updated: March 2024).
765,234 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The initial setup and deployment are simple.""The tool's most valuable feature is node syncing, which takes only 0.54 milliseconds.""CockroachDB is highly reliable.""The most valuable features of the solution are its resiliency features and the geo-partitioning capabilities.""The product has valuable security features.""The subset of SQL that my client is using is completely supported.""The best feature of CockroachDB is the ability to keep the nodes in different locations.""I use CockroachDB to test big data samples and to create the best structure for databases. We have four users and required 10 people for deployment and maintenance."

More CockroachDB Pros →

"Valuable features for us include the compression, speed, fast response time, and easy object maintenance.""It is very robust for ad hoc DW queries and its columnar compression is unique and valuable.""The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves moving data from SAP HANA to SAP NLS, which is essentially archiving. This allows us to retain access to the data via a link whenever it is required.""Unbeatable speed and compression with a colummn-structured relational database.""Columnar storage allows high compression, high load rates and high query performance.""The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."

More SAP IQ Pros →

Cons
"Cockroach does not support all types of protocols. I need to improve it myself to support a CouchDB on my network.""CockroachDB needs to improve store processes.""I find the serverless offer a bit confusing.""The product must improve its disaster recovery features.""The initial setup and pricing could be improved.""We are looking for more features to support distributed high availability and geo-partitioning.""The platform could be more extensible.""The closer they can make CockroachDB to being completely compatible with Postgres, the better. It's almost compatible, but not completely. If it was, it would be nice to just be able to use Postgres libraries without any fiddling."

More CockroachDB Cons →

"Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups.""Concurrency and functional error messaging.""I think the universe should be part of the Sybase IQ tool set.""The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better.""The room for improvement would be the marketing of the product, because this product is much better than advertised.""The organization who owns the product does not support it well and appears not to be doing significant development for the future."

More SAP IQ Cons →

Pricing and Cost Advice
  • "I've used CockroachDB at a small scale on the free accounts because we are only testing."
  • "The pricing is good but can be made cheaper. I would rate the pricing a five out of ten."
  • "The platform is affordable even for the enterprise version. It provides value for investment in terms of performance."
  • "The product's price depends on the user's company and the contract model they enter into with CockroachDB. Depending on the contract model one enters into with CockroachDB, the product may or may not be expensive."
  • More CockroachDB Pricing and Cost Advice →

  • "Evaluate all options; check to see if you need expensive add-ons."
  • "Negotiate based on the features required."
  • "Negotiation is very important."
  • "The only costs after standard licensing fees are for add-ons and upgrades."
  • More SAP IQ Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
    765,234 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The subset of SQL that my client is using is completely supported.
    Top Answer:I find the serverless offer a bit confusing. The price is a function of the maximum database size. A single SELECT can use a number of request units, for example. If the throughput is high enough, you… more »
    Top Answer:Cockroach nodes were installed in the following: 1. Single host, triple nodes (containers): for evaluation on a low-end PC. 2. Single host, triple nodes (process): to test applications against a… more »
    Top Answer:The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves… more »
    Top Answer:The solution’s pricing is high, but coverage is good with high implementation with customer requirements.
    Top Answer:The product should add more business intelligence factors.
    Ranking
    Views
    4,264
    Comparisons
    2,852
    Reviews
    8
    Average Words per Review
    416
    Rating
    8.5
    Views
    475
    Comparisons
    372
    Reviews
    1
    Average Words per Review
    559
    Rating
    7.0
    Comparisons
    Oracle Database logo
    Compared 28% of the time.
    MySQL logo
    Compared 19% of the time.
    Citus Data logo
    Compared 16% of the time.
    Amazon Aurora logo
    Compared 12% of the time.
    SQL Server logo
    Compared 7% of the time.
    Snowflake logo
    Compared 28% of the time.
    SQL Server logo
    Compared 15% of the time.
    SAP HANA logo
    Compared 15% of the time.
    Apache Hadoop logo
    Compared 14% of the time.
    SAP BW4HANA logo
    Compared 12% of the time.
    Also Known As
    Sybase IQ
    Learn More
    Overview

    CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.

    CockroachDB is inspired by Google’s Spanner and F1 technologies, and it’s completely open source.

    SAP® IQ software delivers speed and power for extreme-scale enterprise data warehousing and analytics. Its column-oriented, grid-based massively parallel processing (MPP) architecture and patented data compression and indexing technologies enable companies to exploit the value of huge amounts of data at the speed of business.

    Sample Customers
    Baidu, Kindred, Tierion, Heroic Labs, Gorgias
    ASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm38%
    Computer Software Company13%
    Retailer6%
    Comms Service Provider5%
    REVIEWERS
    Financial Services Firm55%
    Marketing Services Firm9%
    Healthcare Company9%
    Insurance Company9%
    VISITORS READING REVIEWS
    Financial Services Firm37%
    Computer Software Company11%
    Manufacturing Company6%
    Healthcare Company4%
    Company Size
    REVIEWERS
    Small Business60%
    Large Enterprise40%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise14%
    Large Enterprise72%
    REVIEWERS
    Small Business22%
    Midsize Enterprise11%
    Large Enterprise67%
    VISITORS READING REVIEWS
    Small Business11%
    Midsize Enterprise9%
    Large Enterprise80%
    Buyer's Guide
    CockroachDB vs. SAP IQ
    March 2024
    Find out what your peers are saying about CockroachDB vs. SAP IQ and other solutions. Updated: March 2024.
    765,234 professionals have used our research since 2012.

    CockroachDB is ranked 9th in Relational Databases Tools with 10 reviews while SAP IQ is ranked 21st in Relational Databases Tools with 17 reviews. CockroachDB is rated 8.0, while SAP IQ is rated 8.0. The top reviewer of CockroachDB writes "Open source with extensive documentation and a University for training". On the other hand, the top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". CockroachDB is most compared with Oracle Database, MySQL, Citus Data, Amazon Aurora and SQL Server, whereas SAP IQ is most compared with Snowflake, SQL Server, SAP HANA, Apache Hadoop and SAP BW4HANA. See our CockroachDB vs. SAP IQ report.

    See our list of best Relational Databases Tools vendors.

    We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.