We performed a comparison between Informatica PowerCenter, SAP Replication Server, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."I like the automated scheduling feature."
"The number of docs has been reduced drastically, which is very good."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"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."
"Good interface, reasonable documentation."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"I found the map links, work links, and workflows valuable. They are important features."
"SAP Replication Server is an application that I consider to be a robust system. It has proven to be highly reliable in my experience."
"SAP is renovating different things. We are using external tools to connect as of now. It is going well, and now the new generation integration platforms are going to be pretty easy."
"We can customize any workflow and we also like the business domain modeling that can be done."
"It speeds up the performance in terms of how fast you are able to access the data, look at it, get it reported to you, and send it to somebody. It also reduces the amount of storage."
"The data reader is the most valuable feature."
"The simplicity of the solution is great. The solution also offers excellent integration."
"It is easy to set up the product."
"SSIS is easy to use."
"It has good data integration and good processes."
"The solution is stable."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The solution is easy to use and developer friendly."
"They should release new versions for the solution's on-premises setup."
"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."
"There is some room for improvement in terms of pricing."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"We had stability issues, mostly with JVM size."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"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."
"I would like to see it become mobile-friendly."
"There is room for improvement in terms of pricing and faster support."
"Improvement is a never ending story, and HANA is doing some improvements. We are able to adopt that, and we have to do it by integration with HANA. They are very major changes that we need to see."
"The private solution is expensive. If you're in a situation where you're paying IBM or AWS or somebody just to host you specifically, you're paying people to run it and you're taking care of all the upgrades."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"I would like to see better integration with Power BI."
"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."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"The performance of this solution is not as good as other tools in the market."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."