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."The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"It has a Data Catalog that uses the Model repository."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"It reduces a lot of legacy coding."
"The technical support for Informatica PowerCenter is good."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"I found the map links, work links, and workflows valuable. They are important features."
"Good performance and reliability."
"The solution is very scalable. It can handle a lot. We have encryption plus integration servers running on that platform currently."
"It is a seamless and sophisticated tool."
"It is user friendly, it's not complex."
"The most valuable feature is the low-code platform."
"Stability-wise, I rate the solution a ten out of ten…On a scale from one to ten, where one is difficult, and ten is easy, I rate the initial setup a nine."
"The initial setup of TIBCO BusinessWorks was straightforward since we have used the solution in our organization for a long time."
"The Business Studio interface based on SCA Standards helps to show the business logic at first look and improve code maintenance."
"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 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."
"Data transformations and rollups are easy to accomplish."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."
"I like the data vault implementations."
"The tool supports multiple target update methods."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"They should release new versions for the solution's on-premises setup."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"We had stability issues, mostly with JVM size."
"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."
"Integrating new tools can be tricky and challenging."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"The solution does not scale."
"I would like the solution to be integrated into the cloud."
"Could be more user friendly in the development area."
"There are multiple plugins which increase the number of product installations."
"The technical support's turnaround time is an area where TIBCO needs to consider improvements...Getting support from TIBCO on a particular issue takes a lot of turnaround time."
"Cloud fitness is lacking"
"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 cost of this product is too expensive for smaller companies or those with a small number of integrations."
"Improve Business Studio's stability to further minimize development time."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Customization could be better."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"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."
"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."
Earn 20 points