We performed a comparison between Oracle Data Integrator (ODI), SAS Data Integration 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 installation of the client ODI Studio is easy."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"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."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"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."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"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."
"The product has an ELT approach."
"The solution is very stable."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution offers very good data manipulation and loading."
"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."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"The most valuable feature is the metadata generated code."
"Naturally produces a way to easily debug your DW data solutions."
"Support is absolutely excellent, efficient, and timely."
"The tool supports multiple target update methods."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"Data transformations and rollups are easy to accomplish."
"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."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"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 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 performance of the user interface is in need of improvement."
"The initial setup is a bit complex compared to other tools."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"Technical Support could be better."
"The initial setup of SAS Data Integration Server was complex."
"So I would like to see improved integration with other software."
"The transform tool has limited access. They should make it more flexible."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"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."
"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."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"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."
Earn 20 points