We performed a comparison between CloverETL and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Server features for scheduler: It is very easy to schedule jobs and monitor them. The interface is easy to use."
"Connectivity to various data sources: The ability to extract data from different data sources gives greater flexibility."
"Key features include wealth of pre-defined components; all components are customizable; descriptive logging, especially for error messages."
"No dependence on native language and ease of use."
"The most valuable feature that we use is the Knowledge Modules."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"Oracle provides great documentation."
"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."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"It has the ability to easily load slowly changing dimensions."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"Its documentation could be improved."
"Needs: easier automated failure recovery; more, and more intuitive auto-generated/filled-in code for components; easier/more automated sync between CloverETL Designer and CloverETL Server."
"Resource management: We typically run out of heap space, and even the allocation of high heap space does not seem to be enough."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"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 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."
"The price needs to be lowered. It's too expensive."
"It needs easier security."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
Earn 20 points
CloverETL is ranked 60th in Data Integration while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. CloverETL is rated 7.0, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of CloverETL writes "Provides wealth of pre-defined, customizable components, and descriptive logging for errors". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". CloverETL is most compared with iWay Universal Adapter Framework, Talend Open Studio and SSIS, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Oracle GoldenGate.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.