I've worked extensively with Fivetran, mainly used for extraction purposes, and I've worked with the transformation element in it as well. Fivetran not only has built-in connectors but also provides SDK connectors, allowing us to develop our own connectors in an easy manner. I don't have to write raw Python scripts or dumping scripts; it offers straightforward examples and guidelines, making it much simpler to develop custom connectors inside Fivetran. We've been able to develop many custom connectors as well, which is unique and beneficial for having everything centralized instead of having those connectors located elsewhere. One of the best features by Fivetran is its clean, simple, and intuitive UI. It includes a transformation section where I can deploy my DBT queries and scripts. It also supplies good tracking capabilities for billing estimates and user permissions, allowing for customization to the desired level. The number of connectors it has remains a standout feature, and within connectors, the options available are very helpful. Although it sometimes appears static due to its built-in nature, it offers good flexibility for data transformation and caching, which I appreciate because it saves us extensive script-writing time.
