We performed a comparison between Oracle Data Integrator (ODI), SAP Data Services, 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 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 most valuable feature that we use is the Knowledge Modules."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"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."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The user interface is ok."
"The most valuable feature of SAP Data Services is the integration with data sources."
"I like how SAP Data Services links reporting and data integration. That's what's most interesting. You also have the opportunity to leverage the power of the Data Services server."
"Data Services' best features are its robustness and plug-and-play integration with other SAP applications."
"The solution is easy to use since it's a graphical tool. It also requires only low-level coding."
"The maintenance of data services is the solution's most valuable feature."
"It is a powerful product with a broad range of features."
"The BA reporting tools, such as Data Services, and ETL tool in SAP Data Services are the most valuable. When we had in-memory requirements, we used HANA. HANA is most preferably for most the customers for in-memory. SAP is the first company that created the in-memory concept."
"It has a built-in automatic scheduling environment."
"I like the data vault implementations."
"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 most valuable feature is the metadata generated code."
"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."
"The tool supports multiple target update methods."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"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."
"The resource management aspect of the solution could be improved."
"We used a third party to do the implementation of ODI."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"If you have something like Cisco on top of it, you will have endless problems."
"Scheduling of jobs in the sequence is not available. It's a very tedious process to do that particular task. If there was a tool to schedule in the sequence that would be extremely helpful."
"The interface is not quite user-friendly and is in need of improvement."
"The execution engines and processing engines have shortcomings and need improvements."
"It would be nice if this solution was a bit easier to move from development to production."
"It's an ETL that is very good with relational databases but not as good with files and semi-structured files."
"Data Services SAP is lacking in sources and target databases compared to Informatica. SAP Data Services should have more connectivity."
"We encounter challenges while exporting implemented rules, such as those applied to objects like the material master, into a format like Excel for documentation and further analysis."
"The solution should offer more machine learning and automation."
"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)."
"Customization 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."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"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."
"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."
Earn 20 points