We performed a comparison between Oracle Data Integrator (ODI), Pentaho Data Integration and Analytics, and WhereScape RED based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The product has an ELT approach."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"It has the ability to easily load slowly changing dimensions."
"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."
"It has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient."
"I can create faster instructions than writing with SQL or code. Also, I am able to do some background control of the data process with this tool. Therefore, I use it as an ELT tool. I have a station area where I can work with all the information that I have in my production databases, then I can work with the data that I created."
"It has improved our data integration capabilities."
"Provides a good open source option."
"The amount of data that it loads and processes is good."
"We use Lumada’s ability to develop and deploy data pipeline templates once and reuse them. This is very important. When the entire pipeline is automated, we do not have any issues in respect to deployment of code or with code working in one environment but not working in another environment. We have saved a lot of time and effort from that perspective because it is easy to build ETL pipelines."
"It's my understanding that the product can scale."
"We're using the PDI and the repository function, and they give us the ability to easily generate reporting and output, and to access data. We also like the ability to schedule."
"Support is absolutely excellent, efficient, and timely."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Data transformations and rollups are easy to accomplish."
"I found the initial setup very easy."
"The tool supports multiple target update methods."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"The most valuable feature is the metadata generated code."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"The initial setup is a bit complex compared to other tools."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"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 stability of the software could be improved. Sometimes, the software just crashes. "
"Lumada could have more native connectors with other vendors, such as Google BigQuery, Microsoft OneDrive, Jira systems, and Facebook or Instagram. We would like to gather data from modern platforms using Lumada, which is a better approach. As a comparison, if you open Power BI to retrieve data, then you can get data from many vendors with cloud-native connectors, such as Azure, AWS, Google BigQuery, and Athena Redshift. Lumada should have more native connectors to help us and facilitate our job in gathering information from these new modern infrastructures and tools."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."
"I would like to see more improvements with AS400 DB2."
"It could be better integrated with programming languages, like Python and R. Right now, if I want to run a Python code on one of my ETLs, it is a bit difficult to do. It would be great if we have some modules where we could code directly in a Python language. We don't really have a way to run Python code natively."
"One thing that I don't like, just a little, is the backward compatibility."
"If you develop it on MacBook, it'll be quite a hassle."
"A big problem after deploying something that we do in Lumada is with Git. You get a binary file to do a code review. So, if you need to do a review, you have to take pictures of the screen to show each step. That is the biggest bug if you are using Git."
"I have been facing some difficulties when working with large datasets. It seems that when there is a large amount of data, I experience memory errors."
"Improve the object renaming ability (it works, but it could be more automated)."
"No support for change data capture or delta detection - that must be custom coded ."
"Technical support isn't the best."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Customization could be better."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Earn 20 points