We performed a comparison between Oracle Data Integrator (ODI) and Talend Open Studio based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"It is an ETL tool, which does the extract, transform, and load."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"It has the ability to easily load slowly changing dimensions."
"The initial setup is easy."
"The most valuable feature is Data movement."
"The most valuable feature that we use is the Knowledge Modules."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"There are many architectures: hybrid, cloud, and on-prem."
"The most valuable features are the ETL tools."
"We have contacted their technical support. They are great. They offer very professional help. If I need some technical answer, they are very professional. They are quick, professional, and very accurate."
"This solution has improved our overall time to value for data ingestion."
"The most valuable features are definitely data integration, data preparation, and data stewardship."
"Talend is safe to use because it is very restrictive. It is easy to use when one learns how to manipulate data with SQL."
"The solution's technical support is responsive and helpful."
"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."
"Technical Support could be better."
"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."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"The solution lacks some functions and features."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"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."
"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."
"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."
"Having additional training materials, such as a video tutorial, would be an improvement."
"The technical support and documentation need a lot of work to come up to standard."
"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 is not as visually appealing as some of the other tools."
"It is complicated to understand the configuration process for email components."
"The price for Talend Data Integration should be less expensive."
"The documentation is lacking within the product. They need to get better at all aspects of describing how it works and how to use it."
"The stability of the solution could improve when running jobs. There can be errors when running projects but in the end, it works well and the errors do not impact the result."
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews while Talend Open Studio is ranked 5th in Data Integration with 47 reviews. Oracle Data Integrator (ODI) is rated 8.2, while Talend Open Studio is rated 8.0. 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". On the other hand, the top reviewer of Talend Open Studio writes "An open-source ETL tool, when deployed on-premises, requiring an easy installation phase". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Azure Data Factory and IBM InfoSphere DataStage, whereas Talend Open Studio is most compared with SSIS, IBM InfoSphere DataStage, Talend Data Fabric, Talend Data Management Platform and Azure Data Factory. See our Oracle Data Integrator (ODI) vs. Talend Open Studio report.
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.