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."It has good integrations with Amazon Redshift and other AWS services."
"We allow non-technical people to use Matillion to load data into our data warehouse for reporting. Thus, it is easy enough to use that we don't always have to get a technical person involved in setting up a data movement (ETL)."
"The most valuable feature of Matillion ETL is its user-friendly graphical interface."
"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 is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"It has improved the costs of managing my customer’s data."
"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 can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"Overall, it's a good product."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"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."
"It is easy to set up the product."
"It's a competent product."
"SSIS integrates well with SQL servers and Microsoft products."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"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 product must enhance its near-real-time data capture feature."
"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."
"The cost of the solution is high and could be reduced."
"The tool's lineage is very weak."
"The performance of SSIS could improve when comparing it to Oracle Database."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"Future releases should improve the data lineage, as it currently is not good."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"The performance of this solution is not as good as other tools in the market."
"I would like to see better technical documentation because many times information is missing."
Matillion ETL is ranked 4th in Cloud Data Integration with 22 reviews while SSIS is ranked 2nd in Data Integration with 68 reviews. Matillion ETL is rated 8.6, while SSIS is rated 7.8. 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 Azure Data Factory, Snowflake, AWS Glue, Informatica PowerCenter and Informatica Cloud Data Integration, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and FME. 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.