We performed a comparison between Oracle Data Integrator (ODI), SAP Data Services, 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."I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"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."
"It's completely user-friendly."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"The initial setup is easy."
"We can extract data at a table level, extract data at the ETL level, and we can extract data at an ODP level."
"Data Services' best features are its robustness and plug-and-play integration with other SAP applications."
"The solution is easy to use since it's a graphical tool. It also requires only low-level coding."
"The product's most valuable features are data validation and rules."
"The most valuable feature is the ETL functionality."
"It's easy to understand and deploy. It's easy to create new applications, and depending on the complexity of the application, it is easy to deploy the new requirements."
"Its integration capabilities and the data migration capabilities are the most valuable. It is very good for SAP and non-SAP tools. It has very good integration with SAP, but it also has the capabilities to connect to other systems. We find it very helpful and stable."
"The solution offers very good integration capabilities."
"Data transformations and rollups are easy to accomplish."
"It has a built-in automatic scheduling environment."
"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."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"I like the data vault implementations."
"The most valuable feature is the metadata generated code."
"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."
"Support is absolutely excellent, efficient, and timely."
"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."
"We used a third party to do the implementation of ODI."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"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."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"The price needs to be lowered. It's too expensive."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"The solution could improve the overall features. There is a lot that can be done in the solution, therefor there are areas where it can improve. Additionally, there is a need to make it easier for one to create connections to other non-SAP systems. The flexibility to connect to other non-SAP systems is needed."
"There needs to be multi-language support, however, my understanding is they are working on multi-language now."
"With SAP Data Services, the problem arises when I try to connect to Azure Databricks."
"There should be some kind of enhancement that can be done on the admin side of certain sites where we can assign the roles and responsibilities. We should be able to control who is using the tool and how."
"In the future, Data Services should offer a cloud version."
"The solution shows a lack of cloud support data services."
"Source code control is another headache. When your source code base gets too large, managing the source code becomes cumbersome."
"Integration with other products could be improved."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"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."
"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)."
"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."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"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