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."
"The solution is stable. We've never faced any stability issues."
"The most important feature of the solution is its ability to build data pipelines in less time."
"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."
"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."
"Fivetran's most valuable feature is replication."
"The compare feature is the most valuable piece of it."
"SSIS integrates well with SQL servers and Microsoft products."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The scalability of SSIS is good."
"The interface is very user-friendly."
"The solution is stable."
"It's a competent product."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The interface needs to be more user-friendly."
"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."
"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."
"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."
"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."
"More connectors are needed for exotic, popular, and rising star portals."
"The solution is very expensive. I would like to have a better integration of the solution with Azure."
"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."
"Video training would be a helpful addition."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"I would like to see better integration with Power BI."
"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."
"The performance of this solution is not as good as other tools in the market."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"I would like to see more features in terms of the integration with Azure Data Factory."
"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.
