Fivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance.The vendor says Fivetran began with a realization: For modern companies using…
2 years of experience1 year of experience2 years of experience1 year of experience1 year of experience2 years of experience
| Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
| Supported Countries | Worldwide |
| Supported Languages | English |
Fivetran is a versatile data integration platform that offers a wide range of digital connectors, making it a valuable tool for organizations that require multiple data sources for making informed business decisions. Users appreciate the ease with which they can export and convert communication data from the panel to other services, as well as the seamless integration with software such as Microsoft Access without compromising data integrity. The platform ensures complete replication of all loaded data by default, eliminating concerns about incomplete or damaged files. This reliability and availability make Fivetran a popular choice for near real-time data replication between source systems and organization-wide databases, including traditional RDBMS, APIs, and SAP HANA. It also supports data transformations, proving useful for specific use cases.
Data management teams rely on Fivetran to replicate and synchronize data across various systems, ensuring that organizations have accurate and up-to-date information to analyze and strategize based on. Reporting and analytics teams find value in using Fivetran to ingest data from multiple SaaS, Ad platforms, and internal sources, enabling the ELT approach. The software excels at ETL processes, facilitating seamless data transfer to data warehouses while keeping production systems unaffected. By securely replicating production databases to data warehouses at regular intervals, Fivetran helps organizations maintain comprehensive historical records of their data. It also serves as an Extract Transform Load provider, seamlessly bringing data from third-party services into data warehouses like Microsoft Azure.
Users have found specific connectors like Twilio's SendGrid to be particularly valuable when formatting and analyzing email and notification data within their data warehouse. Overall, Fivetran proves to be an essential tool for organizations seeking reliable and efficient data integration solutions across various platforms and systems.
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.
