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."The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"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."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"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 product has an ELT approach."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"Besides loading data, we do most of our transformations in ODI."
"SSIS is easy to use."
"We can connect with multiple data sources easily using an external connector in SSIS."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The initial setup of this solution is very straightforward."
"It is easy to set up the product."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"Overall, it's a good product."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"Support is absolutely excellent, efficient, and timely."
"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."
"The tool supports multiple target update methods."
"Data transformations and rollups are easy to accomplish."
"Naturally produces a way to easily debug your DW data solutions."
"It has a built-in automatic scheduling environment."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"I like the data vault implementations."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"We used a third party to do the implementation of ODI."
"Technical Support could be better."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"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."
"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."
"The resource management aspect of the solution could be improved."
"The performance of the user interface is in need of improvement."
"Performance could be better."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"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."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"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."
"It hangs a lot of the time."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"Improve the object renaming ability (it works, but it could be more automated)."
"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."
"Customization could be better."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"No support for change data capture or delta detection - that must be custom coded ."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
Earn 20 points
