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 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 has helped us to get onto the cloud quickly."
"Matillion ETL has great Git integration that is perfect and convenient to use."
"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"It has good integrations with Amazon Redshift and other AWS services."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"The data reader is the most valuable feature."
"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."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"It's already very user-friendly and has a good dashboard."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The performance and stability are good."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"The solution is easy to use and developer friendly."
"Performance can be improved for efficiency, and it can be made faster."
"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."
"It needs integration with more data sources."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"The tool's lineage is very weak."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."
"In the next release, we would like to have connections to more databases."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"We have issues with SSIS connectors while extracting data from Excel sources."
"The security could be improved, as it is more important in our context."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"It needs more integration tools, so you can connect to different sources."
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.