We performed a comparison between Informatica PowerCenter, Oracle Data Integrator (ODI), 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 product's initial setup phase is very easy."
"Good interface, reasonable documentation."
"The solution is stable."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"In the end, you have structured, proper data for use in an integrated BI solution."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"It has a Data Catalog that uses the Model repository."
"Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"It's completely user-friendly."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"Support is absolutely excellent, efficient, and timely."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"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."
"It has a built-in automatic scheduling environment."
"The tool supports multiple target update methods."
"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."
"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 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."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"It should be more cloud-centric than on-prem-centric."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"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."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"Technical Support could be better."
"Stability could be improved because some operators have issues."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"The initial setup is complex, especially if you also have to install a console."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"Reverse engineering is complicated and challenging to manage."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Customization could be better."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"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 ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"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."
"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