We performed a comparison between Oracle Data Integrator (ODI), Talend Open Studio, and Unifi based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"It's scalable."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"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."
"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."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"Talend Studio has the ability to use it to ensure data quality."
"The standout feature for me is the user-friendly nature of the components."
"We're sold on the customization part of the solution."
"The initial setup was quite straightforward. The deployment took between two and three days."
"The drag-and-drop feature in the interface is very good."
"Talend can connect to multiple data sources, including relational data sources, ERP, CRM, and others."
"This product is very easy to use."
"The API integration and big data approach are very good because of how you extract data from JSP files or big data web repositories like MongoDB."
"The controller makes it easy to control everything from one platform. The management is easy."
"It's easy to manage and support the user, our guests, and our customers if they have a problem."
"If you have something like Cisco on top of it, you will have endless problems."
"We used a third party to do the implementation of ODI."
"The initial setup is a bit complex compared to other tools."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"The solution lacks some functions and features."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"Stability could be improved because some operators have issues."
"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 high price of the solution is an area of concern where improvements are required."
"We don't get continuous replication of the data."
"Inter-version compatibility is a problem, and migration projects between versions are required."
"If I compare Open Studion to other solutions, their interface is robust but not so fancy looking. This is an area that could use improvement. I would like to see an updated interface."
"Talend should improve the log and error handling to better track the errors you find during development. Sometimes it's challenging to see what's causing an issue, and tracking that on Talend is complicated."
"It needs better installation configuration for other databases. Although the installation allows you to select another database, this doesn't mean that all connection points in the application point to the database selected. You actually need to do a search through the entire install to locate the configuration settings and change them."
"There used to be many Youtube channels that offered Talend training, but now there don't seem to be any. The solution should offer more online training resources."
"Having additional training materials, such as a video tutorial, would be an improvement."
"It's stable, but it depends on the office and location."
"There are issues with certain Apple devices."