We performed a comparison between Oracle Data Integrator (ODI), SAP Data Services, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"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."
"It's scalable."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"Besides loading data, we do most of our transformations in ODI."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"The product has an ELT approach."
"The most valuable feature is the ETL functionality."
"The solution offers very good integration capabilities."
"Technical support from SAP is awesome. If we have an issue, they give a good solution."
"We can extract data at a table level, extract data at the ETL level, and we can extract data at an ODP level."
"It is a powerful product with a broad range of features."
"Data Services' best features are its robustness and plug-and-play integration with other SAP applications."
"I have worked with Data Services for a long time, and currently, I find the dashboarding and reporting part to be the most valuable function."
"You can always manipulate a lot of things as long as you have the skill level."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"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 main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The scalability of SSIS is good."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"The price needs to be lowered. It's too expensive."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"It needs easier security."
"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."
"Technical Support could be better."
"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."
"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."
"We would like the different tools offered within this solution to be available as standalone entities, rather than having to purchase the entire package when we only require a few features."
"They could make it easier to work with web services."
"It would be nice if this solution was a bit easier to move from development to production."
"In the future, Data Services should offer a cloud version."
"The execution engines and processing engines have shortcomings and need improvements."
"I want some more business intelligence applications. People need to know more and more about data, including the transformation rules, etc. Informatica is a better product for data cataloging. SAP should update the data catalog."
"There needs to be multi-language support, however, my understanding is they are working on multi-language now."
"With SAP Data Services, the problem arises when I try to connect to Azure Databricks."
"Video training would be a helpful addition."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"I would like to see better integration with Power BI."
"It needs more integration tools, so you can connect to different sources."
"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."
"Performance could be better."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"The security could be improved, as it is more important in our context."