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."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's a complete package, which is why we use this solution."
"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."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"Jitterbit provides the ability to quickly map data between files and databases."
"It is a scalable solution."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"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."
"Easy integration with Salesforce"
"The Cloud Console for monitoring and troubleshooting data operations."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"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."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"The most valuable feature is the metadata generated code."
"The tool supports multiple target update methods."
"Naturally produces a way to easily debug your DW data solutions."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"I would like to see it be able to import data from NoSQL."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"The solution does not scale."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"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."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"I would like the ability to offer a dedicated cloud version for security."
"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."
"Sometimes additional connectors are needed."
"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."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"Improve the object renaming ability (it works, but it could be more automated)."
"Customization could be better."
"No support for change data capture or delta detection - that must be custom coded ."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Technical support isn't the best."
Earn 20 points