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."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The data reader is the most valuable feature."
"SSIS' best feature is SFTP connectivity."
"The initial setup of this solution is very straightforward."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"We need help with large data migrations. It only works well for a few thousand records or less than a million records."
"The high prices attached to the product can be an area of concern where improvements are required."
"We have issues with SSIS connectors while extracting data from Excel sources."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"This solution needs full support for real-time processing."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
Dataloader.io is ranked 40th in Data Integration with 1 review while SSIS is ranked 2nd in Data Integration with 69 reviews. Dataloader.io is rated 8.0, while SSIS is rated 7.6. 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 BMC Data Management for IMS and DB2 on zOS, DBamp and Mule Anypoint Platform, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) 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.