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."The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"The loading of data is the most valuable feature of Matillion ETL."
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"It's been able to do everything we require."
"The product has a good user interface."
"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."
"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"The solution is easy to use and developer friendly."
"The solution is stable."
"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."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The setup is straightforward. It's very easy to install."
"The setup was easy. All Microsoft products are easy to set up."
"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."
"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"The tool's lineage is very weak."
"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."
"It needs integration with more data sources."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"The performance of this solution is not as good as other tools in the market."
"Video training would be a helpful addition."
"We'd like them to develop data exploration more."
"I would like to see more features in terms of the integration with Azure Data Factory."
"Future releases should improve the data lineage, as it currently is not good."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
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.