We performed a comparison between Oracle Data Integrator (ODI), SAP Replication Server, 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 is an ETL tool, which does the extract, transform, and load."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"It's completely user-friendly."
"The initial setup is easy."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"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 feature of ODI is the to use of the whole ETL to create a data lake."
"The most valuable feature is Data movement."
"It speeds up the performance in terms of how fast you are able to access the data, look at it, get it reported to you, and send it to somebody. It also reduces the amount of storage."
"We can customize any workflow and we also like the business domain modeling that can be done."
"SAP Replication Server is an application that I consider to be a robust system. It has proven to be highly reliable in my experience."
"SAP is renovating different things. We are using external tools to connect as of now. It is going well, and now the new generation integration platforms are going to be pretty easy."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"SSIS' best feature is SFTP connectivity."
"The simplicity of the solution is great. The solution also offers excellent integration."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"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."
"It's already very user-friendly and has a good dashboard."
"Reverse engineering is complicated and challenging to manage."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"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."
"If you have something like Cisco on top of it, you will have endless problems."
"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 the ease of use. There is a steep learning curve to use the solution."
"It needs easier security."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"The private solution is expensive. If you're in a situation where you're paying IBM or AWS or somebody just to host you specifically, you're paying people to run it and you're taking care of all the upgrades."
"I would like to see it become mobile-friendly."
"Improvement is a never ending story, and HANA is doing some improvements. We are able to adopt that, and we have to do it by integration with HANA. They are very major changes that we need to see."
"There is room for improvement in terms of pricing and faster support."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"The solution could improve on integrating with other types of data sources."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"The solution could improve by having quicker release updates."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"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."
