Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
- Connect to traditional data sources (91)9.090%
- Testing and debugging (82)8.989%
- Simple transformations (92)8.787%
- Complex transformations (91)7.474%
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Matillion, and make your voice heard!
Entry-level set up fee?
- No setup fee
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
Matillion is data transformation for cloud data warehouses. According to the vendor, only Matillion is purpose-built for Amazon Redshift, Snowflake, and Google BigQuery enabling businesses to achieve new levels of simplicity, speed, scale, and savings.
Users can develop custom Transformation jobs by combining Filters, Joins, Aggregates, Calculators, Ranks, as well as more complex transformations such as Rankings, window calculations, and change-detection by dragging and dropping these onto a canvas GUI. Use Orchestration features to automate ETL workflows with scheduling, notifications and alerting, and control flow.
Once jobs are built, run them with component level validation and data sampling. For any custom or unique needs, Matillion also has Bash and Python Script components to give users extensibility and flexibility.
Shared Job templates, Dynamic and Grid variables, and Version control help development teams share resources across Matillion instance.
Enterprise customers gain additional auditing and permissions, automatic job documentation, data lineage and more. Learn more about enterprise features here.
Each product comes with a set of warehouse specific features to help users get the most out of the platform. Their Product Feature pages on matillion.com provides more information.
- Supported: Connect to traditional data sources
- Supported: Connecto to Big Data and NoSQL
- Supported: Simple transformations
- Supported: Complex transformations
- Supported: Business rules and workflow
- Supported: Collaboration
- Supported: Testing and debugging
Matillion has been less good at extracting data from APIs. The functionality was found to be complex and it was unclear how to manage things like pagination and rate limiting in API calls.
- Great if you have many developers working at the same time.
- If you want to build a pipeline quickly and schedule it right away.
Less suited - Pushing output other than CSV or writing to tables.
Less appropriate: the Zuora API has some issues and we had to build the data pull from a bunch of basic API components instead of the proper highlevel one.