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."Once you have learned Informatica, it is very easy to use."
"The solution is stable."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"It is an excellent ETL tool."
"I like the completeness of the way I can build ETL workflows."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"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."
"It runs like an appliance and has tremendous throughput."
"Easy integration with Salesforce"
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"It is a scalable solution."
"The Cloud Console for monitoring and troubleshooting data operations."
"Jitterbit provides the ability to quickly map data between files and databases."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"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."
"I would like to see it be able to import data from NoSQL."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"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 good to recreate the entire interface to make it easier for users to build workflows."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"Looping through complex data structures can be difficult."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"Its API management capabilities need improvement."
"Sometimes additional connectors are needed."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"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.