Matillion ETL vs StreamSets comparison

Matillion and IBM are both solutions in the Cloud Data Integration category. Additionally, 96% of Matillion users are willing to recommend the solution, compared to 100% of IBM users who would recommend it.

Matillion ETL

Read 26 Matillion ETL reviews

1,761 Views
1,245 Comparison Views

96% willing to recommend

StreamSets

Read 20 StreamSets reviews

2,609 Views
1,760 Comparison Views

100% willing to recommend

Matillion ETL

StreamSets

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Matillion ETL and StreamSets based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Matillion ETL vs. StreamSets Report (Updated: January 2025).

Buyer's Guide

Matillion ETL vs. StreamSets

January 2025

Download the complete report

Helped 832,138 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

Matillion ETL

Average Rating

8.4

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Cloud Data Integration (5th)

StreamSets

Average Rating

8.4

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

Data Integration (10th)

Featured Reviews

Tomáš Hronek

Data Engineer at Merck

Used for wrangling or transforming data from sources like S3 and Databricks

I use Matillion ETL for wrangling or transforming data from sources like S3 and Databricks The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation. Sometimes, we have issues with the solution's stability and need to restart it for…

Read full review

Reyansh Kumar

Technical Specialist at Accenture

We no longer need to hire highly skilled data engineers to create and monitor data pipelines

The things I like about StreamSets are its * overall user interface * efficiency * product features, which are all good. Also, the scheduling within the data engineering pipeline is very much appreciated, and it has a wide range of connectors for connecting to any data sources like SQL Server, AWS, Azure, etc. We have used it with Kafka, Hadoop, and Azure Data Factory Datasets. Connecting to these systems with StreamSets is very easy. You just need to configure the data sources, the paths and their configurations, and you are ready to go. It is very efficient and very easy to use for ETL pipelines. It is a GUI-based interface in which you can easily create or design your own data pipelines with just a few clicks. As for moving data into modern analytics systems, we are using it with Microsoft Power BI, AWS, and some on-premises solutions, and it is very easy to get data from StreamSets into them. No hardcore coding or special technical expertise is required. It is also a no-code platform in which you can configure your data sources and data output for easy configuration of your data pipeline. This is a very important aspect because if a tool requires code development, we need to hire software developers to get the task done. By using StreamSets, it can be done with a few clicks.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"Matillion ETL is one hundred percent stable."

"It is pretty user-friendly, even for people who aren't super technical."

"The technical support treats us well. They already have a support portal, and they are responsive, which helps."

"Matillion ETL has great Git integration that is perfect and convenient to use."

"The simplicity of this tool is nice. It has a good graphical user interface. You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool."

"The solution's most valuable feature is the CDC (Change Data Capture) component."

"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"

"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."

More Matillion ETL pros

"The most valuable would be the GUI platform that I saw. I first saw it at a special session that StreamSets provided towards the end of the summer. I saw the way you set it up and how you have different processes going on with your data. The design experience seemed to be pretty straightforward to me in terms of how you drag and drop these nodes and connect them with arrows."

"It is really easy to set up and the interface is easy to use."

"The Ease of configuration for pipes is amazing. It has a lot of connectors. Mainly, we can do everything with the data in the pipe. I really like the graphical interface too"

"I have used Data Collector, Transformer, and Control Hub products from StreamSets. What I really like about these products is that they're very user-friendly. People who are not from a technological or core development background find it easy to get started and build data pipelines and connect to the databases. They would be comfortable like any technical person within a couple of weeks."

"The best thing about StreamSets is its plugins, which are very useful and work well with almost every data source. It's also easy to use, especially if you're comfortable with SQL. You can customize it to do what you need. Many other tools have started to use features similar to those introduced by StreamSets, like automated workflows that are easy to set up."

"In StreamSets, everything is in one place."

"For me, the most valuable features in StreamSets have to be the Data Collector and Control Hub, but especially the Data Collector. That feature is very elegant and seamlessly works with numerous source systems."

"The most valuable feature is the pipelines because they enable us to pull in and push out data from different sources and to manipulate and clean things up within them."

More StreamSets pros

Cons

"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."

"I am looking forward to seeing the expansion of the source range for their data loader product."

"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."

"Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems."

"Performance can be improved for efficiency, and it can be made faster."

"While the UI is good, it could be improved in its efficiency and made easier to use."

"In the next release, we would like to have connections to more databases."

"The tool's lineage is very weak."

More Matillion ETL cons

"Sometimes, it is not clear at first how to set up nodes. A site with an explanation of how each node works would be very helpful."

"The monitoring visualization is not that user-friendly. It should include other features to visualize things, like how many records were streamed from a source to a destination on a particular date."

"The design experience is the bane of our existence because their documentation is not the best. Even when they update their software, they don't publish the best information on how to update and change your pipeline configuration to make it conform to current best practices. We don't pay for the added support. We use the "freeware version." The user community, as well as the documentation they provide for the standard user, are difficult, at best."

"There aren't enough hands-on labs, and debugging is also an issue because it takes a lot of time. Logs are not that clear when you are debugging, and you can only select a single source for a pipeline."

"The documentation is inadequate and has room for improvement because the technical support does not regularly update their documentation or the knowledge base."

