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.676%
- Complex transformations (123)6.464%
- Testing and debugging (109)5.454%
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…
What is Dataloader.io?
Dataloader.io delivers a cloud based solution to import and export information from Salesforce.
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
(51-75 of 125)Companies can't remove reviews or game the system. Here's why
October 05, 2020
Easy to use and recommended for existing ETL developers
- Ease of use.
- Multiple source feeds.
- Very good integration with Redshift.
- Provides a lot of flexibility with Python scripting.
- Target should always be Redshift or it gets complicated.
- Python scripts not in Jython don't comply with commit/rollback blocks.
- Excel input component is too slow and you are better off processing it in Python.
October 05, 2020
Simple and Powerful
- Super easy to use. Anyone can start using it with very little previous experience.
- Lots of connections available to fetch data from most popular sources available.
- Great UI.
- Not very much scalable. Sometimes there are server shutdowns when it goes out of memory.
- Speed of processing can be improved, but not bad.
- SQL compilation errors are very vague and there is no way to understand what the actual error is. It steals extra time to debug.
October 05, 2020
I'd bet my job on Matillion
- Clean interface.
- Features.
- Diversity of supported data warehouse platforms.
- Ability to rapidly onboard new users.
- Support can be slow to respond.
- Minor UI irritations.
- Upgrade process is onerous, often requiring manual intervention to successfully complete.
- Git integration needs improvement.
October 01, 2020
Get up and running with your data fast!
- Extremely user friendly.
- It has many different job components already built.
- Data loads very fast.
- Makes organizing data jobs very easy.
- The Git workflow could be enhanced, the UI is confusing.
- The text editor for writing SQL is too basic and could be enhanced. Because of this, I often write my code in a separate text editor and copy/paste.
October 01, 2020
Matillion ETL - excellent cloud based data tool
- User friendly.
- Build complex workflows visually.
- Support is good.
- Easier email integration to mail out results.
- Version control of jobs.
- Ability to use external APIs to push data not just pull.
October 01, 2020
Matillion: flexible and complex
- Fairly customizable: can piece together components like Legos.
- Responsive support and good standard documentation.
- Deployment, upgrades, and migration are very smooth.
- Many connectors, APIs, python scripting.
- Bugs in Zuora API; no SFDC push component.
- Few “best practices” like Legos without instructions.
- Next to no information in "google land" or stack exchange on gotchas or tips. Too much help in video form and not enough searchable text.
- Pay AWS and Matillion by the hour.
October 01, 2020
Fell in love with Matillion in less than a week!
- The API component is very powerful. At our company we integrated Google Analytics and custom APIs.
- Easy of use. Transition from an SQL developer to learning Matillion takes less than a day!
- Last but not least is the amazing support team! We tried to integrate Elastic Search using API into our warehouse but had many issues. Finally realised that Matillion has an ES component. But the journey wasn't easy either. We had weeks long conversation with the support team in resolved one issue at a time and they in fact shared their sample server for us to test on! Hands down! They were very keen on resolving our issue rather than just giving out suggestions. And they sure did!
- Large complex workflows can exhaust Matillion's memory. If they can work on this, it will save us memory and time to create multiple staging/temporary tables.
- It would be great if the SNS component can also include the error message when a job fails. So, as a user I don't have to login to Matillion to check the exact reason for my job failure.
October 01, 2020
Great product that does what it says on the tin
- Data transformation.
- Pulling data from various sources.
- Speed of data transformations.
- Automatic jobs backup.
September 17, 2020
Good stepping stone for data infrastructure
- Development speed
- Number of connectors
- Load/unload speed
- GIT integration
- CI/CD integrations
- Failure messaging
September 08, 2020
My experience with Matillion over the past couple of years!!
- UI is very simple to understand and documentation complements it very well.
- Able to mail logs for processed and errors in daily tasks.
- Having a detailed log of daily tasks maintained in the UI is a good addition.
- Slightly over priced for a startup.
- I feel support is a bit slow.
- Not all the libraries are installed in Python, would be easier if we could install them from the user side.
- Hides the SQL code
- Creates an intuitive UI for data flows
- Interfaces with many third-party platforms
- Moving data through a flow can be very tedious.
- Errors are often obtuse and hard to pinpoint.
- They used to auto-complete typing table names, but they removed that, making point number one all that much worse.
September 03, 2020
Matillion: the last puzzle piece in modern analytical solutions
- Tailor-made for Redshift, including most of the features like Spectrum.
- Cloud-based solution with centralized project repository, easy team collaboration.
- Built-in scheduling and monitoring, everything in one place.
- Awesome support, the short time from raising a question to the solution providing.
- Documentation is not always updated in time when new stuff is implemented.
- Some connectors already implemented still have some bugs which make them useless for our use case.
- Small fine tuning still missing, in terms of covering all use cases of some connectors.
September 01, 2020
Matillion - the swiss knife of ETL
- Python integration.
- Easy to set up, back up and restore.
- Scalable, works for any and all file types.
- Python libraries.
- Bigquery metadata.
August 31, 2020
Matillion for ETL and Data Collection
- Great UI
- Support
- Data Collection via API
- Developing in Python is primitive
August 29, 2020
Robust ELT with Matillion for Redshift
- Visual flow of ETL
- Integrations with GIT
- Multi-user editing
- Shared components portability
- Having other databases other than Redshift as targets (such as MySQL)
- Matillion connection to AWS S3 and Snowflake are the vital parts for our architecture and Matillion is extremely simple to configure and robust in handling the connections. The interface is very intuitive to configure.
- Python and Jython interface provides an extremely useful capability to implement our design outside of available components.
- The scheduler is a nice feature and very helpful to schedule workloads. It has all the major capabilities of good scheduler software, except for event triggers.
- Has the interface to do query connections to Salesforce and similar software, but does not have a solid OAUTH interface, or it may be solid, but misses help documentation.
- Help and support are really awesome. But materials do not cover a few petty things that can support beginners to get it going.
- Examples in documentation and workflows could be better.
- A component to write direct SQL processing code in orchestration jobs will be a great way to do a few trivial steps.
- Shared jobs are a great way to create a framework for processing. But once embedded, if a rollback change is done on a shared job, say remove a job variable, it breaks the orchestration jobs using it. There should be an easy way to update the job, similar to when shared jobs are enhanced and orchestration jobs inherit seamlessly.
August 26, 2020
Simple and powerful data aggregation tool
- Quick to set up
- Tailor-made for data warehouses (Bigquery, Snowflake, Redshift)
- Graphical UI to connect all the modules
- Easy to learn
- Customer response time needs improving
- SAAS model instead of charging hourly
- Lack of documentation
- Versioning logs not updated
August 17, 2020
My experience as a newbie to Matillion
- Connection to numerous data sources
- Validation of objects and components
- Ease of use to schedule run-times
- Variable driven code development
- Documentation examples
- Speed of processing
- Requires upfront investment in design of system processing.
- Assistance with upgrades
August 14, 2020
Matillion is fast, fairly flexible, and easy to use
- Move large amounts of data quickly from various sources into Storage/Data Warehouse. This is important for any ETL tool.
- The built-in API connectors are very useful and are usually granular enough to save us loads of development time.
- Matillion usually responds to support tickets in a day or two.
- A couple of times, we've had components stop working. We were basically told to keep checking the release notes for fixes. It would be nice if they prioritized maintaining existing components over developing new ones.
- It can be hard for multiple users to work on the same job.
- Most of their documentation is good, but sometimes their support pages link to missing docs.
- Variety of connectors
- Graphical interface
- Source control integration
- Some connectors have significant limitations (web services, NetSuite)
- Runs out of memory easily
- Logging not easily exportable
August 13, 2020
Matillion Is Easy Data Pipelines!
- The workspace is drag and drop, which makes it intuitive and easy to use.
- Server creation and management is robust. We haven't had to worry too much about it once we got it created.
- The job scheduler is very simple and intuitive.
- Matillion allows you to run Python, which grants almost unlimited flexibility, even without using any other components.
- The Python script component needs a friendlier window in which to edit your scripts. The script is not searchable, and tabbing is frustrating.
- The High Availability server configuration was not working for us. It was allowing duplicate jobs to run, and causing a lot of confusion in the scheduler. Love the idea, but the implementation fell short.
- Better alerting around queued jobs would be nice. Sometimes jobs start queuing and nothing runs. Usually this is the result of a badly written job, but it would be nice to get alerts.
March 05, 2020
Good at its core, but not a commercial dev tool
- Processing large data
- Easy to use UI
- Simplified the building of complicated SQL
- GIT implementation is shocking
- Multi-developers is almost impossible to manage
- Variable handling is time consuming
- No telephone support
June 28, 2019
Excellent Entry-Level ETL/ELT Resource
- Shallow learning curve - Matillion is powerful, but only as complicated as you need at a given time.
- Superb helpdesk and documentation.
- Jobs are translated directly to SQL which makes them easy to debug.
- Parsing of flat files is inconsistent depending on the source
- The product is constantly evolving (good!) but that means relearning parts of the interface every few months
- Support for a larger set of APIs and database engines would be helpful
June 18, 2019
Lean & Mean Data Integration with Matillion
- Simplicity
- Performance
- Documentation
- Dealing with semi-structured data
- Data profiling
- Integrates very well with most, if not, all AWS services - Easy to get data from anywhere inside your AWS account into Redshift or Snowflake databases.
- It has many available integrations and datasource connectivity outside of AWS and other cloud service providers - Makes it easy to get data from many sources and systems in more traditional on or off premise technologies as well as vendor-specific data and application interfaces.
- Very intuitive, easy-to-learn-and-use interface with a large collection online tutorial articles and videos - makes for an extremely easy onboarding of users who may or may not have past experience with other similar tools.
- Limited selection of instance sizes - Larger organizations and groups my need to set up multilple instances depending on estimations on concurrent users.
- Lack of complete github, gitlab, or other source control integration - it has internal versioning but it is limited. Manual job exports currently don't lend well for useful DIFFs comparison when using those technologies.
- Needs more options for authentication and security - User creation is very manual and can be tedious and difficult to manage for larger installations.