Actian Pervasive Data Integrator [EOL] vs Dataloader.io vs SSIS comparison

"We have been using it for ETL, it is very robust and easy to use."

"There were no concerns with the stability; this product is very good from a stability perspective."

"There were no concerns with the stability. This product is very good from a stability perspective."

"This product is extremely useful and better than building an in-house solution."

"Web based interface."

"For data transfers and ETLs on Windows, this is a great product."

"DataLoader is cost-effective since it is free."

"he product’s most valuable feature is ease of access."

"I find DataLoader's ability to easily integrate with external keys valuable, which is a bit more challenging with DBM."

"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."

"It is well designed and quite straightforward, with not much of a learning curve involved, and it is a well-documented solution."

"The most valuable feature of SSIS is that it can handle real complex transformations."

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."

"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."

"The data reader is the most valuable feature."

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"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)."

"The areas which I think need to be improved are the transform and load steps."

"Technical support is an area which can definitely improve."

"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)."

"At the moment, we can't even use it for 1, since it keeps failing in our QA testing."

"We need help with large data migrations. It only works well for a few thousand records or less than a million records."

"DataLoader has limitations, including constraints with file sizes and transactions."

"Dataloader has limitations, including constraints with file sizes and transactions. Additionally, at times it can be slow, and when integrating DBM, we find it more complex than Dataloader."

"We have issues with SSIS connectors while extracting data from Excel sources."

"The solution could improve by having quicker release updates."

"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically."

"SSIS is not that scalable. You can scale it vertically to handle a high load, but it lacks horizontal scalability."

"The performance of SSIS could improve when comparing it to Oracle Database."

"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."

"We'd like them to develop data exploration more."

"This solution is stable, but the performance is not good."

"The product is inexpensive and economical."

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

"SSIS' licensing is a little high, but it gives good value for money."

"SSIS is a cheaper option compared to the cost of other ETL tools."

"All of my clients have this product included as part of their Microsoft license."

"It would be beneficial if the solution had a less costly cloud offering."

"The solution comes free of cost."

"We have an enterprise license for this solution."

"This solution is included with the MSSQL server package."