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."PowerCenter performs well during data transformation and optimization."
"The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible."
"Good product if you are trying implement data quality, data integration, and data management projects."
"We can scale the product."
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"I like the completeness of the way I can build ETL workflows."
"What I like the most is that we have to deal with less while writing the queries."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"It's pretty good at handling replication, even under high load. It also provides cross-database replication, for example, from Sybase to Oracle."
"SAP Replication Server is an application that I consider to be a robust system. It has proven to be highly reliable in my experience."
"We can customize any workflow and we also like the business domain modeling that can be done."
"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."
"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 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 scalability of SSIS is good."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The performance is good."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"SSIS is easy to use."
"The solution is stable."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"Support could be better."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"Lacks ability to calculate cost of the product."
"I would like to see it become mobile-friendly."
"If someone wants to replicate their data from Sybase to a newer technology for data warehousing or other purposes, it would be better if they supported those."
"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."
"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."
"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."
"Options for scaling could be improved."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"This solution needs full support for real-time processing."