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.565%
- 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…
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
(76-100 of 125)Companies can't remove reviews or game the system. Here's why
June 13, 2019
Easily set up your ETL/ELT pipeline with Matillion
- Managing Schedule
- Intuitive UI
- Easily integrates with the rest of AWS
- Create different versions is easy
- The deployment process is quite manual; need to export and import, create a new version. Would be nice if there's a repo for continuous integration
- The Python script module is very limited. We try to use it to parse data on a file with 500 records, and it constantly crashes. It does not have the capabilities to run Python programs
- In the Mongo module, the field must exist in the source system. Working with NoSQL DB, some fields might not exist just yet, and essentially we'll have to create everything downstream once the field appears in the source system.
June 08, 2019
Matillion ELT for Snowflake
- ELT - out of the box support for a variety of popular APIs.
- Support for the big players in the cloud data warehouse marketplace - Snowflake, Redshift, and Google Big Query.
- Strong documentation and technical articles, including data models for each supported external data source.
- Support for other programming languages beyond Python.
- Expanded the number of concurrent users (limited depending on license level).
- Increased number of project environments (limited depending on license level).
- Fast - easy to use
- Flexible - data ingress and back-end data stores
- Cost-effective - easy to start small and scale up
- More data stores beyond Redshift, Snowflake, BQ
- More connectors for Redshift, Snowflake, BQ
- UI updates to reduce clicks and time to configure
- Makes it easy to design ETL pipelines because of the "drag-and-drop" components.
- Handles workloads nicely and seamlessly,
- Has a wide variety of input and output sources
- Theming or color selections (overall UI, folder and job icons, etc.) would be a nice to have feature.
- The ability to "inspect" environment variables during the transformation/orchestration building process (similar to debugging in programming).
- When environment variables are mentioned inside the components' parameters setting, it "invalidates" the job but the jobs would still run on executions. This might be caused by the default values of environment variables being NULL.
- Quick access to Google Sheets data.
- Utilizes SQL well.
- Supports custom API data sources.
- Pricing is by server size not # of data sources or volume.
- Source control integration is archaic and not implemented with teams in mind.
- Has some performance issues related to memory issues.
- Documentation is lacking and there is no real training available.
May 29, 2019
Matillion to go
- Fast data transfer.
- No coding required.
- Lots of connectors.
- Matillion support.
- Need Github connectors.
- More learning materials based on common use-cases.
May 28, 2019
A good solution for a one man data shop
- Easy to learn
- Visual interface
- Pretty reliable
- Version control
- Search
- Explaining dependencies
- Easy to use.
- Ability to leverage several technologies (SQL, Python, Bash, AWS).
- Pre-built connectors to simply provide connections between several commonly used technologies.
- Their customer support is extremely prompt and good at helping out.
- Alerting needs to be done via AWS SNS, not pre-built in the platform.
- There's an inability to track data lineage (where did a column of data from a downstream table come from?)
May 27, 2019
2 Years with Matillion
- Cloud connectivity: It makes pulling data from cloud services like Salesforce super simple and easy to bring into a data warehouse
- ETL Orchestration: The drag and drop interface makes it easy to compose new orchestration layers in our ETL. It's something that does not require a Data Engineer to complete.
- Enterprise integration: It was really easy to configure into our LDAP system, and that makes administering the box really easy.
- Variety of Data sources: It is pretty easy to bring data into Matillion to process into the data warehouse.
- The Gui provides other non-functional visual elements to mark up the job. This is great for team members to communicate complicated parts of the ETL or to otherwise label parts of their ETL.
- Matillion has no clustering ability. For particularly large jobs or large data sources, processing can take a long time and it does not have the ability to map-reduce, like Spark.
- The output is limited to Redshift. Often times we would want to drop a Parquet or Avro file into s3 as the output of our ETL.
- We often get OOM errors and other server related constraints. We need to be very careful about how our jobs are scheduled in order to make everything work well.
- It is not clear from the documentation how to organize work in Matillion. Between environments, projects, and jobs in a project, we've had to organize in a way to accommodate for Matillion's limitations, which doesn't allow us to organize our jobs in a way that makes sense for us.
May 27, 2019
Matillion for Snowflake - Excellent (cloud-only) solution for ELT pipelines and complex transformation needs
- Seamless connectivity with Snowflake. Direct data connectors are available for popular applications
- Powerful data transformation capabilities. Several components available to support complex data transformation
- Python and Bash script component allows endless possibilities
- Pretty impressive performance
- Excellent Technical support and usage documentation
- Timely upgrade and bug fixes. New features included in every release
- Integration with SOAP API's especially Amazon MWS is not straight forward
- Collaborative and autosave feature sometime become painful when multiple developers are working on the same Project
- Merge Job or changes feature is not available which makes production deployment time consuming
- Ease of use.
- Suitable for developers from junior to senior.
- Connects to a variety of data sources and platforms.
- Matillion has many tools available for transforming data.
- Does not integrate easily into the source code control system.
- The small instance needs more concurrent user connections. Two is too few, and moving to the next instance size does not make sense in our development environment.
- Matillion for Snowflake does not have a Dynamo DB connector.
- The GUI is very intuitive, making it easy for new users while also having more complex functions available to experienced users.
- There is a good mix of defined components and customization options, giving users flexibility for both their skill level and the task at hand.
- Matillion includes a chron scheduler and s3 export options which streamline the process, enabling all portions of the ETL process to take place within the same utility.
- Areas for improvement include local variable updates, e.g. a last run date.
- More python library support would greatly broaden the potential uses.
- The S3 export function could use some adjustments in making clear defaults, particularly in regards to snowflake file types.
May 24, 2019
Matillion has met the needs of our data warehousing and ETL better than we had exptected
- Loading an FTP file into the database.
- Transforming data before loading it into the database.
- Flexible scheduling of jobs.
- Straight data copy from one database to another.
- When I make changes to a job and add fields to what is being pulled, I have to drop the entire list and repopulate it.
- Honestly, the first thing is the one part I have had issues with.
May 24, 2019
Matillion Review
- Reading from multiple databases.
- Writing to a data warehouse.
- Performing data transformations.
- Reading from other kinds of data storage in addition to relational databases.
- Interface for API profile builder could be more user-friendly, especially for new users.
- Could use better documentation & examples for API Profiles syntax.
- No built-in version-control management.
- No way to add integration tests for jobs for QA purposes.
- If you have a lot of jobs currently running at the same time, then you cannot easily manage them, and they're relegated to the "Jobs" panel in the lower-right corner. It would be nicer to have an interface that allowed you to manage a large amount of currently running jobs (sortable columns, inline searching/filtering for currently running jobs, etc.). Maybe even have a larger view than just 25% of the window.
- Difficult to track/identify changes made by collaborators (having a VCS/Git integration would improve this).
May 23, 2019
Great product and great customer support
- Easy to setup and provision
- Expert customer support
- Can take some getting used to
- Inability to update/install Python libraries
- Very nice and intuitive user-interface
- Easy drag and drop of components with a good documentation of each component
- Good integration of different data sources
- Detailed task history with a good overview of the current workflow with the defined parameters - easy error handling and detection
- Better parallel workflows
- More configuration opportunities for data sources without Python
- Cloud-based solution
- Seamless integration with Redshift
- Minimum scripting required
- Good feature documentation
- Easy to learn/good tech support and tutorials
- Installation/setup
- Better out of the box support for CRM tools like Zendesk would be helpful.
May 22, 2019
Matillion For All
- Data extraction is really quick and hassle-free.
- Transformation is very easy to perform as it provides an elaborate list of components that can be used to create and optimize your query.
- Scheduling is very manageable and easy to monitor and review.
- UI is very user-friendly, every component and sub-component can be understood by the help option provided as a hyperlink.
- There can definitely be some improvements w.r.t the NetSuite orchestration component. We have had lots of trouble connecting it to Matillion during POC.
- Although the UI is quite user-friendly there is room for much improvement.
- There should be requirement specific customized training before a company starts working with Matillion. We got general training which definitely benefited us, I just think a more project-specific training would have been more useful
May 22, 2019
Feedback on Matillion ELT
- Drag n Drop to build orchestration and transformation jobs
- Simplicity
- Pay as you Go
- Ability to scale up and down
- Minimal code compared to the competition
- Cloud based
- Ability to migrate jobs created for one platform to other easily (for e.g. from Redshift to Snowflake).
- There is a scope of improving developer productivity by enhancing the user interface. Sometimes the UI is confusing.
- Some times the orchestration and transformation job diagrams become very complex. Need to come up with design patterns for proper diagram preparation.
May 18, 2019
Matillion: ELT vs ETL
- Easy drag and drop logic/control functions.
- Ability to script (in Python) when out of the box components are not enough.
- ELT vs ETL allows for super fast transformations done directly in Redshift.
- We have had issues with out-of-memory errors when Matillion is up and running for a long time. For this reason, we've implemented an automated monthly restart job which works around this issue.
- We do a lot of "reverse ETL" processing. For certain use cases we need to run extracts out of the analytical data warehouse, massage the data, then move it back to our transactional databases for certain operational tasks. Although it is possible with certain components in Matillion, there could be more enhancements to those components to make life easier for some tasks.
May 15, 2019
Excellent ELT product that helps deliver rapid value and clear, easy to maintain transformations
- Excellent visual layout of transformation jobs.
- Easy debugging while building SQL transformation by allowing you to sample the data at any point along with the job.
- Good connection to many different sources.
- Good auditing of jobs, steps, and operations.
- Poor SQL query generation for performance. It only does subquery composition, so becomes very inefficient on large tables.
- Limit scheduling and triggering capabilities without creating separate apps to call via API.
- Lack of on-prem file support, such as moving a file once processed, checking last modified date, etc.
May 15, 2019
Small scale Matillion user
- Native data connectors
- No fixed fees
- Good support
- Development timeline
- More data connectors to various ad platforms
- Need the instance live to do setup, which you then pay for
- Initial setup is very technical
- Ease of Administration and Management
- Better visibility over ETL processes
- Seamless solution with complete integration into Snowflake
- Authentication methods need to be broader
- UI for projects could be better
- Ability to manage it using both AD and local accounts.
- Replication
- Ease of use
- Trainable
- APIs
- Customer representatives aren't the best at communication but solution architects are great.
- Pricing explaination
- Update documentation
May 11, 2019
Matillion ETL for Amazon Redshift
- Works very well with Redshift and integrates with other AWS Services, such as S3, SNS or SQS for example
- Has scripting components like Python using Boto and any other libraries. Additional libraries need s to be installed on Matillion EC2 instance
- Plenty of data sources out of the box, the rest can be pulled via API
- Automatic validation of database objects and components
- Easy to install
- Excellent integration with CI/CD
- Minor: Changes to the ETL can only be reviewed in Matillion GUI rather than true source code diff, i.e. Bitbucket