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."The loading of data is the most valuable feature of Matillion ETL."
"Matillion ETL is one hundred percent stable."
"It has good integrations with Amazon Redshift and other AWS services."
"The technical support treats us well. They already have a support portal, and they are responsive, which helps."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"It has helped us to get onto the cloud quickly."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple."
"The ability to have a good bifurcation rate and fewer mistakes is valuable."
"The ETL capabilities are very useful for us. We extract and transform data from multiple data sources, into a single, consistent data store, and then we put it in our systems. We typically use it to connect our Apache Kafka with data lakes. That process is smooth and saves us a lot of time in our production systems."
"It is really easy to set up and the interface is easy to use."
"In StreamSets, everything is in one place."
"Also, the intuitive canvas for designing all the streams in the pipeline, along with the simplicity of the entire product are very big pluses for me. The software is very simple and straightforward. That is something that is needed right now."
"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"
"Important features include that it comprises lots of functionality to connect data from various sources through connector availability, scheduling pipelines at any time, and integration with third-party and security solutions for encryption."
"What I love the most is that StreamSets is very light. It's a containerized application. It's easy to use with Docker. If you are a large organization, it's very easy to use Kubernetes."
"It needs integration with more data sources."
"In the next release, we would like to have connections to more databases."
"The cost of the solution is high and could be reduced."
"Performance can be improved for efficiency, and it can be made faster."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"In terms of the product, I don't think there is any room for improvement because it is very good. One small area of improvement that is very much needed is on the knowledge base side. Sometimes, it is not very clear how to set up a certain process or a certain node for a person who's using the platform for the first time."
"The data collector in StreamSets has to be designed properly. For example, a simple database configuration with MySQL DB requires the MySQL Connector to be installed."
"I would like to see further improvement in the UI. In addition, upgrades are not automatic and they should be automated. Currently, we have to manually upgrade versions."
"The documentation is inadequate and has room for improvement because the technical support does not regularly update their documentation or the knowledge base."
"We've seen a couple of cases where it appears to have a memory leak or a similar problem."
"One thing that I would like to add is the ability to manually enter data. The way the solution currently works is we don't have the option to manually change the data at any point in time. Being able to do that will allow us to do everything that we want to do with our data. Sometimes, we need to manually manipulate the data to make it more accurate in case our prior bifurcation filters are not good. If we have the option to manually enter the data or make the exact iterations on the data set, that would be a good thing."
"The software is very good overall. Areas for improvement are the error logging and the version history. I would like to see better, more detailed error logging information."
"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."
Matillion ETL is ranked 4th in Cloud Data Integration with 22 reviews while StreamSets is ranked 8th in Data Integration with 23 reviews. Matillion ETL is rated 8.6, while StreamSets is rated 8.4. The top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". On the other hand, the top reviewer of StreamSets writes "We no longer need to hire highly skilled data engineers to create and monitor data pipelines". Matillion ETL is most compared with Azure Data Factory, Snowflake, AWS Glue, Informatica PowerCenter and SSIS, whereas StreamSets is most compared with Fivetran, Azure Data Factory, Informatica PowerCenter, SSIS and Oracle GoldenGate. 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.