Matillion

Matillion

Top Rated
TRUE
About TrustRadius Scoring
Score 8.6 out of 100
Top Rated
TRUE
Matillion

Overview

What is Matillion?

Matillion is data transformation for cloud data warehouses. According to the vendor, only Matillion is purpose-built for Amazon Redshift, Snowflake, and Google BigQuery enabling businesses to achieve new levels of simplicity, speed, scale, and savings.

Users can develop...

Read more

Recent Reviews

Matillion Review

9 out of 10
July 09, 2021
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, …
Continue reading
Read all reviews

How Matillion Differs From Its Competitors

Time to Value

We have started doing some research about ETL tools since we decided to do not to develop it a house, and after talking with some colleagues and reading about Matillion, we decided to move it forward, and that was our time schedule: Research and ETL tools try 45 days Developing our project on …
Continue reading

Time to Value

Matillion was up and running almost overnight. Our ops department spun up in an instance and we were off to the races.
Continue reading

Cost Savings

The long term savings from Matillion have primarily come through decreased work hours associated with building, maintaining and trouble shooting ETL processes.
Continue reading

Business Outcomes

Matillion's connection options are robust. We have been able to connect to many different database types, as well as build direct connections with our partner APIs.
Continue reading

Onboarding

Maybe two weeks to get over the initial hurdle and then we were off to the races. For the most part Matillion is very intuitive, simple, and easy to implement.
Continue reading

Time to Value

My learning curve was long. Matillion is simply not like any other ETL / ELT tool out there, because Snowflake isn't like other cloud databases out there. I had to first learn a different pattern of data movement and error checking. Next, I had to learn which components to use and when. There …
Continue reading

Onboarding

a full year to get fully implemented. The onboarding was immensely painful given the documentation was lite and incorrect in many places. Many patterns of use I had to figure out for myself. At the time of implementation there was no developer community and the only company contact was through the …
Continue reading

Time to Value

The internal communication and collaboration than the setup of Matillion, once the EC2 instance triggered, we were able to get started with transformation jobs within 1 hour.
Continue reading

Time to Value

Matillion was implemented within one week in our organization for full functionality. Our company secured its deployment within this period of time and all our programs were able to run smoothly. The learning curve was easy to master and get it run as expected within a short period of time. Our …
Continue reading

Time to Value

I started reading about Matillion and after one week and talking to their support team I started my project and it was up and running after 2 weeks of developing.
Continue reading

Time Saved

Yes, after I started using Matillion our ETL process became much faster and we are running the instance on AWS only 1 or 2 hours per day which means we are not spending too much money but we are having many benefits once the process is much faster now and our visualization team can find the data …
Continue reading

Cost Savings

Before Matillion we used to use software created by our own company which was already old to date and it was really hard for our new employees to get in of it. Using Matillion we are saving money on training for new partners and now we have a much more organized ETL environment.
Continue reading

Business Outcomes

Yes. We don't have a lot of data sources but all of them we were able to connect smoothly and import our data easily.
As an example of our data sources I can mention, Relational Databases on AWS running SQL SERVER, we have some input from S3 (text files) and of course, some excel files.
Continue reading

Onboarding

Matillion's implementation was really really easy and smooth, most of my questions I could find solve questions using their forum or sending them an e-mail which was replied to within 1 or 2 days. Their documentation about all the components I consider complete and with good examples of how to …
Continue reading

Time to Value

It took some days in order to figure out how to configure the environment and all the basic configurations. Writing simple jobs took a really short time to learn (hours), while in some other days I was able to prepare a full orchestrator. Parameters configuration is a little more complex and I had …
Continue reading

Time Saved

We're using Matillion for ELT and processes are slower. It is a mix of Matillion efficiency and DB performance, but the total result is better than before. We are using a Large account and it is the right choice, while with the Medium size we weren't able to performe the same results and we had …
Continue reading

Cost Savings

We are reading from many different sources. Extraction times are better than before and we found almost all the connectors we needed and the support helped us to obtain the best extraction performance. Matillion costs are coherent with the usage, and it is useful that we are not paying when the …
Continue reading

Business Outcomes

We were able to connect all data source, but we had some issues with SAP: the native Netweaver connector do not allow to read SAP tables in join, as the 2 tables are loaded in memory and the join is apply at the end. Therefore we had "out of memory" issues with this strategy. But we could find …
Continue reading

Onboarding

Matillion is really easy to use, so we were able to start writing our flows easily. The activation is still easy, but you need to have some tech skills to work with putty and install what is missing (specific ODBC etc). For these aspects we moved questions directly to Matillion's support and the …
Continue reading

Time to Value

Within a month of getting Matillion we had an established pipeline that was extracting data from the company's application database and updating the corresponding data in the warehouse. Additional data source (e.g. Salesforce and Netsuite) were quick to implement (c. 2 weeks per data source) …
Continue reading

