Actian Ingres 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 Actian Ingres and Microsoft Analytics Platform System based on real PeerSpot user reviews.

Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse.
To learn more, read our detailed Data Warehouse 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 deployment of our solution across a number of servers using Ingres .NET has meant that we can protect the database server behind a highly secure firewall and deploy the front end solutions on a normal web server."

More Actian Ingres Pros →

"Helps our customers to discover trends, which provides useful information based on their business.""We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services.""This solution will connect to any database, you can combine databases, and you can create a cube or tabular model.""This is a well-integrated solution and that integration empowers results.""It is closely integrated with other products in the MS portfolio.""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.""The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."

More Microsoft Analytics Platform System Pros →

Cons
"The ability to reset the log file without stopping the DBMS would be helpful for us."

More Actian Ingres Cons →

"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.""The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps.""The pricing model needs to be improved.""We need better real-time analytics capabilities. It's a bit challenging for us.""Microsoft Analytics Platform System could have better support.""I think the biggest problem with the product is that it does a data ingest model, which is very expensive.""Functionality needs to be more up-to-date with competing products."

More Microsoft Analytics Platform System Cons →

Pricing and Cost Advice
Information Not Available
  • "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.
    765,234 professionals have used our research since 2012.
    Questions from the Community
    Ask a question

    Earn 20 points

    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
    22nd
    out of 33 in Data Warehouse
    Views
    430
    Comparisons
    230
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    17th
    out of 33 in Data Warehouse
    Views
    359
    Comparisons
    266
    Reviews
    2
    Average Words per Review
    439
    Rating
    7.5
    Comparisons
    Also Known As
    Ingres, Ingres 2006
    Microsoft APS, MS Analytics Platform System
    Learn More
    Actian
    Video Not Available
    Overview

    Actian’s Ingres is a leading, enterprise-grade database management system designed to reduce IT costs and time-to-value, while delivering the strength and features expected from an enterprise-class database. Ingres 10.2 is the latest version of the database, containing enhancements that will make it easier to internationalize customer applications. Along with improved performance and reduced configuration overhead, users can take their first steps into big data analytics with the new Window functions.

    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
    Groupe Adeo, IsCool Entertainment
    Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company22%
    Manufacturing Company11%
    Government11%
    Financial Services Firm8%
    VISITORS READING REVIEWS
    Financial Services Firm13%
    Computer Software Company10%
    University10%
    Government9%
    Company Size
    VISITORS READING REVIEWS
    Small Business29%
    Midsize Enterprise19%
    Large Enterprise52%
    REVIEWERS
    Small Business36%
    Large Enterprise64%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise6%
    Large Enterprise73%
    Buyer's Guide
    Data Warehouse
    March 2024
    Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: March 2024.
    765,234 professionals have used our research since 2012.

    Actian Ingres is ranked 22nd in Data Warehouse while Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews. Actian Ingres is rated 9.0, while Microsoft Analytics Platform System is rated 6.6. The top reviewer of Actian Ingres writes "Good multi-platform SQL compatibility, as well as performance and data integrity". 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". Actian Ingres is most compared with Oracle Database Appliance, Snowflake, Databricks and Teradata, whereas Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, IBM Netezza Performance Server and Snowflake.

    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.