We performed a comparison between Oracle Data Integrator (ODI), WhereScape RED, and Zapier based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The product has an ELT approach."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"The scalability is great. It's one of the reasons we chose the solution."
"The initial setup is easy."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"The CAEM is very useful in its modularity and portability."
"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."
"Oracle provides great documentation."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Naturally produces a way to easily debug your DW data solutions."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"I found the initial setup very easy."
"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."
"The tool supports multiple target update methods."
"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."
"Zapier luckily has a wide range of integrations, I would say."
"Zapier’s most valuable feature is its ability to interconnect applications or devices."
"Zapier is user friendly and makes it easy to integrate different tools. It has a drag and drop functionality which makes it easy to connect environments."
"We find it effortless to set up. We really don't have to do anything other than finding the application in the Zapier catalog. And as long as the application has been re-integrated into Zapier, they're able to then just provide the connection details and hook it up."
"The product's most valuable feature is automation."
"Zapier is a really good tool for connecting multiple different platforms and data sources. For example, with Quickbase, I can easily integrate data from other sources like AWS or task-tracking platforms such as ClickUp or Asana."
"There are a few valuable features, like the stability that it comes with and also the number of features that it offers. I've used other services like Pabbly, but they don't offer similar numbers of applications that Zapier has or allows to integrate with – it's maximum."
"The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve."
"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 lacks some functions and features."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"If you have something like Cisco on top of it, you will have endless problems."
"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."
"The price needs to be lowered. It's too expensive."
"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."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"No support for change data capture or delta detection - that must be custom coded ."
"Technical support isn't the best."
"Customization could be better."
"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)."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"It is not worth the money if you have a little bit of a technical mind...Zapier is not able to set up different modules. When automation doesn't work, it's not that easy to find why it didn't work."
"Some apps are not available yet. For instance, a connection with Joomla! would be great. In general, all the most-used apps are available, but I bumped into Joomla! with a client."
"Zapier needs more YouTube or video tutorials or more training for people. That would help a lot. In particular, Zapier should have documentation for every connector. Its documentation needs to be more detailed and visual."
"I think that this solution should have more apps connected to it."
"With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation."
"Being able to share Zaps and organize them with teammates would allow sharing and refining scenarios and even combining steps that require different people's credentials."
"System-to-system is fine, but when it comes to system-to-user, where Zapier is helping to communicate to a user, that's a one-way communication. If that user has to perform some action on that notification, the action isn't handled by Zapier. So there's no way to orchestrate that and it's very cumbersome."
"I would like to see them improve the Quickbase integration. Currently, it only allows triggering actions when records are added, but it would be more useful if we could also trigger actions when records are modified or deleted."
Earn 20 points
