We performed a comparison between Oracle Data Integrator (ODI), Spring Cloud Data Flow, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."ODI's most valuable features are it utilizes the database engine and is very lightweight."
"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."
"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 product has an ELT approach."
"It's scalable."
"Besides loading data, we do most of our transformations in ODI."
"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."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"There are a lot of options in Spring Cloud. It's flexible in terms of how we can use it. It's a full infrastructure."
"The product is very user-friendly."
"The most valuable feature is real-time streaming."
"The most valuable features of Spring Cloud Data Flow are the simple programming model, integration, dependency Injection, and ability to do any injection. Additionally, auto-configuration is another important feature because we don't have to configure the database and or set up the boilerplate in the database in every project. The composability is good, we can create small workloads and compose them in any way we like."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"SSIS' most valuable feature is its reporting services."
"The solution is easy to use and developer friendly."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The simplicity of the solution is great. The solution also offers excellent integration."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The initial setup is complex, especially if you also have to install a console."
"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."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"If you have something like Cisco on top of it, you will have endless problems."
"The solution lacks some functions and features."
"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."
"It needs easier security."
"Some of the features, like the monitoring tools, are not very mature and are still evolving."
"Spring Cloud Data Flow could improve the user interface. We can drag and drop in the application for the configuration and settings, and deploy it right from the UI, without having to run a CI/CD pipeline. However, that does not work with Kubernetes, it only works when we are working with jars as the Spring Cloud Data Flow applications."
"The configurations could be better. Some configurations are a little bit time-consuming in terms of trying to understand using the Spring Cloud documentation."
"On the tool's online discussion forums, you may get stuck with an issue, making it an area where improvements are required."
"Tuning using this solution requires extensive expertise to improve performance."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"The solution could improve on integrating with other types of data 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."
"This solution needs full support for real-time processing."
"Performance could be better."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"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."