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
(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
We're using Matillion to mainly load data from three places into our RedShift clusters. The first one is from a s3, the second is syncing data from our production DB.
June 08, 2019
Matillion ELT for Snowflake
Matillion is used by two different departments at our company - engineering and professional services. For engineering, it is used as an ETL pipeline tool for ingesting data into our internal data warehouse from a variety of 3rd party platforms, ultimately for the purposes of advanced analytics. For professional services, this tool is being used to automate client data load processes.
Matillion is being used to assist our data pipeline ETL, and allows our business analysts to rapidly make adds, moves, and changes to our data ingress and reporting needs via an easy to use UI.
Matillion is being used by my department, and we use it as our main ETL tool daily.
It is being used across all of our internal data to bring data together for reporting. This includes
Sales, Marketing, Billing, Support and ustomer activity. We have processes that run every minute as well as batch processes that run every day.
Sales, Marketing, Billing, Support and ustomer activity. We have processes that run every minute as well as batch processes that run every day.
May 29, 2019
Matillion to go
Matillion is being used as a data pipeline tool, and we use it to pipe data from Postgres to Redshift, and also for piping other external APIs directly using Matillion connectors. It helps in removing and having a separate data end-team for maintaining jobs written in code basics, and it's easy to maintain.
May 28, 2019
A good solution for a one man data shop
It was a self-hosted SaaS ETL for us for all data warehousing, connecting all internal and external data sources.
We are using Matillion throughout our organization to run and automate all data pipelines into our data warehouse. We integrate various sources from API's, Python Scripts, SQL Scripts, and other databases, into a single data warehouse.
May 27, 2019
2 Years with Matillion
Matillion is used in our Data Analytics and Data Engineering department. At the time we purchased it, we had no dedicated data engineers. We needed something powerful enough to handle more complex jobs, but simple enough that a semi-technical analyst could use. We were using a lot of different tools at the time and were evaluating a lot of different ETL solutions in the space.
Matillion provided a solution that was simple, easy to connect, and also provided Internet connectors to some of our most crucial systems, such as Salesforce and Jira. It has allowed us to consolidate much of our processes onto a single system that is easily understood.
Matillion provided a solution that was simple, easy to connect, and also provided Internet connectors to some of our most crucial systems, such as Salesforce and Jira. It has allowed us to consolidate much of our processes onto a single system that is easily understood.
May 27, 2019
Matillion for Snowflake - Excellent (cloud-only) solution for ELT pipelines and complex transformation needs
Few months ago, we'd decided to migrate on-premise BI stack to cloud as on-premise solutions were not able to meet growing demands. Clearly, we were looking for cloud-only solutions. After extensive research and POC of several tools, we've onboarded Matillion. Matillion is primarily used by BI developers for ELT pipelines (External applications, API, Database, CSV ..) and transformation but the resulting data is used by the whole organization via the dashboard or Excel extracts. Direct data integration connectors, powerful transformation capabilities, user-friendly interface, error handling, logging, tight integration with Snowflake, extensive usages documentation and excellent technical support inclined our decision towards Matillion. It reduced the development time drastically. Data load performance is pretty impressive compared to on-premise deployments.
Matillion for Snowflake is used by our Data Engineering team for developing data flows for extracting and transforming data into our Snowflake data lake. The data lake is available to the entire organization for analysis and decision support. We needed an ETL tool for batch processing for replacement of Airflow.
We use Matillion to support our recurring data requests and cleaning processes on large data sets. Approximately half of our department currently uses it.
May 24, 2019
Matillion has met the needs of our data warehousing and ETL better than we had exptected
Matillion is being used by Xyngular to ETL data from multiple environments into an AWS Redshift database. We also use it to pull data files from FTP and load them into the database. It also allows us to be very flexible on the scheduling of the jobs.
May 24, 2019
Matillion Review
We use it to transport data to our data warehouse.
May 23, 2019
Great product and great customer support
We currently use Matillion for Redshift as our ELT tool for data retrieval, aggregation, and management. It is currently being used by multiple departments in our organization, including our data team and operations team. Having used Apache AirFlow, Matillion is a breath of fresh air. It is easy to use, easy to implement with a variety of technologies, and the support system is quick and convenient.
Matillion is our ELT-Tool to load and analyze our web-log data with Redshift.
Currently driving the ETL /ELT processes to load a Redshift Data warehouse. We have 5+ data sources that include on-premise/cloud databases, CRM and marketing tools that are feeding the data warehouse. Matillion is also used to automate various marketing processes.
May 22, 2019
Matillion For All
Matillion is being used in our company as an ELT tool. We load data into it from various sources, such as Salesforce, NetSuite, etc. We are exploring more such options, from there we can pull the data into matillion. Once in matillion, we transform this data using various components provided by the matillion tool to modify the data as we need. Then, once all the modification are in place we load the data into Snowflake which is our data warehouse
May 22, 2019
Feedback on Matillion ELT
We're exploring Matillion as an ELT tool when we migrate our workloads to the cloud. This software is not in production yet as we're still exploring. Once accepted, this software will be used in our Information Management department. This business problem that is addressed by this software is ELT.
May 18, 2019
Matillion: ELT vs ETL
We are using Matillion within the Analytics department. We had a core need to be able to move data from multiple single-tenant client database sources into a proper data warehouse (AWS Redshift) for analytical reporting.
May 15, 2019
Excellent ELT product that helps deliver rapid value and clear, easy to maintain transformations
Used to re-platform on-prem SQL servers to Snowflake. Also used to create data warehouse transformations, marts, and reporting tables. We also used it to remap several Excel-based calculations into an automated pipeline with backup and recovery on S3 and Snowflake. As consultants, we recommended the product, provided initial implementation and ran training workshops tailored to the client's tasks and workflows.
May 15, 2019
Small scale Matillion user
As a ETL tool to pull data from various data sources for which Matillion had data connectors into a central database.
It was used only by the Marketing department. Since Matillion had its own native connectors to certain platforms, it was easy to pull data from those sources. And since we didn't have a developer to write scripts for those connectors, someone less tech savvy could do it themselves by dragging & dropping. Also since Matillion was responsible to keep its native connectors up to date, a developer wasn't required to read and implement all new API documentation if there were certain changes.
It was used only by the Marketing department. Since Matillion had its own native connectors to certain platforms, it was easy to pull data from those sources. And since we didn't have a developer to write scripts for those connectors, someone less tech savvy could do it themselves by dragging & dropping. Also since Matillion was responsible to keep its native connectors up to date, a developer wasn't required to read and implement all new API documentation if there were certain changes.
It is used by the analytics department as a replication tool.
May 11, 2019
Matillion ETL for Amazon Redshift
I met with Matillion team at AWS Summit 2018 at Sydney, Australia. At that time we were using legacy ETL for our Redshift Data Warehouse.
We were trying to adopt Continuous Integration/Continuous Delivery framework for our ETL and found it to be challenging for our environment. It was time to look for something new and say goodbye to our bellowed legacy ETL. So we had a conversation with Matillion team and quickly decided to do a POC. We've evaluated couple of other tools in the past but nothing came close to Matillion.
First of all, setup was a breeze. The migration was quick and painless, the system is very easy to work with. Almost more importantly, the Matillion team is very friendly and always willing to help, their support is outstanding! Matillion has dozens of native connectors out of the box, so we had no problem with integrations at all. In fact, migration to Matillion allowed us to drop couple of third party legacy ETL components required for AWS infrastructure.
Python scripts component allows to use Boto3 and hundreds of other libraries, so practically there is no limit of where you can use Matillion.
We were finally able to build full scale CI/CD pipeline. Our setup uses combination of JIRA, Bitbucket and Bamboo build server and it works like a charm, thanks to Matillion'™s REST API.