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
(26-50 of 125)Companies can't remove reviews or game the system. Here's why
March 18, 2023
Matillion for driving Data Mesh
Matillion is being used as a low code ETL tool for central platform as well as we make it available as self service platform within Organization. We also see a good potential to use Matillion CDC functionality (Matillion Data Loader) for meeting near real time demands
March 14, 2023
Matillion - Robust ETL tool
We have data residing in multiple systems across various applications using disparate database applications.
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.
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.
March 11, 2023
The Joy of data transformation!
We rely on Matillion to perform all ELT in our datawarehouse. Matillion has met Sophos' needs to increase data availability and reliability in the warehouse, increasing data operation efficiency by 40%.
March 08, 2023
Matillion... Right tool for the right time.
We use Matillion on all data pipelines. We gather data from source systems, update our data lake, and transform our data in dimensional formats for business reporting purposes.
March 08, 2023
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
March 08, 2023
Matillion - easy to use ETL tool
Matillion is a user friendly interface, which allows our different data engineers to easily set up data integrations and transformations. It also support wide range of data sources , including cloud based databased, file systems and APIs, making it an excellent choice for our organization. Matillion has received high marks for its ease of use reliability.
March 08, 2023
Matillion easy and faster
We use Matillion on top of Snowflake to perform extensive ELT data transformation.Its easy orchestration helps non-technical users to create SQL based data pipeline and schedule those as per their requirement.
Reduces involvement of Tech team due to ease of use.
Snowflake acts a source and Target for most of our data system. We populate all our finance and other organizational reports using Matillion. Matillion is being used used in DWH, BI, Marketing and other teams.
Reduces involvement of Tech team due to ease of use.
Snowflake acts a source and Target for most of our data system. We populate all our finance and other organizational reports using Matillion. Matillion is being used used in DWH, BI, Marketing and other teams.
September 21, 2022
Matillion, a nice ETL tool.
We are using Matillion as our main ETL tool in order to move data from our RDS databases to our DWH (Redshift); during the process, we extract the data, perform some transformations, aggregations, and so on before inserting it on Redshift, where this data is used afterward by Quicksight and others B.I tools.
September 02, 2022
Matillion a great, easy to implement resource
We use Matillion for all our redshift data warehouse ETL needs.
June 09, 2022
Matillion review
I have used Matillion in various projects in my company for different pharma clients for Life Sciences data. We were building solutions for clients which can help the analytic users and other down streams to consume data as per their requirements. In other Healthcare Analytics Projects, we were extracting the data from different sources like Facebook and Google Analytics and building a repository using Matillion ETL. Matillion was user-friendly and easy to learn and easily integrated with AWS Redshift and Snowflake DBs.
We are using Matillion to centralize our data to a new data warehouse. Our primary use case is pulling data from a relational database (MySQL). I've been able to implement three different flavors of data sourcing, the two primary types being a full table load and incremental data loading of changed data into Slowly Changing Dimension and Fact tables in the DW. The performance of Matillion combined with Snowflake is astoundingly fast. We are also able to hit APIs to Zendesk and Hubspot easily to round out our integration with other SaaS vendors in our stack.
Score 10 out of 10
Vetted Review
Verified User
Matillion is helping resolve use-cases related to transparent orchestration workflows. These workflows often involve custom Python, SQL, staging locations, and sending data to external systems such as Salesforce and cross-channel marketing platforms all in one workflow. When FiveTran & DBT don't meet our exact requirements and use-case, we use Matillion to help resolve these use-cases in an easily understandable workflow that technical users, new engineers, or non-technical users can understand/troubleshoot.
August 02, 2021
Data Integration and transformation platform
Score 9 out of 10
Vetted Review
Verified User
Matillion is being used to transform and integrate data in our organization. Most of the data that we highly rely in decision making and planning is well analyzed by this great product. Data is safe for use in our departments can easily be saved in the cloud for free for future use.
July 09, 2021
Matillion Review
I have been using Matillion since March and it has been a nice experience. It's helping a lot during our ETL process from RDS to Redshift, both on AWS. I really appreciate the software features and their support team is always able to clarify doubts and lead us to the best solution for our business.
July 08, 2021
Ease and complete tool, I would suggest it!
We have been using Matillion for a specific project in the SupplyChain area. The ETL works well and it was really easy to implement. We didn't use many objects, but we still were able to implement everything we needed, such us datamarts and file exports. We also tested the connection with SAP and we were happy to see it worked correctly. Something I think could be useful is a tool to move jobs between different environments: export/import upload. Json is ok but doesn't allow us to manage to version, and moreover, if you are moving many files, you need to manually substitute the original job with the new one.
Matillion is being used by the BI Team to orchestrate the population of the Data Warehouse. The Warehouse, in turn, is used to produce a range of reports across all business functions in the organisation. We use Matillion to ingest data from an application database (hosted in AWS), Salesforce, Netsuite and Google Analytics
July 01, 2021
Push the data with Matillion
Score 9 out of 10
Vetted Review
Verified User
We use it to get data from various sources into our data space. We use it within our company and also share it externally with our clients. It is very much useful.
June 30, 2021
Visual ELT at its best
Used by developers and business analysts in the IT department to extract and transform data into our Snowflake data warehouse. We have different data sources after a company merger and needed combined reporting. We also needed to pull data from third-party data sources such as Xero, Google Analytics, and so on.
June 29, 2021
Easy to implement and scale
We are implementing ETL workflows for other organizations that we consult for. It is currently being used for smaller sized clients across the whole organization. We use Matillion to automate the ingestion and transformation of data pipelines. We utilize Snowflake as a data warehouse, so we use Matillion as the tool to load data into the Snowflake database.
June 29, 2021
Matillion Review
iQuanti is a Digital Marketing organization, which drives strategic decisions based on a data-driven approach and for this we use Matillion as our ETL solution tool for our organization, which is consumed by our Data Management team. We have large numbers of the digital platform from which we report and analyze the performance. Matillion helps us to automate most of our reporting needs by providing connectors to digital platforms like Google Analytics, Google Adwords, Facebook, Bing, JIRA, Google BigQuery, and various Data source connectors like Postgres, SQL, MongoDB along with AWS support as SNS, S3 etc, which provides lots of flexibility in today's world.
January 05, 2021
ETL made easy for non-programmers
We use Matillion for Redshift to ETL data from various sources into our data warehouse which is used across the organization with the desire to share it with external users in the market too. It allows us to seamlessly integrate within the AWS stack and even outside so we don't have to think twice about whether we will be able to ingest data from any new source.
November 30, 2020
Ease of Use and Reusability for Excellent ROI
We use Matillion to bring together data from multiple sources - our application, Salesforce, Qualtrics, etc. - into a central data warehouse for use throughout the business in reporting, both internally and externally. Matillion performs the ETL that transforms this raw data into a structure in Redshift useful for reporting.
November 27, 2020
Good at what it does.
Being used by the financial services department for ETL processes. It does the job of cleaning and transforming our data for internal and external reports.
November 25, 2020
Excellent AWS Data Integration Platform
Matillion is used by the software department for data integration, for syncing up data from the OLTP database to the OLAP system, and populating data for our data warehouse.
October 06, 2020
Beautiful UI and UX to compete with any ETL, but at a cost!
We still have an old-fashioned process in our monolith environment to extract-transform-load from a SQL server data store. Currently the monolith is the main product of the CM brand and is still being heavily maintained. The way we are moving forward is to "unlock" the data from its current storage in order to have better analytics using event streaming. For the time being, the only way we are able to extract large amounts of data from our relational SQL data store is using the ETL process through Matillion into our data warehouse solution in Redshift.