We performed a comparison between Informatica PowerCenter, TIBCO BusinessWorks, 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."
"Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"It is UI friendly and has all the advantages of an ETL tool."
"The interface is very clean and clear."
"It has helped us monetize."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"The most valuable feature is the integration."
"Good performance and reliability."
"The most important thing is that it is easy for developers to work with."
"Areas for improvement would be the cloud fitness of the product and the ease of migrating to newer versions."
"XML to JSON transformations, out-of-the-box, helps to build REST services."
"The Business Studio interface based on SCA Standards helps to show the business logic at first look and improve code maintenance."
"The initial setup of TIBCO BusinessWorks was straightforward since we have used the solution in our organization for a long time."
"The solution is stable. We haven't had any serious technical issues."
"The tool supports multiple target update methods."
"Support is absolutely excellent, efficient, and timely."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"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."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"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."
"The most valuable feature is the metadata generated code."
"It should be more cloud-centric than on-prem-centric."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"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."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"The UI is a little outdated."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"Though it is a stable product, if we have an issue with the product, it gets difficult, and it gets really difficult to explain the issue to the support team. Also, it takes a long time to get resolved."
"Its price can be improved. For medium enterprises, it is a very expensive tool. In the market, you won't get many resources for this solution. You won't find many developers in the market very easily. The latest version of TIBCO (6.4 or 6.x) is not very stable. It has got many issues. We have raised this with TIBCO, and they are taking a lot of time to come up with a fix, which is making us move away from this product. Some of the performance-tuning aspects are also missing in version 6. They should provide performance-related fixes, which will be helpful for the customers. If you are migrating from the current version to the container-supported version, it is quite expensive. The product has evolved, but it is very pricey. That's one of the challenges. They have provided all the features that are there in other products, but this is a platform upgrade. The platform has completely been changed from 5.x to 6.x, and we can't use the same environment. We can't run both versions on the same server as VM. The development environment is entirely different. In version 5.x, there was a proprietary designer. Now, it has common plug-ins developed on top of Eclipse."
"Scaling with the solution is costly because if we need to scale up, we have to buy more memory. That means more money. Solutions like Camel or Pulsar come with built-in options to scale horizontally, vertically, region-wide or country-wide."
"I'd like to see a new cloud approach in the next release. They need to work on integrations, stability and management issues on their cloud platform."
"The communication protocols could be improved."
"The initial setup is not easy."
"The container-based image is too large and this makes auto-scaling difficult."
"The cost of this product is too expensive for smaller companies or those with a small number of integrations."
"Improve the object renaming ability (it works, but it could be more automated)."
"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."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"Technical support isn't the best."
"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."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
Earn 20 points