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 is a very accessible tool, especially since the mapping functionality has been added."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"The installation of the client ODI Studio is easy."
"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 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 CAEM is very useful in its modularity and portability."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"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 product is very user-friendly."
"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."
"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."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"The performance is good."
"SSIS' best feature is SFTP connectivity."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"It needs easier security."
"The resource management aspect of the solution could be improved."
"The price needs to be lowered. It's too expensive."
"We used a third party to do the implementation of ODI."
"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."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"Technical Support could be better."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"The configurations could be better. Some configurations are a little bit time-consuming in terms of trying to understand using the Spring Cloud documentation."
"Some of the features, like the monitoring tools, are not very mature and are still evolving."
"On the tool's online discussion forums, you may get stuck with an issue, making it an area where improvements are required."
"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."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"The creation of the measure in the DAC's model could be improved."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"We'd like more integration capabilities."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"Tuning using this solution requires extensive expertise to improve performance."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."