"The execution engine could be improved. When I was at their session, they were using some obscure platform to run. There is a controller, which controls what happens on that, but you should be able to easily do this at any of the cloud services, such as Google Cloud. You shouldn't have any issues in terms of how to run it with their online development platform or design platform, basically their execution engine. There are issues with that."

"If you use JDBC Lookup, for example, it generally takes a long time to process data."

"One area for improvement could be the cloud storage server speed, as we have faced some latency issues here and there."

More StreamSets cons

Pricing and Cost Advice

"It is cost-effective. Based on our use case, it's efficient and cheap. It saves a lot of money and our upfront costs are less."

"The AWS pricing and licensing are a cost-effective solution for data integration needs."

"A rough estimation of the cost is around 20,000 dollars a month, however, this is dependent on the machine used and how Matillion ETL is used."

"The price of Matillion ETL is reasonable."

"The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running."

"It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."

"It was procured through the AWS Marketplace because it keeps things simple. They offer retail-like checkout and bill through your existing Amazon Web Services account."

"The prices needs to be lower."

More Matillion ETL pricing and cost advice

"We are running the community version right now, which can be used free of charge."

"There are two editions, Professional and Enterprise, and there is a free trial. We're using the Professional edition and it is competitively priced."

"It has a CPU core-based licensing, which works for us and is quite good."

"Its pricing is pretty much up to the mark. For smaller enterprises, it could be a big price to pay at the initial stage of operations, but the moment you have the Seed B or Seed C funding and you want to scale up your operations and aren't much worried about the funds, at that point in time, you would need a solution that could be scaled."

"The pricing is too fixed. It should be based on how much data you need to process. Some businesses are not so big that they process a lot of data."

"We use the free version. It's great for a public, free release. Our stance is that the paid support model is too expensive to get into. They should honestly reevaluate that."

"StreamSets is an expensive solution."

"There are different versions of the product. One is the corporate license version, and the other one is the open-source or free version. I have been using the corporate license version, but they have recently launched a new open-source version so that anybody can create an account and use it. The licensing cost varies from customer to customer. I don't have a lot of input on that. It is taken care of by PMO, and they seem fine with its pricing model. It is being used enterprise-wide. They seem to have got a good deal for StreamSets."

More StreamSets pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

832,138 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

17%

Computer Software Company

14%

Manufacturing Company

Government

Financial Services Firm

18%

Computer Software Company

11%

Manufacturing Company

10%

Insurance Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Matillion ETL?

The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.

See all answers

What is your experience regarding pricing and costs for Matillion ETL?

The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running. Its pricing model is different from the traditional pricing models ...

See all answers

What needs improvement with Matillion ETL?

Depending on the use case, the solution's pricing could be improved. Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems.

See all answers

What do you like most about StreamSets?

The best thing about StreamSets is its plugins, which are very useful and work well with almost every data source. It's also easy to use, especially if you're comfortable with SQL. You can customiz...

See all answers

What needs improvement with StreamSets?

We often faced problems, especially with SAP ERP. We struggled because many columns weren't integers or primary keys, which StreamSets couldn't handle. We had to restructure our data tables, which ...

See all answers

What is your primary use case for StreamSets?

StreamSets is used for data transformation rather than ETL processes. It focuses on transforming data directly from sources without handling the extraction part of the process. The transformed data...

See all answers

Comparisons

Azure Data Factory vs Matillion ETL

Compared 13% of the time

SSIS vs Matillion ETL

Compared 10% of the time

AWS Glue vs Matillion ETL

Compared 10% of the time

Snowflake vs Matillion ETL

Compared 7% of the time

More Matillion ETL Competitors

Informatica PowerCenter vs StreamSets

Compared 13% of the time

IBM InfoSphere DataStage vs StreamSets

Compared 11% of the time

Fivetran vs StreamSets

Compared 9% of the time

webMethods.io vs StreamSets

Compared 9% of the time

Alteryx Designer vs StreamSets

Compared 3% of the time

More StreamSets Competitors

Product Reports

Buyer's Guide

Matillion ETL

January 2025

Download Matillion ETL product report

Buyer's Guide

StreamSets

January 2025

Download StreamSets product report

Also Known As

Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery

No data available

Overview

Matillion ETL is a powerful tool for extracting, transforming, and loading large amounts of data from various sources into cloud data warehouses like Snowflake. Its ability to load data dynamically and efficiently using metadata is a standout feature, as is its open-source ETL with good performance and high efficiency.

The solution has a graphical interface for jobs, is easily adjustable and extensible, and allows for scheduling and error reporting. Matillion ETL has helped organizations move to a cloud-based solution, bridge the gap between on-premises and on-cloud, and perform complex migration projects.

Matillion

StreamSets is a data integration platform that enables organizations to efficiently move and process data across various systems. It offers a user-friendly interface for designing, deploying, and managing data pipelines, allowing users to easily connect to various data sources and destinations. StreamSets also provides real-time monitoring and alerting capabilities, ensuring that data is flowing smoothly and any issues are quickly addressed.

IBM

Sample Customers

Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc

Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge

Buyer's Guide

Matillion ETL vs. StreamSets

January 2025

Free Report: Matillion ETL vs. StreamSets

Find out what your peers are saying about Matillion ETL vs. StreamSets and other solutions. Updated: January 2025.

DOWNLOAD NOW

832,138 professionals have used our research since 2012.

See our Matillion ETL vs. StreamSets report.

See our list of best Cloud Data Integration vendors.

We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.