SSIS and Fivetran are both competitors in the data integration solutions category. Fivetran seems to have an advantage due to its automatic real-time updates and innovative features, which often provide a competitive edge.
Features: SSIS offers customizable ETL capabilities, robust Microsoft integration, and flexibility in data workflows. Conversely, Fivetran provides zero-maintenance pipeline setups, real-time data replication, and automatic schema updates, which are ideal for dynamic environments.
Room for Improvement: SSIS could benefit from reducing setup complexity, enhancing cloud capabilities, and improving real-time integration. Fivetran could improve by expanding customer customization options, offering more detailed user documentation, and enhancing cost efficiency for smaller data volumes.
Ease of Deployment and Customer Service: Fivetran's cloud-first approach simplifies deployment and minimizes infrastructure management, supported by responsive customer service. SSIS requires more setup due to its on-premises model but benefits from extensive documentation and a strong user community, suitable for troubleshooting.
Pricing and ROI: SSIS offers cost-effectiveness for Microsoft-centered organizations due to its inclusion with SQL Server. Fivetran's premium subscription, though costly, is justified by its low-maintenance advantage. It aligns with enterprises seeking a hands-off integration, while SSIS remains appealing for its traditional cost efficiency.
It saves us the effort of having one to two data engineers managing the tasks that Fivetran handles.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
The technical support provided by Fivetran has generally been good, with a response time and competence that I would rate as good.
During the duration of the time that we used Fivetran, it was highly stable.
It processes large volumes of data quickly.
From a cost perspective, if the number of connectors is lesser, then Fivetran is not the most cost-efficient option.
Improvement in existing connectors with new features is desirable.
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
SSIS has a difficult learning curve when dealing with complex transformations.
Our current yearly contract for Fivetran is approximately $70,000.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
The most valuable feature of Fivetran is its built-in connectors for a wide range of data sources.
The ability to seamlessly integrate with a large variety of data sources is valuable.
SSAS is included in the base installation of SQL Server.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
Fivetran, the global leader in data movement, is trusted by companies like OpenAI, LVMH, Pfizer, Verizon and Spotify to centralize data from SaaS applications, databases, files, and other sources into cloud destinations, including data lakes. With high-performance pipelines, seamless interoperability, and enterprise-grade security, Fivetran empowers organizations to modernize their data infrastructure, power analytics and AI, ensure compliance, and achieve transformative business outcomes. Learn more at Fivetran.com
SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.
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.
