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 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…
$0.01
per credit
Matillion
Score 7.8 out of 10
N/A
Matillion is a data pipeline platform used to build and manage pipelines. Matillion empowers data teams with no-code and AI capabilities to be more productive, integrating data wherever it lives and delivering data that’s ready for AI and analytics.
$2.50
Pay as you go per user
Pricing
Fivetran
Matillion
Editions & Modules
Starter
$0.01
per credit
Standard
$0.01
per credit
Enterprise
$0.01
per credit
Developer: For Individuals
$2.50/credit
Pay as you go per user
Basic
$1000
per month 500 prepaid credits (additional credits: $2.18/credit)
Advanced
$2000
per month 750 prepaid credits (additional credits: $2.73/credit)
Enterprise
Request a Quote
Offerings
Pricing Offerings
Fivetran
Matillion
Free Trial
Yes
Yes
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
Optional
No setup fee
Additional Details
—
Billed directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.
Fivetran and Matillion are both tools designed to extract and transform business data. Fivetran is a Data Replication tool that replicates business data from applications and databases and stores them in a single data warehouse, it is most popular with mid-sized businesses with many data sources to replicate. Matillion is a data integration tool that helps businesses to aggregate data from different sources for querying and analysis. Matillion is most popular with mid-sized businesses.
Features
Fivetran and Matillion both pull in data from many business sources, but they also have a few standout features that set them apart from each other.
Fivetran can pull in data directly from many SaaS applications right out of the box, making it a strong choice for organizations looking for a plug and play tool to handle SaaS data. Additionally, Fivetran helps organizations meet regulatory compliance standards for both GDPR and HIPAA. Lastly, customers are able to add new data sources to Fivetran, making it easy to add customer data to a businesses data warehouse.
Matillion provides a simple to use interface that won’t require significant training for new users. For businesses that do need a little more training, however, Matillion provides both thorough documentation as well as in depth tutorial videos so users can get up to speed quickly. Lastly, Matillion provides ticket based support so users can reach out to the vendor for help with any software issues.
Limitations
Fivetran and Matillion both help organizations to handle large amounts of business data, but they also have some limitations that are important to consider.
Fivetran includes detailed documentation for their software, but provides no tutorials or training. New users will have to really on experienced coworkers or third party content when learning to use Fivetran. Additionally, Fivetran’s interface is more complex to use than Matillion, which can handle post load data transformations with a simple drag and drop interface.
Matillion has built in integrations for some SaaS applications, but not as many as Fivetran. For businesses that only use applications supported by Matillion this isn’t an issue, but it can be a problem for businesses with other SaaS applications. Additionally, Matillion only provides support for GDPR compliance, so businesses that need their data to be HIPAA compliant may need to consider other options.
Pricing
Pricing for Fivetran is dependent on the needs of the business starting at $1.00 per credit with access to all Fivetran connectors. Fivetran also offers a free trial so businesses can see if the software is right for them before making a purchasing decision.
Matillion similarly depends on the needs of the business, but it starts as low as $1.37 an hour and offers support for Amazon Redshift, Google BigQuery, Azure Synapse Analytics, and Snowflake.
Features
Fivetran
Matillion
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Fivetran
10.0
Ratings
18% above category average
Matillion
8.3
Ratings
1% below category average
Connect to traditional data sources
10.00 Ratings
8.70 Ratings
Connecto to Big Data and NoSQL
10.00 Ratings
7.90 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Fivetran
7.4
Ratings
10% below category average
Matillion
6.9
Ratings
17% below category average
Simple transformations
7.50 Ratings
7.50 Ratings
Complex transformations
7.30 Ratings
6.30 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Fivetran
6.2
Ratings
25% below category average
Matillion
8.2
Ratings
3% above category average
Data model creation
2.00 Ratings
9.10 Ratings
Metadata management
4.00 Ratings
9.10 Ratings
Business rules and workflow
8.00 Ratings
8.30 Ratings
Collaboration
7.80 Ratings
7.20 Ratings
Testing and debugging
9.00 Ratings
7.40 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
[Fivetran is] very well suited when you are using popular and common data sources, such as the major ad platforms, and SaaS platforms such as Salesforce. 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.
Great: Need to query simpler APIs, or utilize well known services such as GSheets etc.? Matillion has got some of the best and easiest to use connectors out there. Not so great: Do you need have a competent CI/CD flow that you will be able to update / compare from Matillion as well as other sources at the same time? Good luck, you will need to be extra careful, as you might have to have a deeper dive into your servers Terminal each time you have a git conflict.
Static and monolithic, it will show its limits when running multiple concurrent jobs.
Github and versioning implementation is messy and broken. Don't use it.
There's not way to see/query the system resources, just wait for a server to crash due to out of memory. An admin panel would be appreciated + some env variables with updated info.
API implementation is cumbersome and limited.
There's no concept of hub and worker engine, everything happens of the same server (designing workflows and executing them). Having separate light ETL engines to run job could be better. (sort of docker/kubernetes/lambda functions).
Handling of variables is limited especially for returned values from sub components.
Some components could return more metadata at the end of their execution instead of the standard one.
Billing is badly designed not taking into account that the server is hosted by the client. Expensive.
We had several issue with migration where starting a new instance was required and then migrating the content. It was painful and time consuming also have to deal with support and engineering team on Matillion side.
CDC doesn't work as expected or it is not a mature product yet.
Matillion is easy to use and flexible to debug. Performance are good and support is giving us a good service level. There are still some technical points to be developed more (such as SAP extraction). but easy flows are really fast to be developed. We are also using a tool for migration from other tools, and it is useful as Matillion is producing XML code.
Very easy and intuitive to setup and maintain as there usually are not that many options. Very well documented (e.g. how to setup each connector, how the schema looks like, any specific features of this connector etc.). Also the operation is intuitive, e.g. you have status pages, log pages, configuration pages etc. for each connector.
Easy tasks are really easy, and complex tasks are still possible. With prior knowledge of general data warehousing principles and experience with other data transformation tools, it's straightforward to get familiar with and use Matillion. I initially used minimal external support from a partner for some more complex tasks but very soon could work entirely independently with Matillion.
It runs pretty well and gets our data from point A to point cluster quickly enough. Honestly, it's not something I think about unless it breaks and that's pretty rare.
Overall, I've found Matillion to be responsive and considerate. I feel like they value us as a customer even when I know they have customers who spend more on the product than we do. That speaks to a motive higher than money. They want to make a good product and a good experience for their customers. If I have any complaint, it's that support sometimes feels community-oriented. It isn't always immediately clear to me that my support requests are going to a support engineer and not to the community at large. Usually, though, after a bit of conversation, it's clear that Matillion is watching and responding. And responses are generally quick in coming.
Fivetran came well with the connectors' availability and updates with the source changes. 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.
We selected Matillion primarily because of it's ability to connect to numerous data sources and easily create transformation jobs. While Fivetran does a better job managing and examining deltas, it is not easy to use and is very non user friendly. SSIS was not a good fit for our team and required a significant amount of attention and server management that we did not want to invest in.
We're using Matillion on EC2 instances, and we have about 20 projects for our clients in the same instance. Sometimes, we're struggling to manage schedules for all projects because thread management is not visible, and we can't see the process at the instance level.
Time savings -- we could custom code nearly everything Matillion does, but it would take days/weeks instead of minutes/hours.
There's a bit of a learning curve to truly unlock Matillion's potential, and that can be frustrating for some new users, but once you get over that curve, the possibilities are endless.
It allows us to centralize the hundreds of way to bring data in, so that even if you have to troubleshoot what someone else wrote, it's easy to jump in and understand what is happening.
