G2

Alan E.

Lead Data Architect

Small-Business (50 or fewer emp.)

Updated 2/15/2024

Originally submitted 11/18/2022

"The leading low-code data ingestion solution"

5/5

What do you like best about Fivetran?

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 Review collected by and hosted on G2.com.

What do you dislike about Fivetran?

- 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 Review collected by and hosted on G2.com.

What problems is Fivetran 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 Review collected by and hosted on G2.com.

Current UserValidated ReviewerIncentivizedSource: G2 invite on behalf of seller