aws-glue-vs-matillion

AWS Glue and Matillion are both software designed to help organizations extract and transform business data. AWS Glue is a data preparation tool, designed to help businesses prepare data for analysis, bypassing a data warehouse when possible.  Matillion is a data integration tool designed to help businesses quickly pool together data from multiple sources such as SaaS applications.

Features

AWS Glue and Matillion both provide ETL features, but they also have a few unique features that set them apart from each other.

AWS Glue has support for data lakes, allowing businesses to prepare and integrate raw data and blob files with ease. Additionally, developers can create scripts to integrate data into AWS Glue that isn’t natively supported using Python or Scala. Lastly, AWS Glue helps businesses keep their business data compliant with regulatory guidelines including HIPAA and GDPR, making it a good choice for medical businesses.

Matillion provides built in support for over 40 SaaS applications.  This makes Matillion a good choice for businesses with many applications they need to pull data from, particularly if they lack the resources or ability to make custom integrations.  Additionally, Matillion provides features for data ingestion and business intelligence.

Limitations

Though AWS Glue and Matillion both help organizations transform data, they also have some limitations that are important to consider.

AWS Glue doesn’t provide built in integrations for SaaS application, though it is possible to build custom integrations.  For businesses with limited resources or without a dedicated development team, AWS Glue may not provide enough support for data integration.  Additionally, AWS Glue includes some analytics features, but ultimately provides limited business intelligence features.

Matillion offers support for SaaS applications, but doesn’t provide significant support for building out new integrations.  Businesses with niche applications that aren’t covered by Matillion may consider other options.  Additionally, Matillion offers support for ensuring regulatory compliance, but only for GDPR.  Businesses storing medical data may prefer other options that also ensure HIPAA compliance.

Pricing

AWS Glue pricing depends on the needs of the business and the amount of data processes performed.  Despite this, AWS does provide some pricing examples so businesses have an idea of what they might be spending, such as this: “$0.44 per DPU-Hour, billed per second, with a 1-minute minimum for each ETL job of type Python shell”.  Businesses looking for specific pricing information can reach out to the vendor for a quote.

Matillion pricing 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.