1. User Guide
  2. Metadata Report Utility
  3. Utility to Generate a Lineage Report in CSV Format

35.6 Utility to Generate a Lineage Report in CSV Format

This utility uses the following script to retrieve the lineage output as .csv file.

Steps to generate Lineage Report

  1. Navigate to this path $FIC_HOME/utility/DataLineageUtility.

  2. Provide permissions to the Shell Script.

    chmod -R 755 Data_Lineage_Extraction_Utility.sh

  3. To execute the utility run the below command:

    ./Data_Lineage_Extraction_Utility.sh <<Schema_name >> <<Schema_password>> <<Schema_Instance>> << Lineage_Type >> <<MetadataName>>

    Provide the Lineage Type input as one of the following:

    • DataMapping- If you wish to view the T2T output.

      For example: ./Data_Lineage_Extraction_Utility.sh IUT_SCHEMA Password1234 Oracle123 DataMapping T2T_FCT_COMMON_ACCOUNT_SUMMARY

    • TargetModel- If you wish to view the Result area table output.

      For example: ./Data_Lineage_Extraction_Utility.sh IUT_SCHEMA Password1234 Oracle123 TargetModel FCT_COMMON_ACCOUNT_SUMMARY

    • ExtractConnector- If you wish to view the Result area table output.

      For example: ./Data_Lineage_Extraction_Utility.sh IUT_SCHEMA Password1234 Oracle123 ExtractConnector << CONNECTOR NAME>>

      Note:

      The detailed parameter description is available in the Readme.txt in the same path $FIC_HOME/utility/DataLineageUtility.
  4. After the above script is executed, the files are generated in the .csv format in the same path.