We performed a comparison between Informatica PowerCenter and Jitterbit Harmony based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"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."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"The setup is straightforward."
"I like the automated scheduling feature."
"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."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"Easy integration with Salesforce"
"Jitterbit provides the ability to quickly map data between files and databases."
"It is a scalable solution."
"The Cloud Console for monitoring and troubleshooting data operations."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"It runs like an appliance and has tremendous throughput."
"It is very easy to build integrations and processes to pull and push data."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"I would like to see it be able to import data from NoSQL."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"The initial setup is not straightforward. You need expertise to do it."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"The pricing could be improved."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"Looping through complex data structures can be difficult."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"Its API management capabilities need improvement."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"The initial setup can be a little bit difficult."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Jitterbit Harmony is ranked 35th in Data Integration with 13 reviews. Informatica PowerCenter is rated 8.0, while Jitterbit Harmony is rated 8.6. 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 Jitterbit Harmony writes "An easy-to-setup solution with good stability ". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas Jitterbit Harmony is most compared with Microsoft Azure Logic Apps, Azure Data Factory, Mule Anypoint Platform, MuleSoft Composer and SnapLogic. See our Informatica PowerCenter vs. Jitterbit Harmony report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
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.