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."Besides loading data, we do most of our transformations in ODI."
"The CAEM is very useful in its modularity and portability."
"It's completely user-friendly."
"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."
"The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"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."
"The data reader is the most valuable feature."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The interface is very user-friendly."
"We can connect with multiple data sources easily using an external connector in SSIS."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The initial setup was easy."
"The solution is stable."
"Naturally produces a way to easily debug your DW data solutions."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"Support is absolutely excellent, efficient, and timely."
"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."
"The tool supports multiple target update methods."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"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."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"The stability of the software could be improved. Sometimes, the software just crashes. "
"The initial setup is a bit complex compared to other tools."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"The price needs to be lowered. It's too expensive."
"The initial setup is complex, especially if you also have to install a console."
"The performance of SSIS could improve when comparing it to Oracle Database."
"The performance of this solution is not as good as other tools in the market."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"I would like to see better integration with Power BI."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"I would like to see better technical documentation because many times information is missing."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"Performance could be better."
"Technical support isn't the best."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"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."
"Customization could be better."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"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."
"No support for change data capture or delta detection - that must be custom coded ."
Earn 20 points