We performed a comparison between Actian Pervasive Data Integrator [EOL], Dataloader.io, 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."
"he product’s most valuable feature is ease of access."
"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."
"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."
"SSIS integrates well with SQL servers and Microsoft products."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The setup was easy. All Microsoft products are easy to set up."
"The data reader is the most valuable feature."
"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)."
"We need help with large data migrations. It only works well for a few thousand records or less than a million records."
"The security could be improved, as it is more important in our context."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"The performance of this solution is not as good as other tools in the market."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"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."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
Earn 20 points