Matillion
Based on 144 reviews and ratings
Based on 51 reviews and ratings
Highlights
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.
Provided by the TrustRadius Research Team
Published on May 14, 2020
Likelihood to Recommend
Matillion

Talend Data Integration

Feature Rating Comparison
Data Source Connection
Connect to traditional data sources
Connecto to Big Data and NoSQL
Data Transformations
Simple transformations
Complex transformations
Data Modeling
Data model creation
Metadata management
Business rules and workflow
Collaboration
Testing and debugging
feature 1
Data Governance
Integration with data quality tools
Integration with MDM tools
Pros
Matillion
- The workspace is drag and drop, which makes it intuitive and easy to use.
- Server creation and management is robust. We haven't had to worry too much about it once we got it created.
- The job scheduler is very simple and intuitive.
- Matillion allows you to run Python, which grants almost unlimited flexibility, even without using any other components.
Talend Data Integration
- JSON parsing, if you are into highly nested JSON object parsing Talend has the ability to display the structure of JSON and allows you to define the extraction logic in the metadata. Same with XML source.
- Customization, For mostly all ETL work you will have a component in Talend. And in case you have a very specific requirement you can end up easily designing a custom component that you can code and reuse and share with others.
- Talend has a connectivity option to almost all the databases (relational or NOSQ)L and sources available. It also has generic JDBC/ ODBC drivers in case you need it.
- I like the ease of deployment across environment (DEV and PROD) with the use of context variables.

Cons
Matillion
- Limited selection of instance sizes - Larger organizations and groups my need to set up multilple instances depending on estimations on concurrent users.
- Lack of complete github, gitlab, or other source control integration - it has internal versioning but it is limited. Manual job exports currently don't lend well for useful DIFFs comparison when using those technologies.
- Needs more options for authentication and security - User creation is very manual and can be tedious and difficult to manage for larger installations.
Talend Data Integration
- Syncing with Git should be made easier
- Can face issues with certain big data spaces
- Support find it difficult to resolve complex issues

Likelihood to Renew
Matillion
Talend Data Integration
Usability
Matillion
Talend Data Integration

Support Rating
Matillion
Talend Data Integration

Implementation Rating
Matillion

Talend Data Integration
Alternatives Considered
Matillion
Talend Data Integration
Scalability
Matillion

Talend Data Integration
Return on Investment
Matillion
- I was able to build a complete commissions processing system for over 3500 employees using Matillion in just over a month. This included gathering data from 5 different sources, combining them together appropriately and building in the business rules. I was awarded one of the top awards our company gives for this project.
- Our big three Business Intelligence tools: Matillion, Redshift and DOMO allow us to give our employees the right data at the right time. Our productivity has increased as 75%+ of our employees look at their data every day they work.
Talend Data Integration
- Easy to build complex data transformations.
- Licensing model isn't that flexible.
- Memory mangement for huge volumes of information. You have to modify ETL designs to handle it properly.