We performed a comparison between Oracle Data Integrator (ODI), SAS Data Integration 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."ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"The most valuable feature is Data movement."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"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."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"It is an ETL tool, which does the extract, transform, and load."
"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."
"The solution is very stable."
"The solution offers very good data manipulation and loading."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"It's a competent product."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"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."
"We can connect with multiple data sources easily using an external connector in SSIS."
"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."
"It is easy to set up the solution."
"The resource management aspect of the solution could be improved."
"We used a third party to do the implementation of ODI."
"Reverse engineering is complicated and challenging to manage."
"The initial setup is complex, especially if you also have to install a console."
"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."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"The price needs to be lowered. It's too expensive."
"The transform tool has limited access. They should make it more flexible."
"So I would like to see improved integration with other software."
"The initial setup of SAS Data Integration Server was complex."
"We'd like more integration capabilities."
"The solution could improve on integrating with other types of data sources."
"At one point, we did have to purchase an add-on."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"The high prices attached to the product can be an area of concern where improvements are required."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"It's a legacy tool, that is nearing the end of its useful life."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."