Fivetran Data Movement Platform
FivetranExternal reviews
790 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Census is a huge timesaver and makes onboarding new tools seamless
What do you like best about the product?
I love that we don't have to write a custom integration to connect our data warehouse to our applications. It's a huge time saver and allows us more freedom to experiment & add new things.
What do you dislike about the product?
Not a lot of things! There are a handful of integrations that I'd like them to add, but they are typically super responsive and add them pretty quickly. I hadn't set up my error notifications correctly, so I missed a handful of times when a sync broke. But the notifications are there, you just have to remember to customize.
What problems is the product solving and how is that benefiting you?
It solves the problem of being difficult/manual to connect the data in our Snowflake data warehouse to other tools that we use. This enables to do so much more with our data - connecting it to marketing automation tools to send more intelligent/relevant emails to our users, and to our CRM so sales reps know which users are most active in our product, and so much more.
I really liked using Census. It helps provide scalability between dbt and Salesforce
What do you like best about the product?
Easy to use GUI.
I can easily transfer data between dbt and Salesforce and the whole company stays aligned
I can easily transfer data between dbt and Salesforce and the whole company stays aligned
What do you dislike about the product?
I wish the tool was a little cheaper so we could provide more licenses
What problems is the product solving and how is that benefiting you?
We always have up to date data in our salesforce which is great!!
Really easy to use!
What do you like best about the product?
Census was super low-overhead to get set up with and has been very reliable.
What do you dislike about the product?
I haven't really run into any issues with Census so far.
What problems is the product solving and how is that benefiting you?
Census helps me keep Salesforce in sync with the latest product engagement data.
With Census, our entire team has access to the right data in the tool they are using
What do you like best about the product?
The quick onboarding and the integrations
What do you dislike about the product?
Everything is working so well and they are the only major player on the market
What problems is the product solving and how is that benefiting you?
Access to the right data in the right format to make decisions
The perfect sync
What do you like best about the product?
-- Great customer support and very hands on with getting us up and running and maintenance
-- Software was exactly what we needed to get audiences from our robust database into our different markeitng tools.
-- Software was exactly what we needed to get audiences from our robust database into our different markeitng tools.
What do you dislike about the product?
none! software works well and as intended.
What problems is the product solving and how is that benefiting you?
Syncing our customers across all channels. We have a huge customer database and want to ensure we're marketing to the same cohorts across all channels. Creates an omni-channel experience.
Census is an Effective and Functional Data Visualization Package.
What do you like best about the product?
1. Easy to configure Census tools and the interface.
2. Data modeling functions are powerful.
3. Analytics and the reports created by Census are valuable.
4. Excellent workflow and database management system.
5. The easy data transfer across other products is nice.
2. Data modeling functions are powerful.
3. Analytics and the reports created by Census are valuable.
4. Excellent workflow and database management system.
5. The easy data transfer across other products is nice.
What do you dislike about the product?
The Census functions are very simple on the first time to implement this product and the training curve is very short and enjoyable process of tools manipulation and easy navigation.
What problems is the product solving and how is that benefiting you?
1. To create project report is simple through Census.
2. Data analytics preparation is very easy.
3. Employees database easy management and documentation is perfect.
4. Excellent workflow and data control are effective through Census tools.
5. The integration of multiple project big data via Census functions is very easy and secure.
2. Data analytics preparation is very easy.
3. Employees database easy management and documentation is perfect.
4. Excellent workflow and data control are effective through Census tools.
5. The integration of multiple project big data via Census functions is very easy and secure.
Quick to Set up - very well integrated
What do you like best about the product?
Speedy for the data team to set up and connects perfectly with snowflake. We have been able to move into BI tooling quickly as a result of building this layer.
What do you dislike about the product?
No complaints of the software at this time and the integrations and onboarding team have been excellent.
What problems is the product solving and how is that benefiting you?
Connecting and data with snowflake and handling ELT and DBT.
The leading low-code data ingestion solution
What do you like best about the product?
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 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
What do you dislike about the product?
- 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
- 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
What problems is the product solving and how is that benefiting you?
- 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
- 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
Easy set up, excelent customer service and helps us save a lot of time in our analysis.
What do you like best about the product?
The easiness to set up connector with different platforms and the accuracy of the data. If there was a problem, the customer service people tend to help out right away.
What do you dislike about the product?
Would be good to get a projected MAR usage and cost based on the changes you make in the in-between months. As currently, it only shows i'm projectd to spend $300 by in fact it would be way under $150.
What problems is the product solving and how is that benefiting you?
Building custom tables of daily KPIs from different platforms.
As a consultancy, we save a lot of time gathering data from different platforms and analysing with Fivetran compared to the traditional way.
As a consultancy, we save a lot of time gathering data from different platforms and analysing with Fivetran compared to the traditional way.
Great bootstrapping option for the Modern Data Warehouse, but still some way to go
What do you like best about the product?
As the title suggests it's a great option for bootstrapping a brand-new data department where Data Engineers are expensive or difficult to hire. It works well with other lean-team modern data warehouse-type technologies such as Snowflake and DBT. I got 850 Shopify tables and a few other AD sources setup really quickly
What do you dislike about the product?
Whilst Fivetran runs interchangeably across data warehouses,
1) There lack support for low-latency refresh which means if you need data in your apps or dashboards within 5-10 minutes you'll need to build your own custom pipeline
2) APIs are interpreted and landed nicely for you, but this also means there will be a huge switching cost once you build your pipeline on top of the Fivetran loaders.
3) More complicated or large connectors just don't live up to the low-fuss no-code philosophy. There isn't enough architectural knowledge on the Fivetran team to help deploy these connectors successfully.
4) Their logging could be better, troubleshooting really complicated issues like wrong writes has been a non-starter since no write logs take place we simply can't tell how a wrong write ended up there
5) Primary Tables work great (tables with updated timestamps), but not everything syncs and we often have missing records on secondary tables - these are REALLY hard to verify (you only find out when the business points it out)
Some Examples of 3:
1) E.g. We've tried to set up a NetSuite connector for over 6 months, the lack of an ERD or data-dictionary map just makes it really tough to get it going
2) Google/Facebook Ads ==> Some connectors don't really drop data as expected - for web marketing you end up receiving jinja variables rather than the actual attribute {{ UTM }}, other tools such as Supermetrics tend to do better in imputing these for the end user.
1) There lack support for low-latency refresh which means if you need data in your apps or dashboards within 5-10 minutes you'll need to build your own custom pipeline
2) APIs are interpreted and landed nicely for you, but this also means there will be a huge switching cost once you build your pipeline on top of the Fivetran loaders.
3) More complicated or large connectors just don't live up to the low-fuss no-code philosophy. There isn't enough architectural knowledge on the Fivetran team to help deploy these connectors successfully.
4) Their logging could be better, troubleshooting really complicated issues like wrong writes has been a non-starter since no write logs take place we simply can't tell how a wrong write ended up there
5) Primary Tables work great (tables with updated timestamps), but not everything syncs and we often have missing records on secondary tables - these are REALLY hard to verify (you only find out when the business points it out)
Some Examples of 3:
1) E.g. We've tried to set up a NetSuite connector for over 6 months, the lack of an ERD or data-dictionary map just makes it really tough to get it going
2) Google/Facebook Ads ==> Some connectors don't really drop data as expected - for web marketing you end up receiving jinja variables rather than the actual attribute {{ UTM }}, other tools such as Supermetrics tend to do better in imputing these for the end user.
What problems is the product solving and how is that benefiting you?
Bootstrapping - As the person leading up a newly formed team, there was literally no way to build a Data Warehouse within 6 months without one of these low-code points and click connectors. I had a look at Stitch vs. Fivetran and decided to go with Fivetran even though Stitch had more connectors because Fivetran had developed DBT packages. Even though I no longer use them (the packages), they were a huge timesaver when I first started out.
showing 331 - 340