Fivetran

Intuitive Accessibility Permissions: Users have found the accessibility permissions within Fivetran to be intuitive, allowing them to easily secure and identify the allowed managers for data administration. This feature has been praised by multiple reviewers.

High Scalability of Data Replication Operations: The high scalability of data replication operations in Fivetran has received praise from users. It is ideal for creating backups of information in both cloud and non-cloud environments, ensuring source systems are well-protected. Several reviewers have highlighted this advantage.

Quick and Effective Customer Support: The customer support representative provided quick solutions to fix issues with the platform, as acknowledged by a user. Despite the issues being configuration errors on their part, the positive experience with Fivetran's support team was appreciated.

Difficult Metrics Collection: Some users have found it challenging to collect metrics for analysis as the data is not automatically extracted, requiring manual effort and potentially slowing down the analysis process.

Lack of Integrations: Many reviewers have expressed frustration about the lack of integrations, making it difficult to migrate information to other tools such as CRM or online security platforms. This limitation hampers workflow efficiency and prevents seamless collaboration with other systems.

No Process for Database Review: A notable concern raised by users is the absence of a formal process for team leaders to review databases before initiating operations. This creates a sense of insecurity regarding data reviews and increases the risk of errors going unnoticed.

Many users recommend taking advantage of the free trial period to evaluate if Fivetran offers all the required integrations and to understand its functionality. They suggest comparing Fivetran with competitors such as Stitch and Matillion to ensure compatibility with major data sources and destination data warehouse. Additionally, it is recommended to leverage the built-in connectors provided by Fivetran and have a DBA (Database Administrator) available to handle any connection nuances.

Users advise considering Fivetran's pricing model before making a decision, as it can help avoid future migration to a larger platform. They suggest estimating usage and understanding the costs involved to prevent any surprises. While some caution about the cost, many find Fivetran user-friendly for Extract-Load-Transform (ELT) processes.

Reviewers highly appreciate Fivetran's ability to handle a large number of API connectors and its effectiveness in handling data extraction from various sources effortlessly. Users recommend using Fivetran for pulling data from a diverse range of connections, especially considering its unique feature of validating connections during the free trial period. Additionally, they suggest contacting the Fivetran team for guidance on specific use cases and pricing options.

Overall, users find Fivetran to be a valuable tool for data engineering tasks, but they recommend thoroughly evaluating it during the free trial, comparing it with competitors, understanding pricing models, and estimating usage before making a final decision.