We performed a comparison between Oracle Data Integrator (ODI), SSIS, 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."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."
"The most valuable feature is Data movement."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"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."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"It is an ETL tool, which does the extract, transform, and load."
"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."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"The initial setup was easy."
"It is easy to set up the solution."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"It's saved time using visualization descriptions."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The data reader is the most valuable feature."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"Support is absolutely excellent, efficient, and timely."
"Data transformations and rollups are easy to accomplish."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"It has a built-in automatic scheduling environment."
"I found the initial setup very easy."
"The resource management aspect of the solution could be improved."
"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."
"If you have something like Cisco on top of it, you will have endless problems."
"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 performance of the user interface is in need of improvement."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"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."
"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."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"Generic processes should be used instead of custom code for each table."
"We have issues with SSIS connectors while extracting data from Excel sources."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"No support for change data capture or delta detection - that must be custom coded ."
"Improve the object renaming ability (it works, but it could be more automated)."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Technical support isn't the best."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
Earn 20 points