Data integration in Fivetran has three key facets: prebuilt, fully managed connectors; normalisation of the data you are moving; and provision of analysis-ready schemas for target connectors. Between them this means the process of data integration, leaving aside the definition of relevant transformations, is almost completely automatic. Moreover, Fivetran operations are idempotent, meaning that however many times you process a particular workflow you will always get the same result. In other words, once a process flow is correct it will always be correct, and data integrity will be maintained. If it fails, automatic recovery is available. Idempotency is achieved, in part, because Fivetran will automatically add or remove columns whenever there is a schema change.

Fig 2 - Pre-built connectors available in Fivetran
Fivetran currently offers more than 200 connectors to SaaS applications, on-premises and cloud-hosted databases, file systems, and what have you (see Figure 2). In particular, various cloud platforms, including the ‘big 3’ of AWS, Azure and Google Cloud, as well as Snowflake, Redshift, and Databricks, are supported, as is multi-cloud. In addition, the product is well-equipped to work with (and migrate data to) cloud data warehouses. Its robust partner network also provides access to adjacent data management capabilities, including data governance, data cataloguing, data masking, and so on. That said, there are no ODBC/JDBC connectors, and if you want to connect to an unsupported data source, you will need to develop a custom cloud function or write a script that will dump data into a file storage service for Fivetran to pick up.
Instead of traditional transformation building, Fivetran provides a wide selection (presently approaching 50) of pre-built data models that have been custom-built for various different contexts and supply all the necessary transforms, joins and so on to support those contexts. Further transformation capability, if needed, can be accessed through integration with dbt Labs by embedding its SQL-based transformation engine into the Fivetran environment. This also provides version control, logging, alerting, and various other features, perhaps most notably including data quality functionality that can be built into your data integration pipelines.
Additional capabilities include support for stream processing, automatic data updates, and automated schema migrations and management. On the latter point, Fivetran will also standardise your schemas for easy querying and API access (for example, by applying deduplication processes). These revamped schemas are fully documented by the product. It also features integrated scheduling for your data integration jobs, and can also run said jobs automatically whenever data is loaded into your system.
What’s more, security and governance are clearly priorities for Fivetran. Accordingly, the product is certified against industry best practices and other regulations, including GDPR, SOC2, ISO27001, PCI and HIPAA; it encrypts all data, both in transit and at rest, and data moved into the Fivetran environment is deleted as soon as its data integration workflow is verified (or after 24 hours, whichever comes sooner); and it provides role-based access and authorisation, including automated user provisioning, integration with Azure AD (Active Directory), and various other features.