We performed a comparison between 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."he product’s most valuable feature is ease of access."
"The initial setup of this solution is very straightforward."
"It is easy to set up the product."
"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."
"SSIS is easy to use."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The performance is good."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"We need help with large data migrations. It only works well for a few thousand records or less than a million records."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"The solution could improve on integrating with other types of data sources."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
Dataloader.io is ranked 36th in Data Integration with 1 review while SSIS is ranked 2nd in Data Integration with 68 reviews. Dataloader.io is rated 8.0, while SSIS is rated 7.8. The top reviewer of Dataloader.io writes "Provides an ease of access and an automated mapping feature". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Dataloader.io is most compared with DBamp, Mule Anypoint Platform and AWS AppSync, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and AWS Glue.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.