Time Saved

Yes we did. It was possible to update the data warehouse database every 3-4 hours instead of every 24 hours. In addition, and perhaps more importantly, it provided a more stable ETL process. The previous one was prone to breaking/failing and Matillion provided a more reliable process and one that …
Continue reading

Cost Savings

In terms of infrastructure costs, our costs have gone up using Matillion. Historically we used AWS DMS to clone the production database into a Postgres database. This old process, however, was prone to issues and failures, e.g. when the production database was updated with new column(s)/table(s) …
Continue reading

Business Outcomes

We were able to connect to our main data sources using Matillion (a MySQL database, Salesforce and Netsuite). Other data sources, that are API based and didn't have specific components in Matiilion were more of a challenge at the time. Although API functionality has been improved since we …
Continue reading

Onboarding

Onboarding was quick and relatively pain free. The team did have experience using Matillion prior to implementation which obviously helped. However, once the server was setup with the appropriate security groups to access data sources, building the Matillion jobs was straight forward and the UI …
Continue reading

Time to Value

Proof of concept took a couple of weeks. Getting access to private SQL databases was a little fiddly as we needed to install some drivers which we would have expected to be installed as default, but once up and running, we have had no issues. Tweaking firewalls settings to allow Matillion access …
Continue reading

Time Saved

Reports that took approximately 3 hours to pull together and performed on a manual monthly basis were handled automatically and daily in a matter of minutes. These manual reports were pivots in Excel and were pushing Excel to its limit (Excel would freeze). There was a lot of data being shifted …
Continue reading

Cost Savings

As it was automating a manual process, the savings were more in terms of saving resource. Automating has also opened up the report to more internal users.
Continue reading

Business Outcomes

We are able to connect our bespoke systems and third party systems. One that proved quite difficult was the Xero connector. Although hooking up with Matillion was straightforward, the data Xero connector was not provided the data we needed so are looking at our ETLs for this this specific issue.
Mor…
Continue reading

Onboarding

The project has been stop and start over a couple of years. We moved from AWS Matillion to Azure Matillion but it is now stable and pulling various sources in reliably. Setting up success/failure notifications has been key.
Continue reading

Time to Value

I watched training and example videos/seminars for about two weeks before getting an instance set up for the company. And from there, I had a usable workflow going within another week.
Continue reading

Time Saved

Yes, Matillion allowed for daily schedules to provide updated data for reporting at the same time each morning. It also removed any need for manual data updates.
Continue reading

Business Outcomes

Yes, Matillion allowed for connections to all SQL based data sources via JDBC, all files from FTP sites, and all REST API sources. It simplified all of the different data pipelines and allowed for more interaction between them.
Continue reading

Time to Value

Matillion being ELT cloud tool offers easy to implement which requires an AWS EC2 instance and licensing.
Training on Matillion and getting the development team on-board was quite a challenge. Would require immense experience to explore the core functionality of Matillion. Matillion was running …
Continue reading

Time Saved

Yes, there were absoultely increased in reporting speed that our team was able to delivery. Intially we had our own scripting tool to generate result which took 2 weeks (around 80 hours of development time + testing time) whereas using matillion we were able to complete the development in 32-40 …
Continue reading

Cost Savings

While moving away from legacy system towards matillion it offered some significant cost on matillion hosting and licensing part but we were able to save some on legacy system hosting but majority of saving where on people resource which was huge cost saver for our organization. along with that …
Continue reading

Business Outcomes

Our organization work in digital marketing industry and matillion do provides lots of connector related to digital marketers. Matillion was able to solve 90% of our data sources connection problem but there were few of the rarer sources which matillion din't provide the connection to. Hopefully …
Continue reading

Onboarding

Our team member had already the knowledge of other ETL tool in market which made us easier to transform to Matillion as ETL tool. Initally when there were more rigrous update on tool, it took us few months to understand all the different features of the product and use them. We used to reach out …
Continue reading

Time to Value

We were able to get up and running with Matillion within a month. With no real training in the tool, we were able to develop useful jobs and an entire job framework on Matillion within that month. As we got more familiar with it, within three months, we were able to take advantage of additional …
Continue reading

Time to Value

From the moment we bought it on AWS marketplace to connecting to our monolith database it took a matter of hours. Deciding the Redshift table structure we needed for storage actually took longer than the actual setup time! That is a definite plus for anyone who wants to get up an running as soon …
Continue reading

Time to Value

To migrate an existing ETL solution from an old product to Matillion, will require a compete rework with some redesign. Estimate depends on the complexity required. Would estimate anywhere between 3-9 months.
Continue reading

Time to Value

Within 2-3 weeks from starting Matillion, we had our first simple pipeline in production: extracting data from our operational database and putting it into data warehouse.
Continue reading

Time to Value

