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."It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"Besides loading data, we do most of our transformations in ODI."
"It has the ability to easily load slowly changing dimensions."
"The product has an ELT approach."
"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."
"The initial setup is easy."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"The most valuable feature that we use is the Knowledge Modules."
"Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement."
"We're sold on the customization part of the solution."
"This solution has improved our overall time to value for data ingestion."
"The drag-and-drop feature in the interface is very good."
"It's a good tool. It has the ability to take apart and install whatever we need. It's very good for data, transformation, and loading."
"Talend Studio has the ability to use it to ensure data quality."
"Talend lets you do everything — mapping, workflow, and orchestration — in a single place."
"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."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"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 initial setup is a bit complex compared to other tools."
"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."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"Technical support and customer service need to be improved."
"In terms of what can be improved, the scheduling is not there in the sister version, while it is there in the cloud one, which is a paid version. If all kinds of scheduling could be available on the Open Studio that we generally use and practice on, that would be great. The scheduling of the data migration is currently not available in the sister version of Talend Open Studio that we are working on. It is available in the advanced version of the Talend. This is the one thing that can be improvised."
"Talent consumes a lot of resources on my PC."
"I would say that writing to JSON is kind of a pain. It reads from a JSON file pretty well, but writing to a JSON file is not so great because its components are not good."
"When faced with a challenge, such as the necessity to link up with an unconventional data source like the legacy Cyprus Vision database that wasn't inherently supported by Talend, I had to resort to writing Python code to establish the connection."
"The solution should offer better integration with other products."
"In version 6.2 we did encounter issues with the job servers and specifically with ESB. Version 6.3 is better but large jobs can cause the MDM server to fall over, requiring a reboot."
"The price for Talend Data Integration should be less expensive."
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, SSIS, Informatica PowerCenter, Azure Data Factory and AWS Glue, whereas Talend Open Studio is most compared with SSIS, IBM InfoSphere DataStage, Talend Data Fabric, AWS Glue and Informatica PowerCenter. 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.