Overview
What is Fivetran?
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…
Fivetran - next generation data replication
Effortless ETL setup in minutes
Fivetran for fast data replication
Highly recommend Fivetran
Digital Seamless data provider only when you know your data requirement in advance.
Fivetran makes ELT quick and easy
Gets data from Point A to Point B
Popular Features
- Connect to traditional data sources (6)8.686%
- Simple transformations (5)7.575%
- Data model creation (5)7.272%
Pricing
Starter
$0.01
Standard
$0.01
Enterprise
$0.01
Entry-level set up fee?
- Setup fee optional
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Starting price (does not include set up fee)
- $0.01
Product Demos
Fivetran - Interactive Demo
Features
Data Source Connection
Ability to connect to multiple data sources
- 8.6Connect to traditional data sources(6) Ratings
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
- 6.6Connecto to Big Data and NoSQL(4) Ratings
Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases
Data Transformations
Data transformations include calculations, search and replace, data normalization and data parsing
- 7.5Simple transformations(5) Ratings
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
- 7.5Complex transformations(3) Ratings
Complex data transformations are data normalization, advanced data parsing, etc.
Data Modeling
A data model is a diagram or flowchart that illustrates the relationships between data
- 7.2Data model creation(5) Ratings
Ability to create and maintain data models using a graphical tool to define relationships between data
- 8.6Metadata management(3) Ratings
Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management
- 4.2Business rules and workflow(4) Ratings
Ability to define and manage business rules and workflows
- 8.9Collaboration(3) Ratings
Collaboration is enabled by a shared repository of project information and metadata
- 7.1Testing and debugging(2) Ratings
Tool to debug and tune for optimal performance
Data Governance
Data governance is the practise of implementing policies defining effective use of an organization's data assets
- 6.7Integration with data quality tools(4) Ratings
Integration with tools for cleansing, parsing and normalizing data according to business rules
- 7Integration with MDM tools(2) Ratings
Integration with master data management tools to ensure data consistency across the organization
Product Details
- About
- Competitors
- Tech Details
- Downloadables
- FAQs
What is Fivetran?
The vendor says Fivetran began with a realization: For modern companies using cloud-based software and storage, traditional ETL tools badly underperformed, and the complicated configurations they required often led to project failures. To streamline and accelerate analytics projects, Fivetran developed zero-configuration, zero-maintenance pipelines to deliver data into modern cloud warehouses.
Shaped by the real-world needs of data analysts and business intelligence users, Fivetran technology promises to enable organizations to control their data without complex engineering and ultimately supports data-backed decisions and company culture.
Fivetran Features
- Supported: Five-minute setup
- Supported: Complete replication from any source
- Supported: Fully managed 24x7
- Supported: Normalized schemas from denormalized APIs
- Supported: Automatic schema migrations
Fivetran Videos
Fivetran Competitors
Fivetran Technical Details
Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Unspecified |
Mobile Application | No |
Supported Countries | Worldwide |
Supported Languages | English |
Fivetran Downloadables
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(45)Community Insights
- Business Problems Solved
- Pros
- Cons
- Recommendations
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.
Attribute Ratings
Reviews
(1-5 of 5)Fivetran - next generation data replication
- Near real time Data replication
- Basic standardization
- Availability of a wide variety of ingestion plugins
- View based ingestion from RDBMS
- Detailed Logging
- API support
- Near realtime, available and reliable data replication
- High quality ingestion with no data loss
- Cost monitoring features
- Connect to traditional data sources
- 100%10.0
- Connecto to Big Data and NoSQL
- N/AN/A
- Simple transformations
- 80%8.0
- Complex transformations
- N/AN/A
- Data model creation
- 90%9.0
- Metadata management
- 90%9.0
- Business rules and workflow
- N/AN/A
- Collaboration
- N/AN/A
- Testing and debugging
- 80%8.0
- Integration with data quality tools
- 100%10.0
- Integration with MDM tools
- N/AN/A
- Historical refresh cost
- Absence of view to detailed progress logs
Highly recommend Fivetran
- UI is very clean.
- Documentation is easy to use.
- Plenty of connectors for different third party services.
- Honestly, not much they're already crushing it!
- If I had to say one thing, I guess I would say make it more accessible to non-data engineers.
- Security.
- Reliability.
- Speed.
- Connect to traditional data sources
- 70%7.0
- Connecto to Big Data and NoSQL
- 60%6.0
- Simple transformations
- 90%9.0
- Complex transformations
- 80%8.0
- Data model creation
- 80%8.0
- Metadata management
- 80%8.0
- Business rules and workflow
- 70%7.0
- Collaboration
- 90%9.0
- Testing and debugging
- 60%6.0
- Integration with data quality tools
- 60%6.0
- Integration with MDM tools
- 70%7.0
- I can't quantify it, but our entire data process runs on Fivetran.
- It's invaluable.
- Seamless connector for data requirements
- Custom reports
- Database Connection
- Change Lod
- User-based control
- Connect to traditional data sources
- 90%9.0
- Connecto to Big Data and NoSQL
- 80%8.0
- Data model creation
- 70%7.0
- Metadata management
- 90%9.0
- Business rules and workflow
- 70%7.0
- Collaboration
- 60%6.0
- Integration with MDM tools
- 70%7.0
- Development cost have reduced for each connector
- The pay-per-use model is still not out their which requires lot of overhead cost
We had an idea on data requirements in our case which helped us to work out on cost implication and take a decision for Fivetran as a data provider for our organization.
These were 2 places where Fivetran out-performed, other vendors.
Fivetran makes ELT quick and easy
- Easily connects to source data using delivered connectors
- Transforms data into standard models and schemas
- Has very good documentation to help quickly setup connectors
- Alerting and notification could be enhanced and be more timely in some cases
- The error messages when there are connector setup issues could be more clear
If the majority of your data sources are custom internal applications or databases, may be less value as you aren't leveraging the delivered connectors.
- Connect to traditional data sources
- 90%9.0
- Connecto to Big Data and NoSQL
- 70%7.0
- Simple transformations
- 80%8.0
- Complex transformations
- 80%8.0
- Data model creation
- 80%8.0
- Metadata management
- N/AN/A
- Business rules and workflow
- 70%7.0
- Collaboration
- N/AN/A
- Testing and debugging
- N/AN/A
- Fivetran has allowed us to dramatically improve our time to insight
- It allows us to focus on business value as opposed to engineering
- Reduced the amount of engineering resources we need to make data available
Gets data from Point A to Point B
- Quick replication of data with minimal lag.
- Automated reporting if data is out of date.
- The customer support team is relatively good.
- A full schema refresh takes us two-three days and knocks us offline from monitoring up-to-date business KPIs, running updated analyses, etc. This is likely due to us having massive amounts of data (from a count(1) perspective, not size of tables perspective).
- There's little to no progress estimate on the front end UI to see how long this refresh might take and you need to enable back end logging in Amazon to see where it's at in the sync process and derive rough estimates of completion time.
- I don't think about ETL (Extract, Transform and Load).
- I don't process any ETL, it's set it and forget it.