fivetran-vs-matillion

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.