We performed a comparison between Informatica PowerCenter, Informatica PowerExchange, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It's very easy to use it to develop mappings and workflows."
"The number of docs has been reduced drastically, which is very good."
"Can manage a huge quantity of data and provide reliability."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"It has helped us monetize."
"Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application."
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"The product's initial setup phase was not complex. The tool is easy to install onto any of the servers, and you can integrate it."
"The data transformation is the solution's most valuable feature."
"Provides a significant amount of control over the landscape and overall implementation."
"The product’s flexibility is valuable."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"It is a scalable and versatile solution."
"This product is easy to install and it can be done in a few hours."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The scalability of SSIS is good."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"SSIS' best feature is SFTP connectivity."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"The performance of Informatica PowerCenter could improve."
"The UI is a little outdated."
"Support could be better."
"The licensing is difficult."
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"The solution needs better integration with other tools."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."
"The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk."
"The connectivity with T24 core banking could be improved."
"Should diversify more, maybe with a reporting and visualization utility,"
"I would like to have easier integration with cloud platforms."
"I would like the stability to improve."
"The performance of SSIS could improve when comparing it to Oracle Database."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"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."
"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."
"It would be nice if you could run SSIS on other environments besides Windows."
"It hangs a lot of the time."
"We'd like them to develop data exploration more."