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."
"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."
"The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple."
"Matillion ETL has great Git integration that is perfect and convenient to use."
"The loading of data is the most valuable feature of Matillion ETL."
"It's been able to do everything we require."
"The solution is stable."
"The data reader is the most valuable feature."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"SSIS is easy to use."
"The scalability of SSIS is good."
"The technical support is very good."
"It is easy to set up the product."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The cost of the solution is high and could be reduced."
"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."
"I am looking forward to seeing the expansion of the source range for their data loader product."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"When using the SQL loader type there were not a lot of pre-processing features for the data. For example, if there is a table with twenty columns, but we only want to load ten columns. In that case, we can use a security script to select the specific columns needed. However, if we want to perform extensive pre-processing of the data, I faced some challenges with Matillion ETL. I did not encounter many challenges, but my overall experience is limited as I only have three years of experience."
"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."
"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."
"The security could be improved, as it is more important in our context."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"It would be nice if you could run SSIS on other environments besides Windows."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"At one point, we did have to purchase an add-on."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
Matillion ETL is ranked 10th in Cloud Data Integration with 6 reviews while SSIS is ranked 3rd in Data Integration Tools with 35 reviews. Matillion ETL is rated 8.6, while SSIS is rated 7.6. The top reviewer of Matillion ETL writes "User-friendly, stable, and easily scalable". On the other hand, the top reviewer of SSIS writes "SSIS 2016 - The good, the bad, and the ugly". Matillion ETL is most compared with Informatica PowerCenter, Azure Data Factory, AWS Glue, Fivetran and Talend Open Studio, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), AWS Glue and Oracle GoldenGate. See our Matillion ETL vs. SSIS report.
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.