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
We are moving away from Matillion to MWAA Airflow with dbt.
Maintaining source control in github is important to us.
We have used Matillion in the past for:
Replication - Copy from postgres, load to s3, perform transformation in redshift
Running python scripts
S3 data transfers - bucket to bucket
Maintaining source control in github is important to us.
We have used Matillion in the past for:
Replication - Copy from postgres, load to s3, perform transformation in redshift
Running python scripts
S3 data transfers - bucket to bucket
March 25, 2024
Experience the ETL with Matillion
We use Matillion ETL (extract, transform, and load) with Bigquery to transform customer data to a standard format. There are 100+ sources and file formats are different. We use Matillion to transform these files and apply business logic to create and store it in a standard format which can be used by downstream and we deal with terra bytes of data on a daily basis.
March 25, 2024
Matillion for cloud data integration.
Matillion is used to build the data pipeline on the Google Cloud platform. There are multiple use cases: 1. Data is received in GCS storage and picked by Matillion based on the active sensors and on a specific schedule. Data is transformed and then loaded into big query tables. 2. Data is read from HTTP endpoints, transformed using Matillion, and then loaded into big query tables. 3. The data quality framework is built on top of Matillion to apply some business checks.
March 20, 2024
Matillion enables us to manage all ETL/ELT processes without any dedicated data engineering resources.
We use Matillion as our ETL/ELT tool to sync analytical data from various sources and tools to our data warehouse.
March 19, 2024
Matillion - Decent
We use Matillion to schedule and run our ETL jobs. This helps our company to have accurate and timely data in order to make data-driven decisions. Matillion runs and organizes almost all of our data.
Matillion ETL is used to extract, transform and load data into the Data Warehouse in Snowflake from data sources like Oracle databases and external CSV files. Matillion is used both for managing, scheduling and controlling the ETL processes as well as the data loading and transformations.
March 18, 2024
Matilion helped grow my business
Matillion perfectly solves the issue of multiple data sources from different technology stacks and formats that need orchestrating into meaningful views of the data to then allow proper data mining. This then means we can provide the insights and trends the individual and group leadership needs in order to run the business in an adaptive and agile way. The technical team also appreciates the care given to building a UX that is easy to follow compared to other ETL tools used in the past.
March 15, 2024
Good easy to learn ELT tool
We needed a way of empowering people with data in a no-code way. Data is a bottleneck and everyone needs it, but how do we give them this data and enable them to use it effectively? We launched ‘Data as a Product’ - A package of tools and resources that exposes raw data to people and allows them to manipulate it with ease. Matillion is the key tool in this package that allows people to manipulate data at the speed of thought with no code. Matillion’s no-code design, intuitive interface, and collaboration centric architecture allowed us to get people set up and transforming data in a matter of minutes with very little support from the Data team.
February 07, 2024
All That You Need in Your Daily ETL Work
We use Matillion as the main ETL tool for our Data warehouse. Our daily jobs extract and transform data from sources such as Dynamics CRM, several APIs, and tracking data from our websites.
February 07, 2024
Matillion Review
We use Matillion for loading data from various sources into Snowflake Data Lake. We have data in various source systems such as SQL servers, many SAAS applications with proprietary databases, Quickbooks, files, and so forth. It is important to have data from all of these sources in the data lake for integrated reporting for the business.
February 07, 2024
Replication with Matillion Saves Time
We replicate data between PostgreSQL and Snowflake for most of our core business operations. We were using various home-grown techniques for doing that which took a very long time to complete due to the growing size of the data. We turned to Matillion for help and started first with their original CDC product that was part of the ETL server. That could not handle the volume that we pushed, so we switched to their developing CDC product in Data Loader.
February 05, 2024
Small team supported by Matillion
Matillion powers our team of 2 data engineers to manage the database of our entire company. Without Matillion there is no way only 2 people would be able to do this. It helps us be more productive and get to the projects we really need instead of spending all our time deep in legacy code for every single process update.
January 31, 2024
Use Matillion - Become the no code superman
Matillion has played a significant role in streamlining your ETL (Extract, Transform, Load) processes and has resulted in substantial time savings for your team. Automating data processing across different domains like Media Data, Sponsorship Valuation, and Consumer Research has enhanced efficiency and productivity.The reduction in processing time by 600 hours is a noteworthy achievement, allowing team to focus on more strategic tasks and potentially accelerating the pace of decision-making within the organization.Moreover, leveraging Matillion to create data products and explore new offerings demonstrates the platform's versatility in supporting innovative solutions and helping organizations derive more value from their data.
January 29, 2024
Great ETL for the wider organisation.
As a fast prototyping POC tool for end users of data and in production etl.
September 12, 2023
Simplicity in implementing ETL/ELT
We use Matillion as our main tool for all ETL/ELT processing. Our DWH target DB is Snowflake. We extract data from different sources; ex: SQL Server, BOX, S3, SAP HANA.
We also use Matillion to execute Python scripts. We are working currently to configure Matillion to connect to Github.
We also use Matillion to execute Python scripts. We are working currently to configure Matillion to connect to Github.
September 09, 2023
Matillion Helps Build Out Your Datalake
We get a lot of different files from different partners/vendors. We also have multiple databases that all need to be centralized. We use Matillion to read in the data from these different files and databases into a DataLake. That datalake then serves the rest of our company from reporting to billing.
September 07, 2023
A Necessary tool
The main issue at innova is manual process. With matillion we implemented automated data flow for disposal data to Google BigQuery
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.
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.
August 16, 2023
Consider Matillion as an option.
They come in far cheaper than other brands with the same level of support and functionality. When they deliver on the cloud based offering this will be a big step forward. Matillion has become an indispensable asset in our organization's data workflow. It elegantly tackles our complex data integration and transformation needs, streamlining processes that were once time-consuming. Our work with Matillion will continue to thrive and provide our business value going forward.
April 14, 2023
Matillion Transforms Data Quickly and is reliant
Matillion is used to transform data from organizations transactional systems, sales and marketing systems and logistics. Data is transformed to create data assets that are easily consumed by users to take critical business decisions and also report operations and trend analytics. Matillion is also used to feed data into other systems that do not currently provide direct connectivity from various other applications. Matillion is also used to create and support a hub/spoke model for data assets that we have for self service reporting within different business units
April 04, 2023
Matillion is the future
We have helped our clients to implement Matillion in creating data warehouse, datalake and data mart. The use of Matillion have helped in processing large volumes of data in less time and also in much lower cost. The implementation of Matillion was simple and the team could easily learn and start using it.
Matillion is widely used as an ETL tool. It helps to transform and load gigabytes of data in a quick and efficient way.
April 04, 2023
Great tool. Does a lot of the hard work for you. And lets the engineers focus on the data.
ETL tool that integrates with all major data warehouses as well as other internal data sources. The platform is easy to use. Support is detailed and timely. Upgrades can be performed in a blue green manner. And the product has robust backup solutions. All in all a competent and easy to integrate platform that does a great deal of the heavy lifting for you.
March 28, 2023
Solid ETL tool
We used Matillion for common ETL tasks. It has allowed us to handle large volumes of data and aggregate them for reporting purposes. We wanted an automated lights out solution and it did just the job. It was used on an on demand basis which kept the cost down too.
March 20, 2023
Great for maintainable production pipelines
We use Matillion for all our batch ELT/ETL/rETL processes and the orchestration and scheduling of those processes. It makes it easier to create clear and maintainable pipelines with DAGs and notes in the DAGs for documentation. It makes getting setup with extraction of new sources much easier. We use it for database and API sources. The API Profiles make setting up new sources easier. We also used the transformation components for more complicated Snowflake transformations such as flattening json. Matillion jobs parameterization and shared jobs make it easier to reuse code for multiple pipelines. Its great to be able to use both SQL and Python to transform data.