Try our new research platform with insights from 80,000+ expert users

Fivetran vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Fivetran
Ranking in Data Integration
13th
Average Rating
8.0
Number of Reviews
24
Ranking in other categories
Data Replication (3rd), Cloud Data Integration (6th)
SSIS
Ranking in Data Integration
4th
Average Rating
7.8
Number of Reviews
71
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of Fivetran is 2.2%, up from 2.0% compared to the previous year. The mindshare of SSIS is 8.6%, down from 9.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Erik Jones - PeerSpot reviewer
Nov 14, 2022
Solution reduces time-to-value; high ROI
Fivetran has room for improvement in data pipeline observability. The Fivetran logs are fairly basic, compared to, for example, the insight Fivetran gives into helping users understanding the performance of data pipelines. So I think their observability into the pipeline itself could be improved. In addition, Fivetran is in the very early stages of allowing other companies to access its metadata API, but that's something that could use improvement, and I know that they're working on right now. We use a separate tool for "reverse ETL", which is the opposite of what Fivetran does; it pushes data from your data warehouse back out to business applications. If Fivetran pulls data from those same applications, they should also enable users to push it back. I would love to do both ETL and reverse ETL in the same tool. It would be nice if Fivetran offered both their regular offering plus the reverse ETL option as well.
Sakiru Dosumu - PeerSpot reviewer
Mar 1, 2024
Its ability to transform and transport data is extremely valuable
We use SSIS for data extraction, transformation, and loading processes. This includes extracting data from various sources like Oracle and SQL Server, and then transforming it for use in reporting tools like Power BI dashboards. While we haven't directly migrated data between databases using SSIS…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"It is not like a traditional ETL, but it gives quite a lot of flexibility."
"Making the decision to implement Fivetran was supported by the fact that they have better connectors than other competitors."
"Fivetran is remarkably easy to use; I haven't encountered any other data integration tool that is as user-friendly."
"The most important feature of the solution is its ability to build data pipelines in less time."
"The product is very easy to use and very easy to configure."
"There's the general feature of the platform where it just makes it very easy to integrate different things, but I would say a specific difference is their integration of DBT,."
"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."
"SysTrack load is the best feature."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"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 technical support is very good."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"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."
 

Cons

"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."
"Fivetran should add more connectors because its competitors, like Airbyte, have more connectors."
"The environment must be more development-friendly."
"The interface needs to be more user-friendly."
"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."
"Fivetran would be improved by adding the ability to integrate the data from third-party APIs."
"The biggest area for improvement is in customization, particularly in how Fivetran socializes its tools."
"An in-line data quality checking capability is missing"
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"Integration and the user interface are areas with certain shortcomings that require some improvements."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"It needs more integration tools, so you can connect to different sources."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
 

Pricing and Cost Advice

"The licensing costs are extremely high for the usage of somebody who has one GB or two GB of usage per day for real-time traffic. There are many other players in the market which are similarly priced or competitively priced. On average per month, it used to come around 12,000-15,000 USD, which is very high."
"The pricing model is okay and mid to large companies will not have an issue with it."
"I would say they're a little bit on the expensive side, and their contract process is not particularly good, but there is a lot of potential flexibility."
"When you have a lot of workflows and complex use cases, pricing goes down as you use it more."
"Fivetran is very expensive, and its database-driven pricing model is outdated."
"I don't have the exact information, but I know it is high, and it is on a yearly basis. There is no additional cost for what we're doing. We're always open to doing things cheaper, so we might potentially implement a different solution."
"I rate the pricing a six out of ten."
"The solution is affordable."
"The solution is available at a lesser price than that of Informatica."
"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."
"Our license with SSIS is annual."
"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."
"All of my clients have this product included as part of their Microsoft license."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"We have an enterprise license for this solution."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Educational Organization
27%
Computer Software Company
12%
Financial Services Firm
10%
Manufacturing Company
8%
Financial Services Firm
17%
Computer Software Company
12%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What's the deal with the HVR software acquisition?
As a user of HVR Software I followed this deal closely. Fivetran is apparently trying to establish more in its sector and by buying an already established data replication software, they become som...
Does HVR Software provide reliable insights?
I honestly can't think of another data replication software that can give you better statistics and insight than HVR Software. There's the feature for topology and statistics and both of them can ...
How much traffic can HVR Software handle?
As someone who works at a company where a high volume of information is replicated and has tried several data replication softwares, I can tell you that you're looking at the right one. HVR Softwar...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
 

Comparisons

 

Also Known As

No data available
SQL Server Integration Services
 

Overview

 

Sample Customers

DocuSign, Oldcastle Infrastructure, Crossmedia, Talkdesk, Chubbies, Brandwatch
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about Fivetran vs. SSIS and other solutions. Updated: October 2024.
814,649 professionals have used our research since 2012.