We performed a comparison between Informatica PowerCenter, Jitterbit Harmony , and WhereScape RED based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It has good standard features for ETL development."
"It's a complete package, which is why we use this solution."
"The product's initial setup phase is very easy."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"The setup is very simple."
"It reduces a lot of legacy coding."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"Jitterbit provides the ability to quickly map data between files and databases."
"Easy integration with Salesforce"
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"It is a scalable solution."
"It is very easy to build integrations and processes to pull and push data."
"It runs like an appliance and has tremendous throughput."
"I like the data vault implementations."
"I found the initial setup very easy."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Naturally produces a way to easily debug your DW data solutions."
"WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing."
"Data transformations and rollups are easy to accomplish."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"The tool supports multiple target update methods."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"Integrating new tools can be tricky and challenging."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"The initial setup is not straightforward. You need expertise to do it."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"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."
"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."
"There is some room for improvement in terms of pricing."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"Its API management capabilities need improvement."
"I would like the ability to offer a dedicated cloud version for security."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"The initial setup can be a little bit difficult."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"Looping through complex data structures can be difficult."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Improve the object renaming ability (it works, but it could be more automated)."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Technical support isn't the best."
"Customization could be better."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"No support for change data capture or delta detection - that must be custom coded ."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
Earn 20 points