Sprinkle Pipeline is a good alternative to Fivetran due to its no-code data engineering capabilities and ability to host on your own servers.
Start Free TrialYour pipeline is scattered across multiple tools, fivetran doing the ingestion, transformations are executed via Airflow, data is stored in data lake and warehouse. It becomes very difficult to do impact analysis going thru logs of so many systems.
For data replication, there is a round-trip from your datasource servers to your data warehouse via the Fivetran servers. This leads to data egress cost charged by cloud providers.
If you want to have full control for reasons like compliance, you cannot host Fivetran on your own servers. Fivetran offers only SaaS deployment model.
Fivetran provides only data ingestion with very basic transformation capabilities. For any production grade transformation pipelines, you have to integrate and manage different tools like Airflow, and have to optimise transformations using custom coding in python or pyspark.
For debugging and also for building quick reports, you have to rely on different tools.