We performed a comparison between Informatica PowerCenter, SSIS, and Tungsten RPA based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The ability to scale through partitions helped us to improve the performance."
"It has good standard features for ETL development."
"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."
"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"It has a Data Catalog that uses the Model repository."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"The performance is good."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"The initial setup was easy."
"The performance and stability are good."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"It's already very user-friendly and has a good dashboard."
"SSIS' most valuable feature is its reporting services."
"The solution is scalable."
"The best part of Kofax is that they have a whole concept. It's one product, but also has extra elements that can be integrated."
"The most valuable features are workflow and process automation."
"You can automate browsing tasks without needing a server connection. The platform provides its browser, allowing you to run anything inside it."
"The product saves time and resources."
"The pricing of the solution is quite good."
"The features that we have found the most valuable are the integration of different third-party support and productivity services."
"The product provided all the security controls that we asked them."
"The initial setup is not straightforward. You need expertise to do it."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"Its scalability can be improved. It is not scalable."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"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."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"The security could be improved, as it is more important in our context."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"Future releases should improve the data lineage, as it currently is not good."
"I would like to see more features in terms of the integration with Azure Data Factory."
"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 hangs a lot of the time."
"The interface could be better from a usability standpoint."
"The solution needs to be scalable."
"There is really nothing special about the capabilities of this product."
"RPA technology is constantly changing, and sometimes Kofax lags behind."
"Automation with the latest websites is not effective. The support of newer websites developed using new technologies would improve this solution."
"Kofax RPA's UI could be more user-friendly."
"The product should improve desktop automation, which is hard to configure. It needs to have custom connectors. It is the only advantage that Microsoft Power Platform has over Kofax RPA. It has more than 800 custom connectors."
"The product has some constraints and performance issues."