TrustRadius: an HG Insights company

Microsoft R Open / Revolution R Enterprise vs. PostgreSQL

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Microsoft R Open / Revolution R Enterprise

    Score8.9 out of 10
    N/AMicrosoft R Open and Revolution R Enterprise are big data R distribution for servers, Hadoop clusters, and data warehouses. Microsoft acquired original developer Revolution Analytics in 2016. Microsoft R is available in two editions: Microsoft R Open (formerly Revolution R Open) and Revolution R Enterprise.N/A

    PostgreSQL

    Score8.8 out of 10
    N/APostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.N/A
    Pricing
    Microsoft R Open / Revolution R EnterprisePostgreSQL
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Microsoft R Open / Revolution R EnterprisePostgreSQL
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Microsoft R Open / Revolution R EnterprisePostgreSQL
    Considered Both Products
    Microsoft
    No answer on this topic
    PostgreSQL Global Development Group
    No answer on this topic
    Key User Insights
    Would buy again
    No answers on this topic
    100%
    Would buy again
    32 Answers
    Delivers good value for the price
    No answers on this topic
    100%
    Delivers good value for the price
    32 Answers
    Happy with the feature set
    No answers on this topic
    100%
    Happy with the feature set
    32 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    100%
    Lived up to sales and marketing promises
    25 Answers
    Implementation went as expected
    No answers on this topic
    100%
    Implementation went as expected
    31 Answers
    Features
    Microsoft R Open / Revolution R EnterprisePostgreSQL
    Platform Connectivity
    Comparison of Platform Connectivity features of Microsoft R Open / Revolution R Enterprise and PostgreSQL
    Feature
    Microsoft R Open / Revolution R Enterprise
    5.3
    3 Ratings
    45% below category average
    PostgreSQL
    -
    Ratings
    Connect to Multiple Data Sources6.13 Ratings00 Ratings
    Extend Existing Data Sources6.03 Ratings00 Ratings
    Automatic Data Format Detection6.03 Ratings00 Ratings
    MDM Integration3.01 Ratings00 Ratings
    Data Exploration
    Comparison of Data Exploration features of Microsoft R Open / Revolution R Enterprise and PostgreSQL
    Feature
    Microsoft R Open / Revolution R Enterprise
    7.0
    3 Ratings
    19% below category average
    PostgreSQL
    -
    Ratings
    Visualization7.03 Ratings00 Ratings
    Interactive Data Analysis7.03 Ratings00 Ratings
    Data Preparation
    Comparison of Data Preparation features of Microsoft R Open / Revolution R Enterprise and PostgreSQL
    Feature
    Microsoft R Open / Revolution R Enterprise
    4.8
    3 Ratings
    52% below category average
    PostgreSQL
    -
    Ratings
    Interactive Data Cleaning and Enrichment5.13 Ratings00 Ratings
    Data Transformations5.03 Ratings00 Ratings
    Data Encryption3.01 Ratings00 Ratings
    Built-in Processors6.03 Ratings00 Ratings
    Platform Data Modeling
    Comparison of Platform Data Modeling features of Microsoft R Open / Revolution R Enterprise and PostgreSQL
    Feature
    Microsoft R Open / Revolution R Enterprise
    6.0
    3 Ratings
    34% below category average
    PostgreSQL
    -
    Ratings
    Multiple Model Development Languages and Tools5.03 Ratings00 Ratings
    Automated Machine Learning5.02 Ratings00 Ratings
    Single platform for multiple model development8.03 Ratings00 Ratings
    Self-Service Model Delivery6.03 Ratings00 Ratings
    Model Deployment
    Comparison of Model Deployment features of Microsoft R Open / Revolution R Enterprise and PostgreSQL
    Feature
    Microsoft R Open / Revolution R Enterprise
    6.5
    2 Ratings
    27% below category average
    PostgreSQL
    -
    Ratings
    Flexible Model Publishing Options6.02 Ratings00 Ratings
    Security, Governance, and Cost Controls6.92 Ratings00 Ratings
    Best Alternatives
    Microsoft R Open / Revolution R EnterprisePostgreSQL
    Small Businesses
    RapidMiner
    Score8.9 out of 10
    MariaDB Platform
    Score9.1 out of 10
    Medium-sized Companies
    Anaconda
    Score8.8 out of 10
    MySQL
    Score8.4 out of 10
    Enterprises
    IBM Watson Studio
    Score10 out of 10
    SQLite
    Score8 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Microsoft R Open / Revolution R EnterprisePostgreSQL
    Likelihood to Recommend
    6.0
    (5 ratings)
    8.3
    (56 ratings)
    Likelihood to Renew
    7.0
    (1 ratings)
    9.0
    (1 ratings)
    Usability
    7.0
    (1 ratings)
    8.3
    (9 ratings)
    Availability
    -
    (0 ratings)
    9.0
    (1 ratings)
    Performance
    -
    (0 ratings)
    7.0
    (1 ratings)
    Support Rating
    8.0
    (2 ratings)
    9.3
    (7 ratings)
    Implementation Rating
    -
    (0 ratings)
    9.0
    (1 ratings)
    Product Scalability
    -
    (0 ratings)
    8.0
    (1 ratings)
    User Testimonials
    Microsoft R Open / Revolution R EnterprisePostgreSQL
    Likelihood to Recommend
    Microsoft
    If you are a MS shop specifically, or have more generic data requirement needs from Microsoft sourced data this will work well. If you have a lot of disparate data across a number of unique platforms/cloud systems/3rd party hosted data warehouses then this product will have issues or a lack of documentation on the net. Performance-wise this product is equal to other R platforms out there.
    Incentivized
    Read full review
    PostgreSQL Global Development Group
    PostgreSQL is best used for structured data, and best when following relational database design principles. I would not use PostgreSQL for large unstructured data such as video, images, sound files, xml documents, web-pages, especially if these files have their own highly variable, internal structure.
    Incentivized
    Read full review
    Pros
    Microsoft
    • It allows distributed algorithm runs on Hadoop HDFS cluster
    • It allows using different file formats such as SAS7BAT files or complex files in tab or comma delimited making data munging easier
    • It provides scalable solutions by allowing users to re-use R scripts and distributing the computing over nodes through RHadoop
    Read full review
    PostgreSQL Global Development Group
    • It works well with external data sources and runs on platforms with stable performance.
    • Clients can rest assured that their personal information will be safe and secure.
    • Many forums discuss setup and usage, and most are free.
    • Adding tooling applications to a computer is unlimited.
    • PostgreSQL runs on many OS platforms and supports ANSI SQL, stored procedures, and triggers.
    Read full review
    Cons
    Microsoft
    • Very steep learning curve... for such a quick and useful tool the learning curve is unacceptable.
    • Very dangerous in the wrong hands. Because most add-ons are pre-written, you have to trust the community that malicious script is not used.
    Incentivized
    Read full review
    PostgreSQL Global Development Group
    • Clearer indications on what is the query plan, to optimize the query
    • More out of the box, Postgres specific, SQL functions
    • It would be nice to have a more visual aid of the relationship between all tables, but possibly this depend more on the UI used
    Incentivized
    Read full review
    Likelihood to Renew
    Microsoft
    In general, Revolution Analytics brings a lot of value to the organization. The renewal decision would be based on return on investment in terms of quantified actionable insights that are getting generated against the cost of the product. Additionally, market brand of the tool and reputation risk in terms of possible acquisition and its impact to overall organizational analytic strategy would be considered as well.
    Read full review
    PostgreSQL Global Development Group
    As a needed software for day to day development activities
    Incentivized
    Read full review
    Usability
    Microsoft
    It is good, easy to use, improvements are being made to the product and more info being shared in the community. It just needs some more time to become more integrated to other platforms and tools/data out there.
    Incentivized
    Read full review
    PostgreSQL Global Development Group
    Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.
    Incentivized
    Read full review
    Reliability and Availability
    Microsoft
    No answers on this topic
    PostgreSQL Global Development Group
    PostgreSQL's availability is top notch. Apart from connection time-out for an idle user, the database is super reliable.
    Incentivized
    Read full review
    Performance
    Microsoft
    No answers on this topic
    PostgreSQL Global Development Group
    The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
    Incentivized
    Read full review
    Support Rating
    Microsoft
    Generally support comes through the forums and user generated channels which are helpful, easy to access, quickly turned around and provided by knowledgeable users. However the support channels are not employees and the channels are often used as a way to learn quick difficult elements of R. Better design, users interface and tutorial options would alleviate the need for this sort of interaction.
    Incentivized
    Read full review
    PostgreSQL Global Development Group
    There are several companies that you can contract for technical support, like EnterpriseDB or Percona, both first level in expertise and commitment to the software.
    But we do not have contracts with them, we have done all the way from googling to forums, and never have a problem that we cannot resolve or pass around. And for dozens of projects and more than 15 years now.
    Incentivized
    Read full review
    Online Training
    Microsoft
    No answers on this topic
    PostgreSQL Global Development Group
    The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
    Incentivized
    Read full review
    Implementation Rating
    Microsoft
    No answers on this topic
    PostgreSQL Global Development Group
    The online documentation of the PostgreSQL product is elaborate and takes users step by step.
    Incentivized
    Read full review
    Alternatives Considered
    Microsoft
    The two are different products for different purposes. But for someone who has little or no experience in R programming, Power BI would be better for starting with. Having said that, Microsoft R is built on R, thus allowing for customization of complex calculations not typically available otherwise.
    Incentivized
    Read full review
    PostgreSQL Global Development Group
    Although the competition between the different databases is increasingly aggressive in the sense that they provide many improvements, new functionalities, compatibility with complementary components or environments, in some cases it requires that it be followed within the same family of applications that performs the company that develops it and that is not all bad, but being able to adapt or configure different programs, applications or other environments developed by third parties apart is what gives PostgreSQL a certain advantage and this diversification in the components that can be joined with it, is the reason why it is a great option to choose.
    Incentivized
    Read full review
    Scalability
    Microsoft
    No answers on this topic
    PostgreSQL Global Development Group
    The DB is reliable, scalable, easy to use and resolves most DB needs
    Incentivized
    Read full review
    Return on Investment
    Microsoft
    • Helped save company money versus buying other stat software
    Incentivized
    Read full review
    PostgreSQL Global Development Group
    • Easy to administer so our DevOps team has only ever used minimal time to setup, tune, and maintain.
    • Easy to interface with so our Engineering team has only ever used minimal time to query or modify the database. Getting the data is straightforward, what we do with it is the bigger concern.
    • It's free. You can't beat that.
    Incentivized
    Read full review
    ScreenShots