Overview

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Available from Alation version 2024.3.2

Overview

You can install and upgrade the connector using one of the following methods, depending on your Alation deployment type:

• On-premise instances: Download the latest connector package from the Alation Customer Portal (Customer Portal > Connectors), then upload and install it in Alation.

• Alation Cloud Service: Install and upgrade the connector directly from your instance without downloading the package. Any connector available on the Alation Customer Portal (Customer Portal > Connectors) can be installed and upgraded this way. See Install Connectors (Cloud-Native Architecture). You can also download the connector package from the Alation Customer Portal and install or upgrade it manually by uploading the Zip file.

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
Salesforce Sandbox*	Generic
SQL Server	Generic, HVR
Snowflake	N.A.

N.A.: Fivetran doesn’t have an explicitly supported service documented for this connector.

* Support for Salesforce Sandbox is available from Fivetran OCF Connector version 3.1.0.

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

N.A.: Fivetran doesn’t have an explicitly supported service documented for this connector.

For more information, see Fivetran Documentation on Supported Services.