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 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."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"Oracle provides great documentation."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"Besides loading data, we do most of our transformations in ODI."
"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."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"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 most valuable feature is the metadata generated code."
"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."
"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."
"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."
"Naturally produces a way to easily debug your DW data solutions."
"I like the data vault implementations."
"Support is absolutely excellent, efficient, and timely."
"The connection between Facebook lead forms and MailChimp integrations is the most valuable feature."
"The ability to connect web applications to trigger actions in another app after having enriched, formatted, delayed, grouped, and filtered is really valuable for many businesses."
"Webhooks are the most valuable feature of Zapier."
"Zapier handles everything under the sun that you would think you need in automation. It is the most mature integration platform and service on the market."
"The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve."
"What's most valuable in Zapier is its simplicity, seamlessness, and smooth plug-in, so you won't need to build code for every action. I'm not a developer, but I can use Zapier."
"We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature."
"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."
"We used a third party to do the implementation of ODI."
"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."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"The solution lacks some functions and features."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"The initial setup is complex, especially if you also have to install a console."
"If you have something like Cisco on top of it, you will have endless problems."
"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."
"Technical support isn't the best."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"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 ."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"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."
"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."
"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 user interface for Zapier could be improved. It also takes some time to sync the data between different environments."
"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."
"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."
"My biggest concern with Zapier would be their pricing strategy."
"Zapier could be a little faster, but that might not be possible. I would encourage Zapier to make more API endpoints for each application"
"After mapping them out, and they'd worked for a while, I've had Zapier fail."
"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