Overview¶
Alation Cloud Service Applies to Alation Cloud Service instances of Alation
Customer Managed Applies to customer-managed instances of Alation
Available from Alation version 2024.3.2
Overview¶
The OCF Connector for Fivetran is developed by Alation and is available for download from the Connector Hub on Alation Customer Portal. Ask an Alation admin with access to Customer Portal to download the connector from the Connectors section (Customer Portal > Connectors).
This connector enables the creation of cross-system lineage within Alation for cataloged sources and destination warehouses that are extracted and loaded through Fivetran synchronization.
Team¶
The following administrators are required to install this connector:
Fivetran administrator:
Generates API credentials to access the Fivetran API from Alation.
Configure connectors, warehouse, and Fivetran Platform Connector. For more information, see Fivetran Setup Guide
Alation Server administrator:
Installs the OCF connector for Fivetran.
Enables and configures extraction from Fivetran ELT source.
Scope¶
The table below describes which objects are extracted by the connector and which catalog functionality is supported.
Feature |
Scope |
Availability |
|---|---|---|
Authentication |
||
API key and secret |
Basic authentication using an API access key and secret |
Yes |
Metadata Extraction (MDE) |
Not applicable |
|
Catalog Features |
||
Sampling and profiling |
Not applicable |
|
QLI |
Not applicable |
|
Compose |
Not applicable |
|
Lineage |
||
Direct lineage |
Auto-calculation of source lineage based on metadata extracted from Fivetran |
Yes |
Cross System Lineage |
Calculation of lineage across data sources |
Yes |
Table-level lineage |
Calculation of lineage data at the table level |
Yes |
Column-level lineage (CLL)* |
Calculation of lineage data at the column level |
Yes |
Transformations metadata |
Extraction of transformation information from Fivetran |
No |
* Applies to only Fivetran Enterprise and Business critical accounts. For more information, see Enterprise and Business Critical accounts.
Supported Fivetran Sources¶
In Fivetran, the data sources correspond to sources. In addition, they are able to extract and catalog within Alation as Source (Fivetran connected source) datasource.
Refer to the following supported sources to use with the Fivetran OCF Connector 3.0.0 or later:
Data Sources
Fivetran Source Type
Google BigQuery
N.A.
MySQL
Generic, RDS
Oracle
Generic
PostgreSQL
Generic
Salesforce
Generic
Snowflake
N.A.
SQL Server
Generic, HVR
Supported Fivetran Destinations¶
In Fivetran, the data sources correspond to destinations.
Use the latest OCF Connector versions for the following supported destinations with Fivetran OCF Connector 3.0.0 or later:
Data Sources
Fivetran Source Type
Amazon Redshift
N.A.
Azure Databricks
N.A.
Azure Synapse Analytics
N.A.
Databricks on AWS
N.A.
Databricks Unity Catalog
N.A.
Google BigQuery
N.A.
MySQL
Generic, RDS
PostgreSQL
Generic
Snowflake
N.A.
SQL Server
Generic
For more information, see Fivetran Documentation on Supported Services.