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 most valuable feature of Fivetran is that it only synchronizes what needs to be synchronized."
"The ease of usability is the most valuable feature. It's very easy and quick to set up. It also has a central hub as opposed to GoldenGate which is one direct interface. For GoldenGate I would have needed three interfaces whereas with HVR I have a central interface that manages everything."
"The product has some seamless connectors, which are readily available."
"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 solution is stable. We've never faced any stability issues."
"The product is very easy to use and very easy to configure."
"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."
"The scalability of SSIS is good."
"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."
"It is easy to set up the solution."
"SSIS integrates well with SQL servers and Microsoft products."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"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."
"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."
"The interface needs to be more user-friendly."
"Fivetran would be improved by adding the ability to integrate the data from third-party APIs."
"I would like for them to incorporate additional transformations. A valuable aspect of the product is that it does inflight transformations and that could be expanded."
"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."
"The connections with SAP must be improved."
"We experience cost issues because Fivetran is charged on a usage basis. When you reach a certain level, the tool should focus on reducing the costs. The solution is expensive when you are moving gigabytes and petabytes of data. It should also focus more on REST APIs and webhooks."
"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."
"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."
"The creation of the measure in the DAC's model could be improved."
"The solution could improve on integrating with other types of data sources."
"It would be nice if you could run SSIS on other environments besides Windows."
"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."
"I would like to see better technical documentation because many times information is missing."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
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 Informatica PowerCenter, 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.