in my opinion, Meh
We are moving away from Matillion to MWAA Airflow with dbt.
Maintaining source control in github is important to us.
We have used Matillion …
Maintaining source control in github is important to us.
We have used Matillion …
Overview
What is Matillion?
Matillion is a productivity platform for data teams.Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed…
Recent Reviews
How Matillion Differs From Its Competitors
Awards
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
Popular Features
- Simple transformations (124)8.181%
- Connect to traditional data sources (122)7.777%
- Complex transformations (123)6.464%
- Testing and debugging (109)5.555%
Reviewer Pros & Cons
Pricing
N/A
Unavailable
What is Matillion?
Matillion is a productivity platform for data teams. Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality…
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://www.matillion.com/pricing
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
26 people also want pricing
Alternatives Pricing
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…
N/A
Unavailable
What is Astera Centerprise?
Centerprise Data Integrator is an integration platform that includes tools for data integration, data transformation, data quality, and data profiling.
Features
Return to navigation
Product Details
- About
- Integrations
- Competitors
- Tech Details
- FAQs
What is Matillion?
Matillion is a productivity platform for data teams.
Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed and scale that matches the business’s data ambitions.
The vendor states enterprises including Cisco, DocuSign, Pacific Life, Slack, and TUI use Matillion to move, transform, and orchestrate their data for a wide range of use cases from insights and operational analytics, to data science, machine learning, and AI.
Native integration with popular cloud data platforms such as Snowflake, Databricks, Amazon Redshift and Google BigQuery lets data teams at every skill level automate management, refinement, and data delivery for every data integration need.
Matillion Features
Data Source Connection Features
- Supported: Connect to traditional data sources
- Supported: Connecto to Big Data and NoSQL
Data Transformations Features
- Supported: Simple transformations
- Supported: Complex transformations
Data Modeling Features
- Supported: Business rules and workflow
- Supported: Collaboration
- Supported: Testing and debugging
Matillion Screenshots
Matillion Integrations
Matillion Competitors
Matillion Technical Details
| Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
| Supported Countries | Global |
| Supported Languages | English |
Frequently Asked Questions
Talend Data Integration, Informatica Intelligent Cloud Integration Services, and Fivetran are common alternatives for Matillion.
Reviewers rate Data model creation and Metadata management highest, with a score of 9.1.
The most common users of Matillion are from Mid-sized Companies (51-1,000 employees).
Comparisons
Compare with
Reviews and Ratings
(204)Attribute Ratings
Reviews
(1-25 of 125)Companies can't remove reviews or game the system. Here's why
March 29, 2024
in my opinion, Meh
- graphical user interface
- Moving around widgets
- options for out of box operations
- connections
- source control maintenance (sync w/ github)
- poor logging, in my experience, can't see clearly what error is if something fails
- in my experience, difficult to connect with outside tooling
March 25, 2024
Experience the ETL with Matillion
- The jobs logging UI is very unique and helps in easy debugging
- It has a proper hierarchical structure. One can easily organise projects and related pipelines
- Access control and sharing necessary access is easy and quick
- I have seen good performance even with complex pipelines
- More features should be available with Git integration such as passing environment variables, schedules from git
- Need improvement in parallelism of job runs
- Sometimes cancelling a job gets stuck which can be improved
March 25, 2024
Matillion for cloud data integration.
- Matillion has a rich transformation library. It provides multiple functionalities, such as join, group by, pivot, various sources, and sinks.
- It provides the security capability as well. All the credentials can be securely stored in Matillion.
- Reusable templates can be built which reduces the redundancy.
- Time to production is very minimal.
- There is a scope of making it more developer friendly in terms of reusability.
- Many configurations required to set up the Matillion pipeline can be reduced significantly.
- In built python executable is quite slow.
March 20, 2024
Matillion enables us to manage all ETL/ELT processes without any dedicated data engineering resources.
- Easy to use interface - even for users without data engineering background.
- Many native components that do not require any "programming".
- Powerful generic profile creation to easily extract data from any API.
- Minor topic: adjusting a generic API Query profile can be a bit tricky. It would be great if we had proper EDIT functionality/flow.
March 19, 2024
Matillion - Decent
- Scheduling ETL jobs
- Third party API connection components
- Not enough third party API integrations
- No version control easily usable
- Executing Snowflake scripts
- Oracle Database Connection and Data Retrieval
- Low Code programming by setting properties of the different components
- Parameter Passing between jobs
- New components for supporting other programming languages like R
- Upgrade Send Email component with more features
- Upgrade GIT Integration features
March 18, 2024
Matilion helped grow my business
- Combines multiple data sources easily
- Reports and alerts issues effectively
- Customer service of professional
- Has been super stable for us over the last 2+ years
- Billing is confusing
- UX is good but isn't the best on the market
- Detailed help sometimes hard to find
March 15, 2024
Good easy to learn ELT tool
- Extracts Nested JSON
- Had good DB support for multiple products.
- Runs in Azure where your Cloud is (may be).
- Upgrade process is sometimes quirky with no updates listed when there are clearly newer versions.
- Support is sometimes long winded and multiple people have to get involved.
- Docs could be expanded as not enough installed base to make forums or Google results useful in many cases.
- We leveraged Matillion’s no-code principals to make data manipulation easy for our internal customers. People who don't know how to use SQL no longer need to. Everything in Matillion is self-explained with no or little coding.
- We connected Matillion to our data warehouse to allow people to read raw data, transform it, then write results back to their sandbox databases. The drag and drop component design allowed customers to create complex data models at the speed of thought without any risk to production data.
- With sharing capabilities between projects enabled, everyone was able to help each other when questions arose which instilled a strong sense of collaboration and community.
- The new DPC version of Matillion uses Git principals like Commit, Push, Merge etc. This is perfectly fine for engineers, but for our use-case it means our customers will need to understand a basic level of Git. It would be great if they had an auto-commit-push setting which does it all for them.
February 07, 2024
All That You Need in Your Daily ETL Work
- ETL
- API Integrations
- Speed of processing
- Improved data quality monitoring
- Maybe the UI could do with a makeover, it feels a bit old (but still nice though :-) )
- Easier integration with Slack, etc.
February 07, 2024
Matillion Review
- ELT - Extract Load and Transform
- Mostly a direct copy of data into the destination is handled very well
- Managing secrets and all connections being handled using parameters/variables
- Some connections are not straightforward to set up
- Upgrades can get a bit complicated and require a backup instance to be created
- Ability to email data files
February 07, 2024
Replication with Matillion Saves Time
- Provides seamless, end-to-end replication
- Works tirelessly with the customer if there are any issues
- The customer service team needs to improve interaction with the customer
- Provide documentation to current customers on new features that are added so that we don't have to find out either ourselves or have to search through the FAQ pages
February 05, 2024
Small team supported by Matillion
- Scheduled jobs
- Transforming Data
- Customer Support
- API ingestion
- Change management / historic change log
January 31, 2024
Use Matillion - Become the no code superman
- Drag and Drop
- Data Transformation
- Various Pre Built Connectors
- Easy understanding
- Pricing
- BQ Connections
- Less BQ Functionality
January 29, 2024
Great ETL for the wider organisation.
- Easy to learn.
- Easy to show complex calcs to stakeholders.
- Data lineage.
- Billing model.
- Git integration.
- Metadata management.
September 12, 2023
Simplicity in implementing ETL/ELT
- Executing Python scripts
- Data Lineage
- Easy to search of objects included in our project
- Creating job templates
- Jobs metadata to be available in Snowflake
- Error messages some times are not so clear
- Job Optimization recommendation
September 09, 2023
Matillion Helps Build Out Your Datalake
- File Imports
- Large Scale Data Manipulation
- Database Synchronization
- File Manipulation After Processing
- Built-in Error Reporting
- Versioning
September 07, 2023
A Necessary tool
- Integration
- Performance
- Job developing ( if you have complex jobs, design the flow can be expensive)
- Cost
- Flexibility
August 16, 2023
Consider Matillion as an option.
April 14, 2023
Matillion Transforms Data Quickly and is reliant
- Transformation of data
- Efficient SQL query generation passed down to DB engine
- Structured and unstructured data handling options
- Data exploration and data transformation option availability
- Monitoring and reporting on errors
- Expansive API profile options
- Data quality testing / monitoring options
- Extended grid iterator limits
April 04, 2023
Matillion is the future
- Checking the sample records to verify the code has been correctly implemented
- Generation of SQL in Matillion helps to debug the code easily
- Use of grid variables helps in solving complex scenarios
- Implementing slowly changing dimensions
- Scheduling the tasks based on events
- Implementation in change data capture
- Really good user interface
- No complexity for anyone without much technical experience to get familiar with the tool
- Efficient in loading and transforming data
- Prevention of application crashes during huge volume of data load
- Improvement of button and default home page of UI
- Font size too small for few tabs
April 04, 2023
Great tool. Does a lot of the hard work for you. And lets the engineers focus on the data.
- ETL
- Data manipulation
- Integrates with data warehouses
- Containerisation. Hopefully this will arrive soon.
- Billing model. New hub model is much better but the previous market place model wasn't very flexible.
- External AD solution would be a big win.
March 28, 2023
Solid ETL tool
- Automation
- Integrates with other tools
- Notifies users of success or failures
- There is a generic failure alert option but not one for success
- The process behind creating and unpacking shares jobs has a clunky UX
- Pulling out the name of a pipeline to a slack webhook seems odd as it wants to only give the name of the component not the pipeline
March 20, 2023
Great for maintainable production pipelines
- API Extraction
- Maintainable and documented DAGs
- Python
- Database Extraction
- Database CDC
- Too much clicking, more shortcuts needed