Our initial POC demonstrated that migrating to Matillion was the logical next step for our organization. Our expectation had been six months to migrate our production loads from legacy tooling to Matillion. We were able to migrate complex production workflows, validate the result, and promote the …
Continue reading

Time to Value

About 1 week which included hands on and looking at online documentation. Part of the delay was just getting access to internal company data.
Continue reading

Time to Value

Used the trial edition initially and was able to set up an ETL process for production, which then started populating real reports in 6 weeks. Previous process was quite manual, a combination of Alteryx and Excel which took a lot of time.
Continue reading

Time to Value

Took 1 day to deploy, get logged in, and connect to Redshift.

Took 1 month to make it useful in production, and 9 months in, I'm still learning features and quirks of Matillion.
Continue reading

Time to Value

It has to be taken into account that the learning curve is high. It is a new tool that requires some understanding about its myriad of functionalities. However, jobs and ETLs can be done fast after getting a grasp on its components.
Continue reading

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

View all 12 features
  • Connect to traditional data sources (92)
    9.2
    92%
  • Testing and debugging (83)
    9.2
    92%
  • Simple transformations (93)
    9.0
    90%
  • Complex transformations (92)
    7.9
    79%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Matillion, and make your voice heard!

Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is Matillion?

Matillion is data transformation for cloud data warehouses. According to the vendor, only Matillion is purpose-built for Amazon…

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?

12 people want pricing too

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 TIBCO Cloud Integration?

TIBCO Cloud™ Integration is an enterprise iPaaS platform. It offers a drag-and-drop and API- led design approach for user-friendliness.

Return to navigation

Product Demos

Introducing Matillion ETL for Amazon Redshift | Available on AWS Marketplace
01:15
Introducing Matillion ETL for Snowflake | Available on Azure, AWS and GCP Marketplaces
00:53
Introducing Matillion ETL for BigQuery | Available on GCP Marketplace
00:53
Siemens Power and Gas Use Matillion ETL for Redshift from AWS Marketplace to Speed Data Analytics
04:30
Thrive Market - "Able to Deliver Better Value and Service" | Matillion ETL for Amazon Redshift
04:34
Return to navigation

Features Scorecard

Data Source Connection

8.9
89%

Data Transformations

8.4
84%

Data Modeling

8.9
89%

Data Governance

8.2
82%
Return to navigation

Product Details

What is Matillion?

Matillion is data transformation for cloud data warehouses. According to the vendor, only Matillion is purpose-built for Amazon Redshift, Snowflake, and Google BigQuery enabling businesses to achieve new levels of simplicity, speed, scale, and savings.

Users can develop custom Transformation jobs by combining Filters, Joins, Aggregates, Calculators, Ranks, as well as more complex transformations such as Rankings, window calculations, and change-detection by dragging and dropping these onto a canvas GUI. Use Orchestration features to automate ETL workflows with scheduling, notifications and alerting, and control flow.

Once jobs are built, run them with component level validation and data sampling. For any custom or unique needs, Matillion also has Bash and Python Script components to give users extensibility and flexibility.

Shared Job templates, Dynamic and Grid variables, and Version control help development teams share resources across Matillion instance.

Enterprise customers gain additional auditing and permissions, automatic job documentation, data lineage and more. Learn more about enterprise features here.

Each product comes with a set of warehouse specific features to help users get the most out of the platform. Their Product Feature pages on matillion.com provides more information.



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

Screenshot of Matillion uses an easy to follow GUI. Orchestrate your jobs quickly and simply with control data flow functionality, automating the ETL process.Screenshot of Bring your data together. Use Matillion to read and combine data across your target warehouse external storage, such as S3 or Blob. Then prepare your structured and semi-structured data to create clean data sets that can be used with your BI/reporting/visualization tool of choice.Screenshot of Develop confidence in your ETL jobs with self-validating components, sample and row counts. If a job does fail, use warehouse queue services with Matillion to get an alert to your email or Slack account.Screenshot of With hundreds of pre-built connectors out of the box, Matillion is well equipped to handle your most complex transformation needs. In case you need a bit more flexibility for unique use cases, use the SQL component to run custom scripts from within Matillion.

Matillion Videos

Matillion ETL for Amazon Redshift
Matillion ETL for Snowflake
Matillion ETL for BigQuery
Siemens Power and Gas Use Matillion ETL for Redshift from AWS Marketplace to Speed Data Analytics
Thrive Market Use Matillion ETL for Amazon Redshift to Revolutionize Their Data Warehousing Strategy

Matillion Integrations

Matillion Competitors

Matillion Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

Reviewers rate Connect to traditional data sources and Testing and debugging highest, with a score of 9.2.

The most common users of Matillion are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews

Companies can't remove reviews or game the system. Here's why

No reviews found

Try adjusting your results by removing or modifying your filters.

Return to navigation