We performed a comparison between Actian Pervasive Data Integrator [EOL], Denodo, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."There were no concerns with the stability. This product is very good from a stability perspective."
"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."
"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 is lightweight in terms of how it leads you to combine your discrete data systems at one spot."
"Overall, the product works quite well and has a good set of features."
"The most valuable feature is Data Catalogs."
"In general, it's good for us to make tests so we can scout the data."
"The most valuable aspects of this solution are the short time frame in which you can deliver and connect."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"We can connect with multiple data sources easily using an external connector in SSIS."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The solution is easy to use and developer friendly."
"It's a competent product."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"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."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"I would like to see a proper way to avoid killing the sourcing systems."
"We can't scale it to meet digital requirements."
"Monitoring event logs can be improved. In the older version, there was a monitoring schedule to get event reports and properly audit the reports. In the newer version, it is not there, and we have to manually configure data and audit events."
"There are a couple of areas that can be improved in Denodo. From a stability point of view, sometimes we see issues in the data management functionality. This only happens now and then, however, and usually takes place when we add in our own customization."
"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 support is not the best and should be improved."
"Lacks integrations with AWS, GCP and the like."
"The solution should have its own acceleration technology."
"The security could be improved, as it is more important in our context."
"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."
"I would like to see more features in terms of the integration with Azure Data Factory."
"At one point, we did have to purchase an add-on."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"Options for scaling could be improved."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
Earn 20 points