IBM Db2 Warehouse vs Microsoft Analytics Platform System comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IBM Db2 Warehouse and Microsoft Analytics Platform System based on real PeerSpot user reviews.

Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed IBM Db2 Warehouse vs. Microsoft Analytics Platform System Report (Updated: March 2024).
768,578 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
"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well.""The analytics engine is not bad at forecasting predictions.""The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.""Provides good security and reliability.""It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily.""Some of the best features are stored procedures, parallelism, and different indexing strategies."

More IBM Db2 Warehouse Pros →

"It is closely integrated with other products in the MS portfolio.""This is a well-integrated solution and that integration empowers results.""We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services.""I like that it's integrated with other Azure products.""Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases.""Helps our customers to discover trends, which provides useful information based on their business.""The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics.""This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."

More Microsoft Analytics Platform System Pros →

Cons
"The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web.""IBM Db2 Warehouse needs to improve its interface.""In terms of improvement, IBM Db2 Warehouse should be more scalable.""There should be more material available for training and training should be free.""Lacks sufficient documentation and particularly in Spanish.""The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting.""The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."

More IBM Db2 Warehouse Cons →

"I think the biggest problem with the product is that it does a data ingest model, which is very expensive.""The pricing model needs to be improved.""Microsoft Analytics Platform System could have better support.""The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps.""We need better real-time analytics capabilities. It's a bit challenging for us.""Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release.""​Hybrid environments are complex to manage.""Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."

More Microsoft Analytics Platform System Cons →

Pricing and Cost Advice
  • "In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
  • More IBM Db2 Warehouse Pricing and Cost Advice →

  • "The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership."
  • "Users have to pay extra for premium-level technical support."
  • "We are currently paying $200,000 a year for all the different parts of the suite during an ingest model Microsoft now charges us $700,000 a year."
  • "I rate Microsoft Analytics Platform System a seven out of ten for pricing."
  • More Microsoft Analytics Platform System Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    768,578 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.
    Top Answer:Db2 is a very expensive database. In comparison to Oracle, for example, where the cost depends on the size of the implementation. For an enterprise database, the cost is mid-range.
    Top Answer:IBM Db2 Warehouse needs to improve its interface.
    Top Answer:We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services.
    Top Answer:It's not too confusing. It's based on features, and we don't have to buy additional licenses.
    Top Answer:We need better real-time analytics capabilities. It's a bit challenging for us. Moreover, there are some permission limitations.
    Ranking
    14th
    out of 34 in Data Warehouse
    Views
    973
    Comparisons
    521
    Reviews
    3
    Average Words per Review
    363
    Rating
    7.3
    17th
    out of 34 in Data Warehouse
    Views
    323
    Comparisons
    240
    Reviews
    2
    Average Words per Review
    439
    Rating
    7.5
    Comparisons
    Also Known As
    InfoSphere Warehouse, IBM InfoSphere Warehouse
    Microsoft APS, MS Analytics Platform System
    Learn More
    IBM
    Video Not Available
    Overview
    InfoSphere Warehouse is a suite of products that combines the strength of DB2 with a data warehousing infrastructure from IBM. You can use InfoSphere Warehouse to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools.
    The Microsoft Analytics Platform System can meet the demands of your evolving data warehouse environment with its scale-out, massively parallel processing integrated system supporting hybrid data warehouse scenarios. It provides the ability to query across relational and non-relational data by leveraging Microsoft PolyBase and industry-leading big data technologies. It offers the lowest price per terabyte for large data warehouse workloads.
    Sample Customers
    Alameda County Social Services Agency, Sui Southern Gas Company Limited
    Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
    Top Industries
    VISITORS READING REVIEWS
    Educational Organization52%
    Financial Services Firm9%
    Computer Software Company7%
    Insurance Company4%
    VISITORS READING REVIEWS
    Financial Services Firm12%
    Computer Software Company11%
    University11%
    Energy/Utilities Company9%
    Company Size
    REVIEWERS
    Small Business44%
    Midsize Enterprise11%
    Large Enterprise44%
    VISITORS READING REVIEWS
    Small Business9%
    Midsize Enterprise54%
    Large Enterprise37%
    REVIEWERS
    Small Business36%
    Large Enterprise64%
    VISITORS READING REVIEWS
    Small Business22%
    Midsize Enterprise5%
    Large Enterprise73%
    Buyer's Guide
    IBM Db2 Warehouse vs. Microsoft Analytics Platform System
    March 2024
    Find out what your peers are saying about IBM Db2 Warehouse vs. Microsoft Analytics Platform System and other solutions. Updated: March 2024.
    768,578 professionals have used our research since 2012.

    IBM Db2 Warehouse is ranked 14th in Data Warehouse with 8 reviews while Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews. IBM Db2 Warehouse is rated 7.6, while Microsoft Analytics Platform System is rated 6.6. The top reviewer of IBM Db2 Warehouse writes "Useful for ETL process and has good documentation ". On the other hand, the top reviewer of Microsoft Analytics Platform System writes "Offers smooth data integration between systems, but requires better real-time analytics capabilities". IBM Db2 Warehouse is most compared with Oracle Exadata, Snowflake, Amazon Redshift, Apache Hadoop and IBM Db2 Warehouse on Cloud, whereas Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, IBM Netezza Performance Server and Snowflake. See our IBM Db2 Warehouse vs. Microsoft Analytics Platform System report.

    See our list of best Data Warehouse vendors.

    We monitor all Data Warehouse 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.