We performed a comparison between Oracle Data Integrator (ODI), SAP Replication Server, 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 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."
"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."
"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."
"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."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
"SAP is renovating different things. We are using external tools to connect as of now. It is going well, and now the new generation integration platforms are going to be pretty easy."
"It speeds up the performance in terms of how fast you are able to access the data, look at it, get it reported to you, and send it to somebody. It also reduces the amount of storage."
"SAP Replication Server is an application that I consider to be a robust system. It has proven to be highly reliable in my experience."
"We can customize any workflow and we also like the business domain modeling that can be done."
"Support is absolutely excellent, efficient, and timely."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"It has a built-in automatic scheduling environment."
"The most valuable feature is the metadata generated code."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"The tool supports multiple target update methods."
"Data transformations and rollups are easy to accomplish."
"Naturally produces a way to easily debug your DW data solutions."
"Stability could be improved because some operators have issues."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"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."
"If you have something like Cisco on top of it, you will have endless problems."
"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."
"The private solution is expensive. If you're in a situation where you're paying IBM or AWS or somebody just to host you specifically, you're paying people to run it and you're taking care of all the upgrades."
"I would like to see it become mobile-friendly."
"Improvement is a never ending story, and HANA is doing some improvements. We are able to adopt that, and we have to do it by integration with HANA. They are very major changes that we need to see."
"There is room for improvement in terms of pricing and faster support."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"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."
"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."
"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."
Earn 20 points