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."Fivetran can perform data migration incredibly fast, depending on the source and target."
"The most important feature of the solution is its ability to build data pipelines in less time."
"The solution is stable. We've never faced any stability issues."
"The product has some seamless connectors, which are readily available."
"The compare feature is the most valuable piece of it."
"It is not like a traditional ETL, but it gives quite a lot of flexibility."
"For us, Fivetran has been able to scale both in terms of the data we bring into our warehouse and the amount of data that we use as well."
"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."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"It's a competent product."
"The most important features are it works well and provides self-service BI."
"SSIS' best feature is SFTP connectivity."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"It's already very user-friendly and has a good dashboard."
"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."
"The interface needs to be more user-friendly."
"It should have a few more monitoring functionalities."
"The documentation can be laid out better to make it easier to find things, and I really wish there was built-in support for changing passwords. Some features don't work as advertised for the platform/repository database, and HVR is not always the fastest at getting results."
"I would like Fivetran to implement additional resource monitoring and restriction policies."
"Fivetran should add more connectors because its competitors, like Airbyte, have more connectors."
"The documentation is decent, but it's hard to find information online about Fivetran. For example, if you try to search for an error code, you won't find much information about it in forums."
"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."
"Options for scaling could be improved."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"The creation of the measure in the DAC's model could be improved."
"The performance of SSIS could improve when comparing it to Oracle Database."
"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."
"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 19 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.