We performed a comparison between Denodo and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The ability to connect to a lot of different sources."
"Overall, the product works quite well and has a good set of features."
"Denodo's best features are its performance, easy data transformation, and the job scheduler."
"One thing that we have noticed is that when you have a BI tool, you end up building a lot of the logic in the BI tool, but as a company, every company wants to be tool agnostic because today, you could be in the Qlik Sense, and tomorrow, you may decide to go with Tableau or something else that is there. If you have put a lot of logic within the tool, transitioning or moving away from one BI tool to another tool becomes a very intensive process. By keeping the logic in Denodo, you can move to any tool."
"The most valuable feature is the performance. Denodo is very useful, especially in this huge pharma environment. I've found that older SAP solutions were very tightly coupled to each other, which resulted in data restrictions. Getting data from different sources was tough and tedious. Compared to these old solutions, Denodo is very easy to work with for the analytical team. Now that we've implemented this virtualization layer, we are capable of getting the data very smoothly. We implemented a very small unit, but the performance and integration have been very good."
"Access to numerous forums and internet information."
"The most valuable feature is Data Catalogs."
"The data abstraction is the most valuable feature."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The performance is good."
"It has good data integration and good processes."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The solution is easy to use and developer friendly."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"The setup was easy. All Microsoft products are easy to set up."
"Denodo has some difficulty supporting large numbers of records."
"We would like this solution to be more universally user-friendly. At present it is really only aimed at IT specialists."
"It would be good if the solution provided a much-needed cellular platform."
"We can't scale it to meet digital requirements."
"Tasks such as conversion of a date format or conversion of a number format that can be done in a very easy way in different languages, like SQL or Oracle, are not so easy to do in Denodo. For example, if you want to convert a date from one format to another, in Oracle it's pretty easy; in Denodo, however, it requires so many lines of code. Simple things that can be done very quickly in other database languages require more lines of code in Denodo."
"The support is not the best and should be improved."
"Lacks integrations with AWS, GCP and the like."
"Denodo can improve usage management-related aspects. If you deal with the mini views, it gets stuck. The performance is very slow when we go with a large number of views and high volume."
"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."
"The performance of SSIS could improve when comparing it to Oracle Database."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"The solution could improve on integrating with other types of data sources."
"It would be nice if you could run SSIS on other environments besides Windows."
"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."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
Denodo is ranked 12th in Data Integration with 29 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Denodo is rated 7.8, while SSIS is rated 7.6. The top reviewer of Denodo writes "Saves our underwriters' time with data virtualization, but could provide more learning resources". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Denodo is most compared with Azure Data Factory, AWS Glue, Delphix, Mule Anypoint Platform and Alteryx Designer, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our Denodo vs. SSIS report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
