Fivetran Data Movement Platform
FivetranExternal reviews
806 reviews
from
and
External reviews are not included in the AWS star rating for the product.
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
Fantastic tool, great support!
What do you like best about the product?
Support has been fantastic in helping get everything up and running. It's highly customizable and straightforward to use.
What do you dislike about the product?
Not everything is plug and play -- there is absolutely some coding still needed and experience with APIs.
What problems is the product solving and how is that benefiting you?
It is helping bridge the gap of needing SQL abilities to query Zendesk data.
The ONLY solution for Microsoft SQL Integrations
What do you like best about the product?
Super simple to set up and manage in comparison with other products on the market. FiveTran also gives complete control over what data is needed and how it is transformed into the new location.
What do you dislike about the product?
Better integrations with other platforms such as Pipedrive.
What problems is the product solving and how is that benefiting you?
We needed Microsoft SQL data migrated into a data warehouse. Fivetran has been the most accessible and affordable option to allow us to do this regularly without any issues.
Powerful & Easy to Use
What do you like best about the product?
The interface is very intuitive. We were able to start pushing data back into our CRM almost immediately. Census has very deep integrations with the apps we use, so in addition to mapping fields into standard objects, we're also able to easily sync data into custom objects and create object associations.
What do you dislike about the product?
I'd like to see an overall report/list of all the destination fields we're syncing into. It would also be very helpful if Census supported creating HubSpot quotes, which HubSpot recently exposed through their API.
What problems is the product solving and how is that benefiting you?
We're a software product company. Our primary use case involves syncing product usage data into our CRM and marketing automation platform for segmentation and sales lead prioritization.
Helped us a lot
What do you like best about the product?
Census made it really easy for us to conduct simple reverse-etl tasks without having to get our engineering team involved. This made it a lot easier to make changes when we needed to do so.
What do you dislike about the product?
There is a bit of a learning curve with the software, and those who are more senior level or less-technical might have a bit of a higher lift to become proficient in the tool.
What problems is the product solving and how is that benefiting you?
Census allows companies to take data from disparate places such as product databases or tools that do not natively connect to crm systems. These extra connections make it much easier to share insights.
Great user experience and support
What do you like best about the product?
The user interface is so intuitive and the docs are helpful.
What do you dislike about the product?
The recovery can be dangerous if you don't sync properly
What problems is the product solving and how is that benefiting you?
I can centralize data from all my tools and then push to my systems.
Necessary for every analytics engineers toolkit
What do you like best about the product?
- Seamless integration, able to setup within minutes
- Notification system (emails when anything breaks)
- Good UI
- Preview of data is excellent
- Quality tester is useful
- Notification system (emails when anything breaks)
- Good UI
- Preview of data is excellent
- Quality tester is useful
What do you dislike about the product?
- Doesn't integrate with specific tools, so check before purchasing if your tools integrate
- Building a connector is significant work, although I have never tested this directly
- It is challenging to edit certain aspects of a connector, but since it's so easy to set up a new one, this isn't a big deal
- Recovery from a connection that wasn't correctly setup can be extensive
- Building a connector is significant work, although I have never tested this directly
- It is challenging to edit certain aspects of a connector, but since it's so easy to set up a new one, this isn't a big deal
- Recovery from a connection that wasn't correctly setup can be extensive
What problems is the product solving and how is that benefiting you?
Reverse ETL - sending data from multiple sources that have been cleaned and transformed back into critical software to present to the rest of the company. This allows users to get the information they need in one place.
Quick and easy way to sync data from DWH to business systems
What do you like best about the product?
I'm not a primary user of Census, but I do admin a connected business system that relies on product data to function. Census is one of the quickest and easiest ways I've ever used to get product data from a data warehouse to a connected system. I don't even know SQL, but I was able to modify a query that our data team outlined for me to test and deploy a sync in under half a day. I'm looking forward to learning basic SQL so that I can start self-serving the data my team needs through Census.
What do you dislike about the product?
My biggest con of Census currently is not knowing SQL, which is just a gap in my skill set. Once I build knowledge of basic SQL, I don't think I'll have many complaints about the system. Of course, the usability of Census is dependent upon the cleanliness and organization of our DWH, which could use some work, but that's our problem. :)
What problems is the product solving and how is that benefiting you?
I've used Census to push product usage data from our data warehouse into a connected business system. There, we use the data to measure and score customer health, drive action to customer-facing teams, and visualize product usage in the system our reps are working in.
Census is essentially doing my job
What do you like best about the product?
Census makes data so much more accessible to our CRM. Our RevOps and marketing team can get all the data from our warehouse into Salesforce, with very minimal work on my end.
What do you dislike about the product?
We've had an overwhelmingly positive experience with census. One small thing I wish was available was the ability to clone whole syncs or configurations. A lot of the time we'll set something up with a sandbox environment first for QA. It would remove the redundant work of having to do the exact same thing for another destination, but it is a minor inconvenience.
What problems is the product solving and how is that benefiting you?
Unlocking more insights in salesforce, helping us tie important data to our ad audiences, and ultimately making our data warehouse a bit more accessible without having to grant local permissions to a number of users.
Good Reverse ETL Tool
What do you like best about the product?
The fastest and easiest way to send data to Salesforce.
What do you dislike about the product?
It's a good question but still need to figure out.
What problems is the product solving and how is that benefiting you?
Timely data records push to different instances helps the team to deliver things on time.
showing 131 - 140