We performed a comparison between Oracle Data Integrator (ODI), TIBCO Scribe, 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."
"Besides loading data, we do most of our transformations in ODI."
"It is an ETL tool, which does the extract, transform, and load."
"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's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"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 most valuable feature of TIBCO Scribe is the connectors available to various products."
"The tool supports multiple target update methods."
"I like the data vault implementations."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"Data transformations and rollups are easy to accomplish."
"Naturally produces a way to easily debug your DW data solutions."
"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."
"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."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"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."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"We used a third party to do the implementation of ODI."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"The solution should provide better documentation and scenario-based samples."
"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."
"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."
"No support for change data capture or delta detection - that must be custom coded ."
"Customization could be better."
"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 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)."
Earn 20 points