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 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."
"It is not like a traditional ETL, but it gives quite a lot of flexibility."
"The most valuable feature of Fivetran is that it only synchronizes what needs to be synchronized."
"Fivetran can perform data migration incredibly fast, depending on the source and target."
"Fivetran's most valuable feature is replication."
"The product is very easy to use and very easy to configure."
"The portal is very intuitive and easy to use."
"Fivetran is remarkably easy to use; I haven't encountered any other data integration tool that is as user-friendly."
"The initial setup of this solution is very straightforward."
"The performance and stability are good."
"The UI is very user-friendly."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"SSIS integrates well with SQL servers and Microsoft products."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"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 deployment is also very quick."
"The connections with SAP must be improved."
"The solution is very expensive. I would like to have a better integration of the solution with Azure."
"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."
"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 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."
"The interface needs to be more user-friendly."
"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."
"I would like Fivetran to implement additional resource monitoring and restriction policies."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"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."
"Performance could be better."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"Options for scaling could be improved."
"It needs more integration tools, so you can connect to different sources."
"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."
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.
