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."ODI's most valuable features are it utilizes the database engine and is very lightweight."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"It's completely user-friendly."
"The product has an ELT approach."
"The initial setup is easy."
"The most valuable feature of TIBCO Scribe is the connectors available to various products."
"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."
"Support is absolutely excellent, efficient, and timely."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"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."
"I found the initial setup very easy."
"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."
"Stability could be improved because some operators have issues."
"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."
"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."
"It needs easier security."
"If you have something like Cisco on top of it, you will have endless problems."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"Technical Support could be better."
"The solution should provide better documentation and scenario-based samples."
"Technical support isn't the best."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"No support for change data capture or delta detection - that must be custom coded ."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"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."
"Customization could be better."
Earn 20 points
