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."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"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."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"SSIS integrates well with SQL servers and Microsoft products."
"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."
"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 need help with large data migrations. It only works well for a few thousand records or less than a million records."
"Performance could be better."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"Tuning using this solution requires extensive expertise to improve performance."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"We'd like them to develop data exploration more."
"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."
"I would like to see more features in terms of the integration with Azure Data Factory."
"Generic processes should be used instead of custom code for each table."
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.