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

"Web based interface."

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

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

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

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

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

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

"Microsoft SQL Server Integration Services is one of the most effective ETL tools available in the market."

"SSIS integrates well with SQL servers and Microsoft products."

"The most valuable thing is that it is easy to connect with Microsoft tools."

"SSIS is easy to use."

"Overall, I think for what this solution does, it's pretty much all there."

"Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent."

"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."

"SSIS' best feature is SFTP connectivity."

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

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

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

"If you run SSIS from the local system, it will lag, but it will work properly if you host on the cloud somewhere."

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

"The solution could improve on integrating with other types of data sources."

"We've had issues in terms of the amount of data that is transferred when we are scheduling."

"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."

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

"I would like to see more features in terms of the integration with Azure Data Factory."

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

"The product is inexpensive and economical."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

"People have to opt for a perpetual-based licensing model."

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

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

"We have an enterprise license for this solution."

"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."