Actian Ingres vs Microsoft Analytics Platform System comparison

Cancel
You must select at least 2 products to compare!
Actian Logo
409 views|218 comparisons
100% willing to recommend
Microsoft Logo
323 views|240 comparisons
66% willing to recommend
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: April 2024).
768,924 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 →

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

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 →

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

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.
    768,924 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 34 in Data Warehouse
    Views
    409
    Comparisons
    218
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    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
    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 Company23%
    Manufacturing Company12%
    Government10%
    Financial Services Firm9%
    VISITORS READING REVIEWS
    Financial Services Firm12%
    Computer Software Company11%
    University11%
    Energy/Utilities Company9%
    Company Size
    VISITORS READING REVIEWS
    Small Business28%
    Midsize Enterprise19%
    Large Enterprise53%
    REVIEWERS
    Small Business36%
    Large Enterprise64%
    VISITORS READING REVIEWS
    Small Business22%
    Midsize Enterprise5%
    Large Enterprise73%
    Buyer's Guide
    Data Warehouse
    April 2024
    Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: April 2024.
    768,924 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 Snowflake, Oracle Database Appliance, 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.