We performed a comparison between Denodo, Informatica PowerCenter, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The data abstraction is the most valuable feature."
"Denodo is lightweight in terms of how it leads you to combine your discrete data systems at one spot."
"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."
"Denodo makes it easy to export data as a service or data link to other services."
"It is a go-to tool for data virtualization. The virtualization and data catalog are the features of why we chose Denodo."
"Data mining is one of the valuable features. We're able to connect all of the data sources with the installed driver, so that is a good advantage in Denodo. Being able to join the tables and view them is also valuable."
"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 ability to transfer data is very valuable."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"The solution is stable."
"Once you have learned Informatica, it is very easy to use."
"The most valuable features are the monitoring tools and the reporting manager."
"I like the automated scheduling feature."
"It's very easy to use it to develop mappings and workflows."
"Good product if you are trying implement data quality, data integration, and data management projects."
"PowerCenter performs well during data transformation and optimization."
"It's a competent product."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"SSIS integrates well with SQL servers and Microsoft products."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The initial setup was easy."
"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 script component is very powerful, things that you cannot normally do, is feasible through C#."
"It is easy to set up the solution."
"Denodo has some difficulty supporting large numbers of records."
"Lacks integrations with AWS, GCP and the like."
"It would be beneficial to make sure that the team that will be using Denodo has some kind of training on how to use the product at least a month beforehand, and there could even be some kind of feedback or Q&A sessions to go along with the training. If Denodo were able to provide this kind of training, it would be very helpful to users in insurance and banking companies because the staff are typically older and not always technically-minded."
"The solution is slow when there are many virtualization layers."
"The solution should have its own acceleration technology."
"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 dropdown menus feel antiquated to me, and the administrative portals need improvement."
"We occasionally have some integration issues that we need to work through."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"The initial setup is not straightforward. You need expertise to do it."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"Support could be better."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"At one point, we did have to purchase an add-on."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"Future releases should improve the data lineage, as it currently is not good."
"The solution could improve by having quicker release updates."
"Tuning using this solution requires extensive expertise to improve performance."
"I would like to see better integration with Power BI."