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."
"The ability to transfer data is very valuable."
"The best thing about Denodo is that creating and deploying a web service can be done in about 10 minutes, compared to a whole day when it comes to other solutions (such as when deploying with Java and AWS)."
"In PL/SQL, first you need to gather all the data and then start writing the file, but in Denodo you fetch the data and write the data simultaneously. So, for example, if you have 1 million or 2 million records, you don't have to wait to fetch all of the 2 million; you can keep on fetching and writing in the file simultaneously."
"The ability to connect to a lot of different sources."
"Overall, the product works quite well and has a good set of features."
"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."
"It is a very stable solution."
"The most valuable features are data lineage and the concept of a semantic layer."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"SSIS' best feature is SFTP connectivity."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"It has good data integration and good processes."
"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."
"The solution is slow when there are many virtualization layers."
"The integration could use improvement, it's a lot of non-speed line processes that we have discovered, in the country. The configurations could use a lot more improvement."
"It would be good if the solution provided a much-needed cellular platform."
"Denodo's training documentation could be improved by providing more material. From an administrative standpoint, I've found that only Denodo websites provide the usual tutorials. It may be because it's a bit of a restricted tool, but it results in trouble with learning. Normally, I can find help and solutions from other sources, but I haven't been able to find any for Denodo. Other that, it's fine and it performs well. I only have six months of experience, so I can't accurately suggest improvements."
"I would like it if we could pull the data model or export the data model because Denodo has, based on how you build, something called associations. The data model gets very confusing when you go look at it. It depends on how you define it, but it's really huge. I wish there was a way to export it into Visio. It could be that they already have a way to do it, and I don't know, but it would be much easier for the architects and even for the developers to look at it than scrunching it into the screen and expanding every small portion of it. If there was an easy way to export the Denodo model into another modeling tool and view it, it would be great."
"The solution should have its own acceleration technology."
"Lacks integrations with AWS, GCP and the like."
"It needs more integration tools, so you can connect to different sources."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"It hangs a lot of the time."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"It's a legacy tool, that is nearing the end of its useful life."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
Earn 20 points