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…
Matilion helped grow my business
Low-code solution to transforming data at the speed of thought
All That You Need in Your Daily ETL Work
Matillion Review
Replication with Matillion Saves Time
Small team supported by Matillion
Use Matillion - Become the no code superman
Great ETL for the wider organisation.
Simplicity in implementing ETL/ELT
Matillion Helps Build Out Your Datalake
A Necessary tool
currently
Consider Matillion as an option.
Matillion Transforms Data Quickly and is reliant
How Matillion Differs From Its Competitors
Time to Value
Time to Value
I watched a few YouTube videos (which I would like to see more of) and managed to create less complex ELT transfers in a single day.
Snowflake connection was a little more complex than it could be....and variable handling takes a while to grasp …
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Now when we know the process, It can go quickly in few hrs
Time to Value
The very first integrations we started were that of Salesforce and that was both inbound from Salesforce and outbound to Salesforce. We were able to build 5 to 6 such Outbound integrations within a month.
And then there were …
Time to Value
Time to Value
Time to Value
Time to Value
Time to Value
Time Saved
Cost Savings
Business Outcomes
Onboarding
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 (119)9.393%
- Connect to traditional data sources (118)8.787%
- Complex transformations (118)7.575%
- Collaboration (104)7.373%
Reviewer Pros & Cons
Pricing
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…
Entry-level set up fee?
- No setup fee
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
Data Source Connection
Ability to connect to multiple data sources
- 8.7Connect to traditional data sources(118) Ratings
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
- 8.5Connecto to Big Data and NoSQL(79) Ratings
Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases
Data Transformations
Data transformations include calculations, search and replace, data normalization and data parsing
- 9.3Simple transformations(119) Ratings
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
- 7.5Complex transformations(118) Ratings
Complex data transformations are data normalization, advanced data parsing, etc.
Data Modeling
A data model is a diagram or flowchart that illustrates the relationships between data
- 9.1Data model creation(33) Ratings
Ability to create and maintain data models using a graphical tool to define relationships between data
- 9.1Metadata management(40) Ratings
Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management
- 8Business rules and workflow(103) Ratings
Ability to define and manage business rules and workflows
- 7.3Collaboration(104) Ratings
Collaboration is enabled by a shared repository of project information and metadata
- 7.4Testing and debugging(104) Ratings
Tool to debug and tune for optimal performance
Data Governance
Data governance is the practise of implementing policies defining effective use of an organization's data assets
- 8.2Integration with data quality tools(22) Ratings
Integration with tools for cleansing, parsing and normalizing data according to business rules
- 8.2Integration with MDM tools(20) Ratings
Integration with master data management tools to ensure data consistency across the organization
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
Comparisons
Compare with
Reviews and Ratings
(199)Attribute Ratings
Reviews
(1-25 of 120)- 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
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
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.
Easy to get started and self learn, which is important.
- 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.
Matillion has completely changed the way we serve data to our internal customers at the company; we've exported capability and empowerment rather than allowing ourselves to get swamped with tickets and requests for every possible data question. It's a great tool for getting people to self-serve their own answers to questions about their data.
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.
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
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
Small team supported by Matillion
- Scheduled jobs
- Transforming Data
- Customer Support
- API ingestion
- Change management / historic change log
Use Matillion - Become the no code superman
- Drag and Drop
- Data Transformation
- Various Pre Built Connectors
- Easy understanding
- Pricing
- BQ Connections
- Less BQ Functionality
Great ETL for the wider organisation.
- Easy to learn.
- Easy to show complex calcs to stakeholders.
- Data lineage.
- Billing model.
- Git integration.
- Metadata management.
Simplicity in implementing ETL/ELT
We also use Matillion to execute Python scripts. We are working currently to configure Matillion to connect to Github.
- 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
Matillion has so much components that fits majority of our business needs.
A mising point in Matillion is the metadata to be available in Snowflake.
Matillion Helps Build Out Your Datalake
- File Imports
- Large Scale Data Manipulation
- Database Synchronization
- File Manipulation After Processing
- Built-in Error Reporting
- Versioning
A Necessary tool
currently
We have near 50 automated jobs that runs every 5am and finished at 5.30am.
Also we matillion for extract data from HubSpot, zoom, brighspace, PostgreSQL, MySQL, cloud storage.
- Integration
- Performance
- Job developing ( if you have complex jobs, design the flow can be expensive)
- Cost
- Flexibility
On the other hand. Matillion help us for integrate data sources like netsuite, HubSpot and others.
Consider Matillion as an option.
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
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
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.
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
It is difficult to justify if you are not required to make changes and are using large scale systems like AWS and have developer resource available as its probably cheaper and easier to do the ETL in glue jobs and make the developers responsible.
Great for maintainable production pipelines
- API Extraction
- Maintainable and documented DAGs
- Python
- Database Extraction
- Database CDC
- Too much clicking, more shortcuts needed
Matillion for driving Data Mesh
- Push down code to Snowflake
- Supports many transformations
- Scalable platform
- Git integration
- Customer engagement
- Matillion as SaaS
- Documentation needs to be improved
- Some of the functionalities like support for many aws SQS
Matillion is quite good when it comes to cloud connectivity
One of the best tool while working with Snowflake
Matillion - Robust ETL tool
We were looking for a robust tool that would be able to bring in the data from these into our Datawarehouse.
And that is where Matillion ETL tool came into picture.
So we are using Matillion to integrate the data, transform the data by applying Business logic and finally making it available for the Business users to make informed decisions w.r.t Sales, Campaigns and Promotions and also to understand and address the pain areas of our Customers.
- Connectors for multiple systems/applications spread across Databases, APIs, Files, etc.
- The concept of Shared jobs for reusability
- Seamless integration with Multiple Cloud providers
- UI Feature to track job changes
- Option to put the comments while importing/exporting the jobs
- Option to search for component names inside the opened job in canvas
- Salesforce integrations. Not just extracting the data from Salesforce, but it has capability to even push the data to Salesforce.
- API integrations: Nowadays, all the applications are exposing their data using APIs instead of direct connectivity for security and other reasons, and Matillion has the ability to extract from all kinds of API sources.
- The ability to run the same job in other environment by setting up different environments within the same project.
The Joy of data transformation!
- Reliability
- Seamless integration with Snowflake.
- Customer support and engagement.
- Better integration with large enterprise applications. Ie. Salesforce, Anaplan, etc.
Matillion... Right tool for the right time.
- speed of data movement
- ease of use with python
- great integration into our cloud stack
- documentation
- production support
- rsd and api integration components
Low Code and Python component review
- Loading S3 data lake files to Redshift
- Calling APIs and massaging data in Python and loading to redshift
- Automatic migration of files in S3
- Migrating data from Oracle to Redshift
- Excellent support team
- Consistent releases with great documentation
- UI is easy to learn and navigate
- Job scheduling is straightforward
- I like the environment variables and how you can export a variable to a shared job
- I think a non-CLI approach to installing and uninstalling python libraries would be nice. I mean, it isn't difficult to install a python library via Linux or CLI, but I imagine most companies don't feel comfortable allowing Matillion users to go on a virtual server and installing it themselves. Requirement.txt file for installing libraries would be simple, and maybe that could also be used to uninstall libraries as well......or maybe the library gets automatically downloaded if it is imported into a python script but the library doesn't exist.
- Python Component is lacking very much in terms of UI. It would be unrealistic for me to suggest Matillion build its own EDI, but it would be nice if a python component could connect to a local IDE. Right now, if you want to write any decent length python code, you are going to be stuck copying and pasting your code from your local IDE.
- It is also very difficult to debug in Matillion because you can't set breakpoints. Local IDE integration can resolve that.
- I would like to have more templates to copy from for certain simplistic scenarios. For instance, a template for a job that fails which sends an AWS SNS with the Job name, component it failed on, and the error message. It wasn't as simple as I thought it would be to figure out and having to use a shared job for such circumstances can be painful because you have to export a bunch of variables.
- There should be a drop down list for Global Matillion variables as it is difficult to remember at times.