TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Fivetran

    Score8.2 out of 10
    N/AFivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance. The vendor says Fivetran began with a realization: For modern companies using cloud-based software and storage, traditional ETL tools badly underperformed, and the complicated configurations they required often led to project failures. To streamline and accelerate…

    $0.01

    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
    Pricing
    FivetranMicrosoft R Open / Revolution R Enterprise
    Editions & Modules
    Starter
    $0.01
    per credit
    Standard
    $0.01
    per credit
    Enterprise
    $0.01
    per credit
    No answers on this topic
    Offerings
    Pricing Offerings
    FivetranMicrosoft R Open / Revolution R Enterprise
    Free Trial
    YesNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeOptionalNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    FivetranMicrosoft R Open / Revolution R Enterprise
    Considered Both Products
    Fivetran
    No answer on this topic
    Microsoft
    No answer on this topic
    Key User Insights
    Would buy again
    100%
    Would buy again
    9 Answers
    No answers on this topic
    Delivers good value for the price
    100%
    Delivers good value for the price
    8 Answers
    No answers on this topic
    Happy with the feature set
    100%
    Happy with the feature set
    9 Answers
    No answers on this topic
    Lived up to sales and marketing promises
    100%
    Lived up to sales and marketing promises
    7 Answers
    No answers on this topic
    Implementation went as expected
    100%
    Implementation went as expected
    7 Answers
    No answers on this topic
    Features
    FivetranMicrosoft R Open / Revolution R Enterprise
    Data Source Connection
    Comparison of Data Source Connection features of Fivetran and Microsoft R Open / Revolution R Enterprise
    Feature
    Fivetran
    10.0
    8 Ratings
    18% above category average
    Microsoft R Open / Revolution R Enterprise
    -
    Ratings
    Connect to traditional data sources10.08 Ratings00 Ratings
    Connecto to Big Data and NoSQL10.06 Ratings00 Ratings
    Data Transformations
    Comparison of Data Transformations features of Fivetran and Microsoft R Open / Revolution R Enterprise
    Feature
    Fivetran
    7.5
    7 Ratings
    8% below category average
    Microsoft R Open / Revolution R Enterprise
    -
    Ratings
    Simple transformations7.67 Ratings00 Ratings
    Complex transformations7.45 Ratings00 Ratings
    Data Modeling
    Comparison of Data Modeling features of Fivetran and Microsoft R Open / Revolution R Enterprise
    Feature
    Fivetran
    6.2
    8 Ratings
    25% below category average
    Microsoft R Open / Revolution R Enterprise
    -
    Ratings
    Data model creation2.06 Ratings00 Ratings
    Metadata management4.04 Ratings00 Ratings
    Business rules and workflow8.06 Ratings00 Ratings
    Collaboration7.95 Ratings00 Ratings
    Testing and debugging9.04 Ratings00 Ratings
    Data Governance
    Comparison of Data Governance features of Fivetran and Microsoft R Open / Revolution R Enterprise
    Feature
    Fivetran
    8.3
    7 Ratings
    3% above category average
    Microsoft R Open / Revolution R Enterprise
    -
    Ratings
    Integration with data quality tools8.36 Ratings00 Ratings
    Integration with MDM tools8.34 Ratings00 Ratings
    Platform Connectivity
    Comparison of Platform Connectivity features of Fivetran and Microsoft R Open / Revolution R Enterprise
    Feature
    Fivetran
    -
    Ratings
    Microsoft R Open / Revolution R Enterprise
    5.3
    3 Ratings
    45% below category average
    Connect to Multiple Data Sources00 Ratings6.13 Ratings
    Extend Existing Data Sources00 Ratings6.03 Ratings
    Automatic Data Format Detection00 Ratings6.03 Ratings
    MDM Integration00 Ratings3.01 Ratings
    Data Exploration
    Comparison of Data Exploration features of Fivetran and Microsoft R Open / Revolution R Enterprise
    Feature
    Fivetran
    -
    Ratings
    Microsoft R Open / Revolution R Enterprise
    7.0
    3 Ratings
    19% below category average
    Visualization00 Ratings7.03 Ratings
    Interactive Data Analysis00 Ratings7.03 Ratings
    Data Preparation
    Comparison of Data Preparation features of Fivetran and Microsoft R Open / Revolution R Enterprise
    Feature
    Fivetran
    -
    Ratings
    Microsoft R Open / Revolution R Enterprise
    4.8
    3 Ratings
    52% below category average
    Interactive Data Cleaning and Enrichment00 Ratings5.13 Ratings
    Data Transformations00 Ratings5.03 Ratings
    Data Encryption00 Ratings3.01 Ratings
    Built-in Processors00 Ratings6.03 Ratings
    Platform Data Modeling
    Comparison of Platform Data Modeling features of Fivetran and Microsoft R Open / Revolution R Enterprise
    Feature
    Fivetran
    -
    Ratings
    Microsoft R Open / Revolution R Enterprise
    6.0
    3 Ratings
    34% below category average
    Multiple Model Development Languages and Tools00 Ratings5.03 Ratings
    Automated Machine Learning00 Ratings5.02 Ratings
    Single platform for multiple model development00 Ratings8.03 Ratings
    Self-Service Model Delivery00 Ratings6.03 Ratings
    Model Deployment
    Comparison of Model Deployment features of Fivetran and Microsoft R Open / Revolution R Enterprise
    Feature
    Fivetran
    -
    Ratings
    Microsoft R Open / Revolution R Enterprise
    6.5
    2 Ratings
    27% below category average
    Flexible Model Publishing Options00 Ratings6.02 Ratings
    Security, Governance, and Cost Controls00 Ratings6.92 Ratings
    Best Alternatives
    FivetranMicrosoft R Open / Revolution R Enterprise
    Small Businesses
    Skyvia
    Score10 out of 10
    RapidMiner
    Score8.9 out of 10
    Medium-sized Companies
    IBM InfoSphere Information Server
    Score10 out of 10
    Anaconda
    Score8.8 out of 10
    Enterprises
    SolarWinds Task Factory
    Score8.3 out of 10
    IBM Watson Studio
    Score10 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    FivetranMicrosoft R Open / Revolution R Enterprise
    Likelihood to Recommend
    8.0
    (10 ratings)
    6.0
    (5 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    7.0
    (1 ratings)
    Usability
    8.2
    (3 ratings)
    7.0
    (1 ratings)
    Performance
    8.0
    (1 ratings)
    -
    (0 ratings)
    Support Rating
    -
    (0 ratings)
    8.0
    (2 ratings)
    User Testimonials
    FivetranMicrosoft R Open / Revolution R Enterprise
    Likelihood to Recommend
    Fivetran
    Fivetran's business model justifies the use-case where we require data from a single source basically a lot of data but if the requirement is not on the heavier side, Fivetran comes to costly operation when compared to its peers. Otherwise, I'll recommend Fivetran for stability and update and seamless service provider.
    Incentivized
    Read full review
    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
    Pros
    Fivetran
    • Easily connects to source data using delivered connectors
    • Transforms data into standard models and schemas
    • Has very good documentation to help quickly setup connectors
    Incentivized
    Read full review
    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
    Cons
    Fivetran
    • Very difficult to get connectors enhanced if a specific needed object is not supported by them
    • Depending on the edition needed and the data volumes, can get quite expensive
    Incentivized
    Read full review
    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
    Likelihood to Renew
    Fivetran
    No answers on this topic
    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
    Usability
    Fivetran
    Very easy and intuitive to setup and maintain as there usually are not that many options. Very well documented (e.g. how to setup each connector, how the schema looks like, any specific features of this connector etc.). Also the operation is intuitive, e.g. you have status pages, log pages, configuration pages etc. for each connector.
    Incentivized
    Read full review
    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
    Performance
    Fivetran
    It runs pretty well and gets our data from point A to point cluster quickly enough. Honestly, it's not something I think about unless it breaks and that's pretty rare.
    Incentivized
    Read full review
    Microsoft
    No answers on this topic
    Support Rating
    Fivetran
    No answers on this topic
    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
    Alternatives Considered
    Fivetran
    We never seriously considered using anything else. Our data engineers had used Fivetran extensively in previous roles so when it came time to make a decision, there wasn't much of a process. They gladly signed the contract with Fivetran pretty quickly.
    Incentivized
    Read full review
    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
    Return on Investment
    Fivetran
    • It has been very positive in serving BI team with new source requests
    • It has been OK at scaling to match as data volumes as source data size grows
    Incentivized
    Read full review
    Microsoft
    • Helped save company money versus buying other stat software
    Incentivized
    Read full review
    ScreenShots