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 loading of data is the most valuable feature of Matillion ETL."
"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 product has a good user interface."
"It has improved the costs of managing my customer’s data."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"The product's initial setup phase was easy."
"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 aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"It is easy to set up the solution."
"It is easy to set up the product."
"The initial setup of this solution is very straightforward."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"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."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The UI is very user-friendly."
"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."
"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."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"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 found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"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."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"The solution could improve on integrating with other types of data sources."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
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.