We performed a comparison between Oracle Data Integrator (ODI), Oracle Integration Cloud Service, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It has the ability to easily load slowly changing dimensions."
"The CAEM is very useful in its modularity and portability."
"The product has an ELT approach."
"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 most valuable feature that we use is the Knowledge Modules."
"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."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"It is a scalable solution."
"The most valuable feature is the ease of customization."
"The initial setup is easy."
"The lack of features in something like Oracle Integration Cloud leaves some room for leads implementation partners like us"
"In general, there were a lot of great utilities for working with files."
"Oracle Integration Cloud Service offers a lot of adaptors."
"The Oracle integration tool is the most comfortable tool for using those Oracle products."
"Oracle Integration Cloud Service integrates well and is user-friendly. If you are not a developer or ops engineer you can still use the solution with ease. You do not need to have developers' knowledge, you can easily adapt and learn quickly to integrate the services. They have good documentation."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The most important features are it works well and provides self-service BI."
"The setup was easy. All Microsoft products are easy to set up."
"The solution is easy to use and developer friendly."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"It's saved time using visualization descriptions."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The initial setup of this solution is very straightforward."
"Stability could be improved because some operators have issues."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"The resource management aspect of the solution could be improved."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"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."
"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."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"The solution's customer service could be better."
"It would be helpful if there were more tutorials or documentation to learn about Oracle Integration Cloud Service."
"Configurable timeouts on each connection would be good."
"Sometimes, the tech support is slow to get back to us. We have had to wait up to two weeks for a response."
"Dealing with the large file size has occasionally been a challenge."
"The support and resources were lacking — they weren't there."
"If an inbound file is larger than one GB, it cannot be transformed within Oracle."
"Oracle-based automation blueprints for the majority of the integrations would be helpful to have in a future release."
"The solution could improve on integrating with other types of data sources."
"Improvement as per customer requirements."
"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."
"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."
"I would like to see better technical documentation because many times information is missing."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
More Oracle Integration Cloud Service Pricing and Cost Advice →