Automating the data extraction and loading part with ease
- Small initial setup effort
- Fivetran automatically takes care to fix loading issues
- Has connectors to many different systems
Cons
- Very difficult to get connectors enhanced if a specific needed object is not supported by them
- Depending on the edition needed and the data volumes, can get quite expensive
- Saved a lot of manual development days (unable to quantify)
- Accelerated the time to add a new source to the data warehouse a lot