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."In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"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."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"OIC offers a number of pre-built technology and SaaS adapters for high productivity for a wide range of target systems, both in-house via agents and cloud/SaaS, via a very flexible range of interfaces."
"It's easy to build an integration and make changes to it."
"It is a scalable solution."
"The most valuable feature is the ease of customization."
"The out-of-box integration between Oracle and SAP is really beneficial"
"The most valuable feature of Oracle Integration Cloud Service is its performance."
"The most valuable feature of Oracle Integration Cloud Service is its ease of use. We do not depend on any tool to develop it. Everything is on the browser and is easy to integrate, even for someone who does not understand a lot about coding."
"The most valuable features of this solution are the SFTP adapters, file adapters, and risk adapters, that we use in everyday projects."
"The scalability of SSIS is good."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"It's a competent product."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"SSIS integrates well with SQL servers and Microsoft products."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"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."
"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."
"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."
"We used a third party to do the implementation of ODI."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"The initial setup is a bit complex compared to other tools."
"It needs easier security."
"Technical Support could be better."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"It has lengthy documentation, making the process of building applications more time-consuming."
"The solution's customer service could be better."
"The logging capabilities could be enhanced. Currently, logs are only retained for a few days, which can be inconvenient for administrators. Ideally, we'd like the option to configure log retention periods, like a month or fifteen days, instead of the current one-week limit."
"They should provide tutorials for beginners to learn about the processes."
"The solution doesn't currently have a fully fledged workflow feature like they have in OIM."
"Lacks features for more complex integrations."
"The support and resources were lacking — they weren't there."
"The error retrying mechanism could be improved. If an error occurs, it can be retried automatically, it would be helpful."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"At one point, we did have to purchase an add-on."
"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."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"I would like to see better technical documentation because many times information is missing."
More Oracle Integration Cloud Service Pricing and Cost Advice →