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."ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The CAEM is very useful in its modularity and portability."
"It has the ability to easily load slowly changing dimensions."
"The installation of the client ODI Studio is easy."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"The product has an ELT approach."
"The tool supports multiple target update methods."
"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."
"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."
"Naturally produces a way to easily debug your DW data solutions."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"It has a built-in automatic scheduling environment."
"Support is absolutely excellent, efficient, and timely."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"The connection between Facebook lead forms and MailChimp integrations is the most valuable feature."
"The most valuable feature of Zapier is it saves me time doing repetitive tasks."
"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."
"Zapier luckily has a wide range of integrations, I would say."
"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."
"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."
"The solution is a SaaS and does not require a complex setup."
"With the previous CRM we were using – the Google Ads landing pages we had – we were collecting leads manually. That process was not efficient and took a sales team a lot of time to insert these leads manually. Currently, the process is smooth and we use Zapier to collect the leads for us."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"The resource management aspect of the solution could be improved."
"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."
"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."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"The initial setup is complex, especially if you also have to install a console."
"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."
"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."
"Customization could be better."
"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 ."
"Technical support isn't the best."
"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."
"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)."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"The pricing of the solution is quite expensive."
"Zapier needs to improve in the same way most RPA solutions should, such as Robocorp, Make, or UiPath. They are not good at helping you find the connections that you need for the problem that you have. For example, if need something on Instagram. I'm going to have to do research for hours to be able to find the components or the app, which is going to do what I need it to do. It makes it difficult to use the system when you don't know what to use."
"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."
"At the moment, they allow a limited number of apps. I look forward to getting more apps for each package."
"Some recent changes to the solution have made it bulky and not as intuitive to use as it previously was."
"It could support various languages along with Python."
"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."
"There is room for improvement in the support. They are not responsive, and they don't take much time to get resolved."
Earn 20 points
