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."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."
"Its arrays are powerful enough to handle migrations even when the replication is happening in the background, without causing any trouble with the ongoing traffic."
"Making the decision to implement Fivetran was supported by the fact that they have better connectors than other competitors."
"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,."
"The product has some seamless connectors, which are readily available."
"Fivetran can perform data migration incredibly fast, depending on the source and target."
"The general data ingestion is valuable. It's used for a lot of data. It provides about 90% of the data we use in our data warehouse without needing data engineering."
"The product is very easy to use and very easy to configure."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The solution is stable."
"The product's deployment phase is easy."
"The initial setup was easy."
"The solution is easy to use and developer friendly."
"SSIS' most valuable feature is its reporting services."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"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."
"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."
"Fivetran should add more connectors because its competitors, like Airbyte, have more connectors."
"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."
"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."
"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."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"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."
"Future releases should improve the data lineage, as it currently is not good."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"The solution could improve by having quicker release updates."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"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."
"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 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.
