We performed a comparison between Informatica PowerExchange, Oracle Data Integrator (ODI), and Talend Open Studio based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The scalability is excellent."
"The most valuable feature is connectivity to data sources."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"The product’s flexibility is valuable."
"This product is easy to install and it can be done in a few hours."
"Provides a significant amount of control over the landscape and overall implementation."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"It has the ability to easily load slowly changing dimensions."
"It is an ETL tool, which does the extract, transform, and load."
"Oracle provides great documentation."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The most interesting aspect of the solution for us is that Talend Open Studio has a good balance between the features and the cost of the data management platform."
"Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement."
"This solution has improved our overall time to value for data ingestion."
"The most valuable features are the ETL tools."
"Talend Open Studio's installation process is easy. One just needs to install Java before installing the product"
"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."
"There are many architectures: hybrid, cloud, and on-prem."
"Talend Studio has the ability to use it to ensure data quality."
"The solution needs better integration with other tools."
"Technical support can be improved with respect to delays in ticket response time."
"Pushdown optimization could be improved."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"V10.2 is very stable, but we are still struggling to make V10.5 stable. We found services that were down, and PowerExchange stopped working."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"The connectivity with T24 core banking could be improved."
"Integration with the largest number of databases and other systems would be important."
"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."
"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."
"Reverse engineering is complicated and challenging to manage."
"The initial setup is complex, especially if you also have to install a console."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"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."
"Talend Open Studio is in Java language, and right now, you can only use the debug functionality in Java. I see that people who know programming languages other than Java currently face difficulties."
"It gets the job done but it's a bit slow."
"Talend Open Studio's interface does not provide a good experience...I would like to see better documentation and a more enhanced graphical interface in Talend Open Studio."
"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."
"he overall marketing and documentation of this product need to improve a lot."
"As for improvement or additional features, I would like to know how to use Java in Talend and also how to use Talend in the cloud or in big data. I would prefer to have storage directly on Talend."
"The server-side should be completely revamped."
"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."