87% SW Score The SW Score ranks the products within a particular category on a variety of parameters, to provide a definite ranking system. Read more
Reliable and simple access to your data
53.8%
36.6%
5.2%
1.6%
2.8%
Ease of Setup, Extensive Connector Availability, Excellent Customer Support, Data Sync Reliability
High Pricing, Limited Customization Options, Occasional Connector Issues, Opaque Billing Practices
Fivetran is generally well-received by users, earning praise for its ease of use, reliability, and customer support. Reviewers appreciate its seamless data integration capabilities, praising its ability to handle complex data pipelines and automate data transfer processes. Additionally, Fivetran's user-friendly interface and intuitive design are commonly cited as strengths. However, some users have expressed concerns regarding pricing and occasional technical glitches, suggesting room for improvement in these areas. Overall, Fivetran appears to be a solid choice for businesses seeking a reliable and user-friendly data integration solution.
AI-Generated from the text of User Reviews
Fivetren makes data processes simple/quick. Our team likes how easy it is to start without any coding. There are many turn-key connectors available, which is great for businesses that we provide IT services for. Also, their netsuite connector helps us move data smoothly. The interface is quite user-friendly, so we can delegate tasks to junior data specialists within our tema and cut maintenance costs for our clients.
A recurring concern is the pricing model, particularly the cost associated with automating and tracking historical data and data warehouse tables. The model based on monthly active rows can be confusing, making it challenging to forecast expenses, especially for our enterprise customers with vast amounts of data.
We use Fivetran as one of the key elements of our client's data systems. It assists with ELT, offers out-of-the-box integrations for most of the common SaaS tools our clients use, and then the data goes straight to the warehouse. We also created three custom connectors ourselves. Everything works pretty smoothly and requires little attention for maintenance.
Fivetran seamlessly automates the data flow from our CDP (Segment) to our staging warehouse (Google Big Query), ensuring timely and efficient data integration for our marketing dashboards. The extensive range of connectors allows us to integrate various data sources, enhancing the efficiency and accuracy of our TOFU, MOFU, and BOFU marketing strategies.
While Fivetran is efficient, it offers limited customization options, which can be a challenge when dealing with diverse data sources and complex transformations. In our case it was Intercom. The cost of using Fivetran may be a concern for smaller projects with a limited budget.
We utilize Fivetran for transforming and validating data for our marketing dashboards. It plays a crucial role in providing insights into our conversion funnels and helping us optimize our marketing and customer success strategies.
The data flows from Segment to Google Big Query and then undergoes transformation in Fivetran, validation in dbtCloud, and finally moves to the production warehouse (Google BQ with dbt_metrics dataset). This streamlined process has enhanced our ability to monitor and analyze our Acquisition & Activation, Activation & Retention, and Referral & Revenue efforts, corresponding to TOFU, MOFU, and BOFU stages respectively.
The easy administration and overall ease of use.
Lack of advanced features (for example, creating partitioned tables)
Creating multiple data pipelines from multiple data sources with changing schemas to the central data warehouse.
Simplicity and abstraction of ingestion. This tool does not show what is under the hood and it is not required for you to do so. This tool just does the task that you want it to do.
This tool does not support On-Prem use cases where security is a concern. Eventually, this tool will also support on-prem sources as well which will make it the best tool for all sources and destinations.
Check with Fivetran if you are looking to eliminate your custom ingestion framework and maintenance, as well as the development of new ingestion sources and destinations. Complete a Fivetran POC and learn what this product supports and how it can help your business.
This directly supports the business to ensure data in the downstream dashboards is up-to-date. Benefits include no maintenance and human costs since all the development and maintenance of the code is maintained by Fivetran and Fivetran Support in conjunction with Fivetran Engineering ensures that all issues are resolved.
Very easy to add new connectors and get things up and running quickly!
So far nothing. It's made things much easier and faster on our end. The ability to add connectors quickly and move our data has been really helpful.
Moving data from various places into a single location.
The free trial allows you to test and set up connectors within platforms to implement within your BI for an entire month.
Fivetrans's ease of connector and setup alongside its customizability into custom schema was the perfect solution for us.
Fivetrans customer success and tech teams work alongside you to help you get the most out of the platform, ensure you have unanswered questions answered, and are great for technical advice and best practice
Initial sync times & connector setup times are set for life, meaning if you are specifically looking at specifically timed extracts, there is a little bit of disconnect.
You can reset these however and work on improving/optimising these
Extracting from a specific platform (connector) in a mass, customisable way
I love how easy it is to setup new connectors and start bringing new data into my warehouse. I can connect new datasets and work with that data in my end state in minutes.
As with any tool it takes a little while to get acquainted, but I found it relatively easy to figure out how everything works.
Fivetran helps me move data into my data warehouse that otherwise sit in a silo. Being able to put disparate datasets side by side realizes enormous value for our company.
Fivetran as a tool is incredibly intuitive and, due to its speedy implementation time, almost immediately generates value for the business. Additionally, no real coding experience is required to use the tool, making it an excellent choice for analysts without an engineering background.
Potentially, one could argue that Fivetran's pricing is steep - especially if you plan on syncing high-volume connectors like Google Search or Google Ads (at least those are the highest-volume connectors for us).
Using Fivetran allows us to centralize data across our most essential source systems. The seamless integration with dbt additionally facilitates the planning and execution of transformation jobs overarching the whole data pipeline. The only thing currently missing is some Reverse ETL feature.
* Easy to Use
* Lots of connectors available
* Easy integration with DBT
* Great support
* Logarithmic pricing
* How-To-Guides are on POINT
* How we use credits can be confusing
* Missing connectors to some of our largest data providers (Not really their fault)
* Moving data from point A to point B
Looking for the right SaaS
We can help you choose the best SaaS for your specific requirements. Our in-house experts will assist you with their hand-picked recommendations.
Want more customers?
Our experts will research about your product and list it on SaaSworthy for FREE.
Fivetran offers a truly competitive solution for data integration, in particular when you're looking to connect to a source application and ingest that data into a Data Warehouse or Data Lake and to do that with minimal development/configuration/customization. The best features are:
- The number of application connectors. There are hundreds of connectors to both SaaS/Web based applications such as Salesforce, Coupa, JIRA, etc as well as database and on-premise, of particular interest to us was SAP
- The ease of configuration/setup to integrate to a source connection and the time taken to ingest and synch to a destination connection
- The Data Change Capture (CDC) feature for many of the connectors (not all connectors offer CDC) is very slick and will easily manage INSERTS, UPDATES, DELETES in your data and track the date/time of those changes
- The ability to connect to SAP and manage CDC through the database logs. This provides a minimal intrusion feature that is not reliant on many other SAP connectors/integrations which go through the API layer (RFC)
- The SAP integration can ingest many of the complicated SAP objects such as long-text data/tables involving structures like pool and cluster
- The easy UI that allows you to change basic configurations such as frequency of update, tables/fields required to ingest and usage/billing
- Technical Support is excellent and responsive, although you probably have to be on the Business Critical support to realize this
- Integration with dbt and an emerging "Marketplace" of pre-built models and transformations
- The support for dbt does not currently include Azure Synapse, which is what we are using for our Data Platform
- The frequency of refresh configuration is good, but it would also be good if you could have a "Date/Time" of refresh rather than a synch period such as "Every 1 hour, every 24 hours, etc"
- Would be nice if Fivetran could support the ingestion of SAP structure fields/tables
- Would be great if Fivetran could ingest SAP BW data
- We can now ingest data from some of our enterprise applications where it has been extremely difficult or near impossible previously. Many of the previous "integrations" existed of basic text/csv exports from some of our applications or emailed reports. This process was very manual, and now the data just appears in our Data Lake and, all the changes are handled beautifully.
- In SAP, some tables are very difficult sometimes, impossible to ingest without major development/integration efforts, such as ingesting pool/cluster tables. The method we have previously used in going via the SAP API (RFC) has also been much slower, and managing the data changes has had to be managed programmatically
- We will be able to ingest data from some applications at a higher frequency than daily/nightly, which helps with the number of use cases we often have to deal with around manufacturing processes