We performed a comparison between Matillion ETL and SSIS 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."Matillion ETL is one hundred percent stable."
"Matillion ETL has great Git integration that is perfect and convenient to use."
"The product's initial setup phase was easy."
"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."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"The product has a good user interface."
"It has improved the costs of managing my customer’s data."
"The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"It's already very user-friendly and has a good dashboard."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The simplicity of the solution is great. The solution also offers excellent integration."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"The data reader is the most valuable feature."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"The cost of the solution is high and could be reduced."
"There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features."
"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking."
"In the next release, we would like to have connections to more databases."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"Video training would be a helpful addition."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"We'd like more integration capabilities."
"Improvement as per customer requirements."
"It would be nice if you could run SSIS on other environments besides Windows."
"We have issues with SSIS connectors while extracting data from Excel sources."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Matillion ETL is rated 8.6, while SSIS is rated 7.6. 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 SSIS writes "Maintaining the solution and contacting its support team is easy". Matillion ETL is most compared with Snowflake, Azure Data Factory, AWS Glue, Informatica PowerCenter and Informatica Cloud Data Integration, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and SAP Data Services. See our Matillion ETL vs. SSIS 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.