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 like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"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."
"The CAEM is very useful in its modularity and portability."
"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 initial setup is easy."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The product's most valuable features are data validation and rules."
"Data Services' best features are its robustness and plug-and-play integration with other SAP applications."
"The most valuable feature is the logging capability."
"The maintenance of data services is the solution's most valuable feature."
"It is a powerful product with a broad range of features."
"We can extract data at a table level, extract data at the ETL level, and we can extract data at an ODP level."
"The most valuable feature is the ETL functionality."
"It's easy to understand and deploy. It's easy to create new applications, and depending on the complexity of the application, it is easy to deploy the new requirements."
"Overall, it's a good product."
"SSIS' most valuable feature is its reporting services."
"The product's deployment phase is easy."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"The setup is straightforward. It's very easy to install."
"SSIS is easy to use."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"We used a third party to do the implementation of ODI."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"Technical Support could be better."
"Reverse engineering is complicated and challenging to manage."
"The resource management aspect of the solution could be improved."
"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."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The solution should offer more machine learning and automation."
"The skillset of data engineers matters a bit to use all the functionality of this solution. Otherwise, the delivery speed won't be faster."
"It will work fine only in an SAP environment. It could be said that the integration with other vendors could be better."
"Integration with other products could be improved."
"It's an ETL that is very good with relational databases but not as good with files and semi-structured files."
"Scheduling of jobs in the sequence is not available. It's a very tedious process to do that particular task. If there was a tool to schedule in the sequence that would be extremely helpful."
"The initial setup is complex."
"An area for improvement in SAP Data Services could involve making the product more accessible to non-technical end-users."
"Options for scaling could be improved."
"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."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"The high prices attached to the product can be an area of concern where improvements are required."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"The solution could improve by having quicker release updates."
"The solution could improve on integrating with other types of data sources."
"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."