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 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's scalable."
"The product has an ELT approach."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"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."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"The scalability is great. It's one of the reasons we chose the solution."
"The solution's technical support is responsive and helpful."
"The rapidity of integration with data may be one of the valuable features."
"I didn't have many problems installing it. It seemed very straightforward to me."
"The product is easy to install and configure. It is one of the best tools for data integration."
"The most valuable features of Talend Open Studio are customization and integration."
"The initial setup of the product was very easy."
"The standout feature for me is the user-friendly nature of the components."
"Talend Studio has the ability to use it to ensure data quality."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"The initial setup is complex, especially if you also have to install a console."
"Stability could be improved because some operators have issues."
"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 initial setup is a bit complex compared to other tools."
"The price needs to be lowered. It's too expensive."
"We used a third party to do the implementation of ODI."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"The price for Talend Data Integration should be less expensive."
"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 profiling perspective needs improvement. Instead of using it in the studio, we are using a different tool which is also provided by Talend. It's redundant."
"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."
"It doesn't have the ability to keep the repository of the source code (visual pipeline). It can be integrated with Git."
"In the next release, Open Studio should include cloud storage as an input."
"We don't get continuous replication of the data."
"Technical support and customer service need to be improved."
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.