We performed a comparison between Actian Pervasive Data Integrator [EOL], Dataloader.io, and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."There were no concerns with the stability. This product is very good from a stability perspective."
"he product’s most valuable feature is ease of access."
"It has the ability to easily load slowly changing dimensions."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The most valuable feature that we use is the Knowledge Modules."
"It's scalable."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"The installation of the client ODI Studio is easy."
"It's completely user-friendly."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"We need help with large data migrations. It only works well for a few thousand records or less than a million records."
"The performance of the user interface is in need of improvement."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"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."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The initial setup is complex, especially if you also have to install a console."
Earn 20 points