Matillion is a data pipeline platform used to build and manage pipelines. Matillion empowers data teams with no-code and AI capabilities to be more productive, integrating data wherever it lives and delivering data that’s ready for AI and analytics.
$2.50
Pay as you go per user
Talend Data Integration
Score 8.9 out of 10
N/A
The Talend Integration Suite, from Talend, is a set of tools for data integration.
N/A
Pricing
Matillion
Talend Data Integration
Editions & Modules
Developer: For Individuals
$2.50/credit
Pay as you go per user
Basic
$1000
per month 500 prepaid credits (additional credits: $2.18/credit)
Advanced
$2000
per month 750 prepaid credits (additional credits: $2.73/credit)
Enterprise
Request a Quote
No answers on this topic
Offerings
Pricing Offerings
Matillion
Talend Data Integration
Free Trial
Yes
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
Yes
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
Billed directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.
Matillion provided much more flexibility than the other products we tested, at a much lower price point. Other products, in my view, had a cleaner/simpler UI but I also felt that they offered much less functionality. A key design pattern we had to deliver was to perform delta …
Matillion is much easier to set up and easier to work for the team. Offers a lot more connections which are easier to set up. Environment variables make it easy to set up once and job creation is easy. We use Metadata tables to just loop through the list of tables that need to …
If you take the time to build your own with Matillion, you will end up with a vastly better solution than Stitch and Fivetran. We ran Stitch and Fivetran side by side connected from our source DB to both RedShift and Snowflake and documented the performance results as well as …
Matillion is the best alternative for on-premise ETL tools if you are looking for a cloud-only solution. None of the tools we evaluated provide same features offered by Matillion. Extensive technical documentation is available on the website which makes development easy and …
Generally, Matillion is much easier to get up and running, quicker to deliver value and returns on your ELT process, and simpler to maintain. The speed to get data connections and start pulling data is so quick that you can focus on the transformations and business rules …
Matillion is easier to set up and use. Works well for cloud data warehouses. Falls short when legacy application connectors are required, this is where Talend and Informatica have the upper hand.
Talend has a much steeper learning curve. SnapLogic was too expensive but had the best set of features. We did not try Pentaho but that was next on our list.
Being a fairly new player in the market, Matillion is coming up against some well-established names such as Pentaho and Talend. The primary benefit for our use case was the fact that Matillion is built specifically for Amazon Redshift. While Pentaho and Talend are more mature …
We evaluated Fivetran, TreasureData, StitchData and few other options. But only with Matillion did we have the option of a cloud-based ETL solution that we were able to host within the APAC-Sydney region to ensure our data stays within our region.
Matillion and Talend Data Integration are both data integration tools. Matillion specializes in ETL for cloud-based warehouses. Talend differentiates by offering a free open source version of its data integration platform. Talend is more commonly used at the enterprise level, with a larger focus on big data integration, while Matillion’s cloud focus is gives it functionality across company sizes.
Features
Both Matillion and Talend provide a variety of features for data integration.
Matillion offers a robust Extraction, Transformation, and Loading (ETL) capability. Users highlight its ability to centralize and structure data from a wide range of platforms and cloud environments, particularly AWS applications. Matillion’s focus on cloud-based data warehouses makes it ideal for this use case.
Talend differentiates with its free open source data quality management and integration software, which can be used for simple use cases. At larger scale, Talend also provides a high degree of customizable connectors between different system, including custom-built connectors.
Limitations
Talent and Matillion also both have some limitations to their offerings.
Matillion’s users have struggled to create and utilize the platform’s documentation for updates and project management. This issue is particularly pronounced when implementing or integrating Git.
Talend’s free version is extremely limited for most users. Many ETL tasks quickly scale beyond the technical functionality of the free version, requiring paid upgrades. Talend also struggles with utilizing Git, particularly in the free version of the software.
Pricing
Matillion provides four packages for its ETL capabilities, priced per hour of usage. The “Medium” package, at $1.27/hr, provides 2 users and 6 environments. The “Large” package, at $2.74/hr, supports 5 concurrent users and 15 environments and clustering. The “XLarge” package, at $5.48/hr, supports 12 concurrent users and 35 environments. Enterprise package pricing is available by quote from the vendor.
Talend offers four products around data integration. Data Quality and Data Integration are available in open source versions. There are also Data Integration Entry Level and a Data Management Platform package. The former includes more advanced integration features, and the Data Management Platform includes advanced data profiling and quality governance. Pricing is available by quote from the vendor.
Features
Matillion
Talend Data Integration
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Matillion
8.5
143 Ratings
3% above category average
Talend Data Integration
9.5
10 Ratings
14% above category average
Connect to traditional data sources
8.9142 Ratings
10.010 Ratings
Connecto to Big Data and NoSQL
8.1100 Ratings
9.09 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Matillion
8.5
143 Ratings
5% above category average
Talend Data Integration
9.0
10 Ratings
11% above category average
Simple transformations
9.1143 Ratings
9.010 Ratings
Complex transformations
7.9142 Ratings
9.010 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Matillion
8.2
135 Ratings
5% above category average
Talend Data Integration
9.0
10 Ratings
14% above category average
Data model creation
9.133 Ratings
9.09 Ratings
Metadata management
9.140 Ratings
10.09 Ratings
Business rules and workflow
8.3126 Ratings
8.08 Ratings
Collaboration
7.3127 Ratings
9.09 Ratings
Testing and debugging
7.5128 Ratings
9.010 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Great: Need to query simpler APIs, or utilize well known services such as GSheets etc.? Matillion has got some of the best and easiest to use connectors out there. Not so great: Do you need have a competent CI/CD flow that you will be able to update / compare from Matillion as well as other sources at the same time? Good luck, you will need to be extra careful, as you might have to have a deeper dive into your servers Terminal each time you have a git conflict.
This tool fits all kinds of organizations and helps to integrate data between many applications. We can use this tool as data integration is a key feature for all organizations. It is also available in the cloud, which makes the integration more seamless. The firm can opt for the required tools when there are no data integration needs.
Talend Data Integration allows us to quickly build data integrations without a tremendous amount of custom coding (some Java and JavaScript knowledge is still required).
I like the UI and it's very intuitive. Jobs are visual, allowing the team members to see the flow of the data, without having to read through the Java code that is generated.
Matillion is brilliant at importing data -- it would be amazing to have more ways to export data, from emailed exports to API pushes.
Any Python that takes more than a few lines of code requires an external server to run it. It would be great to have more integration (perhaps in a connected virtual environment) to easily integrate customized code.
Troubleshooting server logs requires quite a bit of technical expertise. More human readable detailed error handling would be greatly appreciated.
With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability. 1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow. 2. Scalability: As usage increase, we want Matillion system to be more stable.
We are able to bring on new resources and teach them how to use Matillion without having to invest a significant amount of time. We prefer looking for resources with any type of ETL skill-set and feel that they can learn Matillion without problem. In addition, the prebuilt objects cover more than 95% of our use cases and we do not have to build much from scratch.
We use Talend Data Integration day in and day out. It is the best and easiest tool to jump on to and use. We can build a basic integration super-fast. We could build basic integrations as fast as within the hour. It is also easy to build transformations and use Java to perform some operations.
Overall, I've found Matillion to be responsive and considerate. I feel like they value us as a customer even when I know they have customers who spend more on the product than we do. That speaks to a motive higher than money. They want to make a good product and a good experience for their customers. If I have any complaint, it's that support sometimes feels community-oriented. It isn't always immediately clear to me that my support requests are going to a support engineer and not to the community at large. Usually, though, after a bit of conversation, it's clear that Matillion is watching and responding. And responses are generally quick in coming.
Good support, specially when it relates to PROD environment. The support team has access to the product development team. Things are internally escalated to development team if there is a bug encountered. This helps the customer to get quick fix or patch designed for problem exceptions. I have also seen support showing their willingness to help develop custom connector for a newly available cloud based big data solution
Fivetran offers a managed service and pre-configured schemas/models for data loading, which means much less administrative work for initial setup and ongoing maintenance. But it comes at a much higher price tag. So, knowing where your sweet spot is in the build vs. buy spectrum is essential to deciding which tool fits better. For the transformation part, dbt is purely (SQL-) code-based. So, it is mainly whether your developers prefer a GUI or code-based approach.
In comparison with the other ETLs I used, Talend is more flexible than Data Services (where you cannot create complex commands). It is similar to Datastage speaking about commands and interfaces. It is more user-friendly than ODI, which has a metadata point of view on its own, while Talend is more classic. It has both on-prem and cloud approaches, while Matillion is only cloud-based.
We're using Matillion on EC2 instances, and we have about 20 projects for our clients in the same instance. Sometimes, we're struggling to manage schedules for all projects because thread management is not visible, and we can't see the process at the instance level.
It’s only been a positive RoI with Talend given we’ve interfaced large datasets between critical on-Prem and cloud-native apps to efficiently run our business operations.
