We performed a comparison between Informatica PowerCenter, Matillion ETL, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."It is UI friendly and has all the advantages of an ETL tool."
"It is an excellent ETL tool."
"The technical support for Informatica PowerCenter is good."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"Informatica PowerCenter is a very good ETL tool."
"The setup is straightforward."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"The product has a good user interface."
"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."
"It has helped us to get onto the cloud quickly."
"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."
"Matillion ETL is one hundred percent stable."
"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."
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"SSIS is easy to use."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"It's saved time using visualization descriptions."
"SSIS' best feature is SFTP connectivity."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"We had stability issues, mostly with JVM size."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"Support could be better."
"The solution must improve the integration with new services."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."
"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."
"The product must enhance its near-real-time data capture feature."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"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."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"Options for scaling could be improved."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"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."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"Performance could be better."