We performed a comparison between Actian Pervasive Data Integrator [EOL], Oracle Data Integrator (ODI), 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."There were no concerns with the stability. This product is very good from a stability perspective."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"The most valuable feature is Data movement."
"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."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing."
"Support is absolutely excellent, efficient, and timely."
"The tool supports multiple target update methods."
"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."
"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."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"I found the initial setup very easy."
"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)."
"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."
"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."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"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."
"It needs easier security."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"Technical Support could be better."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"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."
Earn 20 points
Earn 20 points