We performed a comparison between Fivetran and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The general data ingestion is valuable. It's used for a lot of data. It provides about 90% of the data we use in our data warehouse without needing data engineering."
"You can manage all of your connectors individually, which gives you a very good ability to trace which one of your ETL processes is running and when."
"Fivetran is remarkably easy to use; I haven't encountered any other data integration tool that is as user-friendly."
"Making the decision to implement Fivetran was supported by the fact that they have better connectors than other competitors."
"The product is very easy to use and very easy to configure."
"The product has some seamless connectors, which are readily available."
"Its arrays are powerful enough to handle migrations even when the replication is happening in the background, without causing any trouble with the ongoing traffic."
"The compare feature is the most valuable piece of it."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"The initial setup of this solution is very straightforward."
"The interface is very user-friendly."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The product's deployment phase is easy."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"More connectors are needed for exotic, popular, and rising star portals."
"The customization could improve because Fivetran gives more thought to people who don't want to manage analytics workflows rather than engineers who want to be able to customize pipelines more thoroughly."
"Some of the pain points we're looking at are trying to integrate some of the items in the Microsoft stack, so SharePoint and Excel, and then some of the newer Azure services."
"HVR Software's technical support could be improved. Whenever we log a case, the response that we get from the support is a bit delayed."
"I would like Fivetran to implement additional resource monitoring and restriction policies."
"Fivetran is very expensive for data sources with a lot of rows, such as email data. I would like to see cheaper pricing for data sources like that."
"The solution is very expensive. I would like to have a better integration of the solution with Azure."
"There was a random change to our contract in a unilateral manner after the first year. The overall cost of using Fivetran was then unclear and this is the reason I would not recommend this solution."
"The performance of this solution is not as good as other tools in the market."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"Performance could be better."
"The solution could improve on integrating with other types of data sources."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"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."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
Fivetran is ranked 13th in Data Integration with 20 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Fivetran is rated 8.0, while SSIS is rated 7.6. The top reviewer of Fivetran writes "Solution reduces time-to-value; high ROI". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Fivetran is most compared with AWS Database Migration Service, Qlik Replicate, Azure Data Factory, Oracle GoldenGate and Matillion ETL, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our Fivetran vs. SSIS report.
See our list of best Data Integration vendors and best Cloud 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.