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 is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"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 most valuable feature of Matillion ETL is its user-friendly graphical interface."
"Matillion ETL is one hundred percent stable."
"It has improved the costs of managing my customer’s data."
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"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."
"The performance is good."
"It's saved time using visualization descriptions."
"The setup was easy. All Microsoft products are easy to set up."
"It's already very user-friendly and has a good dashboard."
"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."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"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."
"Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
"It needs integration with more data sources."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"We'd like more integration capabilities."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"Future releases should improve the data lineage, as it currently is not good."
"It's a legacy tool, that is nearing the end of its useful life."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"The creation of the measure in the DAC's model could be improved."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
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.