Prerequisites

Before you configure the Fivetran connector in Alation, ensure that you complete the requirements.

Requirements in Fivetran

  • Ensure that you have Enterprise or Business Critical account for column-level lineage before you proceed. For more information, see Enterprise and Business Critical accounts.

  • Alation recommends that you install the Fivetran platform connector at the account level. This ensures that you don’t configure multiple Fivetran platform connectors. For more information, see Fivetran Setup Guide

  • If you install connector at the destination level, then Alation recommends to install only one Fivetran platform connector at each destination level for optimal lineage extraction.

  • Ensure that the metadata sharing is enabled on the Connectors tab to save all the lineage metadata in the destination. For more information, see Fivetran Documentation on Enable Lineage

Requirements in Alation

  • Ensure that you’re using the Alation version 2024.3.2 or later and the Fivetran OCF Connector version 3.0.0 or later.

  • Ensure that you decommission the Fivetran Add-on connector (if you have currently configured one) and use the Fivetran OCF Connector version 3.0.0 or later. For more information, see Migrate from Add-on Connector.

  • Ensure that the Fivetran OCF connector is installed. For more information, see Install the Connector.

  • Ensure that there’s a working Alation data source for the destination in Fivetran.

  • (Only applicable to Alation Cloud Service) Ensure that the Catalog Service flag is enabled for the ELT source. Contact Alation Support to enable the flag.

    Parameter

    Description

    alation.feature_flags.DEV_enable_otype_service

    Enables the Catalog Service.

    Set the value to true

  • (Optional) (Only applicable to Alation on-premise users) Ensure that the following flag is set based on the network configuration:

    Parameter

    Description

    alation.ocf.acm.use_host_network

    Allows the connector to use host network.

    Set the value to true

    Note

    Applicable only if you’re using Alation Agent and have enabled [agent] -> use_host_networking in the hydra.toml file. For more details, see STEP 3: Configure Alation Connector Manager.

  • Ensure that additonal data source connections are filled in for all the data sources where lineage is expected. For more information, see Configure Lineage Across Data Sources.

    Note

    This step is optional when the following conditions are true:

    • You’re using Alation 2024.3.3 or later and,

    • The <hostname>:<port> in the JDBC URI of the Alation data source matches with <hostname>:<port> mentioned in Fivetran sources and destinations.