We performed a comparison between Informatica PowerCenter and JumpMind SymmetricDS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"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."
"The setup is straightforward."
"It reduces a lot of legacy coding."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"It has very good monitoring and process monitoring."
"It is fully featured. It has allowed me to do everything I wanted to do."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"The solution does not scale."
"The initial setup is not straightforward. You need expertise to do it."
"I would like to see it be able to import data from NoSQL."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"The user interface could improve. We are looking at some cloud-based databases, and I don't think they support that."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while JumpMind SymmetricDS is ranked 13th in Data Replication. Informatica PowerCenter is rated 8.0, while JumpMind SymmetricDS is rated 9.0. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of JumpMind SymmetricDS writes "Excellent change data capture utility for distributed multi site environment". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas JumpMind SymmetricDS is most compared with Oracle GoldenGate, AWS Database Migration Service, Confluent, SSIS and Azure Data Factory.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.