Maintain Data Lineage

Version:
Current
Last modified: July 07, 2020

Data lineage is crucial for the establishment of trust and understanding of a data asset, its origins, and relationships to other data assets.

Overview

Alteryx Connect provides technical data lineage by loading metadata from source and target systems and interpreting Alteryx workflows. Metadata from all source and target systems and Alteryx Server must be loaded successfully to provide data lineage.

Alteryx Connect data lineage diagram

    View and Enhance Lineage

    • All relationships, including data lineage, can be viewed using Nexus, which provides an interactive graphical view of connectedness and dependencies:
      1. Browse to a data asset page.
      2. In the Relationships section, select Open Nexus.
    • Captured (loaded) lineage can be enhanced by adding relationships manually in Alteryx Connect.

      Lineage Requirements

      OpenODBC and Oracle OCI Assets

      To maintain lineage between loaded ODBC and Oracle OCI assets, you must be consistent when referencing these resources. For example:

      • If you used the IP address of an Oracle database server when loading metadata from an Oracle database, you must also use the IP address (not the hostname) in Gallery workflows that contain connections to the same Oracle database server.
      • If a Gallery workflow contains an ODBC connection, the DSN parameters for that connection must match the DSN configured on the machine from which you are running the Workflow Loader. The server address in both locations must match.

      Tableau Assets

      To maintain lineage between an Alteryx workflow, Tableau .tde file on a file system, and a workbook on Tableau Server:

      1. Open the .tde file in Tableau Desktop.
      2. Create a report (edit sheet with data).
      3. When publishing the workbook to Tableau Server, deselect Include external files, and select Yes to confirm.

      After loading metadata from both the file system and Tableau Server, you should see the proper lineage in Alteryx Connect.

      Was This Helpful?

      Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.