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."Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"UI-based ability to create data mapping."
"The ability to scale through partitions helped us to improve the performance."
"The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution."
"Informatica PowerCenter is a very good ETL tool."
"The number of docs has been reduced drastically, which is very good."
"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."
"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."
"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."
"It's been able to do everything we require."
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"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 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 loading of data is the most valuable feature of Matillion ETL."
"SSIS is easy to use."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The technical support is very good."
"The solution is stable."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The UI is very user-friendly."
"The most important features are it works well and provides self-service BI."
"The documentation could be improved."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"Its scalability can be improved. It is not scalable."
"The reputation of Informatica is that it is expensive."
"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."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"The cost of the solution is high and could be reduced."
"Performance can be improved for efficiency, and it can be made faster."
"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."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"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."
"I would like to see more features in terms of the integration with Azure Data Factory."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"This solution needs full support for real-time processing."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."